Mortgage Amortization & Early Prepayment Decision Calculator (Term vs Payment)

Calculate monthly mortgage schedules (Equal P&I vs Equal Principal) and simulate early lump-sum prepayments. Compare shortening loan term vs reducing monthly payment.

🏠 Mortgage & Prepayment Decision Engine

Mortgage Amortization & Early Prepayment Optimizer

Compare Equal Principal & Interest vs Equal Principal side by side. Simulate lump-sum prepayments to quantify exact interest saved, term reduction, and investment opportunity cost.

1. Original Mortgage Parameters

Rate Presets:
30 Years (360 mos)
5Y10Y15Y20Y25Y30Y

2. Early Prepayment Simulation

36 mos (3.0 yrs)
2.25%

Used to evaluate whether prepaying your mortgage beats keeping cash in deposits/bonds.

Original Full-Term Comparison (No Prepayment)
Equal P&I (等额本息)¥5,288.56 / moTotal Interest: ¥703.9k
Equal Principal (等额本金)¥6,683.33 (-¥9/mo)Total Interest: ¥604.7k
💡 Prepayment Diagnostic VerdictMortgage Rate exceeds Investment by +1.10% · Prepay Recommended

By month 36, you have paid ¥73.3k in principal and ¥117.1k in interest (16.6% of total scheduled interest). Prepaying ¥300.0k now under Plan A (Shorten Term) saves ¥325.3k in future interest — beating Plan B (Reduce Payment) by ¥169.1k!

Interest Paid So Far: 16.6%Remaining Unpaid Interest: ¥586.8k
★ Best for Maximum Interest Savings

Plan A: Shorten Loan Term (Keep Monthly Payment)

Total Interest Saved
¥325.3k
(¥325,312.69)
New Monthly Payment¥5,282.43
Remaining Term After Prepay206 mos (17.2 yrs)
Time Shortened -118 months (9.8 yrs)
Remaining Future Interest¥261.5k
Net Savings (After Penalty)¥325,312.69
⚡ Best for Monthly Cashflow Relief

Plan B: Reduce Monthly Payment (Keep Term)

Total Interest Saved
¥156.2k
(¥156,245.63)
New Monthly Payment¥3,880.40 (-¥1,408.17)
Remaining Term After Prepay324 mos (27.0 yrs)
Time Shortened0 months (Unchanged)
Remaining Future Interest¥430.6k
Net Savings (After Penalty)¥156,245.63

3. Month-by-Month Amortization Schedule

Highlighting prepayment transition at Month #36.

PeriodMonthly PaymentPrincipal PaidInterest PaidRemaining Principal
#1 ¥5,288.56¥1,938.56¥3,350.00¥1,198,061.44
#2 ¥5,288.56¥1,943.97¥3,344.59¥1,196,117.46
#3 ¥5,288.56¥1,949.40¥3,339.16¥1,194,168.06
#4 ¥5,288.56¥1,954.84¥3,333.72¥1,192,213.22
#5 ¥5,288.56¥1,960.30¥3,328.26¥1,190,252.92
#6 ¥5,288.56¥1,965.77¥3,322.79¥1,188,287.15
#7 ¥5,288.56¥1,971.26¥3,317.30¥1,186,315.88
#8 ¥5,288.56¥1,976.76¥3,311.80¥1,184,339.12
#9 ¥5,288.56¥1,982.28¥3,306.28¥1,182,356.84
#10 ¥5,288.56¥1,987.82¥3,300.75¥1,180,369.02
#11 ¥5,288.56¥1,993.37¥3,295.20¥1,178,375.66
#12 ¥5,288.56¥1,998.93¥3,289.63¥1,176,376.73
#13 ¥5,288.56¥2,004.51¥3,284.05¥1,174,372.22
#14 ¥5,288.56¥2,010.11¥3,278.46¥1,172,362.11
#15 ¥5,288.56¥2,015.72¥3,272.84¥1,170,346.39
#16 ¥5,288.56¥2,021.35¥3,267.22¥1,168,325.05
#17 ¥5,288.56¥2,026.99¥3,261.57¥1,166,298.06
#18 ¥5,288.56¥2,032.65¥3,255.92¥1,164,265.41
#19 ¥5,288.56¥2,038.32¥3,250.24¥1,162,227.09
#20 ¥5,288.56¥2,044.01¥3,244.55¥1,160,183.08
#21 ¥5,288.56¥2,049.72¥3,238.84¥1,158,133.36
#22 ¥5,288.56¥2,055.44¥3,233.12¥1,156,077.92
#23 ¥5,288.56¥2,061.18¥3,227.38¥1,154,016.74
#24 ¥5,288.56¥2,066.93¥3,221.63¥1,151,949.81
#25 ¥5,288.56¥2,072.70¥3,215.86¥1,149,877.11
#26 ¥5,288.56¥2,078.49¥3,210.07¥1,147,798.62
#27 ¥5,288.56¥2,084.29¥3,204.27¥1,145,714.33
#28 ¥5,288.56¥2,090.11¥3,198.45¥1,143,624.22
#29 ¥5,288.56¥2,095.94¥3,192.62¥1,141,528.27
#30 ¥5,288.56¥2,101.80¥3,186.77¥1,139,426.48
#31 ¥5,288.56¥2,107.66¥3,180.90¥1,137,318.81
#32 ¥5,288.56¥2,113.55¥3,175.02¥1,135,205.27
#33 ¥5,288.56¥2,119.45¥3,169.11¥1,133,085.82
#34 ¥5,288.56¥2,125.36¥3,163.20¥1,130,960.45
#35 ¥5,288.56¥2,131.30¥3,157.26¥1,128,829.16
#36 Prepay Point¥5,288.56¥2,137.25¥3,151.31¥1,126,691.91
💡 Recommended Developer Resources & Cost SaversPartner Links · Zero Extra Cost to You

