Simple interest amortization schedule excel

broken image
broken image

However, when creating an amortization schedule, it is the interest rate per period that you use in the calculations, labeled rate per period in the above spreadsheet.īasic amortization calculators usually assume that the payment frequency matches the compounding period.

Usually, the interest rate that you enter into an amortization calculator is the nominal annual rate.

broken image