Commercial Loan Calculator - Equal Installment/Principal Repayment Details & Excel Export

Supports equal installment and equal principal, one-click Excel export of monthly repayment details

Loan Parameters
Calculation Method
Loan Amount CNY
Loan Term
Loan Months Month
Annual Interest Rate %
First Payment
Year Month
Equal Installment (Constant Monthly Payment)
Total Loan 0 CNY
Repayment Months 0 Month
Monthly Payment 0 CNY
Total Interest 0 CNY
Total Payment 0 CNY
Equal Principal (Monthly Decreasing)
Total Loan 0 CNY
Repayment Months 0 Month
First Month Payment 0 CNY
Monthly Decrease 0 CNY
Total Interest 0 CNY
Total Payment 0 CNY
Interest Saved 0 CNY vs Installment
📊 Monthly Repayment Details Report
Equal Installment Details
PeriodPayment DateMonthly Payment (CNY)Interest (CNY)Principal (CNY)Remaining Principal (CNY)
Click "Calculate" to view details
Equal Principal Details
PeriodPayment DateMonthly Payment (CNY)Interest (CNY)Principal (CNY)Remaining Principal (CNY)
Click "Calculate" to view details