Auto Financing, Home Mortgages, Loans, Leases, Investing, Stocks, Insurance, Business Financing, Funding, Calculators, Spreadsheets, Forms, Templates, Contracts

Auto Financing  |  Home Mortgages  |  Stocks & Investing  |  Insurance  |  Business Financing  |  Forms & Templates

 

Maximum or Optimum Commercial Loan Analysis   
      
       
Please enter the information highlighted in yellow.    
       
       
    
       
Loan Criteria:    
       
Amount of Loan:    
Annual Interest Rate:    
Number of Years of Loan:    
Payments per Year:    
Number of Payments:    
Loan Constant:    
Annual Debt Payment:    
Periodic Debt Payment:    
       
Balloon Term (years):    
Balloon Payment:    
Interest until Balloon:    
Principal until Balloon:   
Total Payments until Balloon:    
       
       
Maximum or Optimum Loan Amount Analysis:    
       
Lowest Appraised/Market Value:Increment Appraised/Market Value: 
Lowest Annual Net Income:Increment Annual Net Income: 
Lowest DSC Ratio: Increment DSC: 
Lowest LTV: Increment LTV: 
       
Loan Amounts for varying LTV and Property Value   
Appraised/Market Value:
Loan To Value:      
Highest Loan Amount:
Lowest Loan Amount:
       
Loan Amounts for varying DSC and Annual Net Income   
Annual Net Income:
Debt Service Coverage:      
Highest Loan Amount:
Lowest Loan Amount:
       
       
  Override:   Override:
Lowest Loan Amount:Highest Loan Amount:
Annual Interest Rate:Annual Interest Rate:
Number of Years of Loan:Number of Years of Loan:
Payments per Year:Payments per Year:
Number of Payments: Number of Payments: 
Loan Constant: Loan Constant: 
Annual Debt Payment: Annual Debt Payment: 
Periodic Debt Payment: Periodic Debt Payment: 
       
Balloon Term (years):Balloon Term (years):
Balloon Payment: Balloon Payment: 
Interest until Balloon: Interest until Balloon: 
Principal until Balloon: Principal until Balloon: 
Total Payments until Balloon: Total Payments until Balloon: 
       
       
 Using Lowest Annual Net Income   
Debt service coverage:
Loan Amount:
Annual Debt Payment:
Periodic Debt Payment:
L.T.V. (using lowest value):
Balloon Payment:
Interest until Balloon:
Principal until Balloon:
Total Payments until Balloon:
       
       
 Using Lowest Appraised/Market Value   
Loan to Value:
Loan Amount:
Annual Debt Payment:
Periodic Debt Payment:
D.S.C. (using lowest income):
Balloon Payment:
Interest until Balloon:
Principal until Balloon:
Total Payments until Balloon:
       
       
 Using Highest Annual Net Income   
Debt service coverage:
Loan Amount:
Annual Debt Payment:
Periodic Debt Payment:
L.T.V. (using highest value):
Balloon Payment:
Interest until Balloon:
Principal until Balloon:
Total Payments until Balloon:
       
       
 Using Highest Appraised/Market Value   
Loan to Value: