Purchase Solution

Calculate payback period, discount rate, NPV, IRR

Not what you're looking for?

Ask Custom Question

Please see attached file.

As director, you are reviewing three potential investment projects with the following cost and cash flow projections.

Cash Flow Project 1 Project 2 Project 3
Investment Cost ($400,000) ($375,000) ($400,000)
Year One Cash Flow $200,000 $75,000 $50,000
Year Two Cash Flow $50,000 $75,000 $120,000
Year Three Cash Flow $75,000 $85,000 $140,000
Year Four Cash Flow $50,000 $225,000 $125,000
Year Five Cash Flow $125,000 $60,000 $125,000

1. What is the Payback Period for each project?

2. If the discount rate for all three projects is 10.5%, What is the Net Present Value for each project?

3. What is the Internal Rate of Return (IRR) for each project?

4. If your capital investment budget of $500,000 will only allow selection of one project (making the projects now mutually exclusive), which project is best to fund?

Purchase this Solution
Solution Summary

As director, you are reviewing three potential investment projects with the following cost and cash flow projections.

Cash Flow Project 1 Project 2 Project 3
Investment Cost ($400,000) ($375,000) ($400,000)
Year One Cash Flow $200,000 $75,000 $50,000
Year Two Cash Flow $50,000 $75,000 $120,000
Year Three Cash Flow $75,000 $85,000 $140,000
Year Four Cash Flow $50,000 $225,000 $125,000
Year Five Cash Flow $125,000 $60,000 $125,000

1. What is the Payback Period for each project?

2. If the discount rate for all three projects is 10.5%, What is the Net Present Value for each project?

3. What is the Internal Rate of Return (IRR) for each project?

4. If your capital investment budget of $500,000 will only allow selection of one project (making the projects now mutually exclusive), which project is best to fund?

Purchase this Solution
Free BrainMass Quizzes
Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Operations Management

This quiz tests a student's knowledge about Operations Management

View More Free Quizzes
Related BrainMass Solutions

  • Capital Budgeting - Payback, NPV, PI, IRR

    Calculate the payback period.

  • Payback, NPV, IRR

    Calculate the payback period for the proposed investment. b.) Calculate the net present value (NPV) for the proposed investment. c.)

  • What is the NPV of new insulation in your office?

    It will take 10 years to recover $10,000 at the rate of $1,000 per year, so the payback is 10 years The solution explains how to calculate the NPV, IRR and payback period of the given investment.

  • Caspital Budgeting

    It will take 10 years to recover $10,000 at the rate of $1,000 per year, so the payback is 10 years. The solution explains how to calculate the NPV, IRR and payback period of the investment

  • Time Value of Money

    IRR IRR is the discount rate which equates the PV of expected cash inflows to the PV of project's costs -Rate which forces NPV = 0 Rationale -If IRR > WACC, then the project's rate of return

  • Net present value, payback, IRR, and accounting rate of return

    Compute the internal rate of return for each project We have to calculate NPV at two rates and interpolate to calculate IRR Alternatively, we can use Excel function IRR to calculate IRR Project A Year Cash

  • Capital Budgeting and Forecasting Models

    NPV of the investment at 10% discount rate is a positive value. It means that investment is acceptable. Solution depicts the steps to calculate the payback period, IRR and NPV parameters for the given case.

  • Computing NPV, IRR and Payback Period

    40574 Definition and formulas for NPV, IRR, Payback Period How do I compute NPV, IRR and Payback period when comparing two organizations for acquisition?

  • Payback methods, IRR, and Right Discount Rate

    is the required return, what general principle does this example illustrate regarding a project's life, its discounted payback period, and its NPV, calculate the internal rate of return (IRR) for each projects, what is INTC's cost of equity, and which

  • Payback period, IRR and NPV

    217579 Payback period, IRR and NPV Your company uses a 12% annual rate to discount cash flows for NPV.

View More Related Solutions