I can adjusts pricing on the fly on that screen.

The tool didn't allow for an adjustment to the interest rate.The 55% is pre-reno so the retax will also get reassesed.

If so here are a few ways to adjust your numbers:1.

Your gain will be about $310k- expenses - $150k adjusted basis -$15k renos= about $145kIf you have passive losses in the your rentals those can be used to offset the gains generated by the sale. 

Because that's often not the case in real life, an adjusted IRR, called Modified IRR (MIRR) is also available in Excel.

But if prices continue to drop I may have to adjust it accordingly, so that could work in my benefit.THoughts? 

AirBnb is also a great source for attracting Canadian guests as the company does not adjust Canadian Dollars into US.

I was thinking he could just take this issue into consideration with an adjustment? 

The downside is your in commercial loan territory and we typically get adjustable rates Prime+.25-.5% 5yr balloon loans. 

NOI of -$49k was adjusted to $46k by adding back depreciation, taxes, interest, and insurance. $6,600/mo of income qualification based on 7 months of occupancy.