top of page

Capital Expenditures and Cash  Budgets

I. Capital Project Budgeting

A.  A master budget includes a forecasted income statement (known as the planned operating budget) and a forecasted balance sheet (known as the financial budget), outlining the organization's goals and proposed methods for achieving them.
 

B. The budgeting process begins with management outlining plans and objectives for the upcoming period. These plans consider various policy decisions regarding factors like selling prices, distribution channels, advertising spending, and external influences, which help the company predict its sales for the period (broken down by product or product line). Managers determine the sales budget in terms of dollars by multiplying the expected sales units by the sales price per unit. They then use anticipated production, sales volume, and inventory policies to estimate the cost of goods sold. Following this, managers forecast operating expenses such as selling and administrative costs.

C. Capital projects usually start with proposals and an approval process often referred to as "capital budgeting." This process typically includes three main aspects.

  1. Financial analysis of capital budgeting projects commonly uses tools like net present value (NPV), internal rate of return (IRR), payback period, and return on investment (ROI).

  2. Risk analysis of capital projects involves evaluating uncertainties in inputs and outcomes. Advanced analytical tools can show the possible outcomes for a capital project proposal.

  3. Qualitative analysis is vital to ensure that capital project decisions consider non-quantitative aspects related to core strategic goals of the organization. These goals often include factors like quality, culture, brand, environment, and ethics.

D. Once capital project planning is finished for a master budget cycle and resources are committed, management needs to carefully monitor and evaluate the development and launch of each project. Depending on the project's scale and scope, various budgets, schedules, and oversight procedures can be established to monitor progress.

II. The Cash Budget 

A. The foundation of the budgeting process lies in the sales budget since the effectiveness of the entire operating budget hinges on it. The sales budget entails estimating or predicting the demand for a company's products and determining whether a realistic and achievable profit can be made based on this demand. Sales forecasting can involve formal methods, informal methods, or a combination of both.

B. Formal sales forecasting methods often utilize statistical tools. For instance, management might employ economic indicators (or variables) like gross national product or gross national personal income, along with other factors such as population growth, per capita income, new construction, and population migration, to predict sales for the upcoming period. To utilize economic indicators for sales forecasting, there must be a relationship between the indicators (referred to as independent variables) and the sales being forecasted (referred to as the dependent variable). Subsequently, management can apply statistical methods to forecast sales based on the economic indicators.

C. To demonstrate this process, let's consider an example with Daniel's management forecasting sales for the year at 100,000 units (where each pair of shoes is considered one unit). Quarterly sales projections are as follows: 15,000 units in the first quarter, 40,000 units in the second quarter, 20,000 units in the third quarter, and 25,000 units in the fourth quarter. This pattern reflects increased demand for shoes in late spring and again around Christmas. The projected selling price for each pair of shoes is $40. Daniel's sales budget is then prepared by multiplying the projected sales units for each quarter by the budgeted sales price to determine the sales in dollars. Finally, the totals for the entire year are obtained by summing up the sales from each quarter.

daniel comp.png

D.  The materials budget, also known as the materials purchases budget, maps out the required raw materials to fulfill the budgeted production. Similar to the production budget, this budget determines the desired raw materials inventory at the end of each quarter, usually as a percentage of the next quarter's material requirements. The materials budget initially deals with units and later incorporates the budgeted cost. Additionally, the quantity of direct materials needed for each unit is essential.

E. For instance, in the case of Daniel Company, the budgeted cost per pound is $2, with 5 pounds of materials needed for each unit. They aim to retain 25% of next quarter's production needs in ending inventory. Beginning raw materials inventory stands at 20,000 pounds ($2 per pound), with an expected ending inventory of 30,000 pounds.

leed comp.png
leed comp 2.png

F.  The direct labor budget is straightforward. It requires the units specified in the production budget and the labor hours and cost per hour to complete one unit. Multiplying the production units by the direct labor per unit yields the number of direct labor hours, which are then multiplied by the hourly rate.

G. For example, in Leed Company, each unit demands 0.5 hours of direct labor, with an hourly rate of $12. The direct labor budget calculation involves multiplying the production units by the direct labor per unit and then by the hourly rate. This budgeted direct labor dollar amount is later utilized in the cash disbursement section of the cash budget.
 

leed comp 3.png
leed comp 4.png

