Common size financial statements will help you in your time-series analysis and will give you a better idea of what is going on in the company. Go to the Income Statement and the Balance Sheet tabs and create a common-size statement out to the side of the original ones. Then complete a financial statement analysis listing a few points of interest. You should also mention some of your findings in your Summary (Part 4). (A financial statement analysis is basically just taking a look at the financial statements to get an overall picture of the company. For instance, by looking at the amount of revenues generated, you can get an idea about the size of a company and by looking at multiple years, you can learn if the revenues are growing or declining. Both are important bits of information about the company.)

MYSTERY COMPANY INCOME STATEMENT Common Size Income Statement Sparklines Optional 2015 25,413 15,624 9,789 2,434 2016 24,622 14,417 10,205 2,385 12 Months Ended 2017 22,820 12,200 10,620 2,231 2018 21,025 10,239 10,786 2,200 2019 21,076 9,961 11,115 2,229 Fiscal year ends in December. USD in millions except per share data. 2015 2016 2017 2018 100.000% 100.000% 100.000% 100.000% 61.48% 58.55% 53.46% 48.70% 38.52% 41.45% 46.54% 51.30% 9.58% 9.69% 9.78% 10.46% 2019 100.000 47.26% 52.74% 10.58% 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,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 2,200 8,586 977 147 85 (25) 7,816 1,892 5,924 2,229 8,886 1,085 202 30 (15) 8,018 1,993 6,025 9.58% 28.94% 2.48% -0.36% -0.25% -0.07% 25.79% 7.97% 17.82% 9.69% 31.76% 3.58% 0.32% -0.53% -0.09% 27.89% 8.85% 19.03% 9.78% 36.76% 4.01% 0.69% 4.29% -0.17% 37.57% 14.82% 22.75% 10.46% 40.84% 4.65% 0.70% 0.40% -0.12% 37.17% 9.00% 28.18% 10.58% 42.16% 5.15% 0.96% 0.14% -0.07% 38.04% 9.46% 28.59% Earnings per share Weighted average shares outstanding 4.82 939 5.49 854 6.43 807 7.61 778 7.95 758 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 118 122 172 175 Market Price of Mystery Company's Stock Use this for your Market Ratios 198 MYSTERY COMPANY BALANCE SHEET Common-Size Balance Sheet Sparklines Optional Consolidated Balance Sheet - USD ($) $ in Millions Cash and cash equivalents Receivables 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 Inventories 2016 1,223 1,474 59 ECE 565 1,527 2010 4,849 34,443 444 (13,186) ace 21,258 ac 726 2,336 OCE 1,855 26,175 2012 31,024 77 arc 9,643 602 37,692 (14,575) 23,118 793 2516 2,516 1,869 1 869 28,296 37,939 ) 5,327 36,626 (14,178) 22,448 2.448 1000 1,086 2,380 2,563 28,476 33,804 20 4,053 37,194 (14,351) 22,843 1202 1,203 2223 2,332 2,381 28,758 32,881 2016 3.94% 4.75% 0.19% 1.82% 199 4.92% TEC 15.63% 44 111.02% con -42.50% CON 68.52% 2210 2.34% *** 7.53% 5.98% 84.37% A 220v mer 3,558 52,312 (14,891) 37,421 1220 1,270 2,678 BOR 2,584 43,953 47544 47,511 con 680 000 988 220 338 579 1,036 100.00% 756 925 874 233 464 1,379 279 541 1,146 1,208 297 482 987 Prepaid expenses Other current assets Fans Total current assets Property, plant and equipment Accumulated Depreciation R Net property, plant and equipment Equity and other investments Goodwill Other long-term assets Fatal 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 doht 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 Som Additional paid-in capital Retained earnings Treasury stock Accumulated other comprehensive income Total stockholders' equity TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY 248 533 ar 1,159 cor 695 3,468 25,878 1,817 2015 20.26% 3.42% 0.26% 1.47% Azex oner 0.00% 25.42% ZE 490 99.35% 2001 -38.42% C 60.93% 2.09% ca 6.63% 4.93% w 74.58% 100.00% 0.00% 200 2.30% cao 0.61% 1.22% 200 3.63% Co 0.00% 7.78% 63.58% C CON A 4.49% 0.00% onex 0.00% one 5.47% 73.54% 81.32% 0.04% 17.22% 1.220 117.54% -108.53% -7.59% 18.68% % 100.00% 2017 7.29% 5.85% 0.17% 2.45% 0.00% 15.76% 2 108.35% 44 0 -41.94% CC 190 66.41% 2240 3.21% 7040 7.04% 7.58% 4220 84.24% 100.00% 0.00% 20 2.74% 0.83% co 1.60% 3.39% 0.00% EN 8.55% 20 87.38% 22 3.31% 0.00% 7.01% 3.41% 101.12% 109.67% 0.05% 20.92% 22 142.96% -167.15% -6.44% -9.67% 100.00% 2018 2.63% 7.43% 0.16% 2.11% 490 0.00% 1922 12.33% 442490 113.12% -43.65% 29 CEN 69.47% 3.66% 7.09% 7.24% 02 87.46% 100.00% 100 ne 0.00% 3.67% 0.90% 1.47% 3.00% 0.00% 9.04% 94.51% A 5102 2002 3.70% 1.91% 6.33% 3.33% 109.78% 118.82% 0.05% 22.44% 153.54% -187.13% -7.94% - 19.03% 100.00% 2019 1.89% 4.68% 0.11% ng 0.81% 0.00% 1400 7.49% so 110.11% -31.34% 70 78.76% 2.67% ES 5.64% MB 5.44% 02 92.51% 100.00% 1.43% 2.08% 10 0.71% 1.22% 2.18% 0.00% 7.62% 29 ECO 98.66% 2.77% 1.39% 1 2002 A220 4.77% 2.06% 109.66% 117.28% co 0.04% 16.11% --- 111.41% - 139.61% -5.23% -17.28% 100.00% 2,950 24,122 1,704 2,891 29,537 1,119 0.25% 2220 2.44% non 0.80% 1.72% 3.74% 2.24% 1940 11.18% 02.448 83.41% OCH 5.86% one 0.00% 0.00% 6.66% 95.93% 107.10% 0.05% 21.78% 148.99% - 167.96% -9.97% -7.10% 100.00% 2,074 27,900 30,851 17 6,533 44,594 (41,177) (2,879) 7,088 37,939 2,371 1,154 34,181 37,072 17 7,072 48,325 ( (56,504) (2,178) (3,268) 33,804 2,065 29,760 33,228 17 6,758 46,223 (52,109) (3,093) (2,204) 31,024 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