Formula for Reverse IRR
Posted on 2011-03-09
I am using @Risk to run statistics for a potential real estate transaction. Is there a formula out there that can take a IRR input to generate a rent output. I know you can goal seek to a specific IRR by changing the rent cell. Since the @Risk program runs 1,000 iterations, I need a formula that automatically takes IRR as an input. Is this possible? I'm afraid it's not since it works out to a cyclical process. Thanks for the help.