Mastering Mortgage Amortization & Early Prepayment Mathematics

A 30-year mortgage is the largest financial liability most households ever carry. Whether you are choosing between Equal Principal & Interest (Level Payment) and Equal Principal (Linearly Decreasing Payment), or deciding how to deploy a lump-sum bonus toward an early prepayment, understanding how interest accrues month by month can save you hundreds of thousands in lifetime interest.

1. Level Payment vs. Equal Principal Formulas

  • Equal Principal & Interest (Standard Amortization): Your monthly payment remains constant throughout the loan term, while the internal split shifts from interest-heavy in early years to principal-heavy in later years:
    M = P × [ r × (1 + r)^n ] / [ (1 + r)^n - 1 ]
    where P is initial principal, r is monthly interest rate (Annual Rate / 12), and n is total months.
  • Equal Principal: You repay a fixed slice of principal (P / n) every month plus interest on the remaining balance. Your monthly payment starts higher and drops by (P / n) × r each month.

2. Shortening Loan Term (Plan A) vs. Reducing Monthly Payment (Plan B)

When you inject a lump-sum principal reduction at month k, your remaining balance drops immediately. Recalculating the schedule while keeping your monthly payment unchanged (Plan A) compresses the remaining timeline and eliminates years of interest accrual. Recalculating over the original remaining term (Plan B) lowers your mandatory monthly obligation immediately, providing cashflow flexibility at the cost of higher cumulative interest.

Frequently Asked Questions (FAQ)

Q1 When making a lump-sum mortgage prepayment, is it better to shorten the loan term or reduce the monthly payment?
From a pure interest-saving standpoint, shortening the loan term (Plan A) while keeping your monthly payment steady always saves 2x to 2.5x more total interest than reducing your monthly payment (Plan B). Because mortgage interest accrues monthly on the remaining principal balance over time, cutting off years at the end of the amortization schedule eliminates decades of compounding. Choose Plan B only if you need immediate monthly cashflow relief.
Q2 Is there a point in the mortgage lifecycle where prepaying is no longer worth it?
Under standard Equal Principal & Interest (level-payment) amortization, roughly 65%–70% of total scheduled interest is collected during the first half of a 30-year mortgage. However, the true financial rule of thumb is comparing your mortgage interest rate against your risk-free after-tax investment return (such as Treasury bills or high-yield CDs). As long as your mortgage rate exceeds your safe investment yield, prepaying principal delivers a guaranteed risk-free return equal to that spread.
Q3 What is the difference between Equal Principal & Interest (Fixed Payment) and Equal Principal (Decreasing Payment)?
Both methods apply the exact same monthly interest rate to your outstanding principal balance. Equal Principal & Interest keeps your monthly bill identical for 30 years, meaning early payments are mostly interest. Equal Principal divides the principal equally across all months plus current interest, resulting in higher initial monthly bills that decline linearly each month and lower total lifetime interest.
Q4 In a combined mortgage (Commercial + Provident Fund), which portion should I prepay first?
Always direct lump-sum prepayments toward the Commercial Loan portion first. Commercial mortgage rates are significantly higher than subsidized Provident Fund rates (which often sit near 2.60%). Eliminating the higher-rate balance maximizes your net interest savings.