Explore BrainMass

Stock valuation

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

IP Inc is expected to pay $1.70 dividends next year. The dividend growth rate is expected to be 7% forever. If the required rate of return for IP is 10%, calculate the price of the stock using the constant growth model. If the stock is currently selling for $63, indicate whether the stock is under priced or overpriced.

Please show calculations by hand. Also show calculations via Excel if possible as well.

© BrainMass Inc. brainmass.com December 20, 2018, 4:26 am ad1c9bdddf

Solution Preview

Please see the attached for Excel calculation.

Using the constant growth model
Price ...

Solution Summary

The solution explains how to calculate the price of a stock using constant growth model