Table 30.10 lists data from the budget of Ritewell Publishers. Half the company sales are for cash on the nail; the other half are paid for with a one-month delay. The company pays all its credit purchases with a one-month delay. Credit purchases in January were $30, and total sales in January were $180. Complete the cash budget in Table 30.11.
| February | March | April |
Total sales | 200 | 220 | 180 |
Purchases of materials | | |
|
For cash | 70 | 80 | 60 |
For credit | 40 | 30 | 40 |
Other expenses | 30 | 30 | 30 |
Taxes, interest, and dividends | 10 | 10 | 10 |
Capital investment | 100 | 0 | 0 |
|
|
|
|
|
Sources of cash: | February | March | April |
Collections on cash sales |
|
|
|
Collections on accounts receivable |
|
|
Total sources of cash |
|
|
|
|
Uses of cash: |
|
|
|
Payments of accounts payable |
|
|
|
Cash purchases of materials |
|
|
|
Other expenses |
|
|
|
Capital expenditures |
|
|
|
Taxes, interest, and dividends |
|
|
|
Total uses of cash |
|
|
|
|
Net cash inflow |
|
|
|
|
Cash at start of period | 100 |
|
|
+Net cash inflow |
|
|
|
=Cash at end of period |
|
|
|
+Minimum operating cash balance | 100 | 100 | 100 |
=Cumulative short-term financing required |
|
Current assets: | Current liabilities: |
Cash | 4 | Bank loans | 4 |
Marketable securities | 2 | Accounts payable | 15 |
Inventory | 20 | Total current liabilities | 19 |
Accounts receivable | 22 |
|
|
Total current assets | 48 | Long-term debt | 5 |
|
| Net worth (equity and retained earnings) | 60 |
Fixed assets: |
|
|
Gross investment | 50 |
|
|
Less depreciation | 14 |
|
|
Net fixed assets | 36 | Total liabilities |
Total assets | 84 | and net worth | 84 |