Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

These are three screenshots for the Microsoft company income statement, balance sheet, cash flow statement. calculate the following: Gross Profit, Operating Profit, Net Income and

image text in transcribedimage text in transcribedimage text in transcribed

These are three screenshots for the Microsoft company income statement, balance sheet, cash flow statement. calculate the following:

Gross Profit, Operating Profit, Net Income and Free Cash Flow (FCF), Cash Coverage Ratio, Current Ratio, Quick ratio, Total debt ratio, Debt-equity ratio, Total asset turnover

Microsoft Consolidated Income Statement Annual Data Millions of US $ except per share data 6/30/20 6/30/19 6/30/18 6/30/17 6/30/16 6/30/15 6/30/14 6/30/13 $143,015 $46,078 $96,937 $19,269 $24,709 $125,843 $42,910 $82,933 $16,876 $23,098 $110,360 $38,353 $72,007 $14,726 $22,223 $96,571 $34,261 $62,310 $13,037 $19,942 $91,154 $32,780 $58,374 $11,988 $19,198 $93,580 $33,038 $60,542 $12,046 $20,324 $86,833 $27,078 $59,755 $11,381 $20,488 $77,849 $20,385 $57,464 $10,411 $20,289 Revenue Cost Of Goods Sold Gross Profit Research And Development Expenses selling-general-administrative-expenses Other Operating Income Operating Expenses Operating Income Total Non-Operating Income Pre-Tax Income Income Taxes Income After Taxes Other Income Income From Continuous Operations Income From Discontinued Operations Net Income EBITDA EBIT Basic Shares Outstanding Shares Outstanding Basic EPS EPS-Earnign per share $90,056 $52,959 $77 $53,036 $8,755 $44,281 $82,884 $42,959 $729 $43,688 $4,448 $39,240 $75,302 $35,058 $1,416 $36,474 $19,903 $16,571 $67,546 $29,025 $876 $29,901 $4,412 $25,489 $65,076 $26,078 -$439 $25,639 $5,100 $20,539 $75,419 $18,161 $346 $18,507 $6,314 $12,193 $59,074 $27,759 $61 $27,820 $5,746 $22,074 $51,085 $26,764 $288 $27,052 $5,189 $21,863 $44,281 $39,240 $16,571 $25,489 $20,539 $12,193 $22,074 $21,863 $44,281 $65,755 $52,959 $7,610 $7,683 $6 $6 $39,240 $54,641 $42,959 $7,673 $7,753 $5 $5 $16,571 $45,319 $35,058 $7,700 $7,794 $2 $2 $25,489 $37,803 $29,025 $7,746 $7,832 $3 $3 $20,539 $33,330 $26,078 $7,925 $8,013 $3 $3 $12,193 $31,616 $18,161 $8,177 $8,254 $1 $1 $22,074 $32,971 $27,759 $8,299 $8,399 $3 $3 $21,863 $30,519 $26,764 $8,375 $8,470 $3 $3 Microsoft Balance Sheet Annual Data | Millions of US $ except per share data 6/30/20 6/30/19 6/30/18 6/30/17 6/30/16 6/30/15 6/30/14 6/30/13 $136,527 $32,011 $1,895 $133,819 $29,524 $2,063 $133,768 $26,481 $2,662 $132,981 $22,431 $2,181 $113,240 $18,277 $2,251 $96,526 $17,908 $2,902 $85,709 $19,544 $2,660 $77,022 $17,486 $1,938 Cash On Hand Receivables Inventory Pre-Paid Expenses Other Current Assets Total Current Assets Property, plant, And Equipment Long-Term Investments Goodwill And Intangible Assets Other Long-Term Assets Total Long-Term Assets Total Assets Total Current Liabilities Long Term Debt Other Non-Current Liabilities Total Long Term Liabilities Total Liabilities Common Stock Net Retained Earnings (Accumulated Deficit) Comprehensive Income Other Share Holders Equity Share Holder Equity Total Liabilities And Share Holders Equity $11,482 $181,915 $44,151 $2,965 $50,389 $21,891 $119,396 $301,311 $72,310 $67,249 $40,064 $110,697 $183,007 $80,552 $34,566 $3,186 $10,146 $175,552 $36,477 $2,649 $49,776 $22,102 $111,004 $286,556 $69,420 $72,850 $37,193 $114,806 $184,226 $78,520 $24,150 -$340 $6,751 $169,662 $29,460 $1,862 $43,736 $14,128 $89,186 $258,848 $58,488 $77,810 $35,476 $117,642 $176,130 $71,223 $13,682 -$2,187 $5,103 $162,696 $23,734 $6,023 $45,228 $12,631 $87,616 $250,312 $55,745 $81,445 $17,034 $106,856 $162,601 $69,315 $17,769 $627 $5,892 $139,660 $18,356 $10,431 $21,605 $3,416 $53,808 $193,468 $59,357 $40,557 $13,640 $62,114 $121,471 $68,178 $2,282 $1,537 $5,461 $122,797 $14,731 $12,053 $21,774 $3,117 $51,675 $174,472 $49,647 $27,808 $13,544 $44,742 $94,389 $68,465 $9,096 $2,522 $4,392 $114,246 $13,011 $14,597 $27,108 $3,422 $58,138 $172,384 $45,625 $20,645 $11,594 $36,975 $82,600 $68,366 $17,710 $3,708 $3,388 $101,466 $9,991 $10,844 $17,738 $2,392 $40,965 $142,431 $37,417 $12,601 $10,000 $26,070 $63,487 $67,306 $9,895 $1,743 $118,304 $301,311 $102,330 $286,556 $82,718 $258,848 $87,711 $250,312 $71,997 $193,468 $80,083 $174,472 $89,784 $172,384 $78,944 $142,431 6/30/17 6/30/13 $11,682 $13,455 $7,489 $21,863 $3,755 $4,590 *4,590 $8,345 10,549 $1,807 OU! $802 $537 $697 $1,375 $28,833 $4,257 $624 $ Microsoft Cash Flow Statement Annual Data Millions of US $ except per share data 6/30/20 6/30/19 6/30/18 6/30/16 6/30/15 6/30/14 Net Income/Loss $44,281 $39,240 $16,571 $25,489 $20,539 $12,193 $22,074 Total Depreciation And Amortization - Cash Flow $12,796 $10,261 $8,778 $7,252 $5,212 Other Non-Cash Items $7,293 $1,859 $2.507 $4,184 400 Total Non-Cash Items $4,592 $2,507 $20,089 20.00% $13,541 $12,768 $12,962 12.10 $14,741 Change in Accounts Receivable $15,962 14.14 $2,577 14:04 $2,812 $3,862 2014 $1,216 3,004 $562 Change In Inventories $1,456 $1,120 $168 $597 $465 $50 $600 $272 $161 Change in Accounts Payable $3,018 $232 $1,148 $81 $88 10 $ 1,054 $473 Change In Assets/Liabilities $673 $1,542 $459 $349 -$2,907 $1,383 Total Change In Assets/Liabilities $1,432 $3,695 $596 $14.545 $1,056 $1,955 $1,513 Cash Flow From Operating Activities $60,675 $52,185 $43,884 $39,507 $33,325 $29,668 $32,502 Net Change In Property, plant, And Equipment $15,441 -$13,925 $11,632 -$8,129 -$8,343 -$5,944 Net Change In Intangible Assets $5,485 Net Acquisitions/Divestitures $2,521 $2,388 -$888 $25,944 $1,393 -$3,723 $5,937 Net Change In Short-term Investments Net Change In Long-Term Investments $6,980 $540 $6,557 $12,511 $14,417 $12,868 $7,324 Net Change In Investments - Total $6,980 $540 $6,557 $12,511 $14,417 $12,868 $7,324 Investing Activities - Other $1,241 $98 $197 $203 $466 $87 Cash Flow From Investing Activities MIT $12,223 $15,773 $6,061 $46,781 -$23,950 -$23,001 $18,833 . Net Long-Term Debt $5,518 $4,000 $2,877 $36,422 $11,088 12.02 30 Net Current Debt $9,180 vo . $6,462 $7,324 0.04 $4,963 $7,195 $4,481 $500 Debt Issuance/Retirement Net-Total $5,518 $4,000 * -$10,201 $31,459 $18,283 $13,661 --- $6,962 Net Common Equity Issued/Repurchased $21,625 -$18,401 $9,719 $11,016 $15,301 $13,809 $6,709 Net Total Equity Issued/Repurchased $21,625 $18,401 $9,719 $11,016 $ 15,301 $13,809 -$6,709 Total Common And Preferred Stock Dividends Paid $15,137 $ 13,811 $12,699 $11,845 -$11,006 -$9,882 $8,879 Financial Activities - Other $3,751 -$675 -$971 -$190 -$369 $362 -$39 Cash Flow From Financial Activities -$46,031 -$36,887 -$33,590 $8,408 -$8,393 $9,668 $8,665 Net Cash Flow $2,220 $1,153 $915 $3,074 $4,865 Stock-Based Compensation $5,289 $4,652 $3,266 $2,668 $2,574 $2,446 Common Stock Dividends Paid $15,137 $13,811 $12,699 $11,845 $11,006 $9,882 -$8,879 $1,584 $17,802 $17,802 $168 $23,811 $3,537 $3,537 $4,429 $4,429 $7,455 $199 -$8,148 $590 $4,283 $3,134 $3,940 $2,406 $7,455 Microsoft Consolidated Income Statement Annual Data Millions of US $ except per share data 6/30/20 6/30/19 6/30/18 6/30/17 6/30/16 6/30/15 6/30/14 6/30/13 $143,015 $46,078 $96,937 $19,269 $24,709 $125,843 $42,910 $82,933 $16,876 $23,098 $110,360 $38,353 $72,007 $14,726 $22,223 $96,571 $34,261 $62,310 $13,037 $19,942 $91,154 $32,780 $58,374 $11,988 $19,198 $93,580 $33,038 $60,542 $12,046 $20,324 $86,833 $27,078 $59,755 $11,381 $20,488 $77,849 $20,385 $57,464 $10,411 $20,289 Revenue Cost Of Goods Sold Gross Profit Research And Development Expenses selling-general-administrative-expenses Other Operating Income Operating Expenses Operating Income Total Non-Operating Income Pre-Tax Income Income Taxes Income After Taxes Other Income Income From Continuous Operations Income From Discontinued Operations Net Income EBITDA EBIT Basic Shares Outstanding Shares Outstanding Basic EPS EPS-Earnign per share $90,056 $52,959 $77 $53,036 $8,755 $44,281 $82,884 $42,959 $729 $43,688 $4,448 $39,240 $75,302 $35,058 $1,416 $36,474 $19,903 $16,571 $67,546 $29,025 $876 $29,901 $4,412 $25,489 $65,076 $26,078 -$439 $25,639 $5,100 $20,539 $75,419 $18,161 $346 $18,507 $6,314 $12,193 $59,074 $27,759 $61 $27,820 $5,746 $22,074 $51,085 $26,764 $288 $27,052 $5,189 $21,863 $44,281 $39,240 $16,571 $25,489 $20,539 $12,193 $22,074 $21,863 $44,281 $65,755 $52,959 $7,610 $7,683 $6 $6 $39,240 $54,641 $42,959 $7,673 $7,753 $5 $5 $16,571 $45,319 $35,058 $7,700 $7,794 $2 $2 $25,489 $37,803 $29,025 $7,746 $7,832 $3 $3 $20,539 $33,330 $26,078 $7,925 $8,013 $3 $3 $12,193 $31,616 $18,161 $8,177 $8,254 $1 $1 $22,074 $32,971 $27,759 $8,299 $8,399 $3 $3 $21,863 $30,519 $26,764 $8,375 $8,470 $3 $3 Microsoft Balance Sheet Annual Data | Millions of US $ except per share data 6/30/20 6/30/19 6/30/18 6/30/17 6/30/16 6/30/15 6/30/14 6/30/13 $136,527 $32,011 $1,895 $133,819 $29,524 $2,063 $133,768 $26,481 $2,662 $132,981 $22,431 $2,181 $113,240 $18,277 $2,251 $96,526 $17,908 $2,902 $85,709 $19,544 $2,660 $77,022 $17,486 $1,938 Cash On Hand Receivables Inventory Pre-Paid Expenses Other Current Assets Total Current Assets Property, plant, And Equipment Long-Term Investments Goodwill And Intangible Assets Other Long-Term Assets Total Long-Term Assets Total Assets Total Current Liabilities Long Term Debt Other Non-Current Liabilities Total Long Term Liabilities Total Liabilities Common Stock Net Retained Earnings (Accumulated Deficit) Comprehensive Income Other Share Holders Equity Share Holder Equity Total Liabilities And Share Holders Equity $11,482 $181,915 $44,151 $2,965 $50,389 $21,891 $119,396 $301,311 $72,310 $67,249 $40,064 $110,697 $183,007 $80,552 $34,566 $3,186 $10,146 $175,552 $36,477 $2,649 $49,776 $22,102 $111,004 $286,556 $69,420 $72,850 $37,193 $114,806 $184,226 $78,520 $24,150 -$340 $6,751 $169,662 $29,460 $1,862 $43,736 $14,128 $89,186 $258,848 $58,488 $77,810 $35,476 $117,642 $176,130 $71,223 $13,682 -$2,187 $5,103 $162,696 $23,734 $6,023 $45,228 $12,631 $87,616 $250,312 $55,745 $81,445 $17,034 $106,856 $162,601 $69,315 $17,769 $627 $5,892 $139,660 $18,356 $10,431 $21,605 $3,416 $53,808 $193,468 $59,357 $40,557 $13,640 $62,114 $121,471 $68,178 $2,282 $1,537 $5,461 $122,797 $14,731 $12,053 $21,774 $3,117 $51,675 $174,472 $49,647 $27,808 $13,544 $44,742 $94,389 $68,465 $9,096 $2,522 $4,392 $114,246 $13,011 $14,597 $27,108 $3,422 $58,138 $172,384 $45,625 $20,645 $11,594 $36,975 $82,600 $68,366 $17,710 $3,708 $3,388 $101,466 $9,991 $10,844 $17,738 $2,392 $40,965 $142,431 $37,417 $12,601 $10,000 $26,070 $63,487 $67,306 $9,895 $1,743 $118,304 $301,311 $102,330 $286,556 $82,718 $258,848 $87,711 $250,312 $71,997 $193,468 $80,083 $174,472 $89,784 $172,384 $78,944 $142,431 6/30/17 6/30/13 $11,682 $13,455 $7,489 $21,863 $3,755 $4,590 *4,590 $8,345 10,549 $1,807 OU! $802 $537 $697 $1,375 $28,833 $4,257 $624 $ Microsoft Cash Flow Statement Annual Data Millions of US $ except per share data 6/30/20 6/30/19 6/30/18 6/30/16 6/30/15 6/30/14 Net Income/Loss $44,281 $39,240 $16,571 $25,489 $20,539 $12,193 $22,074 Total Depreciation And Amortization - Cash Flow $12,796 $10,261 $8,778 $7,252 $5,212 Other Non-Cash Items $7,293 $1,859 $2.507 $4,184 400 Total Non-Cash Items $4,592 $2,507 $20,089 20.00% $13,541 $12,768 $12,962 12.10 $14,741 Change in Accounts Receivable $15,962 14.14 $2,577 14:04 $2,812 $3,862 2014 $1,216 3,004 $562 Change In Inventories $1,456 $1,120 $168 $597 $465 $50 $600 $272 $161 Change in Accounts Payable $3,018 $232 $1,148 $81 $88 10 $ 1,054 $473 Change In Assets/Liabilities $673 $1,542 $459 $349 -$2,907 $1,383 Total Change In Assets/Liabilities $1,432 $3,695 $596 $14.545 $1,056 $1,955 $1,513 Cash Flow From Operating Activities $60,675 $52,185 $43,884 $39,507 $33,325 $29,668 $32,502 Net Change In Property, plant, And Equipment $15,441 -$13,925 $11,632 -$8,129 -$8,343 -$5,944 Net Change In Intangible Assets $5,485 Net Acquisitions/Divestitures $2,521 $2,388 -$888 $25,944 $1,393 -$3,723 $5,937 Net Change In Short-term Investments Net Change In Long-Term Investments $6,980 $540 $6,557 $12,511 $14,417 $12,868 $7,324 Net Change In Investments - Total $6,980 $540 $6,557 $12,511 $14,417 $12,868 $7,324 Investing Activities - Other $1,241 $98 $197 $203 $466 $87 Cash Flow From Investing Activities MIT $12,223 $15,773 $6,061 $46,781 -$23,950 -$23,001 $18,833 . Net Long-Term Debt $5,518 $4,000 $2,877 $36,422 $11,088 12.02 30 Net Current Debt $9,180 vo . $6,462 $7,324 0.04 $4,963 $7,195 $4,481 $500 Debt Issuance/Retirement Net-Total $5,518 $4,000 * -$10,201 $31,459 $18,283 $13,661 --- $6,962 Net Common Equity Issued/Repurchased $21,625 -$18,401 $9,719 $11,016 $15,301 $13,809 $6,709 Net Total Equity Issued/Repurchased $21,625 $18,401 $9,719 $11,016 $ 15,301 $13,809 -$6,709 Total Common And Preferred Stock Dividends Paid $15,137 $ 13,811 $12,699 $11,845 -$11,006 -$9,882 $8,879 Financial Activities - Other $3,751 -$675 -$971 -$190 -$369 $362 -$39 Cash Flow From Financial Activities -$46,031 -$36,887 -$33,590 $8,408 -$8,393 $9,668 $8,665 Net Cash Flow $2,220 $1,153 $915 $3,074 $4,865 Stock-Based Compensation $5,289 $4,652 $3,266 $2,668 $2,574 $2,446 Common Stock Dividends Paid $15,137 $13,811 $12,699 $11,845 $11,006 $9,882 -$8,879 $1,584 $17,802 $17,802 $168 $23,811 $3,537 $3,537 $4,429 $4,429 $7,455 $199 -$8,148 $590 $4,283 $3,134 $3,940 $2,406 $7,455

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

Mathematics Of Finance

Authors: Robert Brown, Petr Zima

2nd Edition

0071756051, 9780071756051

More Books

Students also viewed these Finance questions