Purchase Solution

NPV, IRR, PI and Payback Period

Not what you're looking for?

Ask Custom Question

2. There are two mutually exclusive projects under consideration by the BUILDERS-R-US Company:
Year Project A Project B
0 -30,000 -50,000
1 10,000 15,000
2 10,000 15,000
3 10,000 15,000
4 10,000 15,000

The cost of capital is 10%.
Calculate the following values for each project using the time value tables and Microsoft Excel.
A) NPV
B) IRR (round to the nearest whole percentage using Microsoft Excel "IRR" function.)
C) Profitability index
D) Payback period

Prepare a brief memo advocating which project should be chosen and why. You must select a project and recommend it based on your analysis. Do not discuss the merits of both.

Purchase this Solution
Solution Summary

The solution uses the question to calculate NPV, IRR, PI and Payback Period.

Purchase this Solution
Free BrainMass Quizzes
Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

View More Free Quizzes
Related BrainMass Solutions

  • Capital Budgeting - Payback, NPV, PI, IRR

    105592 Project evaluation processes- Payback, NPV, PI, IRR Can someone please describe the following project evaluation processes for me: Payback, NPV, PI, IRR. Is any one evaluation process better the others? Why?

  • Project's Payback period, NPV, PI, and IRR.

    605741 Project's Payback period, NPV, PI, and IRR. You are considering a project with an initial cash outlay of $80,000 and expected free cash flows of $20,00 at the end of each year for 6 years.

  • Project and risk

    The solution explains the impact on payback, discounted payback, NPV, IRR, PI, and MIRR of a company undertaking a highly risky project.

  • Capital budgeting

    264478 Good Foods, Inc: Calculate payback period, NPV, IRR, PI, MIRR USE THE FOLLOWING DATA FOR THE NEXT EIGHT PROBLEMS: .

  • Calculating Payback Period & Comparing Investment Criteria

    We can see that the NPV and the IRR criteria are in conflict and the PI criterion gives a very similar rank to both projects In cases like that we should select the project with the highest NPV Project A should be selected.

  • Calculation of NPV, IRR, Payback and Profitability Index

    The Payback period is 3 years Project B - A similar exercise would give the following results NPV = $8,661 ( since the intial investment and cash flows have doubled) IRR - This remains the same - 20% PI - This remains the same - 1.14 Payback Period

  • What are the various financial tools used to evaluate capital projects?

    The various financial tools used are: Net present Value (NPV), the Payback Rule, the Discounted Payback, the Internal Rate of Return (IRR), MIRR and the PI).

  • Time Value of Money

    164268 Project Evaluation Process and Time Value of Money Describe the following project evaluation processes: Payback, NPV, PI, IRR. Is any one evaluation process better the others? Why? 2.

  • NPV/IRR/Profitability Index

    Payback is 3 years Project B - Initial investment of 60,000 is recovered in 3 years(inflow 20,000 per year). Payback is 3 years We see that both the projects have the same IRR, PI and payback and a different NPV.

View More Related Solutions