Internal Rate of Return
Originally published: 28/07/2022 07:44
Publication number: ELQ-88689-1
View all versions & Certificate
certified

Internal Rate of Return

This template has the purpose of allowing one to calculate the Internal Rate of Return

Description
IRR calculations rely on the same formula as NPV does. Keep in mind that IRR is not the actual dollar value of the project. It is the annual return that makes the NPV equal to zero.
Generally speaking, the higher an internal rate of return, the more desirable an investment is to undertake. IRR is uniform for investments of varying types and, as such, can be used to rank multiple prospective investments or projects on a relatively even basis. In general, when comparing investment options with other similar characteristics, the investment with the highest IRR probably would be considered the best.IRR calculations rely on the same formula as NPV does. Keep in mind that IRR is not the actual dollar value of the project. It is the annual return that makes the NPV equal to zero.
Generally speaking, the higher an internal rate of return, the more desirable an investment is to undertake. IRR is uniform for investments of varying types and, as such, can be used to rank multiple prospective investments or projects on a relatively even basis. In general, when comparing investment options with other similar characteristics, the investment with the highest IRR probably would be considered the best. the 

This Best Practice includes
Excel

Invexic Official offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


0.0 / 5 (0 votes)

please wait...