Find the ratios for the mystery company using the balance sheet & income statement. Then analysis the balance sheet and income statement once you've determined the ratios for the company.

Ratios for Mystery Company 2015 2016 2017 2018 Industry Averages 27.4% 6.0% 2.9% 3.92 6.1% 16.9% 108 0.30 104 0.26 104 0.28 1.10 0.25 0.98 0.32 Part 1 - Ratio Calculations Ratio Formulas (To save you a little bit of time) Ratios Numerators / Denominators 2014 Profitability Ratios Gross Profit Margin ares Provis sales Operating Profit Margin Sherating Polls Sales Net Profit Margin Earnings Available to $4 / Sales Earnings per Share (EPS) Earnings Avaiate le 34 / ostaesowstanding Return on Assets (ROA) Earnings Avaiate le 34 O Acser's Return on Equity (ROE) Earrings Avatate io 34 / Como Sox Eqwiy Liquidity fatos Current Ratio Owent Assets / Curen Liaries I 1.12 Quick Ratio Went Assessmentary curent Lawries 0.30 Debi Aatos Debt to Total Assets Toalliatives/Demy) / Total Assers 80.29% Equity Multiplier (FLM) Total Assets I s hareholder Equity | 5.07 Times Interest Earned ERIT/Amevalling income interest Expense 0.85 Activity Ratios Average Collection Period Accounts Recewate I /Sales/. 23.02 Accounts Payable Turnover 27S / Accu's Payable 4.47 Days AP AP Tudover 81.72 Inventory Turnover 22773 v entory 8.86 Daus Inventory vencay Tunavey 41.20 Total Asset Turnover Sales Total Assers 163 Market Ratios Price Earnings (P/E) Marker Price pey Stare EPS Market/Book (MIB) Ayrier Price per Smare / Food Wwowstanding Stresi Modified DuPont Analysis Net Margin Fran atave -2222 Total Asset Turnover (TAT) Franarave SZA ROA de Proti Alerguir 747 / Equity Multiplier (FLM) Fran ve 22:25 ROE 1024 AZAY -2740241 79.55% 4.89 4.86 76.88% 4.32 8.65 78.90% 4.74 4.84 73.23% 3.73 8.77 64.0% 2.80 8.10 4.18 21.91 4.17 87.52 8.30 43.95 164 22.38 40.77 3.96 87.24 92.10 9.24 8.55 39.514271 163 1.35 26.14 4.53 80.49 10.08 4.78 8.07 45.24 7.07 51.64 2.05 1 .43 16.48 3.21 2.9% 2.05 6.1% 2.80 16.9% MYSTERY COMPANY BALANCE SHEET Consolidated Balance Sheet - USD ($) $ in Mill 2014 Cash and cash equivalents 14,557 Short-term investments 2,859 Total cash 17,416 Receivables 5,612 Inventories 8,299 Total current assets 31.327 Property, plant and equipment 22,730 Accumulated Depreciation 15,763|| Property, plant and equipment, net 16,967 Goodwill 3,319 Intangible assets 764 Other long-term assets 2,128 Total non-current assets 23,178 TOTAL ASSETS 54,505 Accounts payable 16,459 Accrued liabilities 9,807 Deferred revenues 1,823 Total current liabilities 28,089 Long-term debt 8,265 Capital leases 4,224 Deferred taxes liabilities 1,531 Other long-term liabilities 1,655 Total non-current liabilities 15,675 Total liabilities 43,764 Common stock Additional paid-in capital 11,135 Retained earnings 1.949 Treasury stock (1,837) Accumulated other comprehensive income (511) Total stockholders' equity 10,741. |TOTAL LIABILITIES AND SHAREHOL 54,505 2015 15,890 | 3,918 19.808 6,423 10,243 36,474 | 30,053 18,215)| 21,838 3,759 762 2,611 28,970 65,444 20,397 10,384 3,118 33,899 8,235 5,948 2.016 1,962 18,161 52,060 5 13,394 2,545 (1,837) (723) 13,384 65,444 2016 19,334 6,647 25,981 8,339 11,461 45,781 42,441 (13,32711 29,114 3,784 854 3,869 L 37,621 83,402 25,309 13,739 4,768 43,816 7,694 7,519 1,787 3,301 | 20,301 64,117 2017 20,522 10,464 30,986 13,164 16,047 60,197 68,573 (19,70711 48,866 13,350 3,371 5,526 71,113 131,310 34,616 18,170 5,097 57,883 24,743 13,183 1,994 5.798 45,718 103,601 5 21,389 8,636 (1,837) (484) 27,709 131,310 2018 31,750 9,500 41,250 16,677 17,174 75,101 95,770 (33,973|| 61,797 14,548 | 4,110 7,092 87,547 162,648 38,192 23,663 6,536 68,391 23,495 16,292 2,386 8,535 50,708 119,099 5 26,791 19,625 (1,837) (1,035) 43,549 162,648 51 51 17,186 4,916 (1,837) (985) 19,285 83,402 Balance Sheet Analysis List your observations from the Balance Sheet Analysis here: 2017 177,866 137,183 40,683 13,743 22,834 | 36.577 | 4,106 848 MYSTERY COMPANY INCOME STATEMENT Consolidated Statement of Income - 12 Months Ended USD ($1 shares in Millions, $ in Millions 2014 2015 2016 Revenue (Sales) 88,988 107,006 135,987 Cost of revenue (COGS) 73,518 85,061 105,884 Gross profit 15,470 21,945 30,103 Sales, General and administrative 5,884 7.001 9,665 Other operating expenses 9,408 12,711 16,252 Total operating expenses 15,292 19,712 25,917 Operating income (EBIT) 178 2,233 4,186 Interest Expense 210 459 Other income (expense) (79) (206) 190 Income before income taxes (111) 1,568 3,892 Provision for income taxes 950 1.425 Other income 37 (22) Net income (241) 596 2,371 Earnings per share Basic -0.52 1.28 5.01 Diluted -0.52 1.25 4.9 Weighted average shares outstanding Basic 462 474 Diluted 462 484 IEBITDA 4845 8308 12492 2018 232,887 173,183 59,704 1 8,150 29,133 47,283 12,421 1,417 257 11,261 484 548 167 1197 196 3,806 769 (4) 3,033 10,073 6.32 6.15 20.68 20.14 467 477 480 493 16132 487 500 28019 Market Price of Mystery Company's Stoch Use this for your Market Ratios 310 1 676 1 7501 11691 1502 Income Statement Analysis Take a look at the Income Statement and the Common-Size Income Statement you have just calculated. List some of the points of interest below and then talk about a few of them in your ratio analysis and summary. You should be able to use some of this information to back up your time series analysis statements. (Company's performa Points of Interest: List your observations from the financial statement here! I listed a couple to get you | 77 vw -Szalaxe Start 2277esire 62288 W 627323/M2/18 This firm's revenues show a very strong upward trend - this is very good for the company. Ratios for Mystery Company 2015 2016 2017 2018 Industry Averages 27.4% 6.0% 2.9% 3.92 6.1% 16.9% 108 0.30 104 0.26 104 0.28 1.10 0.25 0.98 0.32 Part 1 - Ratio Calculations Ratio Formulas (To save you a little bit of time) Ratios Numerators / Denominators 2014 Profitability Ratios Gross Profit Margin ares Provis sales Operating Profit Margin Sherating Polls Sales Net Profit Margin Earnings Available to $4 / Sales Earnings per Share (EPS) Earnings Avaiate le 34 / ostaesowstanding Return on Assets (ROA) Earnings Avaiate le 34 O Acser's Return on Equity (ROE) Earrings Avatate io 34 / Como Sox Eqwiy Liquidity fatos Current Ratio Owent Assets / Curen Liaries I 1.12 Quick Ratio Went Assessmentary curent Lawries 0.30 Debi Aatos Debt to Total Assets Toalliatives/Demy) / Total Assers 80.29% Equity Multiplier (FLM) Total Assets I s hareholder Equity | 5.07 Times Interest Earned ERIT/Amevalling income interest Expense 0.85 Activity Ratios Average Collection Period Accounts Recewate I /Sales/. 23.02 Accounts Payable Turnover 27S / Accu's Payable 4.47 Days AP AP Tudover 81.72 Inventory Turnover 22773 v entory 8.86 Daus Inventory vencay Tunavey 41.20 Total Asset Turnover Sales Total Assers 163 Market Ratios Price Earnings (P/E) Marker Price pey Stare EPS Market/Book (MIB) Ayrier Price per Smare / Food Wwowstanding Stresi Modified DuPont Analysis Net Margin Fran atave -2222 Total Asset Turnover (TAT) Franarave SZA ROA de Proti Alerguir 747 / Equity Multiplier (FLM) Fran ve 22:25 ROE 1024 AZAY -2740241 79.55% 4.89 4.86 76.88% 4.32 8.65 78.90% 4.74 4.84 73.23% 3.73 8.77 64.0% 2.80 8.10 4.18 21.91 4.17 87.52 8.30 43.95 164 22.38 40.77 3.96 87.24 92.10 9.24 8.55 39.514271 163 1.35 26.14 4.53 80.49 10.08 4.78 8.07 45.24 7.07 51.64 2.05 1 .43 16.48 3.21 2.9% 2.05 6.1% 2.80 16.9% MYSTERY COMPANY BALANCE SHEET Consolidated Balance Sheet - USD ($) $ in Mill 2014 Cash and cash equivalents 14,557 Short-term investments 2,859 Total cash 17,416 Receivables 5,612 Inventories 8,299 Total current assets 31.327 Property, plant and equipment 22,730 Accumulated Depreciation 15,763|| Property, plant and equipment, net 16,967 Goodwill 3,319 Intangible assets 764 Other long-term assets 2,128 Total non-current assets 23,178 TOTAL ASSETS 54,505 Accounts payable 16,459 Accrued liabilities 9,807 Deferred revenues 1,823 Total current liabilities 28,089 Long-term debt 8,265 Capital leases 4,224 Deferred taxes liabilities 1,531 Other long-term liabilities 1,655 Total non-current liabilities 15,675 Total liabilities 43,764 Common stock Additional paid-in capital 11,135 Retained earnings 1.949 Treasury stock (1,837) Accumulated other comprehensive income (511) Total stockholders' equity 10,741. |TOTAL LIABILITIES AND SHAREHOL 54,505 2015 15,890 | 3,918 19.808 6,423 10,243 36,474 | 30,053 18,215)| 21,838 3,759 762 2,611 28,970 65,444 20,397 10,384 3,118 33,899 8,235 5,948 2.016 1,962 18,161 52,060 5 13,394 2,545 (1,837) (723) 13,384 65,444 2016 19,334 6,647 25,981 8,339 11,461 45,781 42,441 (13,32711 29,114 3,784 854 3,869 L 37,621 83,402 25,309 13,739 4,768 43,816 7,694 7,519 1,787 3,301 | 20,301 64,117 2017 20,522 10,464 30,986 13,164 16,047 60,197 68,573 (19,70711 48,866 13,350 3,371 5,526 71,113 131,310 34,616 18,170 5,097 57,883 24,743 13,183 1,994 5.798 45,718 103,601 5 21,389 8,636 (1,837) (484) 27,709 131,310 2018 31,750 9,500 41,250 16,677 17,174 75,101 95,770 (33,973|| 61,797 14,548 | 4,110 7,092 87,547 162,648 38,192 23,663 6,536 68,391 23,495 16,292 2,386 8,535 50,708 119,099 5 26,791 19,625 (1,837) (1,035) 43,549 162,648 51 51 17,186 4,916 (1,837) (985) 19,285 83,402 Balance Sheet Analysis List your observations from the Balance Sheet Analysis here: 2017 177,866 137,183 40,683 13,743 22,834 | 36.577 | 4,106 848 MYSTERY COMPANY INCOME STATEMENT Consolidated Statement of Income - 12 Months Ended USD ($1 shares in Millions, $ in Millions 2014 2015 2016 Revenue (Sales) 88,988 107,006 135,987 Cost of revenue (COGS) 73,518 85,061 105,884 Gross profit 15,470 21,945 30,103 Sales, General and administrative 5,884 7.001 9,665 Other operating expenses 9,408 12,711 16,252 Total operating expenses 15,292 19,712 25,917 Operating income (EBIT) 178 2,233 4,186 Interest Expense 210 459 Other income (expense) (79) (206) 190 Income before income taxes (111) 1,568 3,892 Provision for income taxes 950 1.425 Other income 37 (22) Net income (241) 596 2,371 Earnings per share Basic -0.52 1.28 5.01 Diluted -0.52 1.25 4.9 Weighted average shares outstanding Basic 462 474 Diluted 462 484 IEBITDA 4845 8308 12492 2018 232,887 173,183 59,704 1 8,150 29,133 47,283 12,421 1,417 257 11,261 484 548 167 1197 196 3,806 769 (4) 3,033 10,073 6.32 6.15 20.68 20.14 467 477 480 493 16132 487 500 28019 Market Price of Mystery Company's Stoch Use this for your Market Ratios 310 1 676 1 7501 11691 1502 Income Statement Analysis Take a look at the Income Statement and the Common-Size Income Statement you have just calculated. List some of the points of interest below and then talk about a few of them in your ratio analysis and summary. You should be able to use some of this information to back up your time series analysis statements. (Company's performa Points of Interest: List your observations from the financial statement here! I listed a couple to get you | 77 vw -Szalaxe Start 2277esire 62288 W 627323/M2/18 This firm's revenues show a very strong upward trend - this is very good for the company