Loan calculator
Loan repayment in two methods, equal payment and equal principal, with an amortization table, optional extra payments and CSV export.
Amortization schedule · 36 months
| Month | Payment | Principal | Interest | Balance |
|---|---|---|---|---|
| 1 | $29,970.90 | $25,804.23 | $4,166.67 | $974,195.77 |
| 2 | $29,970.90 | $25,911.75 | $4,059.15 | $948,284.02 |
| 3 | $29,970.90 | $26,019.71 | $3,951.18 | $922,264.31 |
| 4 | $29,970.90 | $26,128.13 | $3,842.77 | $896,136.18 |
| 5 | $29,970.90 | $26,237.00 | $3,733.90 | $869,899.18 |
| 6 | $29,970.90 | $26,346.32 | $3,624.58 | $843,552.87 |
| 7 | $29,970.90 | $26,456.09 | $3,514.80 | $817,096.77 |
| 8 | $29,970.90 | $26,566.33 | $3,404.57 | $790,530.44 |
| 9 | $29,970.90 | $26,677.02 | $3,293.88 | $763,853.42 |
| 10 | $29,970.90 | $26,788.17 | $3,182.72 | $737,065.25 |
| 11 | $29,970.90 | $26,899.79 | $3,071.11 | $710,165.46 |
| 12 | $29,970.90 | $27,011.87 | $2,959.02 | $683,153.58 |
| 13 | $29,970.90 | $27,124.42 | $2,846.47 | $656,029.16 |
| 14 | $29,970.90 | $27,237.44 | $2,733.45 | $628,791.72 |
| 15 | $29,970.90 | $27,350.93 | $2,619.97 | $601,440.79 |
| 16 | $29,970.90 | $27,464.89 | $2,506.00 | $573,975.89 |
| 17 | $29,970.90 | $27,579.33 | $2,391.57 | $546,396.56 |
| 18 | $29,970.90 | $27,694.24 | $2,276.65 | $518,702.32 |
| 19 | $29,970.90 | $27,809.64 | $2,161.26 | $490,892.68 |
| 20 | $29,970.90 | $27,925.51 | $2,045.39 | $462,967.17 |
| 21 | $29,970.90 | $28,041.87 | $1,929.03 | $434,925.30 |
| 22 | $29,970.90 | $28,158.71 | $1,812.19 | $406,766.59 |
| 23 | $29,970.90 | $28,276.04 | $1,694.86 | $378,490.56 |
| 24 | $29,970.90 | $28,393.85 | $1,577.04 | $350,096.70 |
| 25 | $29,970.90 | $28,512.16 | $1,458.74 | $321,584.54 |
| 26 | $29,970.90 | $28,630.96 | $1,339.94 | $292,953.58 |
| 27 | $29,970.90 | $28,750.26 | $1,220.64 | $264,203.32 |
| 28 | $29,970.90 | $28,870.05 | $1,100.85 | $235,333.27 |
| 29 | $29,970.90 | $28,990.34 | $980.56 | $206,342.93 |
| 30 | $29,970.90 | $29,111.13 | $859.76 | $177,231.80 |
| 31 | $29,970.90 | $29,232.43 | $738.47 | $147,999.37 |
| 32 | $29,970.90 | $29,354.23 | $616.66 | $118,645.13 |
| 33 | $29,970.90 | $29,476.54 | $494.35 | $89,168.59 |
| 34 | $29,970.90 | $29,599.36 | $371.54 | $59,569.23 |
| 35 | $29,970.90 | $29,722.69 | $248.21 | $29,846.54 |
| 36 | $29,970.90 | $29,846.54 | $124.36 | $0.00 |
Formula estimate only. Rates, taxes, and legal rules vary by jurisdiction.
What to know
The loan calculator turns a loan amount, an annual rate and a term in years into a monthly schedule. Two methods are available. Equal payment keeps the same total each month, while equal principal repays the same slice of principal each month and starts with a larger payment.
Both methods compute interest monthly on the remaining balance at the annual rate divided by 12, and both round the term to whole months (up to 1,200). The summary shows the monthly payment, the total repayment and the total interest, plus a stacked chart of principal and interest and a month-by-month table.
An optional Extra monthly payment is added to the principal part of every instalment. The page then reports the interest saved and the months saved against the same loan without extra payments, so you can see what 100,000 more a month does to the payoff date.
The schedule can be downloaded as a CSV file with month, payment, principal, interest and balance columns. Amounts follow the chosen currency, and fees, insurance, variable rates and early-repayment charges are not modelled.
Compare offers by running the same loan with two rates: on 1,000,000 over 3 years, 5 percent gives a payment of 29,970.90 and 4.5 percent gives 29,746.92, which saves 224 a month and about 8,063 of total interest. Stretching to 5 years at 5 percent lowers the payment to 18,871.23 but raises the interest to 132,274.02.
Choose a specific task 2
Related tools 3
How to use Loan calculator
- Choose the Equal payment or Equal principal page.
- Enter Principal 1,000,000, Annual rate 5 and Years 3.
- Read the monthly payment and total interest in the summary.
- Open the Amortization schedule, or press Download schedule for the CSV.
Quick answers
Which method costs less interest overall?
Equal principal. On 1,000,000 at 5 percent for 3 years it costs 77,083.33 in interest against 78,952.30 for equal payment.
What is the longest term accepted?
100 years, which becomes at most 1,200 monthly rows in the schedule.
Does the calculator include fees or insurance?
No. It is a pure principal-and-interest schedule at a constant rate. Add costs separately.