In: Accounting
Antioch Company makes eBook readers. The company had the following amounts at the beginning of 2018: Cash, $676,000; Raw Materials Inventory, $59,000; Work in Process Inventory, $29,000; Finished Goods Inventory, $61,000; Common Stock, $597,000; and Retained Earnings, $228,000. Antioch experienced the following accounting events during 2018. Other than the adjusting entries for depreciation, assume that all transactions are cash transactions.
Paid $48,000 for raw materials that will be used to make eBook readers.
Placed $102,000 of the raw materials cost into the process of manufacturing eBook readers.
Paid $73,000 for salaries of selling and administrative employees.
Paid $92,000 for wages of production workers.
Paid $93,000 to purchase equipment used in selling and administrative offices.
Recognized depreciation on the office equipment. The equipment was acquired on January 1, 2018. It has a $13,000 salvage value and a eight-year life. The amount of depreciation is computed as [(Cost – salvage) ÷ useful life]. Specifically, ($93,000 – $13,000) ÷ 8 = $10,000.
Paid $126,000 to purchase manufacturing equipment.
Recognized depreciation on the manufacturing equipment. The equipment was acquired on January 1, 2018. It has a $21,000 salvage value and a seven-year life. The amount of depreciation is computed as [(Cost – salvage) ÷ useful life]. Specifically, ($126,000 – $21,000) ÷ 7 = $15,000.
Paid $46,000 for rent and utility costs on the manufacturing facility.
Paid $73,000 for inventory holding expenses for completed eBook readers (rental of warehouse space, salaries of warehouse personnel, and other general storage cost).
Completed and transferred eBook readers that had total cost of $250,000 from work in process inventory to finished goods.
Sold 950 eBook readers for $435,000.
It cost Antioch $199,500 to make the eBook readers sold in Event 13.
Required
Show how these events affect the balance sheet, income statement, and statement of cash flows by recording them in a horizontal financial statements model. (Enter any decreases to account balances and cash outflows with a minus sign. In the Cash Flow column, indicate whether the item is an operating activity (OA), investing activity (IA), or financing activity (FA). If the item is not affected, leave the cell blank.)
ANTIOCH COMPANY | ||||||||||||||||||||||
Financial Statements Model | ||||||||||||||||||||||
Event No. | Assets | = | Stockholders’ Equity | Income Statement | Statement of Cash Flow | |||||||||||||||||
Cash | + | Raw Materials | + | Work in Process Inventory | + | Finished Goods | + | Office Furniture | + | Manufacturing Equipment | = | Common Stock | + | Retained Earnings | Revenue | – | Expense | = | Net Income | |||
676,000 | + | 59,000 | + | 29,000 | + | 61,000 | + | + | = | 597,000 | + | 228,000 | – | = | ||||||||
1. | + | + | + | + | + | = | + | – | = | |||||||||||||
2. | + | + | + | + | + | = | + | – | = | |||||||||||||
3. | + | + | + | + | + | = | + | – | = | |||||||||||||
4...... | + | + | + | + | + | = | + | – | = | |||||||||||||
14. | + | + | + | + | + | = | + | – | = | |||||||||||||
Total | 676,000 | + | 59,000 | + | 29,000 | + | 61,000 | + | 0 | + | 0 | = | 597,000 | + | 228,000 | 0 | – | 0 | = | 0 | 0 |
ANTIOCH COMPANY | |||||||||||||||||||||||
Financial Statements Model | |||||||||||||||||||||||
Event No. | Assets | = | Stockholders’ Equity | Income Statement | Statement of Cash Flow | ||||||||||||||||||
Cash | + | Raw Materials | + | Work in Process Inventory | + | Finished Goods | + | Office Furniture | + | Manufacturing Equipment | = | Common Stock | + | Retained Earnings | Revenue | – | Expense | = | Net Income | ||||
$676000 | + | $59000 | + | $29000 | + | $61000 | + | + | = | $597000 | + | $228000 | - | = | |||||||||
1. | (24000) | + | + | + | + | + | = | + | (24000) | - | 24000 | = | (24000) | (24000) | OA | ||||||||
2. | (48000) | + | 48000 | + | + | + | + | = | + | - | = | (48000) | OA | ||||||||||
3. | + | (102000) | + | 102000 | + | + | + | = | + | - | = | ||||||||||||
4. | (73000) | + | + | + | + | + | = | + | (73000) | - | 73000 | = | (73000) | (73000) | OA | ||||||||
5. | (92000) | + | + | 92000 | + | + | + | = | + | - | = | (92000) | OA | ||||||||||
6. | (93000) | + | + | + | + | 93000 | + | = | + | - | = | (93000) | OA | ||||||||||
7. | + | + | + | + | (10000) | + | = | + | (10000) | - | 10000 | = | (10000) | ||||||||||
8. | (126000) | + | + | + | + | + | 126000 | = | + | - | = | (126000) | IA | ||||||||||
9. | + | + | 15000 | + | + | + | (15000) | = | + | - | = | ||||||||||||
10. | (46000) | + | + | 46000 | + | + | + | = | + | - | = | (46000) | OA | ||||||||||
11. | (73000) | + | + | + | + | + | = | + | (73000) | - | 73000 | = | (73000) | (73000) | OA | ||||||||
12. | + | + | (250000) | + | 250000 | + | + | = | + | - | = | ||||||||||||
13. | 435000 | + | + | + | + | + | = | + | 435000 | 435000 | - | = | 435000 | 435000 | OA | ||||||||
14. | + | + | + | (199500) | + | + | = | + | (199500) | - | 199500 | = | (199500) | ||||||||||
Total | $536000 | + | $5000 | + | $34000 | + | $111500 | + | $83000 | + | $111000 | = | $597000 | + | $283500 | $435000 | - | 379500 | = | 55500 | (140000) | Net cash flow |
NOTE:- For any problem regarding the answer please ask in the comment section.