Explore BrainMass
Share

Explore BrainMass

    Stock ROI

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

    I would like assistance with a Microsoft Excel solution to the attached problem. Thanks so much.

    © BrainMass Inc. brainmass.com October 10, 2019, 3:13 am ad1c9bdddf
    https://brainmass.com/economics/estimation-and-forecasting/stock-roi-411977

    Attachments

    Solution Preview

    Dear student,
    The solution is attached.

    CorpGroup stock can be purchased for $150 today. An investment analyst forecasts quarterly dividends for CorpGroup stock as shown below. What would the price need to be 3 years from now to make a12% return.
    Quarter 1 2 3 4 1 2 3 4 1 2 3 4
    Dividends $2.00 $3.00 $3.50 $3.50 $4.00 $4.00 $4.50 $4.50 $4.00 $4.00 $3.00 $2.00

    We know that current ...

    Solution Summary

    Price to expedite returns in this case is determined.

    $2.19