|
Chapter Contents |
Previous |
Next |
| The LOAN Procedure |
This example illustrates the comparison of two $100,000 loans. The major difference between the two loans is that the nominal interest rate in the second one is lower than the first with the added expense of paying discount points at the time of initialization.
Both alternatives are 30-year loans. The first loan is labeled "8.25% - no discount points" and the second one is labeled "8% - 1 discount point."
Assume that the interest paid qualifies for a tax deduction, and you are in the 33% tax bracket. Also, your Minimum Attractive Rate of Return (MARR) for an alternative investment is 4% (adjusted for tax rate.)
You use the following statements to find the breakeven point in the life of the loan for your preference between the loans:
proc loan start=1992:1 nosummaryprint amount=100000 life=360;
fixed rate=8.25 label='8.25% - no discount points';
fixed rate=8 points=1000 label='8% - 1 discount point';
compare at=(48 54 60) all taxrate=33 marr=4;
run;
Output 13.1.1 shows the loan comparison reports as of January 1996 (48th period), July 1996 (54th period), and January 1997(60th period.)
Output 13.1.1: Loan Comparison Reports for Discount Point Breakeven|
| ||||||||||||||||||||||||||||
|
Chapter Contents |
Previous |
Next |
Top |
Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.