Explore BrainMass

Explore BrainMass

    Capital project analysis

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

    Able Corporation has Project A with the following cash flows and a 8.7% cost of money: Numbers in parentheses are outflows. Both Year 0 and Year 3 cash flows are outflows.
    Year 0 1 2 3 4 5 6
    Cash flow $(312,000) $ 95,000 $120,000 $(260,000) $ 230,000 $260,000 $180,000

    Please calculate the net present value ______________

    Please calculate the profitability indexes (two decimals please)_________________

    Please calculate the modified profitability index using the terminal value approach in the textbook (two decimals please)_______________________

    Please calculate the internal rate of return (two decimals please)_____________________________

    Please calculate the modified internal rate of return (two decimals please and per the book)________________________

    Please calculate the payback period (two decimals please)________________________

    Please calculate the present value payback period (two decimals please)______________________

    © BrainMass Inc. brainmass.com June 4, 2020, 4:58 am ad1c9bdddf

    Solution Summary

    This solution provides calculations of net present value, profitability index, probability, internal rate of return, present value payback, and payback period in Excel.