The LOAN Procedure

Example 17.3 Prepayments on a Loan

This example compares a 30-year loan with and without prepayments. Assume the $240,000 30-year loan has an 8.25% nominal annual rate. Use the following statements to see the effect of making uniform prepayments of $500 with periodic payment:

proc loan start=1992:12 rate=8.25 amount=240000 life=360;
   fixed label='No prepayments';
   fixed label='With Prepayments' prepay=500;
   compare at=(120) taxrate=33 marr=4 all;
run;

Output 17.3.1: Loan Summary Reports without Prepayments

The LOAN Procedure

Fixed Rate Loan Summary No prepayments
Downpayment	0.00	Principal Amount	240000.00
Initialization	0.00	Points	0.00
Total Interest	409094.17	Nominal Rate	8.2500%
Total Payment	649094.17	Effective Rate	8.5692%
Pay Interval	MONTHLY	Compounding	MONTHLY
No. of Payments	360	No. of Compoundings	360
Start Date	DEC1992	End Date	DEC2022

Rates and Payments for No prepayments
Date	Nominal Rate	Effective Rate	Payment
DEC1992	8.2500%	8.5692%	1803.04

Output 17.3.2: Loan Summary Reports with Prepayments

The LOAN Procedure

Fixed Rate Loan Summary With Prepayments
Downpayment	0.00	Principal Amount	240000.00
Initialization	0.00	Points	0.00
Total Interest	183650.70	Nominal Rate	8.2500%
Total Payment	423650.70	Effective Rate	8.5692%
Pay Interval	MONTHLY	Compounding	MONTHLY
No. of Payments	184	No. of Compoundings	184
Start Date	DEC1992	End Date	APR2008

Rates and Payments for With Prepayments
Date	Nominal Rate	Effective Rate	Payment
DEC1992	8.2500%	8.5692%	2303.04

Output 17.3.3: Loan Comparison Report

The LOAN Procedure

Loan Comparison Report Analysis through DEC2002
Loan Label	Ending Outstanding	Present Worth of Cost	Payment	Interest Paid	True Rate
No prepayments	211608.05	268762.31	1803.04	187972.85	5.67
With Prepayments	118848.23	264149.25	2303.04	155213.03	5.67

Note:

"With Prepayments" is the best alternative based on present worth of cost analysis through DEC2002.

Output 17.3.1 through Output 17.3.3 illustrate the Loan Summary Reports and the Loan Comparison report. Notice that with prepayments you pay off the loan in slightly more than 15 years. Also, the total payments and total interest are considerably lower with the prepayments. If you can afford the prepayments of $500 each month, another alternative you should consider is using a 15-year loan, which is generally offered at a lower nominal interest rate.