Is there a way to calculate or a function for the IRR given 1 payment and 1 income for n periods, rather than having to list every income for all periods?
Regular IRR function:
A1
-1000
200
200
200
200
200
200
=irr(a1:a7) = 5.47%
Looking for something like this:
=irrx(-1000,200,6) payment =-1000 with 6 incomes of 200 each
Bookmarks