ToolPilot

Portfolio mortgage calculator

Combine commercial loan and provident fund loan.

Inputs
Portfolio totalCN¥1,500,000.00
Commercial / fundCN¥1,000,000.00 / CN¥500,000.00
Result

Equal installment repayment (same monthly payment)

Total loan
CN¥1,500,000.00
Loan months
360 months
Monthly payment
CN¥7,483.30
Total interest
CN¥1,193,987.56
Total repayment
CN¥2,693,987.56

Equal principal repayment (decreasing monthly payment)

Total loan
CN¥1,500,000.00
Loan months
360 months
Monthly payment
CN¥9,604.17
Total interest
CN¥981,468.75
Total repayment
CN¥2,481,468.75

Note

Portfolio loans are calculated as two separate loans first, then monthly payment, total interest, and total repayment are combined.