Mortgage & Auto Loan Calculator
Calculate down payment, monthly payments and total interest. Download your complete mortgage or auto loan payment table in Excel format.
These are approximate figures. Actual payments may vary depending on specific bank terms, mortgage program rules, exact disbursement dates, and weekend/holiday payment policies.
How to use
- 1
Enter the total Purchase Price of the house, apartment, or vehicle.
- 2
Input your Down Payment as a percentage (e.g., 30%). The tool will calculate the loan principal automatically.
- 3
Enter the Annual Interest Rate and the loan Term in months.
- 4
Choose your Payment Type: 'Annuity' for fixed monthly amounts, or 'Linear' for equal principal payments (where the total decreases over time).
- 5
Select your Payment Frequency (Once or Twice a month) to see how it affects your interest savings.
- 6
The tool automatically calculates your monthly payment and the full amortization schedule.
- 7
Click the 'Download Excel' button to save your full amortization schedule.