The Payment Calculator worksheet creates an amortization schedule based on the loan amount, interest rate, term (e.g. 3 years), and frequency of payments ......