H.  Lastly, the manufacturing overhead budget is formulated based on the company's chosen overhead allocation method, which can include predetermined rates, departmental rates, or activity-based costing. Daniel Company, for instance, allocates variable overhead at $1.50 per direct labor hour and fixed overhead at $75,000 per quarter, which includes $10,000 quarterly depreciation on factory machinery. The information from the overhead budget is applied in the cash disbursement section of the cash budget.

leed comp 5.png
leed comp 6.png

I. Once the previous analyses are complete, we can gather adequate data to compile the cash budget and determine the Cash account balance for each quarter. Creating a cash budget entails gathering details about cash receipts and cash disbursements from all other operating budget schedules.

 

J. For cash receipts, we establish a schedule based on the company's expectations regarding sales collections. By reviewing past records, we can discern the proportions of cash and credit sales, as well as the typical payment timeline for credit sales.

 

K. For instance, Daniel Company has concluded that all sales are on credit with no cash sales. Based on past trends, Daniel expects to collect 60% of sales in the same quarter and the remaining 40% in the subsequent quarter. Despite the practical challenge of collecting 100%, Daniel opts to budget for full collection. Beginning Accounts Receivable for the year is $200,000, projected to be collected in the 1st Quarter. Here's how Daniel Company plans its cash receipts:

leed comp 7.png
leed comp 8.png

L. Regarding cash disbursements, companies need funds for various expenses such as purchases, wages, rent, and taxes. We can derive the disbursement amounts from other budget sections.
 
M. Since Daniel Company is a manufacturing firm, it must first utilize data from the materials purchases budget. All material purchases are made on credit, with 80% paid in the same quarter and the remaining 20% in the subsequent quarter. Beginning Accounts Payable for the year is $80,000, anticipated to be paid in the 1st Quarter. Here's how cash payments for material purchases are calculated:

Practice Questions

1. What is the purpose of a capital expenditure budget in an organization?

            A) To track short-term operational expenses
            B) To evaluate credit policies
            C) To monitor cash receipts and disbursements
            D) To plan for long-term investments
            E) To analyze sales revenue

2. Which of the following is NOT a section typically found in an organization's cash budget?

            A) Cash from operations            B) Cash from investing
            C) Cash from financing              D) Cash receipts
            E) Cash disbursements

3. How does a cash budget help an organization manage its finances?

            A) By tracking long-term capital projects         B) By evaluating credit policies
            C) By monitoring cash disbursements             D) By analyzing sales revenue
            E) By planning for direct labor costs

4. What is the purpose of the master budget in an organization?

            A) To track daily operational expenses           B) To evaluate short-term credit policies
            C) To plan for long-term capital projects        D) To monitor quarterly sales revenue
            E) To analyze direct labor costs

5. How does a cash budget connect to an organization's capital projects?

             A) By tracking short-term operational expenses
             B) By evaluating credit policies
             C) By monitoring cash receipts and disbursements
             D) By planning for long-term investments
             E) By analyzing sales revenue

6. XYZ Company has a beginning cash balance of $20,000. If they receive cash receipts of $50,000 and make cash disbursements of $30,000, what is the ending cash balance?
 
             A) $40,000                                B) $50,000
             C) $60,000 D) $10,000
 
7. ABC Corporation has a minimum cash balance requirement of $15,000. If their total cash available is $25,000, do they need to borrow money to meet the minimum cash balance?

              A) Yes                                       B) No
 
8. Company DEF has cash receipts of $80,000 and cash disbursements of $60,000. What is their net cash flow?

              A) $20,000                                B) $10,000
              C) $40,000                                D) $30,000
 
9. LMN Inc. has a beginning cash balance of $15,000. If they receive cash receipts of $25,000 and make cash disbursements of $20,000, what is the total cash available?

              A) $20,000                                 B) $25,000
              C) $30,000                                 D) $40,000
 
10. Company PQR has a cash balance of $10,000. If they receive additional cash inflows of $15,000 and make cash outflows of $12,000, what is their ending cash balance?

               A) $13,000                                 B) $15,000
               C) $13,000                                 D) $10,000



​Answer Key:
1. What is the purpose of a capital expenditure budget in an organization?

A) To track short-term operational expenses
B) To evaluate credit policies
C) To monitor cash receipts and disbursements
D) To plan for long-term investments
E) To analyze sales revenue
 
