Analyzing Deal Calculator - Changes Made

[QuoVadis Gates]

Changes made to see if deal is good or bad, so that I would be able to quickly look over deals I've analyzed once Corona is over and attack them quickly. 

= Deal # __________ Good Deal/ Bad 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: __________