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.