Common Size Income Statement 2019 2015 2016 2017 2019 Sorin Option: 2018 21,025 10,239 10.786 2.200 21.025 9,951 11,115 2.229 MYSTERY COMPANY INCOME STATEMENT Consolidated Statement of income. USD hares in 12 Months Ended Millions, Sin Millions 2015 2016 2017 Revenge 2.622 22.820 Cost of revenue (COGS 15.624 14,417 12,200 Grout profit 9,7 10,205 10.620 Sales General and administrative 2,414 2.185 2.231 Other Operating Incomia/Expense Total operating 2,414 2,385 2.231 Operating income (Also called EBIT) 7.355 7.820 8.389 Net Interest pense Net investment income 1911 79 158 income pense 1631 (1301 Other income/Expense (17) 122) (39) Income before taxes 6,866 8.573 Provision for income taxes 2,026 2.180 3,381 Net Income 4,529 4,686 5,192 2.229 2,200 8.586 977 147 105 202 30 555 (25) 7.816 1.892 5924 R018 1.993 6,025 5.49 6.43 807 7.61 778 7.95 758 939 Earines per share Weighted average shares outstanding Market Price of Mystery Company's Stock Use this for your Market Ratios 118 122 172 175 Spardines 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 form down the column to do a sparkline for each item on the Income Statement Income Statement Analysis Take a look at the income Statement and the CommonSite 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 performance over the five year period). ABOUT THE INCOME STATEMENT The Income Statement sumarizes a company's revenues and expenses, Based on the equation: Revenues - Expenses - Net Income The Income Statement is also known as a Profit and Loss Statement Most income statements cover a 1-year period All Income Statements have 3 parts: (they may be named differently, but will always give the same information) First Part = Gross Profits, also called Statement of Earnings The first part always subtracts the COGS from the total revenue Second Part = Operating Results, also called Statement of Operations, or EBIT (Earnings before interest and taxes.) The second part always subtracts the operating expenses from the gross profit Third Part = Net Profits, also called Statement of Income which usually includes EPS and the Number of Shares Outstanding The third part always subtracts out interest and taxes The Common-Size Income Statement expresses the Income Statement as a percentage of Total Revenue (Sales). (Divide everything by Total Sales) Earnings Available to Shareholders (Text page 55 or under section titled "Income Statement" in Chapter 3.1) Earnings Available to Shareholders = Net Income less Preferred Stock Dividends (if the company has Preferred Stock) If the company does not have preferred stock: Earnings Available to Shareholders = Net Income K M N 0 Common Size Income Statement Sparklines Optional 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% 53.46% 48.70% 47.26% 38.52% 41.45% 46.54% 51.30% 52.74% 9.58% 9.69% 9.78% 10.46% 10.58% 0.00% 0.00% 0.00% 0.00% 0.00% 9.58% 9.69% 9.78% 10.46% 10.58% 28.94% 31.76% 36.76% 40.84% 42.16% 2.48% 3.58% 4.01% 4.65% 5.15% -0.36% 0.32% 0.69% 0.70% 0.96% -0.25% -0.53% 4.29% 0.40% 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% 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. Common Size Income Statement 2019 2015 2016 2017 2019 Sorin Option: 2018 21,025 10,239 10.786 2.200 21.025 9,951 11,115 2.229 MYSTERY COMPANY INCOME STATEMENT Consolidated Statement of income. USD hares in 12 Months Ended Millions, Sin Millions 2015 2016 2017 Revenge 2.622 22.820 Cost of revenue (COGS 15.624 14,417 12,200 Grout profit 9,7 10,205 10.620 Sales General and administrative 2,414 2.185 2.231 Other Operating Incomia/Expense Total operating 2,414 2,385 2.231 Operating income (Also called EBIT) 7.355 7.820 8.389 Net Interest pense Net investment income 1911 79 158 income pense 1631 (1301 Other income/Expense (17) 122) (39) Income before taxes 6,866 8.573 Provision for income taxes 2,026 2.180 3,381 Net Income 4,529 4,686 5,192 2.229 2,200 8.586 977 147 105 202 30 555 (25) 7.816 1.892 5924 R018 1.993 6,025 5.49 6.43 807 7.61 778 7.95 758 939 Earines per share Weighted average shares outstanding Market Price of Mystery Company's Stock Use this for your Market Ratios 118 122 172 175 Spardines 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 form down the column to do a sparkline for each item on the Income Statement Income Statement Analysis Take a look at the income Statement and the CommonSite 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 performance over the five year period). ABOUT THE INCOME STATEMENT The Income Statement sumarizes a company's revenues and expenses, Based on the equation: Revenues - Expenses - Net Income The Income Statement is also known as a Profit and Loss Statement Most income statements cover a 1-year period All Income Statements have 3 parts: (they may be named differently, but will always give the same information) First Part = Gross Profits, also called Statement of Earnings The first part always subtracts the COGS from the total revenue Second Part = Operating Results, also called Statement of Operations, or EBIT (Earnings before interest and taxes.) The second part always subtracts the operating expenses from the gross profit Third Part = Net Profits, also called Statement of Income which usually includes EPS and the Number of Shares Outstanding The third part always subtracts out interest and taxes The Common-Size Income Statement expresses the Income Statement as a percentage of Total Revenue (Sales). (Divide everything by Total Sales) Earnings Available to Shareholders (Text page 55 or under section titled "Income Statement" in Chapter 3.1) Earnings Available to Shareholders = Net Income less Preferred Stock Dividends (if the company has Preferred Stock) If the company does not have preferred stock: Earnings Available to Shareholders = Net Income K M N 0 Common Size Income Statement Sparklines Optional 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% 53.46% 48.70% 47.26% 38.52% 41.45% 46.54% 51.30% 52.74% 9.58% 9.69% 9.78% 10.46% 10.58% 0.00% 0.00% 0.00% 0.00% 0.00% 9.58% 9.69% 9.78% 10.46% 10.58% 28.94% 31.76% 36.76% 40.84% 42.16% 2.48% 3.58% 4.01% 4.65% 5.15% -0.36% 0.32% 0.69% 0.70% 0.96% -0.25% -0.53% 4.29% 0.40% 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% 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