Bond amortization schedule excel

broken image
broken image

In that case, the rate per period is simply the nominal annual interest rate divided by the number of periods per year. 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.

broken image

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

broken image