Amortization Schedule Calculator

Reviewed by ArvCalc Editorial TeamLast updated: September 2026

This calculator generates a complete month-by-month amortization schedule for a fixed-rate mortgage loan. See how each payment splits into principal and interest, track your equity buildup, and model extra payments to shorten your loan. Results are for educational purposes only and should not replace professional lending advice.

Monthly Payment
โ€”fill in fields below

What do you want to calculate?

Enter loan details to generate a full amortization schedule showing principal, interest, and remaining balance for every payment.

๐Ÿ’ณLoan Details

The total amount borrowed (after down payment)

Monthly Payment (P&I)

โ€”
Enter values to see result

An amortization schedule is a complete table showing every payment on a loan over its entire term. Each row shows how much of your monthly payment goes toward principal (reducing your debt) versus interest (the cost of borrowing). For real estate investors, understanding amortization is critical because it directly affects equity buildup, cash flow, and long-term wealth creation.

This calculator generates a full month-by-month schedule for any fixed-rate mortgage. It supports extra payment modeling, refinance comparison, and equity tracking. Results are for educational and planning purposes only.

What Is an Amortization Schedule?

An amortization schedule is a detailed table that maps out every single payment you will make over the life of a loan. Per the CFPB, amortization means systematically paying off your debt through regular installments of principal and interest.

For a standard fixed-rate mortgage, every monthly payment is the same amount, but the split between principal and interest changes dramatically over time. In the early years, most of your payment goes toward interest. By the final years, almost all of it goes toward principal. This front-loaded interest structure is how lenders ensure they get paid first.

Real estate investors use amortization schedules for several critical purposes: calculating how much equity they build each year, determining when they hit the 20% equity threshold to drop PMI, modeling how extra payments accelerate payoff, and comparing refinance scenarios to see if lower rates actually save money after closing costs.

Unlike simple mortgage calculators that only show the monthly payment, an amortization schedule gives you the complete picture โ€” every dollar, every month, for the entire life of the loan. This level of detail is essential for serious investment analysis.

How Mortgage Amortization Works

Mortgage amortization follows a precise mathematical formula. Per Freddie Mac PMMS, current 30-year fixed rates are 6.5โ€“7.5% (Sep 2026). The monthly payment is calculated so that the loan balance reaches exactly zero on the final payment date. Here is the step-by-step process:

The Payment Formula

M = P ร— [r(1+r)^n] / [(1+r)^n - 1]

M = Monthly payment

P = Loan principal (amount borrowed)

r = Monthly interest rate (annual rate / 12)

n = Total number of payments (years ร— 12)

Each Month's Breakdown

1

Calculate Interest

Interest = Remaining Balance ร— Monthly Rate

2

Determine Principal

Principal = Monthly Payment - Interest

3

Update Balance

New Balance = Previous Balance - Principal Paid

Worked Example: $150,000 at 7% for 30 Years

Monthly payment: $998.

Month 1: Interest = $150,000 ร— (7%/12) = $875. Principal = $998 - $875 = $123. New balance = $149,877.

Month 2: Interest = $149,877 ร— 0.00583 = $874. Principal = $998 - $874 = $124. Balance drops to $149,753.

Notice how the interest drops slightly each month as the balance decreases, and the principal portion grows. By month 1, only 12.3% of your payment reduces the debt. But by month 300 (year 25), about 75% goes to principal.

Total Cost Over 30 Years

360 payments ร— $998 = $359,263 total. You borrowed $150,000, so you pay $209,263 in interest โ€” that is 139% of the original loan amount. This is why investors obsess over interest rates and loan terms.

How to Read an Amortization Table

An amortization table can look overwhelming with hundreds of rows, but each column tells a specific part of the story. Here is what to focus on:

ColumnWhat It ShowsWhy It Matters
PaymentTotal amount due that month (constant for fixed-rate)This is the cash flow commitment from your property's income
PrincipalPortion that reduces your loan balanceThis is forced savings โ€” you are building equity with each payment
InterestThe cost of borrowing for that monthTax-deductible for investment properties; shrinks over time
BalanceRemaining amount owed after this paymentSubtract from property value to get your current equity position

