IRR

Try it

When to use it

When should I use IRR instead of NPV?

Use IRR to find the discount rate that makes a project's net present value zero; use NPV to value cash flows at a rate you already know.

Use cases

Evaluate a real-estate investment's return

Compare a startup's projected returns

Used in

finance · real-estate

Syntax

IRR(values, [guess])

Examples

=IRR({-4000,200,250,300,350},0.1) // => -0.3524266235692171
=IRR({-4000,200,250,300,350}) // => -0.3524266235692171