Investments

You must specify the loan before generating the amortization table. To specify the loan, follow these steps:

After you have specified the loan, click Create Amortization Schedule to generate the amortization schedule displayed in Figure 56.2.

Let’s include information concerning the purchase price and downpayment. These terms are not necessary to specify the loan, but it may be advantageous to store such information with the loan.

Consider the loan described in the section Loan Tasks. In the Loan dialog box (Figure 56.2) click Initialization to open the Loan Initialization Options dialog box, where you can specify the down payment, initialization costs, and discount points. To specify the down payment, enter 100000 for the Purchase Price, as shown in Figure 56.3.

Click OK to return to the Loan dialog box.

Now let’s observe the effect of prepayments on the loan. Consider the loan described in the section Loan Tasks. You must pay a minimum of $532.24 each month to keep up with payments. However, let’s say you dislike entering this amount in your checkbook. You would rather pay $550.00 to keep the arithmetic simpler. This would constitute a uniform prepayment of $17.76 each month.

In the Loan dialog box, click Prepayments, which opens the Loan Prepayments dialog box shown in Figure 56.4.

You can specify an arbitrary sequence of prepayments in the Prepayments area. If you want a uniform prepayment, clear the Prepayments area and enter the uniform payment amount in the Uniform Prepayment text box. That amount will be added to each payment until the loan is paid off.

To specify this uniform prepayment, follow these steps:

The last payment is on January 2030 without prepayments and February 2027 with prepayment; you would pay the loan off almost three years earlier with the $17.76 prepayments.

To continue this example you must remove the prepayments from the loan specification, following these steps:

Consider the loan described in the section Loan Tasks. Suppose you cannot afford the payments of $532.24 each month. To lessen your monthly payment, you could pay balloon payments of $6,000 at the end of 2007 and 2023. You wonder how this would affect your monthly payment. (Note that Investment Analysis does not allow both balloon payments and rate adjustments to be specified for a loan.)

In the Loan dialog box, click Balloon Payments, which opens the Balloon Payments dialog box shown in Figure 56.6.

You can specify an arbitrary sequence of balloon payments by adding date-amount pairs to the Balloon Payments area.

To specify these balloon payments, follow these steps:

Click OK to return to the Loan dialog box. Click Create Amortization Schedule, and the amortization schedule is updated. Your monthly payment is now $500.30, a difference of approximately $32 each month.

To continue this example you must remove the balloon payments from the loan specification, following these steps:

Consider the loan described in the section Loan Tasks. Another option for lowering your payments is to get a variable rate loan. You can acquire a three-year adjustable rate mortgage (ARM) at 6% with a periodic cap of 1% with a maximum of 9%. (Note that Investment Analysis does not allow both rate adjustments and balloon payments to be specified for a loan.)

In the Loan dialog box, click Rate Adjustments to open the Rate Adjustment Terms dialog box shown in Figure 56.7.

To specify these loan adjustment terms, follow these steps:

Your monthly payment drops to $479.64 each month. However, if the worst-case scenario plays out, the payments will increase to $636.84 in nine years. Figure 56.8 displays amortization table information for the final few months under this scenario.

Click OK to return to the Investment Analysis dialog box.