Purchase Solution

Calculating NPV & IRR of cash flows associated with Project

Not what you're looking for?

Ask Custom Question

1.Consider a project with the expected cash flows:

Year Cash flow
0 - $615,000
1 + 141,000
2 + 300,000
3 + $300,000

What is this project's internal rate of return?
If the discount rate is 0%, what is this project's net present value?
If the discount rate is 4%, what is this project's net present value?
If the discount rate is 8%, what is this project's net present value?
If the discount rate is 12%, what is this project's net present value?

2. If you drew a chart with the discount rate (X axis)and the net present value (y axis, and you plotted the net present value of the project as a function of the discount rate by dots for the four discount rates, what is this discount rate at which the graph intersects the horizontal axis?
What would this graph mean to me?

3. A project requiring a $3.2 million investment has a profitability index of 0.97. What is its net present value? (Remember: Profitability Index is defined as Present Value of the proceeds divided by the initial investment)

Which method do you think is the better one for making capital budgeting decisions - IRR or NPV? what would the determing factors be?

Purchase this Solution
Solution Summary

Solution describes the steps in calculating NPV of cash flows associated with a given project at variuos discout rates. Concept of IRR is explained with the help of graph. At last it which method of project evaluation is better.

Solution Preview

Please see the attached file for complete solution. Graph and tables may not print here.

Solution :
Present Value = Future Value*(1+r)^-n
r is rate of discount (like 0.06 for 6%)
n is number of period
By applying this formula we can get present value of any cash flow at r rate of interest and n period.

We will calculate Present Value of Each Cash flow for different Rates of discount with the help of above formula
Net present Value is sum of present Values of all cash flows at a particular discount rate.

Present Values at Discount Rate
Cash Flow 0% 4% 8% 12%
0 -615,000 -615000 -615000 -615000 -615000
1 141,000 141000 135577 130556 125893
2 300,000 300000 277367 257202 239158
3 300,000 300000 266699 238150 213534
Net Present Value 126000 64643 10907 -36415

From above table we get
If the discount rate is 0%, project's net present value is $126,000
If the discount rate is 4%, project's net present value is $64,643
If the discount rate is 8%, project's net present value is $10907
If the discount rate is 12%, ...

Solution provided by:
Lokesh Jain, MSc
Education
  • BEng (Hons) , Birla Institute of Technology and Science, India
  • MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
  • "Thank you"
  • "Really great step by step solution"
  • "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
  • "Thanks Again! This is totally a great service!"
  • "Thank you so much for your help!"
Purchase this Solution
Free BrainMass Quizzes
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.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Economics, Basic Concepts, Demand-Supply-Equilibrium

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

Basics of Economics

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

View More Free Quizzes
Related BrainMass Solutions

  • Calculating maximum amount that can be invested in a project

    Let us see cash flows associated with the project Year End Cash flows PV Factor @10% PV of cash flow n Ci PVF=1/(1+10%)^n Ci*PVF 1 14000 0.9091 12727.27 2

  • Payback period, NPV, PI, and IRR calculations

    456430 Payback period, NPV, PI, and IRR calculations & Capital rationing 10-5: (Payback period, NPV, PI, and IRR calculations) You are considering a project with an initial cash outlay of $80,000 and expected free cash flows of 20,000 at the end of each

  • NPV, Payback Period, IRR, Profitibility Index & Project NPV

    Calculating internal rate of return (IRR) for cash flows: Calculate the internal rate of return for the cash flows of the two projects in the table below. Problem 3.

  • Calculating Payback period, NPV and IRR

    The cash flows associated with these projects are as follows: Year Project A Project B 0 -$100,000 -$100,000 1 32,000 0 2 32,000 0 3 32,000 0 4 32,000

  • Calculating Payback period, NPV and IRR

    The cash flows associated with these projects are as follows: Year Project A Project B 0 -$100,000 -$100,000 1 32,000 0 2 32,000 0 3 32,000 0 4 32,000 0

  • IRR method and NPV method

    NPV Net Present value helps in calculating the value addition done by the project. It is calculated by: NPV= Present value of Future cash flows- Initial investments. IRR Internal rate of return refers to the return earned from the project.

  • NPV

    155557 NPV Your division is considering two projects with the following net cash flows: year Project A Project B 0 (25) (20) 1 5 10 2 10

  • NPV & IRR - Anderson International Limited

    IRR)3 (1 + IRR)4 Calculating for IRR is a trial and error procedure.

  • Calculating IRR and YTM

    What is the project IRR? 6-20 NPV is the summation of discounted cash inflows and the initial investment.

View More Related Solutions