PREPAY.XLS
Yield Maintenance Prepayment Calculator
Variables The Amount that you Prepay The Interest Rate on Your Loan Number of Years Remaining Until the Maturity Date of Your Loan Comparable Treasury Security Current Comparable Treasury Rate Calculations Loss of Yield to Lender Per Annum as a Percent (Your Note Rate Less the Comparable Treasury Rate) Loss of Yield to Lender Per Month as a Percent Nominal Loss of Yield to Lender in Dollars per Month Yield Maintenance Penalty In Nominal Dollars As a Percent of the Amount Prepaid Example 1 1,200,000 8.500% 3 3 5.700% Example 2 2,000,000 7.500% 5 5 6.600% Example 3 2,000,000 7.500% 7 7 6.700%
2.800% 0.233% 2,800 $
0.900% 0.075% 1,500 $
0.800% 0.067% 1,333
$
$92,451.37 7.70%
$76,479.80 3.82%
$89,207.35 4.46%
Input your appropriate amounts. Call with any questions
Greystone & Company Confidential
11/7/2009
Page 1