Microsoft Office Tutorials and References
In Depth Information
Figure 13-2: A dynamic amortization schedule.
The first difference you'll notice is that this schedule has two additional columns: APR and Addt'l Pmt. These
columns are shaded, which indicates that the values can be changed.
User input section
This schedule has a few changes in the Input Area at the top. The interest rate is labeled Starting Rate, and the
payment is labeled Computed Payment, indicating that they are subject to change. Also, the user can now speci-
fy the term of the loan.