mortgage calculator

5 Year Mortgage Calculator

The 5 year mortgage calculator is a mortgage payoff calculator that will calculate your monthly or biweekly payments with amortization schedule quickly and easily. The 5 Year Mortgage Calculator includes many built in options such as PMI, extra payment so that you can get all the details for your mortgage. Just enter the necessary field that applies to your mortgage such as PMI, property tax, home insurance, payment frequency (monthly and bi-weekly), monthly HOA fees, and extra payments. You can fill in $0 for the fields that you don't want to be included in the mortgage calculation.

5 Year Loan Calculator

Home Value
$
Down Payment
Mortgage Amount
$
Loan Terms
Interest Rate
PMI (Yearly)
Property Tax (Yearly)
Home Insurance (Yearly)
HOA Fees (Monthly)
Payment Frequency
First Payment Date

Amortization Schedule
Extra Payments
One Time
$ On Date
Monthly or Biweekly
$ Starting Date
Quarterly
$ Starting Date
Yearly
$ Starting Date
Check Local Mortgage Rates


5 Year Mortgage Calculator

Home Value: $300,000.00
Mortgage Amount: $255,000.00
Monthly Principal & Interest: $4,812.16
Monthly Extra Payment: $0.00
Monthly Property Tax: $250.00
Monthly Home Insurance: $125.00
Monthly PMI: (Until Dec, 2023) $106.25
Monthly HOA Fees: $0.00
Total Monthly Payment:
$5,293.41
Total # Of Payments: 60
Start Date: Sep, 2023
Payoff Date: Aug, 2028
Down Payment: $45,000.00
Principal: $255,000.00
Total Extra Payment: $0.00
Total Interest Paid: $33,729.87
Total Tax, Insurance, PMI and Fees: $22,925.00
Total of all Payments:
$356,654.87

5 Year Amortization Schedule

