Purchase Solution

Calculating NPV and IRR of cash flows

Not what you're looking for?

Ask Custom Question

Consider the project with the following expected cash flows:
Year Cash flow
0 - $500,000
1 $100,000
2 $110,000
3 $550,000

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

Purchase this Solution
Solution Summary

Solution describes the steps in finding out Net Present Value of given cash flows related to a project at various discount rates. It also explains the method to get IRR for these cash flows.

Solution Preview

Please refer attached file for better clarity of tables and complete formulas.

Solution :

Present Value = Future ...

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
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.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

View More Free Quizzes
Related BrainMass Solutions

  • 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 IRR and YTM

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

  • Depreciation;tax rates;taxable income;NOPAT;NPV;IRR

    Then find the NPV and IRR of these cash flows. Year 0 thru Year 5 will be the time line for your cash flows. 3. Plug in the given EBITD numbers for the 5 years for each Machine. 4.

  • Gardial Fisheries: Net Cash Flows, NPV, IRR & Crossover Rate

    322844 Gardial Fisheries: Net Cash Flows, NPV, IRR & Crossover Rate Please see the attached file that contains the problem. Please see attached file. This solution assists with calculating net cash flows, NPV, IRR and crossover rates.

  • NPV and IRR Example

    If we know the NPV at 12% is +$0MM, what do we know about the IRR? Calculating IRR ? What is the IRR for our pharmaceutical plant? (Higher than 14%!) ? Enter same cash flows, then use IRR to calculate the rate that gives an NPV of 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.

  • Capital Budgeting Methods

    For calculating MIRR, first calculate FV of cash flows.

  • Calculating the IRR Value

    NPV = -1,000 + 450 + 450 + 450 = 0 (1+IRR)^1 (1+IRR)^2 (1+IRR)^3 Calculating for IRR is a trial and error procedure.

  • aftertax cash flows

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

  • Internal rate of return

    To get IRR in Excel, first enter all the cash flows in one row. Let us say you enter in cash flows from Cell A2 to D2 (4 cash flows). Then you can use the following formula to get IRR =IRR(A2:D2) = 7.75% NPV can also be calculated using Excel.

View More Related Solutions