We unexpectedly (and now thankfully) ended up in the Vet Park / Sunset area and have been AirBnB'ing our "extra" unit with amazing results thus far.  

I know that the extra set of () will allow you to use non-contiguous cells in the calculation and excel will see everything inside as a range of cells for the calculation.If all the above is correct, my thought is that I should be adding the sale proceed to the final year cash flow from operating the property (E1+E3) and then using the result to calculate IRR.If I try something like this is get an error: =IRR((A1:E1+E3))With the first forumla above, my concern is that it is interpreting cell E3 as separate cash flow from a subsequent period, rather than occurring in the same period as the final operating cash flow.

Or are you pre-recording each one to match the particular deal?

You'll get a list with matching names from which you select the person of interest.

This results in careless buying, and lots of property on the market due to transfers within 3 years.  

Update :Received the test result of 3 samples the asbestor inspector send for inspections and the result came back that there is no presence of asbestos. 

The only way that I would do it is if I were planning to build a series of 4 plexes on a large plot of land resulting in 32 units or more in the future.

Hope to hear from him as soon as the results are available.

Because the borrower is not personally obligated on the mortgages securing the investment properties, they would not be included in the property count and the result is only two financed properties.The borrower is purchasing and financing two investment properties simultaneously.

Might just save someone else who reads your results before they go that route!