SBA Variable Rate Loan

Please enter information in all fields before clicking 'Calculate'. Use Tab to navigate through each of the fields
Loan Name
Originated (m/d/yyyy)
Matures (m/d/yyyy)
Rate Adjust Frequency
P&I Payment Frequency
Current Index Rate
Current Loan Balance, e.g. 650000
Guaranteed Percent, e.g. 80
Margin on Index Rate, e.g. +2.25
Servicing Fee Retained, e.g. 1.00
Sale Price, e.g. 105.75
SBA Variable Rate Loan Analysis
Loan Name
Originated
Matures
 
Rate Adjust Frequency
P&I Payment Frequency
 
Current Loan Balance
$
Guaranteed Percentage
%
Unguaranteed Percentage   
%
 
Current Index Rate
%
  
Gross Rate
%
%
Servicing Fee (Retained)
%
  
Net Rate
%
%
 
Sale Price
Premium
%
 
Guaranteed Portion (Amount to be Sold)  
$
Unguaranteed Portion (Invested Funds)  
$
 
Premium forwarded to the SBA
    (Guaranteed Portion x 1/2 of Premium over 110)
$
 
Premium Earned on Sale  
$
Servicing Fee on Guaranteed Portion  
$
Interest Income on Unguaranteed Portion  
$
 
  Year 1 Return  
$
  Years 2 and following Return  
$
 
Return on Invested Funds    
  Year 1  
%
  Years 2 and following  
%
Assumptions
  • 0% CPR (No amortization of loan balance in excess of scheduled amortization).
  • All premium taken in Year 1 (may not be allowable under ASC 860 - Sales of Financial Assets).
  • If sale price exceeds 110, seller receives only 50% of the amount greater than 110.