MICROSOFT CORP (MSFT) CashFlowFlag INCOME STATEMENT Fiscal year ends in 2021-06 2020-06 2019-06 2018-06 2017-06 Revenue 168088 143015 125843 110360 89950 Cost of revenue 52232 46078 42910 38353 34261 Gross profit 115856 96937 82933 72007 55689 Operating expenses Research and developmen₤0716 19269 16876 14726 13037 Sales, General and adminis5204e 24709 23098 22223 20020 Restructuring, merger and acquisition 306 Other operating expenses -306 Total operating expenses 45940 43978 39974 36949 33057 Operating income 69916 52959 42959 35058 22632 Interest Expense 2346 2591 2686 2733 2222 Other income (expense) 3532 2668 3415 4149 2739 Income before taxes 71102 53036 43688 36474 23149 Provision for income taxes 9831 8755 4448 19903 1945 Net income from continuing operations 44281 39240 16571 21204 Net income 61271 44281 39240 16571 21204 Net income available to common shareh 39240 16571 21204 Earnings per share Basic 8.12 5.82 5.11 2.15 2.74 Diluted 8.05 5.76 5.06 2.13 2.71 Weighted average shares outstanding Basic 7547 7610 7673 7700 7746 Diluted 7608 7683 7753 7794 7832 EBITDA 85134 68423 58056 49468 34149 MICROSOFT CORP (MSFT) CashFlowFlag BALANCE SHEET Fiscal year ends in 2021-06 2020-06 2019-06 2018-06 2017-06 Assets Current assets Cash Cash and cash equivalents 14224 13576 11356 11946 7663 Short-term investments 116110 122951 122463 121822 125318 Total cash 130334 136527 133819 133768 132981 Receivables 38043 32011 29524 26481 19792 Inventories 2636 1895 2063 2662 2181 Other current assets 13393 11482 10146 6751 4897 Total current assets 184406 181915 175552 169662 159851 Non-current assets Property, plant and equipment Gross property, plant andlaliment 96101 79186 65369 47913 Accumulated Depreciation1351 -43197 -35330 -29223 -24179 Net property, plant and equipment 52904 43856 36146 23734 Equity and other investment 984 2965 2649 1862 6023 Goodwill 49711 43351 42026 35683 35122 Intangible assets 7800 7038 7750 8053 10106 Other long-term assets 15075 13138 14723 7442 6250 Total non-current assets 149373 119396 111004 89186 81235 Total assets 333779 301311 286556 258848 241086 Liabilities and stockholders' equity Liabilities Current liabilities Short-term debt 8072 3749 5516 3998 10121 Accounts payable 15163 12530 9382 8617 7390 Taxes payable 2174 2130 5665 2121 718 Deferred revenues 41525 36000 32676 28905 34102 Other current liabilities 21723 17901 16181 14847 12196 Total current liabilities 88657 72310 69420 58488 64527 Non-current liabilities Long-term debt 50074 59578 66662 72242 76073 Capital leases 9629 7671 6188 5568 Deferred taxes liabilities 198 204 233 541 531 Deferred revenues 2616 3180 4530 3815 10377 Other long-term liabilities 40617 40064 37193 35476 17184 Liabilities Current liabilities Short-term debt 8072 3749 5516 3998 10121 Accounts payable 15163 12530 9382 8617 7390 Taxes payable 2174 2130 5665 2121 718 Deferred revenues 41525 36000 32676 28905 34102 Other current liabilities 21723 17901 16181 14847 12196 Total current liabilities 88657 72310 69420 58488 64527 Non-current liabilities Long-term debt 50074 59578 66662 72242 76073 Capital leases 9629 7671 6188 5568 Deferred taxes liabilities 198 204 233 541 531 Deferred revenues 2616 3180 4530 3815 10377 Other long-term liabilities 40617 40064 37193 35476 17184 Total non-current liabilitie93134 110697 114806 117642 104165 Total liabilities 191791 183007 184226 176130 168692 Stockholders' equity Common stock 83111 80552 78520 71223 69315 Retained earnings 57055 34566 24150 13682 2648 Accumulated other compreHave income186 -340 -2187 431 Total stockholders' equity141988 118304 102330 82718 72394 Total liabilities and stock equity 301311 286556 258848 241086 MICROSOFT CORP (MSFT) Statement of CASH FLOW Fiscal year ends in 2021-06 2020-06 2019-06 2018-06 2017-06 Cash Flows From Operating Activities Net income 61271 44281 39240 16571 21204 Depreciation & amortization686 12796 11682 10261 8778 Investments losses (gains) -219 -792 -2212 -2073 Deferred income taxes -150 -3620 -3534 13040 -3296 Stock based compensation 6118 5289 4652 3940 3266 Change in working capital -936 2148 937 2284 69363 Accounts receivable -6481 -2577 -2812 -3862 -925 Inventory -737 168 597 -465 50 Accounts payable 2798 3018 232 1148 81 Other working capital 3484 1539 2920 5463 70157 Other non-cash items -1249 -57735 Net cash provided by operating activities 0675 52185 43884 39507 Cash Flows From Investing Activities Investments in property, pla62and equip -13925 -11632 -8129 Acquisitions, net -8909 -2521 -2388 -888 -25944 Purchases of investments-62924 -77190 -57697 -137380 -176905 Sales/Maturities of investmб58030 84170 58237 143937 164394 Other investing activities -922 -1241 -98 -197 Net cash used for investingasvities -12223 -15773 -6061 -46781 Cash Flows From Financing Activities Debt issued Debt repayment -3750 -5518 -4000 7183 -10060 44344 -7922 Common stock issued 1693 1343 1142 1002 772 Common stock repurchase2 17385 -22968 -19543 -10721 -11788 Dividend paid -16521 -15137 -13811 -12699 -11845 Other financing activities -2523 -3751 -675 -8295 -5153 Net cash provided by (used8486financing 6tivities -36887 -33590 8408 Effect of exchange rate chang29 -201 -115 50 19 Net change in cash 648 2220 -590 4283 1153 Cash at beginning of perio#3576 11356 11946 7663 6510 Cash at end of period 14224 13576 11356 11946 7663 Free Cash Flow Operating cash flow 76740 60675 52185 43884 39507 Capital expenditure -20622 -15441 -13925 -11632 -8129 Free cash flow 56118 45234 38260 32252 31378
MICROSOFT CORP (MSFT) CashFlowFlag INCOME STATEMENT Fiscal year ends in 2021-06 2020-06 2019-06 2018-06 2017-06 Revenue 168088 143015 125843 110360 89950 Cost of revenue 52232 46078 42910 38353 34261 Gross profit 115856 96937 82933 72007 55689 Operating expenses Research and developmen₤0716 19269 16876 14726 13037 Sales, General and adminis5204e 24709 23098 22223 20020 Restructuring, merger and acquisition 306 Other operating expenses -306 Total operating expenses 45940 43978 39974 36949 33057 Operating income 69916 52959 42959 35058 22632 Interest Expense 2346 2591 2686 2733 2222 Other income (expense) 3532 2668 3415 4149 2739 Income before taxes 71102 53036 43688 36474 23149 Provision for income taxes 9831 8755 4448 19903 1945 Net income from continuing operations 44281 39240 16571 21204 Net income 61271 44281 39240 16571 21204 Net income available to common shareh 39240 16571 21204 Earnings per share Basic 8.12 5.82 5.11 2.15 2.74 Diluted 8.05 5.76 5.06 2.13 2.71 Weighted average shares outstanding Basic 7547 7610 7673 7700 7746 Diluted 7608 7683 7753 7794 7832 EBITDA 85134 68423 58056 49468 34149 MICROSOFT CORP (MSFT) CashFlowFlag BALANCE SHEET Fiscal year ends in 2021-06 2020-06 2019-06 2018-06 2017-06 Assets Current assets Cash Cash and cash equivalents 14224 13576 11356 11946 7663 Short-term investments 116110 122951 122463 121822 125318 Total cash 130334 136527 133819 133768 132981 Receivables 38043 32011 29524 26481 19792 Inventories 2636 1895 2063 2662 2181 Other current assets 13393 11482 10146 6751 4897 Total current assets 184406 181915 175552 169662 159851 Non-current assets Property, plant and equipment Gross property, plant andlaliment 96101 79186 65369 47913 Accumulated Depreciation1351 -43197 -35330 -29223 -24179 Net property, plant and equipment 52904 43856 36146 23734 Equity and other investment 984 2965 2649 1862 6023 Goodwill 49711 43351 42026 35683 35122 Intangible assets 7800 7038 7750 8053 10106 Other long-term assets 15075 13138 14723 7442 6250 Total non-current assets 149373 119396 111004 89186 81235 Total assets 333779 301311 286556 258848 241086 Liabilities and stockholders' equity Liabilities Current liabilities Short-term debt 8072 3749 5516 3998 10121 Accounts payable 15163 12530 9382 8617 7390 Taxes payable 2174 2130 5665 2121 718 Deferred revenues 41525 36000 32676 28905 34102 Other current liabilities 21723 17901 16181 14847 12196 Total current liabilities 88657 72310 69420 58488 64527 Non-current liabilities Long-term debt 50074 59578 66662 72242 76073 Capital leases 9629 7671 6188 5568 Deferred taxes liabilities 198 204 233 541 531 Deferred revenues 2616 3180 4530 3815 10377 Other long-term liabilities 40617 40064 37193 35476 17184 Liabilities Current liabilities Short-term debt 8072 3749 5516 3998 10121 Accounts payable 15163 12530 9382 8617 7390 Taxes payable 2174 2130 5665 2121 718 Deferred revenues 41525 36000 32676 28905 34102 Other current liabilities 21723 17901 16181 14847 12196 Total current liabilities 88657 72310 69420 58488 64527 Non-current liabilities Long-term debt 50074 59578 66662 72242 76073 Capital leases 9629 7671 6188 5568 Deferred taxes liabilities 198 204 233 541 531 Deferred revenues 2616 3180 4530 3815 10377 Other long-term liabilities 40617 40064 37193 35476 17184 Total non-current liabilitie93134 110697 114806 117642 104165 Total liabilities 191791 183007 184226 176130 168692 Stockholders' equity Common stock 83111 80552 78520 71223 69315 Retained earnings 57055 34566 24150 13682 2648 Accumulated other compreHave income186 -340 -2187 431 Total stockholders' equity141988 118304 102330 82718 72394 Total liabilities and stock equity 301311 286556 258848 241086 MICROSOFT CORP (MSFT) Statement of CASH FLOW Fiscal year ends in 2021-06 2020-06 2019-06 2018-06 2017-06 Cash Flows From Operating Activities Net income 61271 44281 39240 16571 21204 Depreciation & amortization686 12796 11682 10261 8778 Investments losses (gains) -219 -792 -2212 -2073 Deferred income taxes -150 -3620 -3534 13040 -3296 Stock based compensation 6118 5289 4652 3940 3266 Change in working capital -936 2148 937 2284 69363 Accounts receivable -6481 -2577 -2812 -3862 -925 Inventory -737 168 597 -465 50 Accounts payable 2798 3018 232 1148 81 Other working capital 3484 1539 2920 5463 70157 Other non-cash items -1249 -57735 Net cash provided by operating activities 0675 52185 43884 39507 Cash Flows From Investing Activities Investments in property, pla62and equip -13925 -11632 -8129 Acquisitions, net -8909 -2521 -2388 -888 -25944 Purchases of investments-62924 -77190 -57697 -137380 -176905 Sales/Maturities of investmб58030 84170 58237 143937 164394 Other investing activities -922 -1241 -98 -197 Net cash used for investingasvities -12223 -15773 -6061 -46781 Cash Flows From Financing Activities Debt issued Debt repayment -3750 -5518 -4000 7183 -10060 44344 -7922 Common stock issued 1693 1343 1142 1002 772 Common stock repurchase2 17385 -22968 -19543 -10721 -11788 Dividend paid -16521 -15137 -13811 -12699 -11845 Other financing activities -2523 -3751 -675 -8295 -5153 Net cash provided by (used8486financing 6tivities -36887 -33590 8408 Effect of exchange rate chang29 -201 -115 50 19 Net change in cash 648 2220 -590 4283 1153 Cash at beginning of perio#3576 11356 11946 7663 6510 Cash at end of period 14224 13576 11356 11946 7663 Free Cash Flow Operating cash flow 76740 60675 52185 43884 39507 Capital expenditure -20622 -15441 -13925 -11632 -8129 Free cash flow 56118 45234 38260 32252 31378
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
What is Microsoft's market value in billion dollars for fiscal year ending in June 2020? What is the market-to-book ratio for MSFT for fiscal year ending in June 2021, 2020. What is the ROE in percentage for MSFT for fiscal year ending in June 2021, 2020.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education