In: Accounting
Vandals Company has not yet prepared a formal statement of cash flows for the 2020 fiscal year. Comparative balance sheets as of December 31, 2019, and 2020, and a statement of income and retained earnings for the year ended December 31, 2020, are presented below.
|
Vandals Company |
||||||
|
Statement of Income and Retained Earnings |
||||||
|
For The Year Ended December 31, 2020 |
||||||
|
($000 Omitted) |
||||||
|
Sales |
$4,250,000 |
|||||
|
Expenses |
||||||
|
Cost of goods sold |
$765,000 |
|||||
|
Bad debt expense |
$21,250 |
|||||
|
Salaries and benefits |
510,000 |
|||||
|
Heat, light, and power |
255,000 |
|||||
|
Depreciation |
8,925 |
|||||
|
Property taxes |
127,500 |
|||||
|
Patent amortization |
1,275 |
|||||
|
Miscellaneous expenses |
116,688 |
|||||
|
Interest |
77,792 |
|||||
|
Total expenses |
1,883,430 |
|||||
|
Income before income taxes |
2,366,570 |
|||||
|
Income taxes |
637,500 |
|||||
|
Net income |
1,729,070 |
|||||
|
Retained earnings - January 1, 2020 |
318,750 |
|||||
|
2,047,820 |
||||||
|
Cash dividend declared and issued |
12,750 |
|||||
|
Retained earnings - December 31, 2020 |
$2,035,070 |
|||||
|
Vandals Company |
||||||
|
Comparative Balance Sheet |
||||||
|
December 31 |
||||||
|
($000 Omitted) |
||||||
|
Assets |
2020 |
2019 |
||||
|
Current assets |
||||||
|
Cash |
$1,782,960 |
$118,575 |
||||
|
U.S. Treasury notes (Available-for-sale) |
17,000 |
85,000 |
||||
|
Accounts receivable |
221,850 |
136,000 |
||||
|
Allowance for doubtful account |
(12,325) |
(12,750) |
||||
|
Inventory |
23,800 |
29,750 |
||||
|
Total current assets |
2,033,285 |
356,575 |
||||
|
Long-term assets |
||||||
|
Land |
19,125 |
4,250 |
||||
|
Buildings and equipment |
51,000 |
21,250 |
||||
|
Accumulated depreciation |
(21,675) |
(12,750) |
||||
|
Patents (less amortization) |
7,225 |
8,500 |
||||
|
Total long-term assets |
55,675 |
21,250 |
||||
|
Total assets |
$2,088,960 |
$377,825 |
||||
|
Liabilities and Stockholders' Equity |
||||||
|
Current liabilities |
||||||
|
Accounts payable |
$20,400 |
$25,500 |
||||
|
Income taxes payable |
4,080 |
5,100 |
||||
|
Short-term Notes payable |
10,625 |
10,625 |
||||
|
Total current liabilities |
35,105 |
41,225 |
||||
|
Long-term notes payable - due 2020 |
17,000 |
17,000 |
||||
|
Total liabilities |
52,105 |
58,225 |
||||
|
Stockholders' equity |
||||||
|
Common stock outstanding |
1,785 |
850 |
||||
|
Retained earnings |
2,035,070 |
318,750 |
||||
|
Total stockholders' equity |
2,036,855 |
319,600 |
||||
|
Total liabilities and stockholders' equity |
$2,088,960 |
$377,825 |
||||
Instructions:
Prepare a statement of cash flows using the direct method. Changes in accounts receivable and in accounts payable relate to sales and cost of sales. Do not prepare a reconciliation schedule.
| Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
| Workings for direct method | |
| Adjustment of Allowance for doubtful account | Amount $ |
| Opening balance | 12,750.00 |
| Add: Bad debt expense | 21,250.00 |
| Less: Closing balance | 12,325.00 |
| Adjustment of Allowance for doubtful account | 21,675.00 |
| Cash Received from customers | Amount $ |
| Opening Accounts Receivable | 136,000.00 |
| Add: Sales | 4,250,000.00 |
| Less: Closing Accounts Receivable | 221,850.00 |
| Less: Adjustment of Allowance for doubtful account | 21,675.00 |
| Cash Received from customers | 4,142,475.00 |
| Inventory purchased | |
| Cost of goods sold | 765,000.00 |
| Add: Closing Inventory | 23,800.00 |
| Less: Opening Inventory | 29,750.00 |
| Inventory purchased | 759,050.00 |
| Cash paid to suppliers | |
| Opening Accounts Payable | 25,500.00 |
| Add: Purchases | 759,050.00 |
| Less: Closing Accounts Payable | 20,400.00 |
| Cash paid to suppliers | 764,150.00 |
| Expenses paid | |
| Total Expenses | 1,883,430.00 |
| Less: Cost of goods sold | 765,000.00 |
| Less: Depreciation Expense | 8,925.00 |
| Less: Patent amortization | 1,275.00 |
| Less: Bad debt expense | 21,250.00 |
| Expenses paid | 1,086,980.00 |
| Income tax paid | |
| Income tax Expense | 637,500.00 |
| Add: Opening Income tax Payable | 5,100.00 |
| Less: Closing Income tax Payable | 4,080.00 |
| Income tax paid | 638,520.00 |
| Land purchased | |
| Closing balance | 19,125.00 |
| Less: Opening balance | 4,250.00 |
| Land purchased | 14,875.00 |
| Building purchased | |
| Closing balance | 51,000.00 |
| Less: Opening balance | 21,250.00 |
| Building purchased | 29,750.00 |
| Sale of U.S. Treasury notes (Available-for-sale) | |
| Opening balance | 85,000.00 |
| Less: Closing balance | 17,000.00 |
| Sale of U.S. Treasury notes (Available-for-sale) | 68,000.00 |
| Equity issued | |
| Closing balance | 1,785.00 |
| Less: Opening balance | 850.00 |
| Equity issued | 935.00 |
| Clarissa Company | ||
| Cashflow statement | Amount $ | Amount $ |
| Particulars | ||
| Cash flow from operating activities | ||
| Cash Received from customers | 4,142,475.00 | |
| Less: Cash Payments | ||
| To Suppliers | 764,150.00 | |
| Expenses paid | 1,086,980.00 | |
| Income tax paid | 638,520.00 | 2,489,650.00 |
| Net cash provided by operating activities | 1,652,825.00 | |
| Cash flow from investing activities | ||
| Land purchased | (14,875.00) | |
| Building purchased | (29,750.00) | |
| Sale of U.S. Treasury notes (Available-for-sale) | 68,000.00 | |
| Net cash used for investing activities | 23,375.00 | |
| Cash flow from financing activities | ||
| Equity issued | 935.00 | |
| Dividends paid | (12,750.00) | |
| Net cash used for financing activities | (11,815.00) | |
| Net Increase/(Decrease) in cash | 1,664,385.00 | |
| Cash Balance, beginning | 118,575.00 | |
| Cash Balance, ending | 1,782,960.00 |