Explore BrainMass

Explore BrainMass

    Stock valuation

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED 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 March 4, 2021, 9:58 pm ad1c9bdddf
    https://brainmass.com/business/finance/stock-valuation-constant-growth-model-287237

    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

    $2.49

    ADVERTISEMENT