Advanced | Simple | Early Payoff | Refinance | HELOC | Recast | Interest Only | Biweekly | Extra Payments | Free Widget |

**Loan Calculator Excel** to calculate the monthly payments for your loan. You can use the loan calculator to calculate any type of loans, such as personal loans, student loans, and etc. You can generate an amortization table that shows you all the details of your monthly payment, and the result is exportable as an excel and pdf file.
Enter the loan amount, terms, interest rate to get started. The loan calculator has the option to download the loan repayment schedule (amortization schedule) in an excel spreadsheet in monthly or yearly form.

https://mortgage-calculator.net | ||||||

## Loan & Payment Summary |
||||||

Loan Amount: |
$60,000.00 | |||||

Monthly Payment: |
$1,132.27 | |||||

Total # Of Payments: |
60 | |||||

Start Date: |
Mar, 2023 | |||||

Payoff Date: |
Feb, 2028 | |||||

Total Interest Paid: |
$7,936.44 | |||||

Total Payment: |
$67,936.44 | |||||

## Amortization Schedule |
||||||

Payment Date | Payment # | Interest Paid | Principal Paid | Total Payment | Remaining Balance | |
---|---|---|---|---|---|---|

Mar, 2023 | 1 | $250.00 | $882.27 | $1,132.27 | $59,117.73 | |

Apr, 2023 | 2 | $246.32 | $885.95 | $1,132.27 | $58,231.78 | |

May, 2023 | 3 | $242.63 | $889.64 | $1,132.27 | $57,342.13 | |

Jun, 2023 | 4 | $238.93 | $893.35 | $1,132.27 | $56,448.79 | |

Jul, 2023 | 5 | $235.20 | $897.07 | $1,132.27 | $55,551.71 | |

Aug, 2023 | 6 | $231.47 | $900.81 | $1,132.27 | $54,650.91 | |

Sep, 2023 | 7 | $227.71 | $904.56 | $1,132.27 | $53,746.34 | |

Oct, 2023 | 8 | $223.94 | $908.33 | $1,132.27 | $52,838.01 | |

Nov, 2023 | 9 | $220.16 | $912.12 | $1,132.27 | $51,925.90 | |

Dec, 2023 | 10 | $216.36 | $915.92 | $1,132.27 | $51,009.98 | |

Jan, 2024 | 11 | $212.54 | $919.73 | $1,132.27 | $50,090.25 | |

Feb, 2024 | 12 | $208.71 | $923.56 | $1,132.27 | $49,166.68 | |

Mar, 2024 | 13 | $204.86 | $927.41 | $1,132.27 | $48,239.27 | |

Apr, 2024 | 14 | $201.00 | $931.28 | $1,132.27 | $47,307.99 | |

May, 2024 | 15 | $197.12 | $935.16 | $1,132.27 | $46,372.84 | |

Jun, 2024 | 16 | $193.22 | $939.05 | $1,132.27 | $45,433.78 | |

Jul, 2024 | 17 | $189.31 | $942.97 | $1,132.27 | $44,490.82 | |

Aug, 2024 | 18 | $185.38 | $946.90 | $1,132.27 | $43,543.92 | |

Sep, 2024 | 19 | $181.43 | $950.84 | $1,132.27 | $42,593.08 | |

Oct, 2024 | 20 | $177.47 | $954.80 | $1,132.27 | $41,638.28 | |

Nov, 2024 | 21 | $173.49 | $958.78 | $1,132.27 | $40,679.50 | |

Dec, 2024 | 22 | $169.50 | $962.78 | $1,132.27 | $39,716.72 | |

Jan, 2025 | 23 | $165.49 | $966.79 | $1,132.27 | $38,749.93 | |

Feb, 2025 | 24 | $161.46 | $970.82 | $1,132.27 | $37,779.12 | |

Mar, 2025 | 25 | $157.41 | $974.86 | $1,132.27 | $36,804.26 | |

Apr, 2025 | 26 | $153.35 | $978.92 | $1,132.27 | $35,825.33 | |

May, 2025 | 27 | $149.27 | $983.00 | $1,132.27 | $34,842.33 | |

Jun, 2025 | 28 | $145.18 | $987.10 | $1,132.27 | $33,855.23 | |

Jul, 2025 | 29 | $141.06 | $991.21 | $1,132.27 | $32,864.02 | |

Aug, 2025 | 30 | $136.93 | $995.34 | $1,132.27 | $31,868.68 | |

Sep, 2025 | 31 | $132.79 | $999.49 | $1,132.27 | $30,869.19 | |

Oct, 2025 | 32 | $128.62 | $1,003.65 | $1,132.27 | $29,865.54 | |

Nov, 2025 | 33 | $124.44 | $1,007.83 | $1,132.27 | $28,857.71 | |

Dec, 2025 | 34 | $120.24 | $1,012.03 | $1,132.27 | $27,845.67 | |

Jan, 2026 | 35 | $116.02 | $1,016.25 | $1,132.27 | $26,829.42 | |

