IRR function when the cash flows are not in array?

G

Guest

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?
 
G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top