The key insight from any amortization table is the crossover point โ€” the month where the principal portion first exceeds the interest portion. For a 30-year loan at 7%, this happens around year 19. For a 15-year loan at 7%, it happens around year 5. Everything before the crossover point is primarily paying the bank; everything after is primarily building your equity.

Why Most of Your Early Payments Go to Interest

This is the single most important concept in mortgage amortization, and it catches many first-time investors off guard. On a $200,000 loan at 7% for 30 years, your monthly payment is $1,331. But in month one, only $164 goes to principal โ€” the other $1,167 (87.7%) goes to interest.

The reason is simple math: interest is calculated on the remaining balance. When you owe $200,000, the monthly interest charge is $200,000 times 7% divided by 12 = $1,167. After you pay that interest, whatever is left from your $1,331 payment goes to principal. Since the balance barely changes in the early years, the interest charge barely drops, and the principal portion grows very slowly.

After 5 years (60 payments), you have paid $79,860 in total payments, but your balance has only dropped from $200,000 to $188,283. You have built only $11,717 in equity through principal paydown (5.9% of the original loan). The other $68,143 went to interest.

This is precisely why extra payments early in the loan have such a dramatic impact โ€” a $200 extra payment in month 1 saves about $480 in total interest over the life of the loan, because that $200 will never accrue 29+ years of compounding interest charges.

How Extra Payments Save You Thousands

Extra payments go directly to reducing your principal balance, which means every dollar of extra payment eliminates years of future interest charges. The earlier you make extra payments, the more powerful the effect.

Worked Example: $150,000 Loan at 7%, 30 Years

No Extra Payments

$209,263

total interest over 30 years

360 payments

+$200/month Extra

$131,850

total interest

Saves $77,413 and 10.5 years

+$500/month Extra

$82,407

total interest

Saves $126,856 and 17.4 years

These figures are approximate and based on the specific rate and term shown. Use the calculator above in "Extra Payments" mode to model your own scenario.

The key strategies for extra payments include: making one extra full payment per year (equivalent to paying bi-weekly instead of monthly), rounding up your payment to the next $100, applying all rental income increases toward extra principal, and making lump-sum payments from bonuses or tax refunds. Always verify with your lender that extra payments are applied to principal, not future payments.

Amortization for Investment Property vs Primary Residence

While the amortization math is identical for both property types, investment properties carry higher rates. Per FRED historical mortgage data, the spread between owner-occupied and investment property rates is typically 0.5โ€“1.5%. Here are the key differences investors should understand:

1

Interest Rate Difference

Investment property rates are typically 0.5-0.75% higher than primary residence rates. On a $200,000 loan, that difference adds $20,000-$30,000 in total interest over 30 years. This is why many investors focus on the DSCR metric โ€” the debt service coverage ratio tells you whether the property's income can handle the higher rate.

2

Tax Treatment of Interest

On investment properties, the entire mortgage interest payment is deductible as a business expense against rental income. This means the effective cost of interest is lower for investors in higher tax brackets. Your amortization schedule shows you exactly how much interest you can deduct each year.

3

Equity Strategy

For a primary residence, paying off the mortgage is often the goal. For investment properties, many investors prefer to keep the loan in place to maximize leverage and use available cash for acquiring additional properties. The amortization schedule helps you track equity for refinancing decisions.

4

PMI Threshold

Most lenders require PMI when your equity is below 20%. Your amortization schedule shows exactly when you hit 20% equity through principal paydown alone. For investment properties with 25% down, PMI is usually not required from the start.

How Amortization Affects Your BRRRR Strategy

The BRRRR (Buy, Rehab, Rent, Refinance, Repeat) strategy depends heavily on understanding amortization at two stages: the initial acquisition loan and the refinance loan.

During the rehab phase, you typically use a short-term hard money or bridge loan. These loans are often interest-only, so there is no amortization โ€” you are paying pure interest until you refinance. The amortization schedule becomes critical when you refinance into a conventional long-term mortgage.

For BRRRR investors, the amortization schedule answers key questions: How much principal will you pay down before your next refinance? How quickly are you building equity that you can pull out? If you refinance every 2-3 years, how much of each period's payments actually go to principal versus interest?

