8-37 Spreadsheet Problem Spreadsheets are especially useful for computing stock value under different assumptions. Consider a firm that is expected to pay the following dividends: Year 1 2 3 4 5 6 $1.20 $1.20 $1.50 $1.50 $1.75 $1.90 and grow at 5% thereafter 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