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
icon
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. 

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
Transcribed Image Text: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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
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…
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