Home Mortgage Calculator
Calculate monthly payments, amortization schedules, and total interest for fixed-rate mortgages.
This spreadsheet helps you analyze fixed-rate mortgages by calculating monthly payments, building complete amortization schedules, and projecting total interest paid over the loan term. Enter your loan amount, interest rate, and term to see detailed breakdowns of principal and interest payments month by month.
Perfect for homebuyers comparing loan options, refinancing decisions, or financial planning. Remove the guesswork from mortgage costs and see exactly how much you'll pay over time with visual charts and detailed calculations.
What's inside
- PMT function calculates exact monthly payment amounts
- Amortization schedule breaks down principal and interest by payment period
- Visual charts show payment distribution and remaining balance over time
- Support for fixed interest rates and custom loan terms
Download this template
.xlsx · 2 sheets · included with lifetime access
More in Personal Finance & Loans
Personal Finance & Loans401(k) Savings Calculator
Track 401(k) contributions, employer matches, and projected retirement savings growth over time.
- Contribution and employer match tracking
- Projected account balance calculations
- Rate of return analysis
Personal Finance & LoansAmortization Chart
Track loan payments month-by-month with principal, interest, and balance breakdowns.
- Automatic monthly payment calculation using PMT function
- Principal vs. interest payment breakdown per month
- Running loan balance after each payment
Personal Finance & LoansAnnuity Calculator
Calculate annuity payments, withdrawals, and retirement income streams with flexible payment schedules.
- Flexible payment frequency options (beginning/end of period)
- Support for multiple annuity types and scenarios
- Interest rate and time period adjustments
Personal Finance & LoansAnnuity Calculator
Calculate annuity payments, withdrawal plans, and retirement income projections with inflation adjustments.
- Flexible annuity payment calculations
- Inflation rate adjustments
- Beginning and end-of-period payment options