In: Accounting
A comparative balance sheet for Party Corporation is presented below.
|
Party Corporation |
|||
|
Comparative Balance Sheets |
|||
|
31-Dec |
|||
|
2019 |
2018 |
||
|
Cash |
$18,700 |
$22,700 |
|
|
Accounts receivable |
$24,700 |
$22,300 |
|
|
Investments |
$25,000 |
$16,000 |
|
|
Equipment |
$59,000 |
$70,000 |
|
|
Accumulated depreciation |
($14,500) |
($10,000) |
|
|
Total |
$112,900 |
$121,000 |
|
|
Accounts payable |
$13,600 |
$11,100 |
|
|
Bonds payable |
$6,000 |
$30,000 |
|
|
Common stock |
$50,000 |
$45,000 |
|
|
Retained earnings |
$43,300 |
$34,900 |
|
|
Total |
$112,900 |
$121,000 |
Additional information:
1. Net income for 2019 was $17,700; Dividends declared and paid were $9,300.
2. Equipment which cost $11,000 and had accumulated depreciation of $2,000 was sold for $4,000.
Using an excel spreadsheet, prepare a statement of cash flows for 2019 using the indirect method. Show your work.
Answer:
Party Corporation
Statement of Cash Flow for the year ended 2019
| Particulars | (Amount in $) | |
| Cash flow from Operating Activities: | ||
| Net Income during the Year | 17700 | |
| Adjustments: | ||
| Add: Depreciation (14500+2000-10000) | 6500 | |
| Add: Loss on Sale of Equipment | 5000 | |
| Operating profit before working capital changes: | ||
| Less: Increase in Accounts Receivable | (2400) | |
| Add: Increase in Accounts Payable | 2500 | |
| Less: Decrease in Bonds Payable | (24000) | |
| Net Cash from Operating Activities | 5300 | |
| Cash Flow from Investing Activities: | ||
| Purchase of Investment | (9000) | |
| Sale of Equipment | 4000 | |
| Net cash flow from Investing Activities | (5000) | |
| Cash flow from Financing Activities: | ||
| Dividend Paid | (9300) | |
| Issue of Common Stock | 5000 | |
| Net cash flow from Financing Activities: | (4300) | |
| Net Increase/(Decrease) in cash & cash equivalent | (4000) | |
| Cash & Cash Equivalent at the beginning of the year | 22700 | |
| Cash & Cash Equivalent at the Closing of the year | 18700 |
Note: Assuming that Bond Payable is for the short term & hence considered as current liabilities.