Purchase Solution

Master Budget with Supporting Schedules

Not what you're looking for?

Ask Custom Question

The cash budget is composed of four major sections:
1. The receipts section.
2. The disbursements section
3. The cash excess or deficiency section.
4. The financing section.
The receipts section lists all of the cash inflows, except from financing, expected during the budget period. Generally, the major source of receipts is from sales.
The disbursements section summarizes all cash payments that are planned for the budget period. These payments include raw materials purchases, direct labor payments, manufacturing overhead costs, and so on, as contained in their respective budgets. In addition, other cash disbursements such as equipment purchases and dividends are listed.

My cash excess section was computed as follows:

If a cash deficiency exists during any budget period, the company will need to borrow funds. If there is a cash excess during any budget period, funds borrowed in previous periods can be repaid or the excess funds can be invested.
The financing section details the borrowings and repayments projected to take place during the budget period. It also lists interest payments that will be due on money borrowed.

The cash balances at both the beginning and end of the year may be adequate even though a serious cash deficit occurs at some point during the year. Consequently, the cash budget should be broken down into time periods that are short enough to capture major fluctuations in cash balances.

Purchase this Solution

Solution Summary

Your tutorial is attached and it has a complete budget (ignoring all student entries in the submission). Click in cells to see computations.

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.