Part 1 - Ratio Calculations Ratios for Mystery Company 2016 2017 2018 2019 Ratio Formulas (To save you a little bit of time) Numerators 7 Denominators 2015 Ratios Sales 38.52% 28.94% 41.45% 31.76% 46.54% 36.76% 51.30% 52.74% 40.84% 42.16% Sales Sales Gross Profits Operating profits Earnings Available to SH Earnings Available to SH Earnings Available to SH Earnings Available to SH 1 / / / #of shares outstanding Total Assets Common Stock Equity Current Assets Current Assets-Inventory Current Liabilities Current Liabilities / Total Assets Total Liabilities (Debe) Total Assets EBIT (Operating Income) 7 / / Shareholder Equity Interest Expense Profitability Ratios Gross Profit Margin Operating Profit Margin Net Prott Margin Earnings per Share (EPS) Return on Assets (ROA) Return on Equity (ROE) Liquidity Ratios Current Ratio Quick Rati Debt Ratios Debt to Total Assets Equity Multiplier (FLM) Times Interest Earned Activity Ratios Average Collection Period Accounts Payable Tumover Days AP Inventory Turnover Days Inventory Total Asset Tumover Market Ratios Price Earings (P/E) MarketBook (M/B) Modified DuPont Analysis Net Margin Total Asset Turnover (TAT) ROA Equity Multiplier (PLM) ROE Accounts Receivable COGS 365 COGS 365 7 1 / / / / (Sales/365) Accounts Payable AP Turnover Inventory Inventory Turnover Total Assets Sales Market Price per Share / EPS Market Price per Share / ACC Book Value per Share Pg 91) / From above From above Net Proft Morgin TAT From above ROA FLM Income Statement Balance Sheet Ratio Analysis ScroLock D MYSTERY COMPANY INCOME STATEMENT 2015 25,413 15,624 9,789 2,434 12 Months Ended 2016 2017 24,622 22,820 14,417 12,200 10,205 10,620 2,385 2,231 2018 21,025 10,239 10,786 2,200 2019 21,076 9,961 11,115 2,229 Consolidated Statement of Income - USD ($) shares in Millions, $ in Millions Revenue (Sales) Cost of revenue (COGS) Gross profit sales, General and administrative Other Operating Income/Expense Total operating expenses Operating income (Also called EBIT) Net Interest Expense Net Investment Income Irrigular Income/Expense Other income/Expense Income before taxes Provision for income taxes Net income 2,200 8,586 977 147 2,434 7,355 629 (91) (63) (17) 6,555 2,026 4,529 2,385 7,820 881 79 (130) (22) 6,866 2,180 4,686 2,231 8,389 914 158 979 (39) 8,573 3,381 5,192 85 2,229 8,886 1,085 202 30 (15) 8,018 1,993 6,025 (25) 7,816 1,892 5,924 Earnings per share Weighted average shares outstanding 4.82 939 5.49 854 6.43 807 7.61 778 7.95 758 Market Price of Mystery Company's Stock Use this for your Market Ratios 118 122 172 175 198 ard Font Xo 37939 D E F G C B MYSTERY COMPANY BALANCE SHEET 2018 866 2015 7,686 1,299 100 559 2017 2,464 1,976 59 828 2,442 51 695 2019 899 2,224 50 385 9,643 37,692 (14,575) 23,118 793 2,516 1,869 28.296 37.939 2016 1,223 1,474 59 565 1,527 4,849 34,443 (13,186) 21,258 726 2,336 1,855 26,175 31,024 77 756 248 533 1,159 695 3,468 25,878 1,817 5,327 36,626 (14,178) 22,448 1,086 2,380 2,563 28,476 33,804 Consolidated Balance Sheet - USD (S) Sin Millions Cash and cash equivalents Receivables Inventories Prepaid expenses Other current assets Total current assets Property, plant and equipment Accumulated Depreciation Net property, plant and equipment Equity and other investments Goodwill Other long-term assets Total non-current assets (Long-term) TOTAL ASSETS Current debt and capital lease obligation Accounts payable Interest payable Taxes payable Accrued liabilities Other current liabilities Total current liabilities Long-term debt Deferred taxes liabilities Deferred income/liabilities Payables and accrued expenses Other long-term liabilities Total non-current liabilities (Long-term) Total Liabilities Common stock Additional paid-in capital Retained earnings Treasury stock Accumulated other comprehensive income Total stockholders' equity TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY 4,053 37,194 (14,351) 22,843 1,203 2,332 2,381 28,758 32,881 3,558 52,312 (14,891) 37,421 1,270 2.678 2,584 43,953 47,511 680 988 338 579 1,036 874 233 464 1,379 925 279 541 1,146 1,208 297 482 987 2,950 24,122 1,704 2,891 29,537 1,119 1 2 3 2,074 27.900 30,851 17 6,533 44,594 (41,177) (2,879) 7,088 37.939 2,065 29,760 33.228 17 6,758 46,223 (52.109) (3,093) (2,204) 31,024 2,371 1,154 34,181 37,072 17 7,072 48,325 (56,504) (2,178) (3,268) 33,804 2,974 31,075 1,216 628 2,081 1,096 36,096 39,070 17 7,377 50,487 (61,529) (2,610) (6,258) 32,881 3,621 46,876 1,318 662 2,266 980 52,100 55,721 17 7,655 52,930 (66,329) (2.483) (8,210) 47,511 35 36 37 88 39
