Knight Supply Corp. has not grown for the past several years, and management expects this lack...

  

 

Transcribed Image Text:

Knight Supply Corp. has not grown for the past several years, and management expects this lack of growth to continue. The firm last paid a dividend of $3.56. You require a rate of return 13 percent. Dividend Rate of Return $ 3.56 13.0% Required: Provide input into cells shaded in gray in this template. Use mathematical formulas with cell references to the Problem area to calculate. Calculate the following. What is the current value of this stock to you? Current Value X Calibri board BIU Font 12 AA ' ' a A Wrap Text Text Merge & Center $ % 960 .00 .00 0 Conditional Format as Formatting Table St Alignment Number Styles B Xfx Formulas: Divide, Add, Cell Referencing C ormulas: Divide, Add, Cell Referencing E9.13-Using Excel to Calculate Rate of Return. PROBLEM D E F G H J K L M Constant growth: Proxicam, Inc., is expected to grow at a constant rate of 7 percent. If the company's next dividend, which will be paid in a year, is $1.15 and its current stock price is $22.35. Student Work Area Required: Provide input into cells shaded in gray in this template. Use Excel or mathematical formulas with cell references to the Problem or work area as indicated. 9 Growth Rate 7.0% 10 Dividend $ 11 Current Stock Price 1.15 $ 22.35 12 13 14 15 16 17 18 19 20 21 Enter Answer Accessibility: Good to go Ready 64F Sunny + Search What is the required rate of return on this stock? Rate of Return F10 F1 F2 F3 F4 F5 F6 F7 F8 a W A S # # 4 $ % A & 5 7 E R T Y D F G H K C V B N M Knight Supply Corp. has not grown for the past several years, and management expects this lack of growth to continue. The firm last paid a dividend of $3.56. You require a rate of return 13 percent. Dividend Rate of Return $ 3.56 13.0% Required: Provide input into cells shaded in gray in this template. Use mathematical formulas with cell references to the Problem area to calculate. Calculate the following. What is the current value of this stock to you? Current Value X Calibri board BIU Font 12 AA ' ' a A Wrap Text Text Merge & Center $ % 960 .00 .00 0 Conditional Format as Formatting Table St Alignment Number Styles B Xfx Formulas: Divide, Add, Cell Referencing C ormulas: Divide, Add, Cell Referencing E9.13-Using Excel to Calculate Rate of Return. PROBLEM D E F G H J K L M Constant growth: Proxicam, Inc., is expected to grow at a constant rate of 7 percent. If the company's next dividend, which will be paid in a year, is $1.15 and its current stock price is $22.35. Student Work Area Required: Provide input into cells shaded in gray in this template. Use Excel or mathematical formulas with cell references to the Problem or work area as indicated. 9 Growth Rate 7.0% 10 Dividend $ 11 Current Stock Price 1.15 $ 22.35 12 13 14 15 16 17 18 19 20 21 Enter Answer Accessibility: Good to go Ready 64F Sunny + Search What is the required rate of return on this stock? Rate of Return F10 F1 F2 F3 F4 F5 F6 F7 F8 a W A S # # 4 $ % A & 5 7 E R T Y D F G H K C V B N M