Mortgage Calculator

This mortgage calculator helps you to calculate interest on mortgage and to generate loan amortization.

Loan Amount _*

₦

Annual Loan Rate _*

Down Payment Percent _*

Down Payment Amount _*

₦

Loan Duration _*

Start Month _*

Repayment Term _*

S/N	Payment Date	Current Balance	Monthly Repayment	Interest Paid	Principal Paid	New Balance
S/N	Payment Date	Current Balance	Monthly Repayment	Interest Paid	Principal Paid	New Balance
1	Nov-2024	100,000.00	4,540.99	700.00	3,840.99	96,159.01
2	Dec-2024	96,159.01	4,540.99	673.11	3,867.88	92,291.12
3	Jan-2025	92,291.12	4,540.99	646.04	3,894.96	88,396.17
4	Feb-2025	88,396.17	4,540.99	618.77	3,922.22	84,473.95
5	Mar-2025	84,473.95	4,540.99	591.32	3,949.68	80,524.27
6	Apr-2025	80,524.27	4,540.99	563.67	3,977.32	76,546.95
7	May-2025	76,546.95	4,540.99	535.83	4,005.17	72,541.78
8	Jun-2025	72,541.78	4,540.99	507.79	4,033.20	68,508.58
9	Jul-2025	68,508.58	4,540.99	479.56	4,061.43	64,447.14
10	Aug-2025	64,447.14	4,540.99	451.13	4,089.86	60,357.28
11	Sep-2025	60,357.28	4,540.99	422.50	4,118.49	56,238.79
12	Oct-2025	56,238.79	4,540.99	393.67	4,147.32	52,091.46
13	Nov-2025	52,091.46	4,540.99	364.64	4,176.35	47,915.11
14	Dec-2025	47,915.11	4,540.99	335.41	4,205.59	43,709.52
15	Jan-2026	43,709.52	4,540.99	305.97	4,235.03	39,474.49
16	Feb-2026	39,474.49	4,540.99	276.32	4,264.67	35,209.82
17	Mar-2026	35,209.82	4,540.99	246.47	4,294.53	30,915.29
18	Apr-2026	30,915.29	4,540.99	216.41	4,324.59	26,590.71
19	May-2026	26,590.71	4,540.99	186.13	4,354.86	22,235.85
20	Jun-2026	22,235.85	4,540.99	155.65	4,385.34	17,850.50
21	Jul-2026	17,850.50	4,540.99	124.95	4,416.04	13,434.46
22	Aug-2026	13,434.46	4,540.99	94.04	4,446.95	8,987.51
23	Sep-2026	8,987.51	4,540.99	62.91	4,478.08	4,509.43
24	Oct-2026	4,509.43	4,540.99	31.57	4,509.43	0.00

Red * indicates required input.

Datamass HR & Payroll Solutions

Ready to streamline your HR & payroll processes to turbo charge productivity?