So don't expect to refi quickly.Also, if you're expected to repay the HELOC, then it will be added to your debt stack.

I know most folks are looking to retire early through passive income, and I wouldn't mind doing that (slowly), but I don't mind my current job.I currently have a property with two doors (renting at 1,850 and 850), and may be adding a duplex where I house hack one side. 

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.

If so, I'd pass because that shows a consistent pattern of poor financial behavior and you can bet you'll soon be added to that list.The point is, you should look at more than just the score. 

So far I have in my mind these positions: new contracts with the utility companies, arrange an insurance, tenant notification letter.What else should be added to the list?

Or, I need to be added to that certificate? 

I would also be adding two tank less gas water heaters.One unit is about 1000 square feet, 1 bedroom.One unit is bigger with 3 bedrooms, large kitchen and a living room.My question is with the mini ducts, how are they able to keep bedrooms warm/cool with the doors closed?

In lieu of the LLC I'll be carrying the highest amount of liability I can get on the landlord policy, and I'll be adding a multi-million dollar umbrella policy.But even if I do set up LLC's, I'm still going to carry a multi-million dollar umbrella because  owners of LLC's can still be sued pesonally if their decisions resulted in a serious injury/death (such as the failure to not remove snow as stated above, or not to fix that faulty furnace that was emitting CO into the house, or some other form of negligence).

You two will negotiate who pays for this 2nd appraisal.Seller doesn't budge & you pay the original price & bring in the difference in cash to be added onto your down payment.Seller doesn't budge & you walk away from the deal.2.

Any work you do to it before it's placed 'in service' will be added to your cost basis.