Purchase Solution

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

##### 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:
###### 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!"

##### Free BrainMass Quizzes

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.