Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise