Please show the values for D1, D2, P2, PV(D1+D2), PV(P2), and the intrinsic value. Thank you and use Excel if possible.

Question 3. Company BMI will experience a supernormal growth rate of 20% in the next two years. The growth rate will then level off to 5% from year 3 and beyond. The most recent dividend payment was $2.00 and the required rate of return for BMI stock is 10%. What is the intrinsic value of the BMI stock