Please fill all required fields
                     
                     
                     
      Acquisition Analysis      
                     
                     
      Purchase Price            
                     
      NOI            
                     
      Appraisal Valuation              
      NOI            
      Cap Rate          
      Estimated Value            
                     
      Cash Flow Analysis              
      NOI            
      Debt Coverage Ratio            
      Annual Income Available for Debt Service          
      Monthly Payment            
      Interest Rate            
      Term  
             
      Maximum Loan based on Cash Flow            
                     
                     
      Purchase Price       Loan to Value Parameters for 223 (f) Program  
      Loan to Value          
      Maximum based on Cash Flow         - 83.3% LTV for market rate  
                  - 85% LTV for Affordable  
      Maximum Loan         - 87% LTV for 90% or greater rental assistance  
                  - 90% LTV for 202 Properties  
      Cash Required before Closing Fees            
                     
      Closing Fees              
      Points          
      Processing            
      Legal            
      Total Closing Fees            
                     
      Cash Requirement            
                     
                     
                     
      Payment Analysis              
                     
      First Mortgage              
      Loan Amount          
      Interest Rate            
      Term  
             
      First Mortgage Payment            
      Annual Debt Service            
                     
      Second Mortgage              
      Loan Amount          
      Interest Rate            
      Term  
             
      First Mortgage Payment            
      Annual Debt Service            
                     
      Total Debt Service            
                     
      Net Cash Flow.            
                     
      Debt Coverage Ratio            
                     
                     
                     
      This interactive calculator is made available to you as a financial tool for your sole use. It is not intended to provide investment advice. Bedford Lending cannot and does not guarantee its accuracy. All results are hypothetical and are for illustrative purposes. We encourage you to seek professional advice for any commercial real estate transactions.      
       
    Powered By SpreadsheetConverter