Explanation: A capital expenditure budget is used to identify and plan for long-term investments in projects that can strengthen the organization's current business position or help in expanding into new business areas.
 
2. Which of the following is NOT a section typically found in an organization's cash budget?

A) Cash from operations B) Cash from investing
C) Cash from financing D) Cash receipts
E) Cash disbursements
 
Explanation: While cash receipts are an important component of a cash budget, they are usually included under the "cash from operations" section, along with other operational cash inflows.
 
3. How does a cash budget help an organization manage its finances?

A) By tracking long-term capital projects B) By evaluating credit policies
C) By monitoring cash disbursements D) By analyzing sales revenue
E) By planning for direct labor costs
 
Explanation: A cash budget helps an organization manage its finances by closely monitoring cash disbursements, ensuring that there is enough liquidity to cover expenses and identifying potential cash shortfalls.
 
4. What is the purpose of the master budget in an organization?

A) To track daily operational expenses     B) To evaluate short-term credit policies
C) To plan for long-term capital projects   D) To monitor quarterly sales revenue
E) To analyze direct labor costs
 
Explanation: The master budget in an organization is used to plan and coordinate all financial activities, including long-term capital projects, operational budgets, and financial statements.
 
5. How does a cash budget connect to an organization's capital projects?

A) By tracking short-term operational expenses
B) By evaluating credit policies
C) By monitoring cash receipts and disbursements
D) By planning for long-term investments
E) By analyzing sales revenue
 
Explanation: A cash budget serves as a connecting bridge between an organization's capital projects and its operating objectives by monitoring cash receipts and disbursements related to both long-term investments and day-to-day operations.
 
6. XYZ Company has a beginning cash balance of $20,000. If they receive cash receipts of $50,000 and make cash disbursements of $30,000, what is the ending cash balance?

A) $40,000 B) $50,000
C) $60,000 D) $10,000
 
Explanation: Ending Cash Balance = Beginning Cash Balance + Cash Receipts - Cash Disbursements Ending Cash Balance = $20,000 + $50,000 - $30,000 Ending Cash Balance = $40,000
 
7. ABC Corporation has a minimum cash balance requirement of $15,000. If their total cash available is $25,000, do they need to borrow money to meet the minimum cash balance?

A) Yes B) No
 
Explanation: Since the total cash available is higher than the minimum cash balance requirement, ABC Corporation does not need to borrow money to meet the minimum cash balance.
 
8. Company DEF has cash receipts of $80,000 and cash disbursements of $60,000. What is their net cash flow?

A) $20,000 B) $10,000
C) $40,000 D) $30,000
 
Explanation: Net Cash Flow = Cash Receipts - Cash Disbursements Net Cash Flow = $80,000 - $60,000 Net Cash Flow = $20,000
 
9. LMN Inc. has a beginning cash balance of $15,000. If they receive cash receipts of $25,000 and make cash disbursements of $20,000, what is the total cash available?

A) $20,000 B) $25,000
C) $30,000 D) $40,000
 
Explanation: Total Cash Available = Beginning Cash Balance + Cash Receipts - Cash Disbursements Total Cash Available = $15,000 + $25,000 - $20,000 Total Cash Available = $30,000
 
10. Company PQR has a cash balance of $10,000. If they receive additional cash inflows of $15,000 and make cash outflows of $12,000, what is their ending cash balance?

A) $13,000 B) $15,000
C) $13,000 D) $10,000
 
Explanation: Ending Cash Balance = Beginning Cash Balance + Additional Cash Inflows - Cash Outflows Ending Cash Balance = $10,000 + $15,000 - $12,000 Ending Cash Balance = $13,000
 
 
References
 
Wiley. (2023). Wiley CMA Exam Review 2023 Study Guide Part 1: Annual Profit Plan and Supporting Schedules. Wiley.
7.5 Cash Budgets | Managerial Accounting. (n.d.). https://courses.lumenlearning.com/suny-managacct/chapter/cash-budgets/

 

Phoenix Notebook

BORN TO SOAR

  • Facebook
  • Twitter
  • Instagram

© 2034 by Batch Ardeo. Powered and secured by Wix

 P del Rosario, Cebu City, 6000 Cebu

© Copyright
bottom of page