Excel Income Statement
Income Statement For the Years ended 2013 to 2017 and pro forma 2018 SCORE POSSIBLE 20 Dollars in Thousands 2018 2017 2016 2015 2014 2013 59,841 $ 56,745 $51,407$ 43,396 $ 42.401 S39,244 19,831 19.413 12,406 Trend Avg % of Sales of Prior 5 years Cost of Sales Gross Operating Profit Selling, General & Administration Expenses Depreciation & Amortization EBIT Other Income, Net nterest expense Pre-tax Income Income Taxes Total Net Income 25,920 30,825 18,010 1,895 10,920 346 834 10,432 3,130 23,343 28,064 16,504 1,733 9,827 152 629 9,350 2,805 20,438 22,958 13.383 1,703 7,872 238 561 7,549 2,265 20.005 22,396 12,571 1.693 8,132 308 603 7,837 2,351 59,841 Avg % of Sales of Prior 5 years 2,2 71 Calculate (see Assumptions) 4,736 674 794 4,616 1,385 $7,302 $6,545$5,284$ 5,486$3,231 59,841 Same as Prior Year Calculate (see Assumptions) 59,841 17,952 Tax Rate Additional Depreciation (to add to last years) Additional Interest Exp (to add to last year's) Additional Debt Rate Basic EPS from Operations Dividends per Common Share Preferred Dividends Hint: Look for additional depreciation on the Balance Sheet notes and link it here. Hint: What is the change in Long Term Debt from the Balance Sheet? Add the new expense to Last Year's expense 12.00% To be applied to Additional Debt as Additional Interest Expense. of dividends by 10% 1.03 136 $ 0.93 131 $ 0.82 125 $ 0.76 124 S 0.7 Assume increase 21 Same as previous year Income Statement For the Years ended 2013 to 2017 and pro forma 2018 SCORE POSSIBLE 20 Dollars in Thousands 2018 2017 2016 2015 2014 2013 59,841 $ 56,745 $51,407$ 43,396 $ 42.401 S39,244 19,831 19.413 12,406 Trend Avg % of Sales of Prior 5 years Cost of Sales Gross Operating Profit Selling, General & Administration Expenses Depreciation & Amortization EBIT Other Income, Net nterest expense Pre-tax Income Income Taxes Total Net Income 25,920 30,825 18,010 1,895 10,920 346 834 10,432 3,130 23,343 28,064 16,504 1,733 9,827 152 629 9,350 2,805 20,438 22,958 13.383 1,703 7,872 238 561 7,549 2,265 20.005 22,396 12,571 1.693 8,132 308 603 7,837 2,351 59,841 Avg % of Sales of Prior 5 years 2,2 71 Calculate (see Assumptions) 4,736 674 794 4,616 1,385 $7,302 $6,545$5,284$ 5,486$3,231 59,841 Same as Prior Year Calculate (see Assumptions) 59,841 17,952 Tax Rate Additional Depreciation (to add to last years) Additional Interest Exp (to add to last year's) Additional Debt Rate Basic EPS from Operations Dividends per Common Share Preferred Dividends Hint: Look for additional depreciation on the Balance Sheet notes and link it here. Hint: What is the change in Long Term Debt from the Balance Sheet? Add the new expense to Last Year's expense 12.00% To be applied to Additional Debt as Additional Interest Expense. of dividends by 10% 1.03 136 $ 0.93 131 $ 0.82 125 $ 0.76 124 S 0.7 Assume increase 21 Same as previous year
