Microsoft Office Tutorials and References
In Depth Information
A simple amortization schedule
This example uses a simple loan to demonstrate the basic concepts involved in creating a schedule. Refer to the
worksheet in Figure 13-1. Notice that rows 20 through 369 are hidden, so only the first five payments and last
five payments are visible.
Figure 13-1: A simple amortization schedule.