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 Fixed
P&I Payment Frequency
Current Loan Balance, e.g. 650000
Guaranteed Percent, e.g. 80
Gross Rate, e.g. 7.00
Servicing Fee Retained, e.g. 1.00
Sale Price, e.g. 105.75
USDA Fixed Rate Loan Analysis
Loan Name
Originated
Matures
 
Rate Adjust Frequency Fixed
P&I Payment Frequency
 
Current Loan Balance
$
Guaranteed Percentage
%
Unguaranteed Percentage   
%
 
Gross Rate
%
Servicing Fee (Retained)
Net Rate
%
 
Sale Price
Premium
%
 
Guaranteed Portion (Amount to be sold)  
$
Unguaranteed Portion (Invested Funds)  
$
 
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).