In: Finance
Problem 16-14
Cash Budgeting
Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently run out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high.
Sales are made on a cash basis only. Koehl's purchases must be paid for during the following month. Koehl pays herself a salary of $4,300 per month, and the rent is $2,100 per month. In addition, she must make a tax payment of $14,000 in December. The current cash on hand (on December 1) is $400, but Koehl has agreed to maintain an average bank balance of $5,500 - this is her target cash balance. (Disregard the amount in the cash register, which is insignificant because Koehl keeps only a small amount on hand in order to lessen the chances of robbery.)
The estimated sales and purchases for December, January, and February are shown below. Purchases during November amounted to $130,000.
Sales | Purchases | |||
December | $170,000 | $45,000 | ||
January | 30,000 | 45,000 | ||
February | 62,000 | 45,000 |
I. Collections and Purchases: | ||||||
|
|
|
||||
Sales | $ | $ | $ | |||
Purchases | $ | $ | $ | |||
Payments for purchases | $ | $ | $ | |||
Salaries | $ | $ | $ | |||
Rent | $ | $ | $ | |||
Taxes | $ | --- | --- | |||
Total payments | $ | $ | $ | |||
Cash at start of forecast | $ | --- | --- | |||
Net cash flow | $ | $ | $ | |||
Cumulative NCF | $ | $ | $ | |||
Target cash balance | $ | $ | $ | |||
Surplus cash or loans needed | $ | $ | $ |
a] | December | January | February | |
Sales | $ 1,70,000 | $ 30,000 | $ 62,000 | |
Purchases | $ 45,000 | $ 45,000 | $ 45,000 | |
Payments for purchases | $ 1,30,000 | $ 45,000 | $ 45,000 | |
Salaries | $ 4,300 | $ 4,300 | $ 4,300 | |
Rent | $ 2,100 | $ 2,100 | $ 2,100 | |
Taxes | $ 14,000 | $ - | $ - | |
Total payments | $ 1,50,400 | $ 51,400 | $ 51,400 | |
Cash at start of forecast | $ 400 | $ 400 | $ 400 | |
Net cash flow | $ 19,600 | $ -21,400 | $ 10,600 | |
Cumulative NCF | $ 19,600 | $ -1,800 | $ 8,800 | |
Target cash balance | $ 5,500 | $ 5,500 | $ 5,500 | |
Surplus cash or loans needed | $ 14,500 | $ -6,900 | $ 3,700 | |
b] | Loan requirement for December = 0 as the firm has total cash of 400+19600 = $20,000 at the end of the month which is more than the minimum required balance of $5,500. |