Predicting an IRR

billyshears

Board Regular
Joined
Aug 29, 2013
Messages
58
I am trying to solve for IRR.

If I want to achieve an IRR in any year of 9% and I have my cash flows but need to solve for sale equity, what should I use?

So if in year 4 of owning a property, I want to sell it to achieve a 9% IRR and I have my original equity number and my cash flows, how do I solve for the sale equity I need?
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,108,854
Messages
5,525,225
Members
409,637
Latest member
LT TASL

This Week's Hot Topics

Top