Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please answer in excel x requirements 1...

please answer in excel X Requirements 1....

60.1K

Verified Solution

Question

Accounting

please answer in excel
image
image
image
image
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.)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students