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 |