if you could at least do 2015, I think I can figure out the rest.

thank you!

Common Size Income Statement 2018 Sparklines Optional 21,025 10,239 2019 21,076 9,961 11,115 2,229 53.46% 10,205 10,786 2,200 MYSTERY COMPANY INCOME STATEMENT Consolidated Statement of Income - USD ($) shares in 12 Months Ended Millions, $ in Millions 2015 2016 2017 Revenue (Sales) 25,413 24,622 22,820 Cost of revenue (COGS) 15,624 14,417 12,200 Gross profit 9,789 10,620 Sales, General and administrative 2.434 2,385 2.231 2,434 2,251 Other Operating Income/Expense Total Old Operating expenses 2,434 2,385 2,231 Operating income (Also called EBIT) 7,355 7,820 8.389 0,389 Net Interest Expense 025 629 881 919 914 Net Investment income (91) 79 13 158 Irrigular Income/Expense (63) (130) (130) 979 Other income/Expense (17) (22) (39) Income before taxes 6,555 6,866 8,573 Provision for income taxes 2,026 2,180 3,381 Net income 4,529 4,686 5,192 2.200 2,200 8,586 977 147 85 (25) 7,816 1,892 5,924 2,229 8.886 1.085 202 -- 30 24 (15) 8,018 1,993 6,025 Fiscal year ends in December. USD in millions except per share data. 2015 2016 2017 2018 2019 100.00% 100.00% 100.00% 100.00% 100.00% 61.48% 58.55% 48.70% 47.26% 38.52% 41.45% 46.54% 51.30% 52.74% 9.58% % 3.0370 9.69% 9.78% 10.4694 % 10.58% 0.00% 0.00% 0.000 0.007 0.00% 0.00% 0.00% Viure 0.007 9.58% 9.69% 3.3070 9.78% 10.4694 2020 Surore 10.58% 10 28.94% 20:37 31.76% 31:70% 36.76% % 40.84% 42.16% 2.48% 3.58% S07 3.3070 4.01% 19.0170 4.65% 5.15% V.1.30 -0.36% 0.32% 0.3070 0.3270 1.097 0.69% V.707 0.70% 0.96% 12070 -0.25% -0.53% 4.29% ca 0.40% 0.14% 0.14% -0.07% -0.09% -0.17% -0.12% -0.07% 25.79% 27.89% 37.57% 37.17% 38.04% 7.97% 8.85% 14.82% % 9.00% 9.46% 17.82% 19.03% 22.75% 28.18% 28.59% Earnings per share Weighted average shares outstanding 4.82 939 5.49 854 6.43 807 7.61 778 7.95 758 118 122 172 175 198 Market Price of Mystery Company's Stock Use this for your Market Ratios Sparklines are a helpful tool in determining trends. They are very easy to do. Click in the cell where you want the sparkline. Click "Insert" at the top of the spreadsheet Find "Sparklines" on the toolbar and click "Line" A pop-up box will appear Click in the Date Range box and then highlight the five years of data on your spreadsheet and click enter Once you do this for the first line of the Income Statement, you can drag the formula down the column to do a sparkline for each item on the Income Statement. MYSTERY COMPANY BALANCE SHEET Common-Size Balance Sheet Sparklines Optional Consolidated Balance Sheet - USD ($) $ in Millions Cash and cash equivalents Receivables Inventories Prepaid expenses 2015 7,686 1,299 100 559 2017 2,464 1,976 59 828 2018 866 2,442 51 695 2019 899 2,224 50 385 Other current assets 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 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 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 2015 20.2588% 3.4239% 0.2636% 1.4734% 0.0000% 25.4171% 99.3490% -38.4169% 60.9347% 2.0902% 6.6317% 4.9263% 74.5829% 100.0000% 0.0000% 2.3037% 0.6141% 1.2230% 3.6348% 0.0000% 7.7756% 63.5810% 4.4914% 0.0000% 0.0000% 5.4667% 73.5391% % 81.3174% 0.0448% 17.2197% 117.5413% -108.5348% -7.5885% 18.6826% 100.0000% 2016 3.9421% 4.7512% 0.1902% 1.8212% 4.9220% 15.6298% 111.0205% -42.5026% 68.5211% 2.3401% 7.5297% 5.9792% 84.3702% 100.0000% 0.2482% 2.4368% 0.7994% % 1.7180% 3.7358% 2.2402% 11.1784% 83.4128% 5.8568% 0.0000% 0.0000% 6.6561% 95.9257% 107.1042% 0.0548% 21.7831% 148.9911% -167.9635% -9.9697% -7.1042% 100.000096 2017 7.2891% 5.8455% 0.1745% 2.4494% 0.0000% 15.7585% 108.3481% 41.9418% 66.4063% 3.2126% 7.0406% 7.5819% 84.2386% 100.0000% 0.0000% 2.7364% 0.8253% 1.6004% 3.3901% 0.0000% 8.5522% 87.3772% 3.3103% 0.0000% 7.0140% 3.4138% 101.1153% 109.6675% 0.0503% 20.9206% 142.9565% -167.1518% -6.4430% -9.6675% 100.0000% 2018 2.6337% 7.4268% 0.1551% 2.1137% 0.0000% 12.3263% 113.1170% 43.6453% 69.4717% 3.6586% 7.0922% 7.2413% 87.4608% 100.0000% 0.0000% 3.6739% 0.9033% 1.4659% 3.00179 0.0000% 9.0447% 94.5075% 3.6982% 1.9099% 6.3289% 3.3332% 109.7777% 118.8224% 0.0517% 22.4354% 153.5446% -187.1263% -7.9377% -19.0323% 100.0000% 2019 1.8922% 4.6810% 0.1052% 0.8103% 0.0000% 7.4888% 110.1050% -31.3422% 78.7628% 2.6731% 5.6366% 5.4387% 92.5112% 100.0000% 1.4312% 2.0795% 0.7114% 1.2187% 2.1805% 0.0000% 7.6214% 98.6635% 2.7741% 1.3934% 4.7694% 2.0627% 109.6588% 117.2802% 0.0358% 16.1121% 111.4058% -139.6077% -5.2262% -17.2802% 100.0000% 987 2,950 24,122 1,704 2,891 29,537 1,119 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 Part 1 - Ratio Calculations Ratios Ratio Formulas (To save you a little bit of time) Numerators Denominators Ratios for Mystery Company 2016 2017 2018 2015 2019 Sales / Sales Gross Profits Operating Profits Eamings Available to SH Earnings Available to SH Earnings Available to SH Eamings Available to SH Competitor Averages 2019 49.9% 24.5% 13.7% 2.81 12.4% -0.8% Sales # of shares outstanding Total Assets Common Stock Equity / / Current Assets Current Assets-Inventory Current Liabilities Current Liabilities 1.34 1.33 Total Liabilities (Debt) Total Assets EBIT (Operating Income) / / / Total Assets Shareholder Equity Interest Expense 3 173.3% 2.58 2.97 Profitability Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Earnings per Share (EPS) Return on Assets (ROA) Return on Equity (ROE) Liquidity Ratios Current Ratio Quick Ratio Debt Ratios Debt to Total Assets Equity Multiplier (FLM) Times Interest Earned Activity Ratios Average Collection Period Accounts Payable Turnover Days AP Inventory Turnover Days Inventory Total Asset Tumover Market Ratios Price/Earnings (P/E) Market/Book (MB) Modified DuPont Analysis Net Margin Total Asset Tumover (TAT) ROA Equity Multiplier (FLM) ROE Accounts Receivable / COGS / 365 (Sales/365) Accounts Payable AP Tumover Inventory Inventory Turnover Total Assets 25.86 23.82 15.33 451.13 0.81 0.80 INT COGS 365 Sales Market Price per Share Market Price per Share / / / EPS ACC Book Value per Share (Pg 91) 22.41 0.16 From above From above Net Profit Margin "TAT From above ROA. FLM