IRR function when the cash flows are not in array?
I am trying to calculate IRR for a real estate investment. I have forecast
over 25 years. The problem is, I know the cash flows for each year if the property is not sold. However, when sold I need to add the proceeds of sale into the cash flows from that year. Question: Can I input cashflows into the IRR function without having them in a single column/row? |
IRR function when the cash flows are not in array?
IRR will work using array functionality to either concatenate a stream or add
stream. Add example: { =IRR( ( D19:H19 + IF( D21:H21, 1000, 0 ) ) ) } In this case, D19:H19 is an original stream (i.e. -10, 10, 10, 10, 10), and D21:H21 is a stream of T/F (i.e. false, false, false, false, true), which makes this entire formula equivalent to =IRR( -10, 10, 10, 10, 1000 ). Contenate example: { =IRR( ( D19:H19, I19:M19 ) ) } equivalent to =IRR( D19:M19 ) , these two (or however many) can be anywhere, but I put them on the same line for illustrative purpose. Let me know if you had something different in mind. Regards, Bill "waradmiral1991" wrote: I am trying to calculate IRR for a real estate investment. I have forecast over 25 years. The problem is, I know the cash flows for each year if the property is not sold. However, when sold I need to add the proceeds of sale into the cash flows from that year. Question: Can I input cashflows into the IRR function without having them in a single column/row? |
All times are GMT +1. The time now is 06:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com