Explore BrainMass

Explore BrainMass

    calculate this problem using excel

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

    I need to know how to calculate this problem using excel. A model is also on the sheet that can be used as a guide. The numbers in the model have nothing to do with the problem.

    The Seattle Corporation has been presented with an investment opportunity which will yield end-of-year cash flows of $30,000 per year in Years 1 through 4, $35,000 per year in Years 5 through 9, and $40,000 in Year 10.
    The investment will cost the firm $150,000 today, and the firm's cost of capital is 10 percent.
    a. What is the payback period, discounted payback period, npv, IRR, and MIRR for this investment?
    b. Should the project be accepted or rejected?

    © BrainMass Inc. brainmass.com June 3, 2020, 6:43 pm ad1c9bdddf


    Solution Summary

    This job calculates this problem using excel.