Benchmark - Microsoft

profileMaree29
Trammel_final.xlsx
Home>Business & Finance homework help>Accounting homework help>Benchmark - Microsoft

Financial Information

Microsoft Microsoft
Income Statement Balance Sheet
For the Years ended 2018 through 2020 For the Years ended 2018 through 2020
(Amounts in millions) (Amounts in millions)
Fiscal Year: 2020 2019 2018 Fiscal Year: 2020 2019 2018
Total Revenue 143,015 125,843 110,360 Cash, Cash Equivalents and Short Term Investments 136,527 133,819 133,768
Cost of Revenue 46,078 42,910 38,353 Inventories 1,895 2,063 2,662
Gross Profit 96,937 82,933 72,007 Trade and Other Receivables, Current 32,011 29,524 26,481
Selling, General and Administrative Expenses 24,709 23,098 22,223 Other Current Assets 11,482 10,146 6,751
Research and Development Expenses 19,269 16,876 14,726 Total Current Assets 181,915 175,552 169,662
Operating Income/Expenses 43,978 39,974 36,949 Deferred Costs/Assets, Current
Total Operating Profit/Loss 52,959 42,959 35,058 Total Non-Current Assets 119,396 111,004 89,186
Non-Operating Income/Expenses, Total 77 729 1,416 Net Property, Plant and Equipment 52,904 43,856 36,146
Pretax Income 53,036 43,688 36,474 Net Intangible Assets 50,389 49,776 43,736
Provision for Income Tax 8,755 4,448 19,903 Total Long Term Investments 2,965 2,649 1,862
Net Income from Continuing Operations 44,281 39,240 16,571 Other Non-Current Assets 13,138 14,723 7,442
Total Assets 301,311 286,556 258,848
Financial Liabilities, Current 3,749 5,516 3,998
Provisions, Current 7,874 6,830 6,103
Deferred Liabilities, Current 36,000 32,676 28,905
Other Current Liabilities 10,027 9,351 8,744
Total Current Liabilities 72,310 69,420 58,488
Long Term Debt 59,578 66,662 72,242
Capital Lease Obligations, Non-Current 7,671 6,188 5,568
Tax Liabilities, Non-Current 204 233 541
Deferred Income/Customer Advances/Billings in Excess of Cost, Non-Current 3,180 4,530 3,815
Payables and Accrued Expenses, Non-Current 29,432 29,612 30,265
Other Non-Current Liabilities 10,632 7,581 5,211
Total Non-Current Liabilities 110,697 114,806 117,642
Total Liabilities 183,007 184,226 176,130
Equity Attributable to Parent Stockholders 118,304 102,330 82,718
Paid in Capital 80,552 78,520 71,223
Retained Earnings/Accumulated Deficit 34,566 24,150 13,682
Reserves/Accumulated Comprehensive Income/Losses 3,186 (340) (2,187)
Total Equity 118,304 102,330 82,718
Total Equity and Liabiltiies 301,311 286,556 258,848

3-Horizontal Analysis IS

Microsoft
Income Statement
For the Years ended 2018 through 2020
(Amounts in millions)
2019 2018
2020 2019 $ Change % Change 2019 2018 $ Change % Change 208 2018 $ Change % Change
Total Revenue 143,015 125,843 17,172 13.6% 125,843 110,360 15,483 14.0% 110,360 110,360 - 0 0.0%
Cost of Revenue 46,078 42,910 3,168 7.4% 42,910 38,353 4,557 11.9% 38,353 38,353 - 0 0.0%
Gross Profit 96,937 82,933 14,004 16.9% 82,933 72,007 10,926 15.2% 72,007 72,007 - 0 0.0%
Selling, General and Administrative Expenses 24,709 23,098 1,611 7.0% 23,098 22,223 875 3.9% 22,223 22,223 - 0 0.0%
Research and Development Expenses 19,269 16,876 2,393 14.2% 16,876 14,726 2,150 14.6% 14,726 14,726 - 0 0.0%
Operating Income/Expenses 43,978 39,974 4,004 10.0% 39,974 36,949 3,025 8.2% 36,949 36,949 - 0 0.0%
Total Operating Profit/Loss 52,959 42,959 10,000 23.3% 42,959 35,058 7,901 22.5% 35,058 35,058 - 0 0.0%
Non-Operating Income/Expenses, Total 77 729 (652) -89.4% 729 1,416 (687) -48.5% 1,416 1,416 - 0 0.0%
Pretax Income 53,036 43,688 9,348 21.4% 43,688 36,474 7,214 19.8% 36,474 36,474 - 0 0.0%
Provision for Income Tax 8,755 4,448 4,307 96.8% 4,448 19,903 (15,455) -77.7% 19,903 19,903 - 0 0.0%
Net Income from Continuing Operations 44,281 39,240 5,041 12.8% 39,240 16,571 22,669 136.8% 16,571 16,571 - 0 0.0%

3- Horizontal Analysis BS