Feb, 2026 | 36 | $111.79 | $1,020.48 | $1,132.27 | $25,808.94 | |

Mar, 2026 | 37 | $107.54 | $1,024.74 | $1,132.27 | $24,784.20 | |

Apr, 2026 | 38 | $103.27 | $1,029.01 | $1,132.27 | $23,755.20 | |

May, 2026 | 39 | $98.98 | $1,033.29 | $1,132.27 | $22,721.90 | |

Jun, 2026 | 40 | $94.67 | $1,037.60 | $1,132.27 | $21,684.30 | |

Jul, 2026 | 41 | $90.35 | $1,041.92 | $1,132.27 | $20,642.38 | |

Aug, 2026 | 42 | $86.01 | $1,046.26 | $1,132.27 | $19,596.12 | |

Sep, 2026 | 43 | $81.65 | $1,050.62 | $1,132.27 | $18,545.49 | |

Oct, 2026 | 44 | $77.27 | $1,055.00 | $1,132.27 | $17,490.49 | |

Nov, 2026 | 45 | $72.88 | $1,059.40 | $1,132.27 | $16,431.09 | |

Dec, 2026 | 46 | $68.46 | $1,063.81 | $1,132.27 | $15,367.28 | |

Jan, 2027 | 47 | $64.03 | $1,068.24 | $1,132.27 | $14,299.04 | |

Feb, 2027 | 48 | $59.58 | $1,072.69 | $1,132.27 | $13,226.34 | |

Mar, 2027 | 49 | $55.11 | $1,077.16 | $1,132.27 | $12,149.18 | |

Apr, 2027 | 50 | $50.62 | $1,081.65 | $1,132.27 | $11,067.53 | |

May, 2027 | 51 | $46.11 | $1,086.16 | $1,132.27 | $9,981.37 | |

Jun, 2027 | 52 | $41.59 | $1,090.68 | $1,132.27 | $8,890.68 | |

Jul, 2027 | 53 | $37.04 | $1,095.23 | $1,132.27 | $7,795.45 | |

Aug, 2027 | 54 | $32.48 | $1,099.79 | $1,132.27 | $6,695.66 | |

Sep, 2027 | 55 | $27.90 | $1,104.38 | $1,132.27 | $5,591.29 | |

Oct, 2027 | 56 | $23.30 | $1,108.98 | $1,132.27 | $4,482.31 | |

Nov, 2027 | 57 | $18.68 | $1,113.60 | $1,132.27 | $3,368.71 | |

Dec, 2027 | 58 | $14.04 | $1,118.24 | $1,132.27 | $2,250.47 | |

Jan, 2028 | 59 | $9.38 | $1,122.90 | $1,132.27 | $1,127.58 | |

Feb, 2028 | 60 | $4.70 | $1,127.58 | $1,132.27 | $0.00 |

Amortization Calculator Excel

Additional Mortgage Payment Calculator

Check Today's Mortgage Rates

### Mortgage Calculators

FHA Loan Calculator

VA Loan Calculator

USDA Loan Mortgage Calculator

Simple Mortgage Calculator

PITI Mortgage Calculator

ARM 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

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

HELOC Calculator

HELOC Payment Calculator

PMI Removal Calculator

Home Equity Loan Calculator

Home Equity Loan Payoff Calculator

Mortgage Insurance Calculator

Amortization Schedule With Irregular Payments

15 Year Mortgage Calculator

30 Year 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

### 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

### Mortgage Calculator Widget

Free Mortgage Calculator Widget

VA Loan Calculator

USDA Loan Mortgage Calculator

Simple Mortgage Calculator

PITI Mortgage Calculator

ARM Mortgage Calculator

Interest Only Mortgage Calculator

Balloon Mortgage Calculator

Mortgage Points Calculator

Second Mortgage Calculator

Cash Out Refinance Calculator

Refinance Break Even Calculator

Refinancing Closing Costs Calculator

Mortgage Recast Calculator

Biweekly Mortgage Calculator with Extra Payments

Mortgage Calculator With Extra Payments

Mortgage Prepayment Calculator

Mortgage Payoff 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

Fix and Flip Calculator

Interest Rate Calculator

Home Sale Calculator

Real Estate Capital Gain Tax 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

HELOC Calculator

HELOC Payment Calculator

PMI Removal Calculator

Home Equity Loan Calculator

Home Equity Loan Payoff Calculator

Mortgage Insurance Calculator

Amortization Schedule With Irregular Payments

15 Year Mortgage Calculator

30 Year 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

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

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

Airbnb Calculator

Money Market Account Calculator

Credit Card Payoff Calculator

Credit Card Minimum Payment Calculator

Credit Card Interest Calculator

Multiple Credit Card Payoff Calculator

How to Improve Credit Score

What Percent Do Real Estate Agents Make

Mortgage Calculator | Terms | Privacy | Disclaimer | Contact

©2023 **Mortgage Calculator Excel**