Cost of Capital - VBA Using Loops 1. Stock Price Make a function that computes the price of the stock given the 5 main inputs (see below). D = $1.95 gs = 13.10% g= 2.90% 8 kDDM 7.000% n = =DDM(kddm,D1,gs,g,n) = (using the 6% kdomi from D10 = 85.272) then compute the KDDM2 (below) that will set The Price of an Equity If the Stock Price equals $51.25 the computed price equal to the actual price. kDDM2 ( = 9.450%) Goal Seek: Enter Exactly what you would in the Goal Seek tool Set Cell Use Your function from part 1 here (using the 9.450% kpDM2 from D18 = 51.25) use the same function as part a - don't make a new one! To Value By Changing Cost of Capital - VBA Using Loops 1. Stock Price Make a function that computes the price of the stock given the 5 main inputs (see below). D = $1.95 gs = 13.10% g= 2.90% 8 kDDM 7.000% n = =DDM(kddm,D1,gs,g,n) = (using the 6% kdomi from D10 = 85.272) then compute the KDDM2 (below) that will set The Price of an Equity If the Stock Price equals $51.25 the computed price equal to the actual price. kDDM2 ( = 9.450%) Goal Seek: Enter Exactly what you would in the Goal Seek tool Set Cell Use Your function from part 1 here (using the 9.450% kpDM2 from D18 = 51.25) use the same function as part a - don't make a new one! To Value By Changing