Mircosoft
Balance Sheet
Horizontal Analysis for the Years ended 2018through 2020
(Amounts in millions)
2020 2019 $ Change % Change 2019 2018 $ Change % Change 2018 2018 $ Change % Change
Cash, Cash Equivalents and Short Term Investments 136,527 133,819 2,708 2.0% 133,819 133,768 51 0.0% 133,768 133,768 - 0 0.0%
Inventories 1,895 2,063 (168) -8.1% 2,063 2,662 (599) -22.5% 2,662 2,662 - 0 0.0%
Trade and Other Receivables, Current 32,011 29,524 2,487 8.4% 29,524 26,481 3,043 11.5% 26,481 26,481 - 0 0.0%
Other Current Assets 11,482 10,146 1,336 13.2% 10,146 6,751 3,395 50.3% 6,751 6,751 - 0 0.0%
Total Current Assets 181,915 175,552 6,363 3.6% 175,552 169,662 5,890 3.5% 169,662 169,662 - 0 0.0%
Deferred Costs/Assets, Current
Total Non-Current Assets 119,396 111,004 8,392 7.6% 111,004 89,186 21,818 24.5% 89,186 89,186 - 0 0.0%
Net Property, Plant and Equipment 52,904 43,856 9,048 20.6% 43,856 36,146 7,710 21.3% 36,146 36,146 - 0 0.0%
Net Intangible Assets 50,389 49,776 613 1.2% 49,776 43,736 6,040 13.8% 43,736 43,736 - 0 0.0%
Total Long Term Investments 2,965 2,649 316 11.9% 2,649 1,862 787 42.3% 1,862 1,862 - 0 0.0%
Other Non-Current Assets 13,138 14,723 (1,585) -10.8% 14,723 7,442 7,281 97.8% 7,442 7,442 - 0 0.0%
Total Assets 301,311 286,556 14,755 5.1% 286,556 258,848 27,708 10.7% 258,848 258,848 - 0 0.0%
Financial Liabilities, Current 3,749 5,516 (1,767) -32.0% 5,516 3,998 1,518 38.0% 3,998 3,998 - 0 0.0%
Provisions, Current 7,874 6,830 1,044 15.3% 6,830 6,103 727 11.9% 6,103 6,103 - 0 0.0%
Deferred Liabilities, Current 36,000 32,676 3,324 10.2% 32,676 28,905 3,771 13.0% 28,905 28,905 - 0 0.0%
Other Current Liabilities 10,027 9,351 676 7.2% 9,351 8,744 607 6.9% 8,744 8,744 - 0 0.0%
Total Current Liabilities 72,310 69,420 2,890 4.2% 69,420 58,488 10,932 18.7% 58,488 58,488 - 0 0.0%
Long Term Debt 59,578 66,662 (7,084) -10.6% 66,662 72,242 (5,580) -7.7% 72,242 72,242 - 0 0.0%
Capital Lease Obligations, Non-Current 7,671 6,188 1,483 24.0% 6,188 5,568 620 11.1% 5,568 5,568 - 0 0.0%
Tax Liabilities, Non-Current 204 233 (29) -12.4% 233 541 (308) -56.9% 541 541 - 0 0.0%
Deferred Income/Customer Advances/Billings in Excess of Cost, Non-Current 3,180 4,530 (1,350) -29.8% 4,530 3,815 715 18.7% 3,815 3,815 - 0 0.0%
Payables and Accrued Expenses, Non-Current 29,432 29,612 (180) -0.6% 29,612 30,265 (653) -2.2% 30,265 30,265 - 0 0.0%
Other Non-Current Liabilities 10,632 7,581 3,051 40.2% 7,581 5,211 2,370 45.5% 5,211 5,211 - 0 0.0%
Total Non-Current Liabilities 110,697 114,806 (4,109) -3.6% 114,806 117,642 (2,836) -2.4% 117,642 117,642 - 0 0.0%
Total Liabilities 183,007 184,226 (1,219) -0.7% 184,226 176,130 8,096 4.6% 176,130 176,130 - 0 0.0%
Equity Attributable to Parent Stockholders 118,304 102,330 15,974 15.6% 102,330 82,718 19,612 23.7% 82,718 82,718 - 0 0.0%
Paid in Capital 80,552 78,520 2,032 2.6% 78,520 71,223 7,297 10.2% 71,223 71,223 - 0 0.0%
Retained Earnings/Accumulated Deficit 34,566 24,150 10,416 43.1% 24,150 13,682 10,468 76.5% 13,682 13,682 - 0 0.0%
Reserves/Accumulated Comprehensive Income/Losses 3,186 (340) 3,526 -1037.1% (340) (2,187) 1,847 -84.5% (2,187) (2,187) - 0 0.0%
Total Equity 118,304 102,330 15,974 15.6% 102,330 82,718 19,612 23.7% 82,718 82,718 - 0 0.0%
Total Equity and Liabiltiies 301,311 286,556 14,755 5.1% 286,556 258,848 27,708 10.7% 258,848 258,848 - 0 0.0%

