|
Cash Budget |
|
|
|
|
|
January |
February |
March |
Quarter |
Beg Cash balance |
64,000 |
30,480 |
33,100 |
64,000 |
Add cash collections |
301,000 |
448,400 |
549,000 |
1,298,400 |
Total Cash available |
365,000 |
478,880 |
582,100 |
1,362,400 |
Less cash disbursements |
|
|
|
|
Purchase of inventory |
229,800 |
297,900 |
248,925 |
776,625 |
Selling and administrative expense |
128,720 |
144,480 |
121,680 |
394,880 |
Purchase of equipment |
|
3,400 |
82,000 |
85,400 |
Cash dividends |
45,000 |
0 |
0 |
45,000 |
Total cash disbursements |
403,520 |
445,780 |
452,605 |
1,301,905 |
Excess (deficiency) of cash |
(38,520) |
33,100 |
129,495 |
60,495 |
Financing: |
|
|
|
|
Borrowings |
69,000 |
0 |
0 |
69,000 |
Repayments |
0 |
0 |
(69,000) |
(69,000) |
Interest |
0 |
0 |
(2,070) |
(2,070) |
Total financing |
69,000 |
|
(71,070) |
(2,070) |
Ending cash balance |
30,480 |
33,100 |
58,425 |
58,425 |
4. |
Prepare an absorption costing income statement for the quarter
ending March 31.
|
|
Income Statement |
|
|
For the Quarter Ended March 31 |
|
|
Sales |
|
|
Cost of Goods sold: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross Margin |
|
|
Selling and administrative expenses: |
|
|
Salaries and wages |
|
|
Advertising |
|
|
Shipping |
|
|
Other expenses |
|
|
|
|
|
|
|
|
|
|
|
Net Operating income |
|
|
interest expense |
|
|
Net Icome |
|
|
5. Prepare a balance sheet as of March 31
Balance sheet |
|
|
March 31 |
|
|
Assets |
|
|
Current assets |
|
|
|
|
|
Total Current assets |
|
|
|
|
|
Current Liabilities |
|
|
|
|
|
Stockholder's Equity |
|
|
Total liablilites and stockholders equity |
|
|
|
|
|
|
|