Purchase Solution

Calculating NPV and IRR of Given Investment Proposal

Not what you're looking for?

Ask Custom Question

You are presented with a proposal for a project. The bottom line is that is claimed that if you invest 20 million in a project for this year, you will receive 5 million, 18 million, and 12 million over the following three years

a. Set up a worksheet that will tell you both the net present value of this project assuming a 12% discount rate and the internal rate of return for this project.

b. You decide that most likely the project will cost 24 million this year and return 4 million, 14 million and 10 million over the next three years. What would be the net present values and the internal rate of return?

Purchase this Solution
Solution Summary

Solution describes the steps to calculate NPV and IRR of given investment proposal.

Solution Preview

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

Solution:

a. Set up a worksheet that will tell you both the net present value of this project assuming a 12% discount rate and the internal rate of return for this project.

Discount rate=r=12%

Year End Cash flow, $ million PV factor, PVF PV , $ million
n C 1/(1+r)^n C*PVF
0 ...

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
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

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 Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

View More Free Quizzes
Related BrainMass Solutions

  • Ford Motor Project Viability NPV payback IRR profit index

    Describe the net present value (NPV), internal rate of return (IRR), profitability index, and payback methodologies for calculating the projects viability. Examine the strengths and weaknesses of each methodology. 3.

  • Analyzing the given investment proposal

    NPV criteria suggests that NPV should be equal to or greater than 0 for acceptance. A negative value of an investment proposal indicates decrease in current firm's value.

  • Excel: Relationship Between NPV and IRR

    The solution explains the relationship between NPV and IRR.

  • Choosing the best investment proposal

    Why is the IRR ranking misleading? In the given scenario, NPV of project P=$33.36 NPV of project Q=$19.21 Since NPV of Project P is higher, NPV criteria gives ranking 1 to Project P and ranking 2 to Project Q.

  • Payback period, NPV, IRR , accounting rate of return

    Anuual profit= $10,000 Initial investment= $30,000 Therefore, rate of return on initial investment= 33.33% =10000/30000 Answer: 33.33% Evaluates a capital budgeting decision using payback period, NPV, IRR and

  • Memorandum

    The President has requested that you and your staff analyze the feasibility of acquiring this supplier. Based on the following information, calculate NPV, IRR, and Payback for the investment opportunity.

  • Does MIRR solve all of IRR's shortcomings?

    Sensitivity analysis Sensitivity analysis is a way of analyzing change in the project's NPV (or IRR) for a given change in one of the variables. The following three steps are involved in the use of sensitivity analysis: ?

  • Capital Budgeting Integral Projections

    Second, the IRR is the next closest alternative to the NPV calculations; therefore it is next in line as far as a method to calculate for investments. The IRR is the discount rate that makes the NPV of an investment zero.

  • Creating a NPV & IRR Spreadsheet

    • Using the net present value rule (NPV), which proposal(s) do you recommend? • How do you explain any differences between the IRR and NPV rankings? Which rule is better? See the attached document.

  • Payback, NPV, IRR

    Calculate the internal rate of return (IRR), rounded to the nearest whole percent, for the proposed investment. d.) Evaluate the acceptability of the proposed investment using NPV and IRR.

View More Related Solutions