The LOAN Procedure

Example 17.4 Output Data Sets

This example shows the analysis and comparison of five alternative loans. Initialization cost, discount points, and both lump sum and periodic payments are included in the specification of these loans. Although no printed output is produced, the loan summary and loan comparison information is stored in the OUTSUM= and OUTCOMP= data sets.

proc loan start=1998:12 noprint outsum=loans
   amount=150000 life=360;

   fixed rate=7.5 life=180 prepayment=500
         label='BANK1, Fixed Rate';

   arm rate=5.5 estimatedcase=(12=7.5 18=8)
       label='BANK1, Adjustable Rate';

   buydown rate=7 interval=semimonth init=15000
           bdrates=(3=9 10=10) label='BANK2, Buydown';

   arm rate=5.75 worstcase caps=(0.5 2.5)
       adjustfreq=6 label='BANK3, Adjustable Rate'
       prepayments=(12=2000 36=5000);

   balloon rate=7.5 life=480
       points=1100 balloonpayment=(15=2000 48=2000)
       label='BANK4, with Balloon Payment';

   compare at=(120 360) all marr=7 tax=33 outcomp=comp;
run;

proc print data=loans;
run;

proc print data=comp;
run;

Output 17.4.1 and Output 17.4.2 illustrate the contents of the output data sets.

Output 17.4.1: OUTSUM= Data Set

Obs TYPE LABEL PAYMENT AMOUNT INITIAL POINTS TOTAL INTEREST RATE EFFRATE INTERVAL COMPOUND LIFE NCOMPND COMPUTE START END
1 FIXED BANK1, Fixed Rate 1890.52 150000 0 0 207839.44 57839.44 0.0750 0.077633 MONTHLY MONTHLY 110 110 PAYMENT DEC1998 FEB2008
2 ARM BANK1, Adjustable Rate 851.68 150000 0 0 390325.49 240325.49 0.0550 0.056408 MONTHLY MONTHLY 360 360 PAYMENT DEC1998 DEC2028
3 BUYDOWN BANK2, Buydown 673.57 150000 15000 0 288858.08 138858.08 0.0700 0.072399 SEMIMONTHLY SEMIMONTHLY 360 360 PAYMENT DEC1998 DEC2013
4 ARM BANK3, Adjustable Rate 875.36 150000 0 0 387647.82 237647.82 0.0575 0.059040 MONTHLY MONTHLY 360 360 PAYMENT DEC1998 DEC2028
5 BALLOON BANK4, with Balloon Payment 965.36 150000 0 1100 467372.31 317372.31 0.0750 0.077633 MONTHLY MONTHLY 480 480 PAYMENT DEC1998 DEC2038



Output 17.4.2: OUTCOMP= Data Set

Obs DATE TYPE LABEL PAYMENT INTEREST TRUERATE PWOFCOST BALANCE
1 DEC2008 FIXED BANK1, Fixed Rate 1772.76 57839.44 0.051424 137741.07 0.00
2 DEC2008 ARM BANK1, Adjustable Rate 1093.97 108561.77 0.052212 130397.88 130788.65
3 DEC2008 BUYDOWN BANK2, Buydown 803.98 118182.19 0.087784 161810.00 75798.19
4 DEC2008 ARM BANK3, Adjustable Rate 1065.18 107015.58 0.053231 131955.90 125011.88
5 DEC2008 BALLOON BANK4, with Balloon Payment 965.36 107906.61 0.052107 130242.56 138063.41
6 DEC2028 FIXED BANK1, Fixed Rate 1772.76 57839.44 0.051424 137741.07 0.00
7 DEC2028 ARM BANK1, Adjustable Rate 1094.01 240325.49 0.053247 121980.94 0.00
8 DEC2028 BUYDOWN BANK2, Buydown 800.46 138858.08 0.086079 161536.44 0.00
9 DEC2028 ARM BANK3, Adjustable Rate 1065.20 237647.82 0.054528 124700.22 0.00
10 DEC2028 BALLOON BANK4, with Balloon Payment 965.36 282855.86 0.051800 117294.50 81326.26