hi guys,
dont know if anyone can help here.
i have a spread sheet which is basically a cash flow for a property.
in this cash flow i work out IRR and exit values after holding the property for say 5 years (20 quarters)
i want to insert a function whereby i can change the hold period field to say 3 years and the IRR and exit value will also change accordingly.
i am happy to post the spreadsheet if required.
can anyone help with this?
/eidt. this is my lame effort but its not even close toworking:
=IF(B21:BS21=B12,(IRR=B26:G26,C33))
thanks in advance.
here is the SS
http://www.zen10595.zen.co.uk/ss_hold_period.xls
more explanation:
the formual needs to be based off the hold period field.
so if i change that field i get an IRR based of exit value and rent at that time.
so it would have to select the fields at that date and calculate IRR and exit value at the required date.
does that make sense?
Bookmarks