The LOAN Procedure |

Analyzing Fixed Rate Loans |

The most common loan analysis is the calculation of the periodic payment when the loan amount, life, and interest rate are known. The following PROC LOAN statements analyze a 15-year (180 monthly payments) fixed rate loan for $100,000 with an annual nominal interest rate of 7.5%:

proc loan; fixed amount=100000 rate=7.5 life=180; run;

Another parameter the PROC LOAN statement can compute is the maximum amount you can borrow given the periodic payment you can afford and the rates available in the market. The following SAS statements analyze a loan for 180 monthly payments of $900, with a nominal annual rate of 7.5%, and compute the maximum amount that can be borrowed:

proc loan; fixed payment=900 rate=7.5 life=180; run;

Assume that you want to borrow $100,000 and can pay $900 a month. You know that the lender charges a 7.5% nominal interest rate compounded monthly. To determine how long it will take you to pay off your debt, use the following statements:

proc loan; fixed amount=100000 payment=900 rate=7.5; run;

Sometimes, a loan is expressed in terms of the amount borrowed and the amount and number of periodic payments. In this case, you want to calculate the annual nominal rate charged on the loan to compare it to other alternatives. The following statements analyze a loan of $100,000 paid in 180 monthly payments of $800:

proc loan; fixed amount=100000 payment=800 life=180; run;

There are four basic parameters that define a loan: life (number of periodic payments), principal amount, interest rate, and the periodic payment amount. PROC LOAN calculates the missing parameter among these four. Loan analysis output includes a loan summary table and an amortization schedule.

You can use the START= and LABEL= options to enhance your output. The START= option specifies the date of loan initialization and dates all the output accordingly. The LABEL= specification is used to label all output that corresponds to a particular loan; it is especially useful when multiple loans are analyzed. For example, the preceding statements for the first fixed rate loan are revised to include the START= and LABEL= options as follows:

proc loan start=1998:12; fixed amount=100000 rate=7.5 life=180 label='BANK1, Fixed Rate'; run;

The loan summary table is produced by default and contains loan analysis information. It shows the principal amount, the costs at the time of loan initialization (down payment, discount points, and other loan initialization costs), the total payment and interest, the initial nominal and effective interest rates, payment and compounding intervals, the length of the loan in the time units specified, the start and end dates (if specified), a list of nominal and effective interest rates, and periodic payments throughout the life of the loan.

Figure 16.1 shows the loan summary table for the fixed rate loan labeled "BANK1, Fixed Rate."

Fixed Rate Loan Summary BANK1, Fixed Rate |
|||
---|---|---|---|

Downpayment | 0.00 | Principal Amount | 100000.00 |

Initialization | 0.00 | Points | 0.00 |

Total Interest | 66862.61 | Nominal Rate | 7.5000% |

Total Payment | 166862.61 | Effective Rate | 7.7633% |

Pay Interval | MONTHLY | Compounding | MONTHLY |

No. of Payments | 180 | No. of Compoundings | 180 |

Start Date | DEC1998 | End Date | DEC2013 |

The loan is initialized in December 1998 and paid off in December 2013. The monthly payment is calculated to be $927.01, and the effective interest rate is 7.7633%. Over the 15 years, $66,862.61 is paid for interest charges on the loan.

Copyright © SAS Institute, Inc. All Rights Reserved.