I’ve already done the monthly cash budget for the problem.
this is what it looks like:
I am having a hard time applying these assumptions:
The assumptions used to develop the pro forma financial statements were used by Stewart and Ford as a starting point. Historical information and current market conditions were also used in developing the cash budget assumptions.
1. A minimum $20,000 cash balance will be maintained.
2. The company has negotiated a $200,000 line of credit for short-term cash needs.
3. Ford stated that the primary cash inflow will be the collection of accounts receivables.
Projected revenue for the year is $6,000,000 and monthly sales forecasts were provided by the marketing department.
4. Ford indicated that last year receivables were collected as follows:
% of sales
Current Month 20.0
Month following the sale 50.0
Second month following the sale 30.0
Ford thought the new credit policy implemented by the new credit manager should allow an acceleration of collections in the coming year. The projected collection schedule for 2007 is:
% of sales
Current Month 25.0
Month following the sale 60.0
Second month following the sale 15.0
Stewart suggested they use the 2007 collection assumptions for the cash budget. For example, 25% of January sales will be collected in January, 60% of January sales will be collected in February and 15% of January sales will be collected in March. Note: 15% of 2006 November sales and 60% of 2006 December sales will be collected in January and 15% of December 2006 sales will be collected during February. Ford stated there would a small amount of bad debts in 2007 but for planning purposes these would be ignored.
5. The purchase of inventory represents the largest cash outflow. Inventory is typically purchased two months prior to expected sales and is paid in the month of purchase.
Example, inventory for January sales would be purchased in November and paid for in
November. Inventory for February sales would be purchased and paid for in December, etc.
Cost of Goods Sold in 2007 were 76% of sales, assume that 2008 cost of goods sold will also be 76% of sales.
6. Annual plant operating expenses were projected to total $688,500. Ford suggested that these expenses be distributed equally over the twelve months. She stated that in some cases this was probably an over simplification but a reasonable assumption. Stewart agreed. Example:
One twelfth, or $4,375, of the annual manager salary and benefits of $52,500 will be distributed monthly.
Plant Operating Expenses Annual Expense $
Manager (salary and benefits) 52,500
Employees (wages and benefits) 225,000
Lease Expense 72,000
Utilities Expense 12,000
Repairs & Maintenance Expense 6,000
Supplies Expense 9,000
Delivery Expense 120,000
Miscellaneous Expense 12,000
7. Selling Expenses were projected at $301,500 for the year. Ford stated that most could be spread evenly over the twelve months. The exceptions would be Commissions and Promotion and Advertising. Commissions are paid in the month following the end of a quarter and will be allocated based on sales for the previous quarter. Example: ($30,000 *first quarter sales/annual sales). The accounts payable on the 2006 year end balance sheet represents the fourth quarter 2006 commissions that will be paid in January of 2007. One fourth of the annual promotion and advertising expense will be spent during the first month of each quarter.
Selling Expenses Annual Expense $
Sales Representatives 105,000
Auto Expense 24,000
Internal Sales Representatives 52,500
Promotion and Advertising 54,000
8. Annual general administrative expenses will be treated the same as plant operating expenses.
These expenses will be distributed equally over the twelve months.
General Administrative Expenses Annual Expense $
Officer’s Salaries 83,700
Auto Expense 12,000
Administrative Staff 52,500
Utility Expense 12,000
Office Supplies 12,000
Legal & Professional 6,000
9. Annual interest expense is forecasted to total $90,000 and interest payments are made in the third month of each quarter. Again for simplicity purposes, Ford suggested the $90,000 be spread evenly over the four quarters.
10. Capital expenditures for the year include a $40,000 expansion to the warehouse and $20,000 for new drum filling equipment. The warehouse expansion is scheduled for April and the equipment acquisition for June. Assume the expenditures are paid for in the month of their installation. The depreciation expense associated with the projects is included in $180,000 projected for the year.
11. Income taxes are expected to total $34,740 and payments are made quarterly with the first payment of 2007 taxes to be made in April. The $34,740 will be spread evenly over the four quarters. The taxes payable on the year end 2006 balance sheet will be paid in January of
1. Construct a monthly cash budget for Cape Chemical for the period January through
December 2007. Assume that all cash flows occur on the 15th of each month. Is the current
$200,000 line of credit sufficient to meet the needs of Cape Chemical during the year?
Explain your answer.
2. The cash budget contains both cash inflows and cash outflows. Which do you feel are likely to be the most accurate? Explain your answer.
4. Why is depreciation expense not part of the cash budget?
6. Temporary excess cash can be invested in marketable securities. What are the characteristics of marketable securities? If excess cash is projected to be continuing rather than temporary, are marketable securities the appropriate investment? Explain your answer.
7. Once again assume all cash flows occur on the 15th of each month. How large of a line of credit would you recommend Stewart and Ford arrange with the bank? Defend your answer.
8. Suppose the bank refused to grant a larger line of credit what options are available to the company?