Answer:
Cash flow from all activities -$18,100
Cash at the beginning of the year $84,500
Cash at the end of year $66,400
Explanation:
Preparation of a complete statement of cash flows using a spreadsheet using the indirect method.
FORTEN COMPANY
Statement of Cash Flows
For the Year ended December 31
Cash Flow from Operating Activities:
Net Income $110,575
Adjustments to reconcile net income to cash flow from operating activities:
Depreciation $31,750
Loss on sale of Equipment $16,125
Increase in Accounts Receivables -$20,755
($61625 - $82380)
Increase in Inventory -$29,356
($262800-292156)
Decrease in Prepaid Expenses $795
($2115-1320)
Decrease In Accounts Payable -$67,034
($64141 - $131175)
Increase in Short term note payable $5,100
($13300-8200)
Total Adjustments -$63,375
Net Cash Flow From Operating Activities (A) $47,200
Cash Flow from Investing Activities:
Cash Received from sale of Equipment $22,625
Purchase of Equipment (In cash) -$52,000
Net Cash Flow From Investing Activities (B) -$29,375
($22,625-$52,000)
Cash Flow from Financing Activities:
Repayment of Long Term Note Payable -$55,625
Cash received from issue of common stock $72,000 (3600*$20)
Dividend paid -$52,300
Net Cash Flow From Financing Activities (C) -$35,925
Total Cash flow from all activities
(A+B+C) -$18,100
($47,200+-$29,375+-$35,925)
Cash at the beginning of the year $84,500
Cash at the end of year $66,400
($84,500-$18,100)
Therefore The complete statement of cash flows using a spreadsheet using the indirect method will be :
Cash flow from all activities -$18,100
Cash at the beginning of the year $84,500
Cash at the end of year $66,400