Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following financial data is for Microsoft (FY2018 and FY2017). Given the above financial data, calculate: a.) net working capital for FY2018, b.) year over

The following financial data is for Microsoft (FY2018 and FY2017).

image text in transcribed

Given the above financial data, calculate:

a.) net working capital for FY2018, b.) year over year change net working capital, c). cash flow from assets for FY2018, d.) total cash flows from operations as it would appear on the statement of cash flows for FY2018, e). total cash flows from investing activities as it would appear on the statement of cash flows for FY2018 (negative number), and e). total cash flows from financing activities as it would appear on the statement of cash flows for FY2018.

Simplified Statements for MSFT Income Statement Sales COGS SGA Depreciation EBIT Interest Expense EBT Taxes Net Income Dividends FY2018 110,360 38,353 36,949 14,410 20,648 2,733 17,915 3,583 14,332 5,916 Balance Sheet Cash Acct. Receivable Inventory Other Current Assets Net Fixed Assets Total Assets FY2017 FY2018 132,981 133,768 19,792 26,481 2,1812,662 4,897 6,751 81,235 89,186 241,086 258,848 Acct. Payable Long Term Debt Common Stock Retained Earnings Total Liab. And Equity 7,390 161,302 69,315 3,079 241,086 8,617 167,513 71,223 11,495 258,848 Simplified Statements for MSFT Income Statement Sales COGS SGA Depreciation EBIT Interest Expense EBT Taxes Net Income Dividends FY2018 110,360 38,353 36,949 14,410 20,648 2,733 17,915 3,583 14,332 5,916 Balance Sheet Cash Acct. Receivable Inventory Other Current Assets Net Fixed Assets Total Assets FY2017 FY2018 132,981 133,768 19,792 26,481 2,1812,662 4,897 6,751 81,235 89,186 241,086 258,848 Acct. Payable Long Term Debt Common Stock Retained Earnings Total Liab. And Equity 7,390 161,302 69,315 3,079 241,086 8,617 167,513 71,223 11,495 258,848

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Finance Financial Management And Investment Management

Authors: Pamela P. Drake, Frank J. Fabozzi, Francesco A. Fabozzi

1st Edition

9811239657, 978-9811239656

More Books

Students also viewed these Finance questions