2. Your boss wants you to create a spreadsheet for a 2-stage dividend discount model valuation. The spreadsheet takes inputs of i) The most recent annual dividend, Do ii) The cost of equity in the first stage, k ii) The dividend growth rate in the first stage, gi iv) The duration (in years) of the first stage growth period v) The cost of equity in the second stage, k2 vi) The dividend growth rate in the second stage (into perpetuity), g2 and returns the intrinsic (model) value for the stock. The configuration of your spreadsheet is 1 Two-Stage Dividend Discount Model 3 Recent Annual Dividend, D First Stage Growth Period Inputs 6 8 7 duration of Stage1 9 Second Stage Growth Period Inputs 10 k 11 82 12 13 Intrinsic Value 14 a. Copy and paste the formula you use in cell B13 b. What is the intrinsic value of a stock with the following jnputs