Answered step by step
Verified Expert Solution
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
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,455Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started