3 Vertical Analysis IS

Micorsoft
Income Statement
Vertical Analysis for the Years ended 2018 through 2020
(Amounts in millions)
2020 % 2019 % 2018 %
Total Revenue 143,015 100.0% 110,360 100.0% 110,360 100.0%
Cost of Revenue 46,078 32.2% 38,353 34.8% 38,353 34.8%
Gross Profit 96,937 67.8% 72,007 65.2% 72,007 65.2%
Selling, General and Administrative Expenses 24,709 17.3% 22,223 20.1% 22,223 20.1%
Research and Development Expenses 19,269 13.5% 14,726 13.3% 14,726 13.3%
Operating Income/Expenses 43,978 30.8% 36,949 33.5% 36,949 33.5%
Total Operating Profit/Loss 52,959 37.0% 35,058 31.8% 35,058 31.8%
Non-Operating Income/Expenses, Total 77 0.1% 1,416 1.3% 1,416 1.3%
Pretax Income 53,036 37.1% 36,474 33.1% 36,474 33.1%
Provision for Income Tax 8,755 6.1% 19,903 18.0% 19,903 18.0%
Net Income from Continuing Operations 44,281 31.0% 16,571 15.0% 16,571 15.0%

3 Vertical Analysis BS

Microsoft
.
Vertical Analysis for the Years ended 2018 through 2020
(Amounts in millions)
2020 % 2019 % 2018 %
Cash, Cash Equivalents and Short Term Investments 136,527 45.3% 133,819 46.7% 133,768 51.7%
Inventories 1,895 0.6% 2,063 0.7% 2,662 1.0%
Trade and Other Receivables, Current 32,011 10.6% 29,524 10.3% 26,481 10.2%
Other Current Assets 11,482 3.8% 10,146 3.5% 6,751 2.6%
Total Current Assets 181,915 60.4% 175,552 61.3% 169,662 65.5%
Deferred Costs/Assets, Current
Total Non-Current Assets 119,396 39.6% 111,004 38.7% 89,186 34.5%
Net Property, Plant and Equipment 52,904 17.6% 43,856 15.3% 36,146 14.0%
Net Intangible Assets 50,389 16.7% 49,776 17.4% 43,736 16.9%
Total Long Term Investments 2,965 1.0% 2,649 0.9% 1,862 0.7%
Other Non-Current Assets 13,138 4.4% 14,723 5.1% 7,442 2.9%
Total Assets 301,311 100.0% 286,556 100.0% 258,848 100.0%
Financial Liabilities, Current 3,749 1.2% 5,516 1.9% 3,998 1.5%
Provisions, Current 7,874 2.6% 6,830 2.4% 6,103 2.4%
Deferred Liabilities, Current 36,000 11.9% 32,676 11.4% 28,905 11.2%
Other Current Liabilities 10,027 3.3% 9,351 3.3% 8,744 3.4%
Total Current Liabilities 72,310 24.0% 69,420 24.2% 58,488 22.6%
Long Term Debt 59,578 19.8% 66,662 23.3% 72,242 27.9%
Capital Lease Obligations, Non-Current 7,671 2.5% 6,188 2.2% 5,568 2.2%
Tax Liabilities, Non-Current 204 0.1% 233 0.1% 541 0.2%
Deferred Income/Customer Advances/Billings in Excess of Cost, Non-Current 3,180 1.1% 4,530 1.6% 3,815 1.5%
Payables and Accrued Expenses, Non-Current 29,432 9.8% 29,612 10.3% 30,265 11.7%
Other Non-Current Liabilities 10,632 3.5% 7,581 2.6% 5,211 2.0%
Total Non-Current Liabilities 110,697 36.7% 114,806 40.1% 117,642 45.4%
Total Liabilities 183,007 60.7% 184,226 64.3% 176,130 68.0%
Equity Attributable to Parent Stockholders 118,304 39.3% 102,330 35.7% 82,718 32.0%
Paid in Capital 80,552 26.7% 78,520 27.4% 71,223 27.5%
Retained Earnings/Accumulated Deficit 34,566 11.5% 24,150 8.4% 13,682 5.3%
Reserves/Accumulated Comprehensive Income/Losses 3,186 1.1% (340) -0.1% (2,187) -0.8%
Total Equity 118,304 39.3% 102,330 35.7% 82,718 32.0%
Total Equity and Liabiltiies 301,311 100.0% 286,556 100.0% 258,848 100.0%

REFERENCES

References:
TAB
FINANCIAL INFORMATION U.S. Securities and Exchange Commission (2019). 2019 Annual SEC Form 10-K Report, Costco Wholesale Corporation. Retrieved from https://www.sec.gov/Archives/edgar/data/909832/000090983219000019/cost10k9119.htm This is an example of your reference. You will use the actual reference from your company. You will create one for each different SEC Form 10K report you will cite