Share
Explore BrainMass

Cash Budgeting

Short-term financing looks at the financial decisions that will impact the firm within the year. Managing cash and other current assets to ensure that the current portion of a firm’s liabilities can be met is crucial to the ongoing operations of a business.

The cash budget is the primary tool in short-term financial planning. It allows the corporate financial manager to identify short-term financing needs (where cash-shortfalls may exist) as well as opporunities when extra cash is on hand. The purpose of the cash budget is to identify the cash flow gap on the cash flow timeline (see: Working Capital Management). 

You’re probably familiar with budgeting how to spend your own paycheck, and many people know the stress of “being a little short this month.” Short-term financial decision-making is needed because of the gap in time and value between a firm’s cash inflows and cash outflows. A successful business must be able to manage its cash in a way that it can meet all of its obligations when they come due.

Sources of Cash

Sources of cash typically involve cash sales and cash collections from sales on account. For example, imagine a firm that expects to sell $100m in the first quarter, $75m in the second quarter, $50m in the third quarter, and $75m in the fourth quarter. 20% of its sales are typically for cash, and 80% of its sales are on credit. It allows 90 days for payment on account, so its cash collections for one period typically equal its sales on account from the previous period. 



Disbursements of Cash

Disburesment of cash typically include the following categories:

1. Payments of accounts payable: Purchases of ray materials or merchandise inventory will typically reflect the business's sales forecasts. If a business has a raw materials cost equal to 50% of sales, its purchases will equal 50% of forecasted sales for the upcoming quarter. Imagine the same company above is given 90 day credit terms from its suppliers. Its payments of accounts payable will typically equal its purchases, then, from the previous quarter. 

2. Wages, taxes and other expenses: This category includes all ordinary business expenses that must be paid in cash. For example, while depreciation is an ordinary business expense, it is not included on the cash budget because it requires no cash outflow. These numbers are also typically based on forecasted sales (or income). 

3. Capital expenditures: These are cash payments made for new capital assets. Our hypothetical company is going to invest $20m in new manufacturing equipment in the third quarter. 

4. Long-term financing: Interest payments, principle payments on maturing long-term debt, and dividend payments to shareholders also require cash during the year. Imagine our hypothetical company has interest payments of $5m a year, and will have to settle a $20m loan in the fourth quarter. 



The Cash Balance

Knowing the business's sources of cash and disbursements of cash, we can then calculate the net cash flow from each quarter. We can add this net cash flow to our current cash balance to get our forecasted cash balance. Most firms have a minimum cash balance requirement; that is, they have a policy that requires them to keep a minimum level of excess cash in their bank account in case of contingencies. Using this information, we can calculate whether the firm will have a cash surplus of deficit; that is, whether they have excess cash they can invest or whether they will not have enough cash to meet their short-term needs, and will need to arrange borrowing. 



Our hypothetical firm is going to need to arrange a small amount of borrowing in the fourth quarter to keep its minimum cash balance. 

Signals of debt and equity financing

What signals are provided to investors when a company obtains equity financing? What signals are provided to investors when a company obtains debt financing?

Return on Equity and Assets

Payne Products's sales last year were an anemic $1.6 million but with an improved product mix it expects sales growth to be 25% this year, and Payne would like to determine the effect of various current assets policies on its financial performance. Payne has $1 million of fixed assets and intends to keep its debt ratio at its h

Working Capital - Application of Financial Concepts

The Green Restaurant Balance Sheet Assets Liabilities Cash $15,905.00 Accounts Payable $500.00 Food $1,200.00 Accrued Expenses Payable $4,300.00 Prepaid Rent $1,500.00 Notes Payable $9,000.00 Equipment $10,000.00 Accrued Interest $111.00 Accumulated Depreciation $(160.00) $13,911.

Completing Ratio Analysis

I need to prepare ratio analysis for 2 companies for the most recent 3 years 2012, 2011 and 2010 the analysis should include: Liquidity Long term debt paying ability Profitability and investor analysis -- Ratio List: Liquidity • Days sales in receivables • Accounts receivables turnover • Accounts recei

The Additional Funds Needed equation (AFN)

Additional External Financing You have been running your small business, Craft's Boat Shop, for several years now and have been very successful. You have come to the point where you expect sales to increase next year and want to be sure that you have enough assets available to support your sales. You also need to have the fi

P16-11 Negus Cash Conversion Cycle

P16-11 Negus Cash Conversion Cycle Inventory conversion period of 50 days Average collection period of 35 days Payables deferral period of 25 days Costs of goods sold is 80% of it's sales. REQUIRED: Compute the cash conversion cycle. REQUIRED: Annual credit sales are $4,380,000. What is the firm's investment in account

Concerning statement of cash flows

1) If a firm issues $10 million in common stock and invests the proceeds in marketable securities, all of the following balance sheet categories will increase, except: a) total assets b) total liabilities c) stockholder's equity d) current assets 2) Which of the following accounts are included when calculating a fir

Advanced accounting (cash flow)

I have attached a file that includes the following information, as well as charts. Statement of Cash Flows Team Assignment Robin Corporation's balance sheet on December 31, 2012 included the following items: Cash $ 35,000 Current Liabilities $ 150,000 Other Current Assets

