By entering the loan amount, the number of years to repay the loan, the payment frequency, the annual nominal interest rate, the number of compound periods per year, and hit the "Generate Amortization Table" button. The worksheet will calculate automatically the total payments, the total interest paid, and the payment per period as well as the amortization table. To open the amortization table, just click on the triangle beside the amortization table.
