New Deal Analysis Template

[QuoVadis Gates]

This calculator is meant for the first loan in a Brrr deal with 20% down. 
Use where obvious, infer where you think, and ask all the questions you want, I'm here to help.

Posting this new one because I've made some edits to the old one.

The edits are:

- I've added monthly total including operating savings (to see full monthly cash flow. The same was done for yearly. 

- I've also added property type for obvious reasons.

= Deal # __________

• Location: __________ 333- Message Me
• Property Type: __________

• Price: __________
• Acquisition: __________
  • Loan: __________
  • Down Payment: (20%) - __________
  • Closing Cost – (3%) – __________
    
  
  
• Due At Closing: __________
• Rehab Estimate: __________
• After Repair Value: __________
  
• Equity: __________
  • Income:
  • • Rent: __________
    • Washer/ Dryer: __________
    • Parking: __________
    • Storage: __________
• Monthly Gross: __________
• Expenses:
  • Mortgage: __________
  • Gas: __________
  • PMI: __________
  • Garbage: $20 {Times The Number Of Units}
  • Electricity: __________
  • Water & Sewer:$75 {Times The Number Of Units}
  • Taxes: __________ /12 = __________
  • Insurance {$100} /12 = $8.34
    
• Monthly Expenses: __________
• 
  
  • Expenses:
    
    
  • Vacancy {5-10%}- __________
  • Repairs and Maintenance {10%} - __________
  • Cap Ex - {Capital Expenditures} {8%} - ________
  • Management {10%} - __________
    
• Operating Expenses: __________

{Optional}

• Future Assumptions:
• Annual Income Growth: {2%}
• Annual PV Growth: {2%}
• Annual Expenses Growth: {2%}
• Sales Expenses: {9%}

Totals:

• Monthly Income: __________
• Monthly Expenses: __________
• Monthly Cash Flow: _________
• Annual Cash Flow: __________
• Total Cash Needed: __________
• Cash On Cash Return: _____

Monthly Cash Flow Total Including Operating Savings: __________

Year Total Including Operating Savings: __________