UNDERWRITING SELLER FINANCING DEAL WITH MICHEL BLANK CALCULATOR

[Jason Malabute]

Is it possible to underwrite seller financing deals in Michael Blank calculator?

I need help on a seller financing deal offer I am putting together. It's a 12 unit apartment building. Each unit is $700 rent, insurance is $50 per unit monthly ($7200 annually), property tax is $4815 annually, capex is $250 per unit annually, vacancy is 5%, operating expenses should be 50% of effective gross rent , I want to cash flow at least $100 per unit monthly. Upfront rehab cost is $66k. Let's assume I'm paying the $66k rehab cost out of my pocket for scenario 1. Let's assume I raised the $66k rehab cost from investors in scenario 2. We want to do all the rehab in first 12 months. We are looking to push rent to $825 per month per unit. We want to raise rent in first 12 months. We want to do 0% interest and 0 money down. The offer price is $1.2M

QUESTIONS:

1.How do I calculate how much I pay seller every month in year 1 when rent is still $700? Remember I want to cashflow $100 per unit monthly myself

2. How do I calculate how much I pay seller every month in year 2 and years after when rent is pushed up to $825?

3.Remember I want to cashflow $100 per unit monthly myselfHow do I calculate when (what year) we should pay the balloon payment for the remaining balance? How long should the loan be for?

4. how do I calculate when I should be paying investors back if I raised the $66k rehab cost? how much is their return for letting me borrow rehab cost money ? 

5. is there closing costs associated with seller financing? how much is it in seller financing? does the buyer or seller pay closing cost in seller financing deals? is it included in our calculation?if it is not possible to underwrite seller financing deals with Michael Blank calculator, do you have an excel worksheet that you can share that I can use to underwrite seller financing deals and make sense of this?

6. how can I make this deal a win win for the seller as well?