All tools

Loan amortization schedule

Compute the fixed payment and how it splits between principal and finance cost across the term.

Result

Fixed payment
15210.97
Total paid
547594.87
Total finance cost
47594.87

Download the workbook

The method

  1. The fixed payment is derived from principal, periodic rate and number of periods, so the amount paid each period stays the same.
  2. Finance cost accrues on the outstanding balance, so an early payment is mostly cost and little principal, and that reverses over the term.

Built forAn accountant or analyst who needs an evidenced decision from period figures

When you need it

You need to explain a figure or compare alternatives before taking the analysis to management. Compute the fixed payment and how it splits between principal and finance cost across the term.

The decision it supports

Use the result to explain a trend, gap or scenario effect, then connect it to an operating cause. The tool shows its method beside the result so you can review it.

What you receive

Loan amortization schedule result

A shareable interactive result with findings, calculation method and an Excel workpaper carrying the same figures.

An example you can inspect

A ready-to-run example

The tool opens with: Principal = 500000.00, Periodic rate = 0.5, Number of payments = 36. Change any value to see its effect immediately.

Continue the workflow