If we assume that - both Cash and ST Investments earn interest - the company does not pay interest on Other Long Term Liabilities, the 2019 Interest Income (C25) and the 2019 Interest Expense (C26) should be calculated as... Make sure that you click on the button that is located ABOVE the correct answer Interest Income = $B$14*(B34+C34)/2 Interest Expense = $B$15*(B45+C45)/2 Interest Income = $B$14*C34 Interest Expense = $B$14*C45 Interest Income = $B$15*B34 Interest Expense = $B$14*B45 Interest Income = $B$14*B34 Interest Expense = $B$15*B45 Interest Income = $B$15*AVERAGE(B34:C34) Interest Expense = $B$14*AVERAGE(B45:C45)

A 1 A11Y 2 Back to Index 3 Value Drivers - The value drivers 4 Sales Growth 5 Directly related to sales 6 ting Expenses (excluding depreciation) - Slope 7 Expenses (excluding depreciation) - Intercept 8 Operating Current Assets 9 Operating Current Liabilities 10 Capital Expenditures 11 Other Fixed Assets 12 Not directly related to sales 13 Depreciation Rate 14 Interest Rate on Debt 15 Interest Rate on ST Investments 16 Tax Rate 17 Dividend Payout 18 19 INCOME STATEMENT - This regio 20 PERIOD ENDING 12/31 ($1,000) 21 Sales 22 Operating Expenses (excluding depreciation) 23 Depreciation 24 Earnings Before Interest And Taxes 25 Interest Income 26 Interest Expense 27 Earnings Before Taxes 28 Income Tax Expense 29 Net Income 30 31 BALANCE SHEET - This region con 32 PERIOD ENDING 12/31 ($1,000) 33 Assets 34 Cash & ST Investments 35 Operating Current Assets 36 Total Current Assets 37 Addition to fixed assets 38 Addition to depreciation 39 Net fixed assets 40 Other Fixed Assets 41 Total Fixed Assets Total Assets 42 43 44 Operating Current Liabilities 45 Long Term Debt 46 Other Long Term Liabilities 47 Total Liabilities 48 All Other Equity 49 Retained Earnings 50 Total Equity Total Liabilities & Equity 51 52 Liabilities & Equity B 8.35% 0.61 9,447,564 21.11% 30.75% 5.23% 98.20% 19.52% 2.10% 2.55% 25.75% 26.27% C D 2018 2019 2020 248,363,925 269,090,271 291,546,26 161,452,028 174,137,030 187,880,61 12,587,298 15,123,891 17,872,16 74,324,599 79,829,349 85,793,47 ? ? 74,094,159 79,659,145 86,145,31 19,081,180 20,514,309 22,184,66 55,012,979 59,144,836 63,960,64 2018 2019 2020 100,124,036 40,028,723 69,919,60 52,427,988 56,803,183 61,543,49 152,552,023 96,831,905 131,463,10 12,995,576 14,080,077 15,255,08 2,430,298 2,536,593 2,748,21 34,191,278 33,147,464 30,530,31 243,890,017 264,243,009 286,294,48 278,081,295 297,390,473 316,824,86 430,633,319 394,222,378 448,287,96 76,379,127 82,753,081 89,658,95 136,393,802 50,000,000 50,000,00 43,251,000 43,251,000 43,251,00 256,023,929 176,004,081 182,909,95 35,717,000 35,717,000 35,717,00 138,892,390 182,501,297 229,661,01 174,609,390 218,218,297 265,378,01 430,633,319 394,222,378 448,287,96 A 1 A11Y 2 Back to Index 3 Value Drivers - The value drivers 4 Sales Growth 5 Directly related to sales 6 ting Expenses (excluding depreciation) - Slope 7 Expenses (excluding depreciation) - Intercept 8 Operating Current Assets 9 Operating Current Liabilities 10 Capital Expenditures 11 Other Fixed Assets 12 Not directly related to sales 13 Depreciation Rate 14 Interest Rate on Debt 15 Interest Rate on ST Investments 16 Tax Rate 17 Dividend Payout 18 19 INCOME STATEMENT - This regio 20 PERIOD ENDING 12/31 ($1,000) 21 Sales 22 Operating Expenses (excluding depreciation) 23 Depreciation 24 Earnings Before Interest And Taxes 25 Interest Income 26 Interest Expense 27 Earnings Before Taxes 28 Income Tax Expense 29 Net Income 30 31 BALANCE SHEET - This region con 32 PERIOD ENDING 12/31 ($1,000) 33 Assets 34 Cash & ST Investments 35 Operating Current Assets 36 Total Current Assets 37 Addition to fixed assets 38 Addition to depreciation 39 Net fixed assets 40 Other Fixed Assets 41 Total Fixed Assets Total Assets 42 43 44 Operating Current Liabilities 45 Long Term Debt 46 Other Long Term Liabilities 47 Total Liabilities 48 All Other Equity 49 Retained Earnings 50 Total Equity Total Liabilities & Equity 51 52 Liabilities & Equity B 8.35% 0.61 9,447,564 21.11% 30.75% 5.23% 98.20% 19.52% 2.10% 2.55% 25.75% 26.27% C D 2018 2019 2020 248,363,925 269,090,271 291,546,26 161,452,028 174,137,030 187,880,61 12,587,298 15,123,891 17,872,16 74,324,599 79,829,349 85,793,47 ? ? 74,094,159 79,659,145 86,145,31 19,081,180 20,514,309 22,184,66 55,012,979 59,144,836 63,960,64 2018 2019 2020 100,124,036 40,028,723 69,919,60 52,427,988 56,803,183 61,543,49 152,552,023 96,831,905 131,463,10 12,995,576 14,080,077 15,255,08 2,430,298 2,536,593 2,748,21 34,191,278 33,147,464 30,530,31 243,890,017 264,243,009 286,294,48 278,081,295 297,390,473 316,824,86 430,633,319 394,222,378 448,287,96 76,379,127 82,753,081 89,658,95 136,393,802 50,000,000 50,000,00 43,251,000 43,251,000 43,251,00 256,023,929 176,004,081 182,909,95 35,717,000 35,717,000 35,717,00 138,892,390 182,501,297 229,661,01 174,609,390 218,218,297 265,378,01 430,633,319 394,222,378 448,287,96