3 Sales/Revenue 4 Cost of Goods Sold (COGS) $ $ ho - 6 Gross Income 7 S&A Expense EBIT 9 Interest Expense 10 Pretax Income 11 $ $ $ $ $ D E F 3,412,000 $3,300,000 $2,945,000 $2,755,000 $3,275,000 2,699,000 $ 2,614,000 $2,361,000 $2,230,000 $2,641,000 713,000 $ 686,000 $ 584,000 $ 525,000 $ 634,000 484,000 $ 502,000 $ 457,000 $ 420,000 $ 414,000 229,000 $ 184,000 $ 127,000 $ 105,000 $ 220,000 81,000 $ 84,000 $ 88,000 $ 84,000 $ 77,000 148,000 $ 100,000 $ 39,000 $ 21,000 $ 143,000 12 13 14 $ $ $ $ $ 2019 2018 2017 2016 414,000 $ 279,000 $ 358,000 $ 307,000 $ 701,000 $ 662,000 $ 565,000 $ 532,000 $ 215,000 $ 199,000 $ 176,000 $ 178,000 $ 201,000 $ 186,000 $ 163,000 $ 167,000 $ 1,531,000 $ 1,326,000 $1,262,000 $ 1,184,000 $ 2015 185,000 522,000 150,000 136,000 993,000 15 16 Assets 17 18 Cash & Short Term Investments 19 Accounts Receivable 20 Finished Goods Inventory 21 Raw Materials 22 Total Current Assets 23 24 Buildings 25 Land 26 Machinery & Equipment 27 Construction in Progress 28 Transportation Equipment 29 Other Property, Plant & Equipment 30 Accumulated Depreciation 31 Total Plant Assets 32 33 Total Assets 34 35 Liabilities & Shareholders' Equity 36 37 Accounts Payable 18 Income Tax Payable 39 Accrued Payroll 40 Miscellaneous Current Liabilities Sheet1 + $ $ $ $ S $ $ $ 499,000 $ 440,000 $ 414,000 $ 373,000 S 344,000 131,000 $ 124,000 $ 122,000 $ 121,000 $ 101,000 1,938,000 $ 1,850,000 $ 1,814,000 5 1,636,000 $1,478,000 37,000 $ 21,000 $ 58,000 $ 147,000 $ 114,000 785,000 $ 722,000 $ 618,000 $ 541,000 $ 501,000 204,000 $ 176,000 $ 165,000 $ 160,000 $ 154,000 2,006,000 $1,771,000 1,603,000 $1,366,000 5 1,159.000 5,600,000 $5,104,000 $4,794,000 $4,344,000 $3,851,000 $ 7,131,000 $ 6,430,000 $ 6,056,000 $5,528,000 $4,844,000 $ S 347,000 $ 36,000 $ 72,000 $ 265,000 5 $ 284,000 $ 26,000 $ 81,000 $ 212.000 6 228,000 $ 27,000 $ 56.000 $ 192.000 6 230,000 $ 35,000 $ 35,000 5 205.000 $ 241,000 37,000 36,000 203.000 $ Ready G34 x fe D E F $ $ 2,006,000 $ 1,771,000 $1,603,000 $1,366,000 $ 1,159,000 5,600,000 $ 5,104,000 $4,794,000 $ 4,344,000 $ 3,851,000 $ 7,131,000 $ 6,430,000 $ 6,056,000 $ 5,528,000 $4,844,000 $ $ $ $ $ 347,000 $ 36,000 $ 72,000 $ 265,000 $ 720,000 $ 284,000 $ 26,000 $ 81,000 $ 212,000 $ 603,000 $ 228,000 $ 27,000 $ 56,000 $ 192,000 $ 503,000 $ 230,000 $ 35,000 $ 35,000 $ 205,000 $ 505,000 $ 241,000 37,000 36,000 203,000 517,000 30 Accumulated Depreciation 31 Total Plant Assets 32 33 Total Assets 34 35 Liabilities & Shareholders' Equity 36 37 Accounts Payable 38 Income Tax Payable 39 Accrued Payroll 40 Miscellaneous Current Liabilities 41 Total Current Liabilities 42 43 Long-Term Liabilities 44 Note Payable 45 Other Long Term Liabilities 46 Total Long Term Liabilities 47 48 Total Liabilities 49 50 Common Equity (Total) 51 Retained Earnings 52 Total Equity 53 54 Uabilities & Shareholders' Equity $ $ $ 2,395,000 $2,401,000 $2,352,000 $2,432,000 $2,167,000 444,000 $ 168,000 $ 166,000 $ 166,000 $ 168,000 2,839,000 $2,569,000 $ 2,518,000 $2,598,000 S 2,335,000 $ 3,559,000 $3,172,000 $3,021,000 $3,103,000 $ 2,852,000 $ $ $ 1,770,759 $ 1,770,759 $ 1,802,379 $ 1,834,000 $ 1,834,000 1,801,241 $ 1,487,241 $ 1,232,621 S 591,000 $ 158,000 3,572,000 $3,258,000 $3,035,000 $2,425,000 $ 1,992,000 $ 7,131,000 $ 6,430,000 $ 6,056,000 $ 5,528,000 $ 4,844,000 56 Current Stock Price S7 Basic Shares Outstanding 59 $49.55 56000 56000 57000 58000 58000 61 62 64 69 55 Sheet1 + Please complete a financial analysis and call out at least 5 areas you would want to do additional research on and support your answer with financial analysis reasoning. You can use Vertical, Trend or Ratio analysis to support your answer 3 Sales/Revenue 4 Cost of Goods Sold (COGS) $ $ ho - 6 Gross Income 7 S&A Expense EBIT 9 Interest Expense 10 Pretax Income 11 $ $ $ $ $ D E F 3,412,000 $3,300,000 $2,945,000 $2,755,000 $3,275,000 2,699,000 $ 2,614,000 $2,361,000 $2,230,000 $2,641,000 713,000 $ 686,000 $ 584,000 $ 525,000 $ 634,000 484,000 $ 502,000 $ 457,000 $ 420,000 $ 414,000 229,000 $ 184,000 $ 127,000 $ 105,000 $ 220,000 81,000 $ 84,000 $ 88,000 $ 84,000 $ 77,000 148,000 $ 100,000 $ 39,000 $ 21,000 $ 143,000 12 13 14 $ $ $ $ $ 2019 2018 2017 2016 414,000 $ 279,000 $ 358,000 $ 307,000 $ 701,000 $ 662,000 $ 565,000 $ 532,000 $ 215,000 $ 199,000 $ 176,000 $ 178,000 $ 201,000 $ 186,000 $ 163,000 $ 167,000 $ 1,531,000 $ 1,326,000 $1,262,000 $ 1,184,000 $ 2015 185,000 522,000 150,000 136,000 993,000 15 16 Assets 17 18 Cash & Short Term Investments 19 Accounts Receivable 20 Finished Goods Inventory 21 Raw Materials 22 Total Current Assets 23 24 Buildings 25 Land 26 Machinery & Equipment 27 Construction in Progress 28 Transportation Equipment 29 Other Property, Plant & Equipment 30 Accumulated Depreciation 31 Total Plant Assets 32 33 Total Assets 34 35 Liabilities & Shareholders' Equity 36 37 Accounts Payable 18 Income Tax Payable 39 Accrued Payroll 40 Miscellaneous Current Liabilities Sheet1 + $ $ $ $ S $ $ $ 499,000 $ 440,000 $ 414,000 $ 373,000 S 344,000 131,000 $ 124,000 $ 122,000 $ 121,000 $ 101,000 1,938,000 $ 1,850,000 $ 1,814,000 5 1,636,000 $1,478,000 37,000 $ 21,000 $ 58,000 $ 147,000 $ 114,000 785,000 $ 722,000 $ 618,000 $ 541,000 $ 501,000 204,000 $ 176,000 $ 165,000 $ 160,000 $ 154,000 2,006,000 $1,771,000 1,603,000 $1,366,000 5 1,159.000 5,600,000 $5,104,000 $4,794,000 $4,344,000 $3,851,000 $ 7,131,000 $ 6,430,000 $ 6,056,000 $5,528,000 $4,844,000 $ S 347,000 $ 36,000 $ 72,000 $ 265,000 5 $ 284,000 $ 26,000 $ 81,000 $ 212.000 6 228,000 $ 27,000 $ 56.000 $ 192.000 6 230,000 $ 35,000 $ 35,000 5 205.000 $ 241,000 37,000 36,000 203.000 $ Ready G34 x fe D E F $ $ 2,006,000 $ 1,771,000 $1,603,000 $1,366,000 $ 1,159,000 5,600,000 $ 5,104,000 $4,794,000 $ 4,344,000 $ 3,851,000 $ 7,131,000 $ 6,430,000 $ 6,056,000 $ 5,528,000 $4,844,000 $ $ $ $ $ 347,000 $ 36,000 $ 72,000 $ 265,000 $ 720,000 $ 284,000 $ 26,000 $ 81,000 $ 212,000 $ 603,000 $ 228,000 $ 27,000 $ 56,000 $ 192,000 $ 503,000 $ 230,000 $ 35,000 $ 35,000 $ 205,000 $ 505,000 $ 241,000 37,000 36,000 203,000 517,000 30 Accumulated Depreciation 31 Total Plant Assets 32 33 Total Assets 34 35 Liabilities & Shareholders' Equity 36 37 Accounts Payable 38 Income Tax Payable 39 Accrued Payroll 40 Miscellaneous Current Liabilities 41 Total Current Liabilities 42 43 Long-Term Liabilities 44 Note Payable 45 Other Long Term Liabilities 46 Total Long Term Liabilities 47 48 Total Liabilities 49 50 Common Equity (Total) 51 Retained Earnings 52 Total Equity 53 54 Uabilities & Shareholders' Equity $ $ $ 2,395,000 $2,401,000 $2,352,000 $2,432,000 $2,167,000 444,000 $ 168,000 $ 166,000 $ 166,000 $ 168,000 2,839,000 $2,569,000 $ 2,518,000 $2,598,000 S 2,335,000 $ 3,559,000 $3,172,000 $3,021,000 $3,103,000 $ 2,852,000 $ $ $ 1,770,759 $ 1,770,759 $ 1,802,379 $ 1,834,000 $ 1,834,000 1,801,241 $ 1,487,241 $ 1,232,621 S 591,000 $ 158,000 3,572,000 $3,258,000 $3,035,000 $2,425,000 $ 1,992,000 $ 7,131,000 $ 6,430,000 $ 6,056,000 $ 5,528,000 $ 4,844,000 56 Current Stock Price S7 Basic Shares Outstanding 59 $49.55 56000 56000 57000 58000 58000 61 62 64 69 55 Sheet1 + Please complete a financial analysis and call out at least 5 areas you would want to do additional research on and support your answer with financial analysis reasoning. You can use Vertical, Trend or Ratio analysis to support your