Since this is the tenant's money, I want the bank calculating and holding everything versus storing balances in my spreadsheet.

I think I have calculated the appropriate numbers, but this our first new-build adventure and I would appreciate more experienced eyes on this analysis.We are considering purchasing land in Packwood, WA and building an upscale modern 3/2 1500 sq ft A-Frame cabin.

If you're planning on only living there 1-2 years, rent may not change THAT much, so calculate what the rent would likely be right now for your side as well. 4.

I tried calculating value based on NOI and cap rate (see below) but I'm new to this and the value seems to come out lower than I would expect.

I'm happy to chat about the calculator I use when evaluating properties along with my set inputs.

We already paid them a pretty sizeable entry fee ($30k) to cover some of their equity and debt in another project..Your title report should have alerted you to the issue.The payoff the escrow company got from the lender should have alerted you to the problem.Your interview of the seller before you bought the house, should have alerted you to the problem.You calculations on the numbers should have alerted you to the problem.Check, cross check and check again.

How do you calculate rehab cost given you can’t look inside? 

In any case, you can easily calculate that.Looking at your objective of retiring in Costa Rica, you have two options:1.

If you find someone giving you confused looks, seek a mortgage broker that helps investors.I'm not so sure how they would calculate income from short-term rentals.  

Some banks and lenders will calculate your Heloc payment based on the Max limit even if you only have a small portion used due to preventive risk.