Compare the 2015 Company Financials to the Industry Averages and export the results into a Microsoft

User Generated

Snzr23

Business Finance

Description

Hello,

I dont have time to focus on this assignment and would love assistance from an expert on this matter. Here is more detail about the assignment:

Compare the 2015 Company Financials to the Industry Averages and export the results into a Microsoft® Excel® document.

Add a new column in your Microsoft® Excel® document titled "Change" and calculate the difference between the company's 2015 financial results and the industry averages.

Explain in 200 words how the company you selected compares to the industry averages in terms of financial profitability.


I have attached a copy of what needs to be done and shown within the excel with the example: Target Corporation. It can be viewed to help assist in the accuracy of the assignment. I also have attached all the necessary information about the company Microsoft Corporation Financials and the 2015 comparson to the industry average. I believe that using the ratios page in the second pdf for the Industry Average when compared to Microsoft would be best, as it is the same way in the Target Example. Please if you have any questions or hangups I am willing to provide any other necessary information, but i believe that everyting I have attached is all you will need.


Thank you very much in advance for you help and your time. It is truly appreciated.


Unformatted Attachment Preview

Trends in the Growth, Profitability and Financial Ratios for Target Corp Financials 2015-01 Revenue USD Mil Gross Margin % Operating Income USD Mil Operating Margin % Net Income USD Mil Earnings Per Share USD Dividends USD Working Capital USD Mil Key Ratios -> Profitability Profitability Net Margin % Asset Turnover (Average) Return on Assets % Financial Leverage (Average) Return on Equity % Return on Invested Capital % Liquidity/Financial Health Current Ratio Quick Ratio Financial Leverage Debt/Equity 2015 Company Financials to the Industry Averages Profitability Net Margin % Return on Assets % Return on Equity % Return on Invested Capital % Liquidity/ Solvency ratios Current Ratio Quick Ratio Debt/Equity 72,618 29.4 4,535 6.2 -1,636 -2.56 1.9 2,351 2015-01 -2.25 1.69 -3.81 2.96 -10.82 -5.76 2015-01 1.2 0.28 2.96 0.91 Target -2.25 -3.81 -10.82 -5.76 Target 1.2 0.28 0.91 2016-01 2017-01 73,785 29.5 4,910 6.7 3,363 5.31 2.16 1,508 2016-01 69,495 29.7 4,969 7.2 2,737 4.7 2.32 -718 2017-01 4.56 1.8 8.24 3.11 24.95 12.81 2016-01 3.94 1.78 7.05 3.42 22.89 11.08 2017-01 1.12 0.38 3.11 0.92 Industrial Average Difference 0.86 4.83 4.92 7.32 Industrial Average 1.31 0.57 81.2 0.94 0.26 3.42 1.01 3.11 8.64 15.74 13.08 -0.11 -0.29 -80.29 Plunkett Research Ltd. Copyright (C) All Rights Reserved www.plunkettresearch.com MICROSOFT CORPORATION (WWW.MICROSOFT.COM) Ticker: MSFT Exchange: NAS Year Established: 1975 Employees: 118,000 Fiscal Year Ends in June Phone: 425 882-8080 Fax: 425 936-7329 Address: One Microsoft Way Redmond, WA 98052-6399 United States Industry Ranks Types Of Business Industry NAICS code: 511210I Computer Software, Operating Systems, Languages & Development Tools Enterprise Software Game Consoles Operating Systems Software as a Service (SAAS) Search Engine and Advertising E-Mail Services Instant Messaging Contacts Text Satya Nadella Amy Hood John Thompson Frank Brod William Gates Padmasree Warrior Sandra Peterson Charles Noski Charles Scharf G. Morfit Helmut Panke John Stanton Teri List-Stoll Margaret Johnson Kathleen Hogan Christopher Capossela Jean-Philippe Courtois Bradford Smith Excel CEO/Director CFO/Executive VP Chairman of the Board/Director Chief Accounting Officer/Vice President, Divisional Co-Founder/Director/Other Corporate Officer Director Director Director Director Director Director Director Director Executive VP, Divisional Executive VP, Divisional Executive VP/Chief Marketing Officer Executive VP/President, Divisional Other Executive Officer/President 1. Microsoft Corporation 2. Quest Software Inc 3. Progress Software Corporation 4. Serena Software Inc 5. Access Co Ltd 6. IAR Systems Group AB 7. Wandisco PLC 85,320,000,000 920,000,000 405,341,000 210,000,000 73,767,850 34,552,140 10,994,000 Description Microsoft Corporation develops, license and supports software products, services and devices. It is a technology company that builds best-in-class platforms and productivity services for a mobile-first, cloud-first world. The firm’s products include operating systems; cross-device productivity applications; server applications; business solution applications; desktop and server management tools; software development tools; video games; and training and certification of computer system integrators and developers. Microsoft also designs, manufactures and sells devices such as personal computers (PCs), tablets, gaming and entertainment consoles, phones, other intelligent devices and related accessories that integrate with its cloud-based offerings. The company operates its business in two segments: productivity and business processes, which consists of products and services in its portfolio of productivity, communication and information services through its devices and platforms; and intelligent cloud, which consists of the company’s public, private and hybrid server products and cloud services that can power modern businesses. Products offered through the productivity and business processes segment include Office 365 and Dynamics. Products offered through the intelligent cloud segment include SQL servers, Windows servers, Visual Studio, system centers and Azure, as well as enterprise and consulting services. In 2016, the firm sold its entry-level phone business. Auditor: DELOITTE & TOUCHE LLP Legal Advisor: -1- Plunkett Research Ltd. Copyright (C) All Rights Reserved Financials Financial Details Compare to Industry Averages $USD, In whole numbers, except marked * or % Financials Revenue Cost of Revenue Gross Margin % R&D Expense Operating Income Operating Margin % SGA Expense Net Income Earnings Per Share Dividends Book Value Per Share Operating Cash Flow Capital Expenditure Free Cash Flow Profitability EBITDA Return on Assets % Return on Equity % Net Margin % Assets Turnover Financial Leverage www.plunkettresearch.com Build Custom Table Compare Companies 2016 2015 2014 2013 2012 2011 85,320,000,000 32,780,000,000 61.58 11,988,000,000 20,182,000,000 23.65 19,260,000,000 16,798,000,000 2.12 1.39 9.10 33,325,000,000 8,343,000,000 24,982,000,000 93,580,000,000 33,038,000,000 64.70 12,046,000,000 18,161,000,000 19.41 20,324,000,000 12,193,000,000 1.49 1.21 9.77 29,080,000,000 5,944,000,000 23,136,000,000 86,833,000,000 26,934,000,000 68.98 11,381,000,000 27,759,000,000 31.97 20,632,000,000 22,074,000,000 2.66 1.07 10.97 32,231,000,000 5,485,000,000 26,746,000,000 77,849,000,000 20,249,000,000 73.99 10,411,000,000 26,764,000,000 34.38 20,425,000,000 21,863,000,000 2.61 0.89 9.84 28,833,000,000 4,257,000,000 24,576,000,000 73,723,000,000 17,530,000,000 76.22 9,811,000,000 21,763,000,000 29.52 18,426,000,000 16,978,000,000 2.02 0.76 8.67 31,626,000,000 2,305,000,000 29,321,000,000 69,943,000,000 15,577,000,000 77.73 9,043,000,000 27,161,000,000 38.83 18,162,000,000 23,150,000,000 2.73 0.61 7.09 26,994,000,000 2,355,000,000 24,639,000,000 27,616,000,000 9.08 22.09 19.69 0.46 2.69 25,245,000,000 7.00 14.36 13.03 0.54 2.20 33,629,000,000 14.02 26.17 25.42 0.55 1.92 31,236,000,000 16.58 30.09 28.08 0.59 1.80 25,614,000,000 14.77 27.51 23.03 0.64 1.83 31,132,000,000 23.77 44.84 33.10 0.72 1.90 Brands, Divisions and Affiliates Office 365 Dynamics SQL Windows Visual Studio Azure Other Thoughts Apparent Female Officers or Directors: Top Salaries Name Title Satya Nadella B. Turner Amy Hood Bradford Smith Margaret Johnson Director/CEO COO CFO/Executive VP Other Executive Officer/President Executive VP, Divisional Salary Bonus (US$) (US$) 1,200,000 4,464,000 866,667 2,384,000 731,250 2,304,000 704,167 1,972,000 704,167 1,909,000 Corporate Culture Microsoft offers its employees health, dental and vision coverage; onsite health screenings; adoption assistance; childcare service discounts; a 401(k) plan; an employee stock purchase plan; and tuition assistance. -2- Plunkett Research Ltd. Copyright (C) All Rights Reserved www.plunkettresearch.com Income Statement $USD, In whole numbers, except marked * or % Microsoft Corporation Industry Average of 5 Companies Column Name - - Total Revenue 93,580,001,280 19,158,518,085 Cost Of Revenue 33,038,000,128 8,343,922,534 Gross Profit 60,542,001,152 12,483,380,067 4,610,999,808 1,209,586,700 SGA Expense 20,323,999,744 5,352,566,301 R&D Expense 12,046,000,128 4,166,926,709 Other Operating Expenses 22,057,000,960 3,436,931,889 - 12,989,000 - 7,059,774 42,381,000,704 8,802,487,190 18,161,000,448 3,680,892,878 Misc Other Special Charges 355,000,000 355,000,000 Interest Expense 781,000,000 158,850,434 Gain On Sale Of Security 716,000,000 716,000,000 Other Income (expense) 361,000,000 122,501,333 18,506,999,808 3,750,610,133 6,313,999,872 1,282,305,760 Net Income from Continuous Operations 12,193,000,448 2,468,304,474 Net Income for Common Stockholders 12,193,000,448 2,468,304,474 Basic Earnings per Share 1.49 0.36 Diluted Earnings per Share 1.48 0.36 Basic Average Shares 8,176,999,936 1,688,820,594 Diluted Average Shares 8,254,000,128 1,704,764,034 1.21 0.83 Operating Expenses General & Administrative Costs Restructuring and Merger/Acquisition Costs Amortization Total Operating Expenses Operating Income Pre-Tax Income Income Taxes Earnings per Share Weighted Average Shares Common Dividend -1- Plunkett Research Ltd. Copyright (C) All Rights Reserved www.plunkettresearch.com Balance Sheet $USD, In whole numbers, except marked * or % Microsoft Corporation Industry Average of 5 Companies Assets Current Assets Cash - 186,240,992 5,594,999,808 1,373,463,377 90,931,003,392 30,391,719,131 96,526,003,200 31,951,423,500 17,908,000,768 6,147,493,587 2,902,000,128 1,451,282,733 Deferred Income Taxes - - Prepaid Expenses - 51,102,695 Other Current Assets 5,461,000,192 1,095,730,238 Total Current Assets 124,712,001,536 25,406,491,597 32,337,000,448 6,562,462,580 (17,606,000,640) (3,570,797,114) 14,730,999,808 2,991,665,469 16,938,999,808 6,078,681,589 4,834,999,808 1,265,203,952 - - 51,511,001,088 10,786,588,943 176,222,994,432 36,193,078,908 Short-Term Debt 7,484,000,256 3,746,687,628 Accounts Payable 6,591,000,064 1,326,866,829 23,222,999,040 8,147,780,349 6,766,000,128 1,353,729,616 49,857,998,848 10,282,268,206 27,808,000,000 9,552,800,661 Deferred Tax Liability - - Minority Interest - - Pensions & Other Benefits - - Other Non Current Liabilities 13,543,999,488 2,721,229,485 Total Non Current Liabilities 46,281,998,336 9,524,483,154 96,140,001,280 19,806,752,205 Cash And Cash Equivalents Short-Term Investments Total Cash Receivables Inventory Non-Current Assets Gross Property, Plant & Equipment Accumulated Depreciation Net Property, Plant & Equipment Goodwill Intangible Assets Other Long Term Assets Total Non Current Assets Total Assets Liabilities and stockholders' equity Liabilities Current Liabilities Deferred Revenues Accrued Liabilities Total Current Liabilities Non-Current Liabilities Long Term Debt Total Liabilities Stockholders' Equity -2- Plunkett Research Ltd. Copyright (C) All Rights Reserved Common Stock www.plunkettresearch.com 68,465,000,448 22,821,843,149 - 568,960,728 9,095,999,488 2,049,703,362 Preferred Stock - 0 Treasury Stock 0 (1,515,288,064) 80,083,001,344 16,386,328,367 176,223,002,624 36,193,080,572 Additional Paid In Capital Retained Earnings Total Stockholders' Equity Total Liabilities & Shareholders' Equity -3- Plunkett Research Ltd. Copyright (C) All Rights Reserved www.plunkettresearch.com Cash Flow $USD, In whole numbers, except marked * or % Operating Cash Flow Microsoft Corporation Industry Average of 5 Companies 29,080,000,512 7,447,415,880 12,193,000,448 4,121,466,813 Depreciation And Amortization 5,957,000,192 1,521,203,298 Investment/Asset Impairment 7,497,999,872 3,751,480,936 224,000,000 81,890,667 - - 1,456,000,000 334,621,500 - - (272,000,000) (272,000,000) (1,054,000,000) (1,054,000,000) - (40,741,000) (624,000,000) (624,000,000) - 2,481,000 Other Working Capital 1,512,999,936 437,926,236 Other Non CashItems 9,484,000,256 2,415,753,812 29,080,000,512 7,447,415,880 (23,000,999,936) (4,719,315,600) (5,944,000,000) (1,199,409,787) (12,867,999,744) (4,288,648,248) (3,723,000,064) (1,420,298,688) (98,729,000,960) (33,107,243,312) 85,860,999,168 28,818,594,395 (466,000,000) (90,926,413) (23,000,999,936) (4,719,315,600) Financing Cash Flow (9,080,000,512) (1,758,868,722) Issuance Of Debt 10,680,000,512 3,873,256,512 Repayment Of Debt (1,500,000,000) (552,744,000) 634,000,000 220,058,333 (9,882,000,384) (4,944,503,072) Other Financing Activities 950,000,000 182,648,132 Effect of Changes in Currency Exchange Rates (73,000,000) (26,301,579) (3,073,999,872) (544,390,613) Beginning Cash Position 8,668,999,680 1,917,828,367 End Cash Position 5,594,999,808 1,373,463,377 Operating Cash Flow 29,080,000,512 7,447,415,880 Capital Expenditure (5,944,000,000) (1,203,032,798) Net Income Deferred Income Taxes Stock Based Compensation Accounts Receivable Cash From Discontinued Operating Activities Change In Inventory Change In Account Payable Prepaid Expenses Accrued Liabilities Income Tax Payable Operating Cash Flow Cash Flow from Investing Purchase of Property, Plants & Equipment Net Investment Purchase & Sale Acquisitions, net Purchase Of Investments Sales/Maturities of Investments Net Other Investing Changes Cash Flow from Investing Common Stock Issued Cash Dividends Paid Net Change in Cash Free Cash Flow -4- Plunkett Research Ltd. Copyright (C) All Rights Reserved Free Cash Flow www.plunkettresearch.com 23,136,000,000 -5- 4,757,087,993 Plunkett Research Ltd. Copyright (C) All Rights Reserved www.plunkettresearch.com Ratios $USD, Microsoft Corporation Industry Average of 5 Companies Profitability Ratios EBITDA Margin 0.27 -0.20 EBIT Margin 0.21 -0.43 Gross Margin % 64.70 85.15 Operating Margin % 19.41 -42.73 Tax Rate % 34.12 64.68 - - 13.03 -46.18 Assets Turnover 0.54 0.56 Return on Assets (ROA) % 7.00 -20.94 14.36 -107.95 10.71 -109.36 Year over Year % 7.77 11.56 3-Year Average % 8.27 12.32 5-Year Average % 8.41 11.16 10-Year Average % 8.93 6.52 -34.58 -12.98 3-Year Average % -5.85 0.51 5-Year Average % -5.50 12.12 2.23 5.68 Year over Year % -44.76 2.18 3-Year Average % -10.45 22.08 5-Year Average % -8.26 10.77 10-Year Average % -0.05 5.26 -43.73 2.91 3-Year Average % -9.55 22.19 5-Year Average % -6.76 10.36 - - Year over Year % - - 3-Year Average % - - 5-Year Average % - - 10-Year Average % - - Book Value PerShare Net Margin % Return on Equity (ROE) % % Return on Invested Capital (ROIC) Growth Ratios Revenue % Operating Income % Year over Year % 10-Year Average % Net Income % Diluted Earnings Per Share % Year over Year % 10-Year Average % Dividend % Cash Flow Ratios -6- Plunkett Research Ltd. Copyright (C) All Rights Reserved www.plunkettresearch.com Operating Cash Flow Year over Year % -9.78 10.73 -13.50 31.36 Capital Expenditures to Sales 0.06 0.19 Free Cash Flow to Sales 0.25 0.27 Free Cash Flow to Net Income 1.90 2.11 Days in Sales 73.04 80.70 Days in Inventory 30.72 30.72 Days in Payment 77.46 131.22 793,051 306,810 26.30 26.30 5.00 5.04 11.88 11.88 Fixed Assets Turnover 6.75 20.22 Assets Turnover 0.54 0.56 Capital Expenditures to Sales 0.06 0.19 Current Ratio 2.50 1.68 Quick Ratio 2.30 1.49 Financial Leverage 2.20 2.29 Debt Equity Ratio 0.35 0.29 Free Cash Flow Year over Year % Efficiency Sales per Employee $ Cash Conversion Cycle Receivables Turnover Inventory Turnover Liquidity / Financial Health -7-
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

I read am managed to understand what was required for this assignment, thanks too, for the further explanation.Here is the complete work please look at it and tell me if it is as required. Thank you.

Trends in the Growth, Profitability and Financial Ratios for Microsoft Corporation
Financials
Revenue USD Mil
Gross Margin %
Operating Income USD Mil
Operating Margin %
Net Income USD Mil
Earnings Per Share USD
Dividends USD
Capital Expenditure USD Mil
Key Ratios -> Profitability
Profitability
Net Margin %
Asset Turnover (Average)
Return on Assets %
Financial Leverage (Average)
Return on Equity %

2016 Company Financials to the Industr...


Anonymous
Excellent! Definitely coming back for more study materials.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags