Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer in excel X Requirements 1. Prepare the statement of cash flows of Morgensen Educational Supply for the year ended December 31, 2018. Use
please answer in excel
X Requirements 1. Prepare the statement of cash flows of Morgensen Educational Supply for the year ended December 31, 2018. Use the indirect method to report cash flows from operating activities. 2. Evaluate Morgensen's cash flows for the year. Mention all three categories of cash flows, and give the reason for your evaluation. 3. If Morgensen plans similar activity for 2019, what is its expected free cash flow? 2018 2017 Current Assets: Cash $ 18,500 79,500 $ 14,900 63,000 Accounts Receivable Merchandise Inventory 21,300 59,800 Current Liabilities: Accounts Payable 29,100 28,600 Accrued Liabilities 10,400 11,800 Data table Payment of cash dividends $ 17200 $ 17,400 Depreciation expense Purchase of building with cash 55,100 104,000 Purchase of equipment with cash Issuance of long-term notes payable to borrow cash Net income 67,600 44,000 106,000 Issuance of common stock for cash The comparative balance sheet of Morgensen Educational Supply at December 31, 2018, reported the following: (Click the icon to view the comparative balance sheet.) Morgensen's transactions during 2018 included the following: Click the icon to view the transactions.) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started