Payment Date Payment # Interest Principal Tax, Insurance, PMI & Fees Total Payment Balance
Sep, 2023 1 $1,062.50 $3,749.66 $481.25 $5,293.41 $251,250.34
Oct, 2023 2 $1,046.88 $3,765.29 $481.25 $5,293.41 $247,485.05
Nov, 2023 3 $1,031.19 $3,780.98 $481.25 $5,293.41 $243,704.07
Dec, 2023 4 $1,015.43 $3,796.73 $481.25 $5,293.41 $239,907.34
Jan, 2024 5 $999.61 $3,812.55 $375.00 $5,187.16 $236,094.79
Feb, 2024 6 $983.73 $3,828.44 $375.00 $5,187.16 $232,266.35
Mar, 2024 7 $967.78 $3,844.39 $375.00 $5,187.16 $228,421.96
Apr, 2024 8 $951.76 $3,860.41 $375.00 $5,187.16 $224,561.56
May, 2024 9 $935.67 $3,876.49 $375.00 $5,187.16 $220,685.07
Jun, 2024 10 $919.52 $3,892.64 $375.00 $5,187.16 $216,792.42
Jul, 2024 11 $903.30 $3,908.86 $375.00 $5,187.16 $212,883.56
Aug, 2024 12 $887.01 $3,925.15 $375.00 $5,187.16 $208,958.41
Sep, 2024 13 $870.66 $3,941.50 $375.00 $5,187.16 $205,016.91
Oct, 2024 14 $854.24 $3,957.93 $375.00 $5,187.16 $201,058.98
Nov, 2024 15 $837.75 $3,974.42 $375.00 $5,187.16 $197,084.56
Dec, 2024 16 $821.19 $3,990.98 $375.00 $5,187.16 $193,093.58
Jan, 2025 17 $804.56 $4,007.61 $375.00 $5,187.16 $189,085.97
Feb, 2025 18 $787.86 $4,024.31 $375.00 $5,187.16 $185,061.67
Mar, 2025 19 $771.09 $4,041.07 $375.00 $5,187.16 $181,020.59
Apr, 2025 20 $754.25 $4,057.91 $375.00 $5,187.16 $176,962.68
May, 2025 21 $737.34 $4,074.82 $375.00 $5,187.16 $172,887.86
Jun, 2025 22 $720.37 $4,091.80 $375.00 $5,187.16 $168,796.06
Jul, 2025 23 $703.32 $4,108.85 $375.00 $5,187.16 $164,687.21
Aug, 2025 24 $686.20 $4,125.97 $375.00 $5,187.16 $160,561.25
Sep, 2025 25 $669.01 $4,143.16 $375.00 $5,187.16 $156,418.09
Oct, 2025 26 $651.74 $4,160.42 $375.00 $5,187.16 $152,257.66
Nov, 2025 27 $634.41 $4,177.76 $375.00 $5,187.16 $148,079.91
Dec, 2025 28 $617.00 $4,195.16 $375.00 $5,187.16 $143,884.74
Jan, 2026 29 $599.52 $4,212.64 $375.00 $5,187.16 $139,672.10
Feb, 2026 30 $581.97 $4,230.20 $375.00 $5,187.16 $135,441.90
Mar, 2026 31 $564.34 $4,247.82 $375.00 $5,187.16 $131,194.08
Apr, 2026 32 $546.64 $4,265.52 $375.00 $5,187.16 $126,928.55
May, 2026 33 $528.87 $4,283.30 $375.00 $5,187.16 $122,645.26
Jun, 2026 34 $511.02 $4,301.14 $375.00 $5,187.16 $118,344.11
Jul, 2026 35 $493.10 $4,319.06 $375.00 $5,187.16 $114,025.05
Aug, 2026 36 $475.10 $4,337.06 $375.00 $5,187.16 $109,687.99
Sep, 2026 37 $457.03 $4,355.13 $375.00 $5,187.16 $105,332.86
Oct, 2026 38 $438.89 $4,373.28 $375.00 $5,187.16 $100,959.58
Nov, 2026 39 $420.66 $4,391.50 $375.00 $5,187.16 $96,568.08
Dec, 2026 40 $402.37 $4,409.80 $375.00 $5,187.16 $92,158.28
Jan, 2027 41 $383.99 $4,428.17 $375.00 $5,187.16 $87,730.11
Feb, 2027 42 $365.54 $4,446.62 $375.00 $5,187.16 $83,283.49
Mar, 2027 43 $347.01 $4,465.15 $375.00 $5,187.16 $78,818.34
Apr, 2027 44 $328.41 $4,483.75 $375.00 $5,187.16 $74,334.59
May, 2027 45 $309.73 $4,502.44 $375.00 $5,187.16 $69,832.15
Jun, 2027 46 $290.97 $4,521.20 $375.00 $5,187.16 $65,310.95
Jul, 2027 47 $272.13 $4,540.04 $375.00 $5,187.16 $60,770.92
Aug, 2027 48 $253.21 $4,558.95 $375.00 $5,187.16 $56,211.96
Sep, 2027 49 $234.22 $4,577.95 $375.00 $5,187.16 $51,634.01
Oct, 2027 50 $215.14 $4,597.02 $375.00 $5,187.16 $47,036.99
Nov, 2027 51 $195.99 $4,616.18 $375.00 $5,187.16 $42,420.81
Dec, 2027 52 $176.75 $4,635.41 $375.00 $5,187.16 $37,785.40
Jan, 2028 53 $157.44 $4,654.73 $375.00 $5,187.16 $33,130.68
Feb, 2028 54 $138.04 $4,674.12 $375.00 $5,187.16 $28,456.56
Mar, 2028 55 $118.57 $4,693.60 $375.00 $5,187.16 $23,762.96
Apr, 2028 56 $99.01 $4,713.15 $375.00 $5,187.16 $19,049.81
May, 2028 57 $79.37 $4,732.79 $375.00 $5,187.16 $14,317.02
Jun, 2028 58 $59.65 $4,752.51 $375.00 $5,187.16 $9,564.51
Jul, 2028 59 $39.85 $4,772.31 $375.00 $5,187.16 $4,792.20
Aug, 2028 60 $19.97 $4,792.20 $375.00 $5,187.16 $0.00

Compare Monthly vs. Bi-weekly

Payment Frequency Monthly Bi-weekly
Payments / Year 12 26
Each Payment $5,293.41 $2,628.20
Total Extra Payments $0.00 $0.00
Total Interest $33,729.87 $30,437.09
Total Tax, Insurance, PMI & Fees $22,925.00 $20,815.38
Total Payment $356,654.87 $351,252.48
Total Savings $0 $5,402.40
Payoff Date Aug, 2028 Apr, 2028

Check Today's Mortgage Rates
Today's Home Equity Rates



Mortgage Calculators

FHA Loan Calculator
VA Loan Calculator
USDA Loan Mortgage Calculator
Simple Mortgage Calculator
PITI Mortgage Calculator
ARM Mortgage Calculator
ARM vs. Fixed Mortgage Calculator
Interest Only Mortgage Calculator
Balloon Mortgage Calculator
Mortgage Points Calculator
Second Mortgage Calculator

