HTML Preview Commercial Loan Amortization Schedule page number 1.
Fast Tools & Resources
Loan
Amortization
Program Navigation
With this program, the
user can select loan
terms and calculate
loan repayment
schedules, determine
how different interest
rates and amortization
lengths affect cash
flow, and determine
how additional
principal payments
will
reduce the loan term.
The program contains three main sections:
Amortization Schedule Contains a loan payment
solver that can calculate a desired input to solve the
loan payment formula as well as create an
amortization schedule.
Annual Summary Totals all loan payments in an
amortization schedule in one-year increments for
the term of the loan.
Sensitivity Tables Allow the user to determine how
various interest rates and amortization lengths affect
the payment amount, the total interest paid over the
life of a loan, and the affect of additional principal
payments on the loan term.
Amortization Schedule
This sheet contains two basic areas. In the “Loan
Data” input area, shown below, the user will input
the loan terms and solve the desired variable. These
loan terms will be used throughout the entire
workbook.