Payback Methods, Even and Uneven Cash Flows

Payback methods, even and uneven cash flows You have the opportunity to expand your business by purchasing new equipment for $159,000. The equipment has a useful life of nine years. You expect to incur cash fixed costs of $96,000 per year to use this new equipment, and you expect to incur cash variable costs in the amount of 10%

Preparing a cash flow forecast given journal entries

QUESTION 1: KK Products Ltd. is a retailer that sells sound systems. The company is planning its cash needs for the month of January, 2013. In the past, KK has had to borrow money during the post-Christmas season to offset a significant decline in sales. The following information has been assembled to assist in preparing a

Cash Basis and Accrual Basis of Accounting

What is the difference between the cash basis of accounting and the accrual basis of accounting? Which one would you select for a company that has inventory and why? Does the size of the company make a difference? Explain how. What would be the advantages and disadvantages of using one basis of accounting over the other?

Preparing a Financial Budget: Note Printing

Note Printing of Baltimore has applied for a loan. Bank of America has requested a budgeted balance sheet at April 30, 2011, and a budgeted statement of cash flows for April. As Note Printing's controller, you have assembled the following information: a. March 31 equipment balance, $80,500; accumulated depreciation, $12,100

Personal Budget, Balance Sheet, and Cash Flow Statement

Choose a client or yourself. For confidentiality purposes, use a fictitious name. Prepare a personal budget, balance sheet, and cash flow statement. Write a memo that includes the following: • A summary of the facts, including ages of the client, spouse, and dependents; educational background; income status of client and

Contains detailed step by step solution of two distinct problems. First concerning separation of total cost into Fixed and Variable cost. Second related to estimating cash collection.

1. Falstags Brewery has estimated $63,375, $68,625, and $73,875 budgeted costs for the manufacture of 3,500, 4,500, and 5,500 gallons of beer, respectively, next quarter. What are the variable and fixed manufacturing costs in the flexible budget for Falstags Brewery? 2. Sales on account for the first two months of the

Cornerstones of Managerial Accounting

The president of Cleantech, Inc. has just approached the company's bank seeking short-term financing for the coming year, Year 2. Cleantech is a distributor of commercial vacuum cleaners. The bank has stated that the loan request must be accompanied by a detailed cash budget that shows the quarters in which financing will be nee

Budget Creation

Marconi, Inc. a retailer of speciality paints, prepares a master budget. Data for the September master budget are given below. Prepare a balance sheet, an income statement and cash budget for September. a. The August 31 balance sheet: Current assets as of August 31: Cash $25,500 Account

Cash Budgeting and Financial Forecasting

Please address the 17 questions in the case study review and evaluate the case, identifying the decisions to be made pertaining to financial forecasting. Determine quantitative and qualitative factors pertaining to financial forecasting. Conclude findings pertaining to a financial forecasting case and provide recommendati

Budgets and Income Statements

1. Prepare a Cash Receipts Budget for the quarter ending June 30th, by month and quarter. You do not need a formal sales budget since the sales budget is above in the data. 2. Prepare a merchandise purchase budget by month and quarter. A merchandiser purchases in dollars. I have set up a formatted budget for you. You can se

The Purpose of the Cash Budget

"The principal purpose of the cash budget is to see how much cash the company will have in the bank at the end of the year." Do you agree? Explain. If you agree, are there any other purposes that might also be important? If you don't agree, what do you feel is the principal purpose then?

Accounting, Master Budgets and Planning

Abcus Company sells its product for $125 per unit. Its actual and projected sales follow: April (actual) ----------------8,000 units $1,000,000 May (actual) ---------------4,000 units $500,000 June (budgeted) ---------12,000 units $1,500,000 July (budgeted) -----------6,000 units $750,000 August

Cash Budgeting: The LBJ Company

The LBJ Company has budgeted sales revenues as follows: April may June Credit sales $94000 $89500 $75000 Cash sales $48000 $75000 $57000 Total sales $142000 $164500 $132000 Past experie

Preparing Budgets, Cash Collections and Cash Disbursement

Crydon, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist in preparing the budget. (Please see the attachment.)

Cyrus Brown's Cash Budget.

Cyrus Brown Manufacturing has estimated the following sales forecast over next 9 mo.: March-$100,000; April-$275,000; May-$320,000; June-$450,000; July-$700,000; August-$700,000; September-$825,000; October-$500,000; November-$115,000. Collection estimates regarding the forecast sales: payment collection with

Materials Purchases Budget

A materials purchases budget must be completed immediately after the preparation of the a. direct labor budget b. operating expense budget c. cash budget d. production budget

Mercy Inc. Ratios, Silver Manufacturing Cash Budget

Mercy Inc. has submitted to you a BS summary data for 2008 and 2009. The company recorded a Net Income in millions of $212 for 2009 MERCY INC. Condensed Balance Sheets December 31, 2008 and 2009 2009 2008 Cash

HOW TO SHOW MATH CALCULATIONS

4.Complete the Cash Budget for the following Company with the following known data and past experience activity rates: January February March SALES : $220,000 $272,000 $304,000 CASH (Receipts) : There is NO remaining balance or cash due from D