Purchase Price     ROE cash flow  
  Total Acquisition Cost   Cap Rate (8%-12%)  
  Monthly Rent      
  Upgrade Costs      
      / 12 =
  Debt to Value     opex pct
  Interest Rate      
  Term     Number of units  
  Loan Amount     Cost per unit  
  Equity     Mo. rent/unit  
  Debt Service      
  Debt Service Ratio NOI   Gross Rent Mult  
  Debt Service Ratio CFO      
  1st year principal     Alt Opex Calc  
  FC      
       
  PGI        
  less vacancy    
  plus other income      
  EGI      
  less opex    
  NOI      
  less reserves      
  CFO        
  less debt service    
  CFE  
  CFE + Principal        
         
  ROA  
  ROE (incl Principal)  
  P/E  
     
  CFE  
  + reserve  
  + principal  
  - depreciation  
  Taxable Income  
       
  Federal Rate  
  State & Local  
       
  Income Taxes  
  CFE after Taxes  
  ROE after Tax  
  ROE after Tax (prin)  

Convert Excel spreadsheet to web form