Spreadsheet Problem: Variable Growth Spreadsheets are especially useful for computing stock value under different assumptions. Consider a firm that is expected to pay the following dividends:

a. Using an 11 percent discount rate, what would be the value of this stock?

b. What is the value of the stock using a 10 percent discount rate? A 12 percent discount rate?

c. What would the value be using a 6 percent growth rate after year 6 instead of the 5 percent rate using each of these three discount rates?

d. What do you conclude about stock valuation and its assumptions?

Year 1 2 3 4 5 6 $1.20 $1.20 $1.50 $1.50 $1.75 $1.90 and grow at 5% thereafter