Based on additional information added in modules 2 and 3, please use the informa

Question

Based on additional information added in modules 2 and 3, please use the information below to make a statement of cash flows. •The beginning cash balance is $30,000. •Use the Net Income from Module 2. •Use depreciation expense of Module 1. •During the year 14, Inventory increases by $42,500. •During the year 14, Land increases by $400,000. •During the year 14, Long-Term Debts increase by $360,000. •During the year 14, the company made a secondary offering of stock and raised an additional $180,000 which includes $150,000 of Paid-in Capital. •During the year 14, the company had paid $15,000 in dividends. I need this in excel form please.

Explanation / Answer

Cash flow Statement for the period ending Indirect Method Details Amt $ Cash Flow From Operating Activities Net Income           150,525 Add Depreciation             24,350 Increased Inventory           (42,500) Total Cash Flow From Operating Activities           132,375 Cash Flow From Investing Activities Cash outflow from purchase of Land        (400,000) Total Cash Flow From Investing Activities        (400,000) Cash Flow From Financing Activities Cash received from issue of Common stock           180,000 Cash Received from Loan(LT Debt)           360,000 Cash Paid for Dividend Payment           (15,000) TotalCash Flow From Financing Activities           525,000 Total Cash Flow from Operating. Investing and Financing Activities           257,375 Intial Cash Balance             30,000 Net Effect of Cash Flow during the period           257,375 Closing Cash Balance           287,375

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.