Hi,
I have a target goal of getting a 20% XIRR return on 3/31/2018. As you can see. My current IRR is -97%. What formula would tell me that I need X amount for 3/31/2018 to reach my goal of getting a exact 20% XIRR?
<colgroup><col span="11"><col><col span="4"><col><col span="2"></colgroup><tbody>
</tbody>
I have a target goal of getting a 20% XIRR return on 3/31/2018. As you can see. My current IRR is -97%. What formula would tell me that I need X amount for 3/31/2018 to reach my goal of getting a exact 20% XIRR?
2/1/2017 | 2/28/2017 | 3/31/2017 | 4/30/2017 | 5/31/2017 | 6/30/2017 | 7/31/2017 | 8/31/2017 | 9/30/2017 | ######## | ######## | 12/31/2017 | 1/31/2018 | 2/28/2018 | 3/31/2018 | ||||
-$150,000 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $700 | $1,300 | $1,300 | Current XIRR | XIRR Goal | |||
-97% | 20% | |||||||||||||||||
Thanks! | ||||||||||||||||||
<colgroup><col span="11"><col><col span="4"><col><col span="2"></colgroup><tbody>
</tbody>