In: Accounting
The following information is provided for Sunland’s Chocolate Company:
SUNLAND CHOCOLATE COMPANY Balance Sheet May 31 |
||||||
Assets | 2021 | 2020 | ||||
Cash | $29,425 | $46,500 | ||||
Accounts receivable | 88,300 | 78,500 | ||||
Inventory | 183,000 | 159,500 | ||||
Prepaid expenses | 5,800 | 7,300 | ||||
Land | 134,500 | 79,000 | ||||
Equipment | 318,000 | 198,000 | ||||
Accumulated depreciation—equipment | (76,200 | ) | (39,500 | ) | ||
Total assets | $682,825 | $529,300 | ||||
Liabilities and Shareholders’ Equity | ||||||
Accounts payable | $42,700 | $39,500 | ||||
Dividends payable | 7,300 | 5,800 | ||||
Income taxes payable | 3,000 | 6,800 | ||||
Mortgage payable | 130,000 | 79,500 | ||||
Common shares | 218,000 | 165,500 | ||||
Retained earnings | 281,825 | 232,200 | ||||
Total liabilities and shareholders’ equity | $682,825 | $529,300 |
Additional Information: | ||
1. | Profit for 2021 was $112,125. | |
2. | Common shares were issued for $52,500. | |
3. | Land with a cost of $52,500 was sold at a loss of $19,800. | |
4. | Purchased land with a cost of $108,000 with a $57,500 down payment and financed the remainder with a mortgage note payable. | |
5. | No equipment was sold during 2021. | |
6. | Net sales for the year were $674,600. | |
7. | Cost of goods sold for the year was $400,800. | |
8. | Operating costs, including depreciation expense, were $98,700. | |
9. | Interest expense was $5,800. | |
10. | Income tax expense was $37,375. | |
11. | Accounts payable is used for merchandise purchases. |
prepare a cash flow statement for the year using the direct
method. (Show amounts that decrease cash flow with
either a - sign e.g. -15,000 or in parenthesis e.g.
(15,000).)
Note X: Land with a cost of $ was purchased by paying $ cash and issuing a mortgage note payable for $ .
Cash flows from operating activities: | ||||||
Cash Inflows: | ||||||
From customers | $ 664,800.00 | |||||
Cash Outflows: | ||||||
To suppliers of goods | $ (421,100.00) | |||||
For Interest | $ (5,800.00) | |||||
For Other Expense | $ (60,500.00) | |||||
For Income Tax | $ (41,175.00) | |||||
Net cash flow from operating activities | $ 136,225.00 | |||||
Cash flows from investing activities: | ||||||
Sale of land | $ 32,700.00 | |||||
Equipment purchased | $ (120,000.00) | |||||
Land Purchased | $ (57,500.00) | |||||
Net cash flow from investing activities | $ (144,800.00) | |||||
Cash flows from financing activities: | ||||||
Common Stock Issued | $ 52,500.00 | |||||
Dividend Paid | $ (61,000.00) | |||||
Net cash flow from financing activities | $ (8,500.00) | |||||
Net cash flow from all activities | $ (17,075.00) | |||||
Add: | Beginning Cash Balance | $ 46,500.00 | ||||
Ending Cash Balance | $ 29,425.00 |
Workings:
Cash Receipts from Customers | |||||
Net Sales | $ 674,600.00 | ||||
Add: | Beginning A/R | $ 78,500.00 | |||
Less: | Ending A/R | $ 88,300.00 | |||
$ 664,800.00 | |||||
Cash Payments to Suppliers | |||||
Cost of Goods Sold | $ 400,800.00 | ||||
Add: | Ending Inventory | $ 183,000.00 | |||
Less: | Beginning Inventory | $ 159,500.00 | |||
Add: | Beginning A/P | $ 39,500.00 | |||
Less: | Ending A/P | $ 42,700.00 | |||
$ 421,100.00 |
Interest Payments | |||||
Beginning Interest Payable | |||||
Less: | Ending Interest Payable | ||||
Add: | Interest Expense | $ 5,800.00 | |||
$ 5,800.00 | |||||
Other Expense | |||||
Operating Expense | $ 62,000.00 | ($ 98700 - $ 36700) | |||
Add: | Ending Prepaid | $ 5,800.00 | |||
Less: | Beginning Prepaid | $ 7,300.00 | |||
$ 60,500.00 |
Depreciation for the year = | Ending Balance of Accumu. Dep - Beginning Balance of Accu. Dep | ||
= | $ 76200 - $ 39500 | ||
= | $ 36,700.00 |
Income Tax Payments | ||||
Beginning Income Tax Payable | $ 6,800.00 | |||
Less: | Ending Income Tax Payable | $ 3,000.00 | ||
Add: | Income Tax Expense | $ 37,375.00 | ||
$ 41,175.00 |
Dividend | ||||
Opening balance of Retained Earnings | $ 232,200.00 | |||
Add: | Net Income | $ 112,125.00 | ||
Less: | Closing balance of Retained Earnings | $(281,825.00) | ||
Dividend Declared | $ 62,500.00 | |||
Add: | Beginning Dividend Payable | $ 5,800.00 | ||
Less: | Ending Dividend Payable | $ (7,300.00) | ||
Dividend Paid | $ 61,000.00 |