Microsoft Office Tutorials and References
In Depth Information
Figure 11-4: Column B shows the payment required to pay off the credit card balance for various payoff peri-
Creating a loan amortization schedule
A loan amortization schedule is a table of values that shows various types of information for each payment
period of a loan. Figure 11-5 shows a worksheet that uses formulas to calculate an amortization schedule.