Refinance Calculators

Mortgage Refinance Calculator
Cash Out Refinance Calculator
Refinance Break Even Calculator
Refinancing Closing Costs Calculator
Mortgage Recast Calculator

Early Mortgage Payoff Calculators

Early Mortgage Payoff Calculator
Biweekly Mortgage Calculator with Extra Payments
Mortgage Calculator With Extra Payments
Mortgage Prepayment Calculator
Mortgage Payoff Calculator

Real Estate Investment Calculators

Commercial Mortgage Calculator
Mortgage Comparison Calculator
15 Year vs. 30 Year Mortgage Calculator
Investment Property Calculator
Home Improvement Loan Calculator
Home Sale Net Proceeds Calculator
Closing Costs Calculator
Construction Loan Calculator
Home Appreciation Calculator
Real Estate Commission Calculator
Commercial Real Estate Commission Calculator
BRRRR Calculator
Hard Money Loan Calculator
70% Rule Calculator
Piggyback Loan Calculator
Bridge Loan Calculator
Seller Financing Calculator
Real Estate Wholesaling Calculator
Fix and Flip Calculator
Interest Rate Calculator
Home Sale Calculator
Real Estate Capital Gain Tax Calculator




Mortgage Related Calculators

Mortgage Interest Tax Deduction Calculator
APR Calculator
Property Tax Calculator
Down Payment Calculator
Mortgage Affordability Calculator
Mortgage Balance Calculator
Mortgage Points Break Even Calculator
Jumbo Mortgage Calculator
Mortgage Calculator App
Monthly Mortgage Payment Calculator
Reverse Mortgage Calculator
How Much House Can I Afford
Mortgage Prequalification Calculator
HELOC Calculator
HELOC Payment Calculator
HELOC Payoff Calculator
PMI Removal Calculator
Home Equity Loan Calculator
Home Equity Loan Payoff Calculator
Home Equity Calculator
Mortgage Insurance Calculator
Amortization Schedule With Irregular Payments
15 Year Mortgage Calculator
30 Year Mortgage Calculator
Manufactured Home Mortgage Calculator
Condo Mortgage Calculator
Coop Mortgage Calculator
Weekly Mortgage Calculator
Mortgage Calculator Canada
Mortgage Calculator UK
Mortgage Calculator By State
Refinance Savings Calculator
Mortgage Interest Calculator
Mobile Home Mortgage Calculator
Rent Vs. Buy Calculator

Auto Loan Calculators

Car Loan Amortization Schedule Excel
Auto Loan Payoff Calculator
Auto Loan Calculator with Trade in
Auto Refinance Calculator
Biweekly Auto Loan Calculator
RV Loan Calculator
Motorcycle Loan Calculator
Car Lease Calculator
Car Depreciation Calculator
LTV Calculator Auto
Reverse Auto Loan Calculator
How Much Car Can I Afford

Loan Calculators

Printable Amortization Schedule
Amortization Schedule Excel
Amortization Schedule With Extra Payments
LTV Calculator
Debt To Income Ratio Calculator
Debt Payoff Calculator
How Much Rent Can I Afford
Boat Loan Calculator
Student Loan Calculator
Student Loan Payoff Calculator
Student Loan Refinancing Calculator
Personal Loan Calculator
Personal Loan Payoff Calculator
Personal Loan Refinance Calculator
Land Loan Calculator
Loan Payoff Calculator
Loan Calculator Excel
Reverse Loan Calculator
Lump Sum Payment Calculator
Biweekly Loan Calculator
Loan Calculator With Extra Payments

Savings & Investments Calculators

Compound Interest Calculator
Airbnb Calculator
Money Market Account Calculator

Credit Card Calculators

Credit Card Calculator
Credit Card Payoff Calculator
Credit Card Minimum Payment Calculator
Credit Card Interest Calculator
Multiple Credit Card Payoff Calculator

Mortgage Guide

How to Pay Off Mortgage Earlier
How to Improve Credit Score
What Percent Do Real Estate Agents Make
First Time Home Buyer Guide
Mortgage Rates Over Time
Mortgage Terms & Definitions

Mortgage Calculator Widget

Free Mortgage Calculator Widget

Mortgage Calculator | Amortization Schedule | Terms | Privacy | Disclaimer | Contact

©2023 Mortgage Calculator Excel