A 30-year amortization at 7% means only about 5% of your total payments in the first 3 years go to principal. If you are using a BRRRR strategy with a 3-year hold before refinancing, your equity growth comes primarily from appreciation and forced value-add, not from principal paydown. Understanding this helps you set realistic expectations and plan your BRRRR exits more accurately.

Common Amortization Mistakes

1

Confusing loan term with amortization period

Some commercial loans have a 5-year term with a 25-year amortization โ€” your payments are calculated as if the loan lasts 25 years, but the entire remaining balance is due as a balloon payment after 5 years. Always confirm both the term and the amortization period.

2

Assuming extra payments automatically reduce principal

Some lenders apply extra payments to future payments (prepaying next month's interest) instead of directly to principal. Always instruct your servicer to apply extra payments to principal, and verify it on your statement.

3

Ignoring total interest cost when comparing loans

A lower monthly payment does not always mean a better deal. A 30-year loan at 6.5% has a lower payment than a 15-year at 6.5%, but you pay nearly three times more total interest. Always compare total interest paid, not just monthly payments.

4

Forgetting that amortization schedules assume fixed rates

The schedule generated here assumes a fixed interest rate for the life of the loan. If you have an ARM (adjustable-rate mortgage), the schedule will change at each rate adjustment. Run a new schedule after each adjustment to see the updated payoff timeline.

5

Not accounting for escrow in total housing cost

This calculator shows P&I (principal and interest) only. Your actual monthly payment to the lender likely also includes property taxes and insurance (PITI). Always budget for the full PITI amount, not just the P&I shown in an amortization schedule.

Amortization Formula & Calculation Method

Fixed Monthly Payment

M = P ร— [r(1+r)^n] / [(1+r)^n - 1]

P = Principal (loan amount)

r = Monthly rate = Annual Rate / 12 / 100

n = Total payments = Years ร— 12

M = Fixed monthly payment

Monthly Breakdown

Interest Portion

Interest = Balance ร— r

Principal Portion

Principal = M - Interest

New Balance

Balance = Balance - Principal

With Extra Payments

Balance = Balance - Principal - Extra

Frequently Asked Questions

What is the difference between amortization and depreciation?

Amortization refers to paying off a loan through regular installments of principal and interest. Depreciation is a tax concept where you deduct the cost of a property over its useful life (27.5 years for residential rental property). They are completely different financial concepts. Your mortgage amortization schedule tracks your actual debt payments, while depreciation is a paper expense used to reduce taxable income.

Should I pay extra on my investment property mortgage?

It depends on your strategy. If you want to build equity faster and reduce total interest, extra payments are powerful. However, many investors prefer to keep that capital available for additional property acquisitions, where the ROI may exceed the interest savings. Compare the interest rate on your mortgage to the returns you could earn by deploying that capital elsewhere. If your mortgage is at 7% and you can earn 12% on a new deal, the extra payment is better deployed elsewhere.

When does the principal portion exceed the interest portion?

For a 30-year fixed loan at 7%, the crossover happens around month 222 (about 18.5 years in). At 6%, it happens around month 200 (16.7 years). At 5%, around month 177 (14.75 years). Shorter loan terms reach crossover much faster โ€” a 15-year loan at 7% crosses over around month 61 (just over 5 years). Use the amortization table above to find the exact crossover month for your specific loan terms.

How do I use the amortization schedule for refinance decisions?

Compare the remaining balance and remaining interest on your current loan against the total cost of a new loan (including closing costs). The breakeven point is when the cumulative savings from the lower payment exceed the closing costs. Our Refinance Compare mode does this calculation automatically. Generally, if you can reduce your rate by 1% or more and plan to hold for at least 3-5 years, refinancing is worth investigating.

Does this calculator account for PMI, taxes, and insurance?

No. This calculator shows principal and interest (P&I) only. PMI, property taxes, homeowner's insurance, and HOA fees are separate costs that vary by location and lender. Your total monthly housing payment (PITI) will be higher than the P&I amount shown here. For a complete rental property analysis including all costs, use our Rental Property Calculator.