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 Monthly Quarterly SemiAnnual Annual Other P&I Payment Frequency Monthly Quarterly SemiAnnual Annual Other Current Index Rate 2.000 2.250 2.500 2.750 3.000 3.250 3.500 3.750 4.000 4.250 4.500 4.750 5.000 5.250 5.500 5.750 6.000 6.250 6.500 6.750 7.000 7.250 7.500 7.750 8.000 8.250 8.500 8.750 9.000 9.250 9.500 9.750 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 USDA 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 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).
