# Calculating NPV and IRR of Given Investment Proposal

Not what you're looking for?

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

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