Internal rate of return
Streit's Chief Investment Officer needs us to find the internal rate of return of West Ridge North in our final test of this project's profitability.
The internal rate of return gives us the discount rate that makes net present value 0
. This also happens to be the project's annualized rate of return.
If you have lost progress, close any open workbooks and load 4_2_xnpv.xlsx
from the Exercises folder.
This exercise is part of the course
Financial Modeling in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
