It appears that I can use the H-Model to solve for “r”, as long as I leave out the “t/2” in the second numerator. Am I correct to assume such?
This is the one-step model. I think the H model only applies if there is more than one change in the growth rate. Plus I have no idea where “t/2” is in the problem.
Now this is a bit of an ugly PV expression, but there is a wonderfully simple way of solving this. Use the CF worksheet and start with choice B (@s2000magician ) of 9%.
CF0=-54.45
C01 = yr 1 dividend = 2.14
F01 = 1
C02 = yr 2 dividend + terminal value assuming 9% = 2.2898 + 60.10725 = 62.39705
F02 = 1
Using the NPV worksheet, set I=9 and CPT NPV -0.01835, which is prettty darned close to 0, implying 9% works! Or you could use the IRR worksheet to solve for the IRR (8.98131%), which is pretty darned close to 9%
Ya know, this would make a veeeeeery interesting exam question!!!
Perfect. I never thought to simply apply one of the answer options into the I function of NPV.