Generate a full payment schedule showing every principal & interest split
Loan amortization is the process of spreading loan payments over time so that each payment covers both interest and a portion of the principal. Early payments are interest-heavy; later payments shift toward principal as the balance declines.
Monthly Payment
$1,264.14
Total Interest
$255,088.98
Total Cost
$455,088.98
| Month | Principal | Interest | Balance |
|---|---|---|---|
| 1 | $180.80 | $1,083.33 | $199,819.20 |
| 2 | $181.78 | $1,082.35 | $199,637.42 |
| 3 | $182.77 | $1,081.37 | $199,454.65 |
| 4 | $183.76 | $1,080.38 | $199,270.89 |
| 5 | $184.75 | $1,079.38 | $199,086.14 |
| 6 | $185.75 | $1,078.38 | $198,900.39 |
| 7 | $186.76 | $1,077.38 | $198,713.63 |
| 8 | $187.77 | $1,076.37 | $198,525.86 |
| 9 | $188.79 | $1,075.35 | $198,337.07 |
| 10 | $189.81 | $1,074.33 | $198,147.26 |
| 11 | $190.84 | $1,073.30 | $197,956.42 |
| 12 | $191.87 | $1,072.26 | $197,764.55 |
| 13 | $192.91 | $1,071.22 | $197,571.64 |
| 14 | $193.96 | $1,070.18 | $197,377.68 |
| 15 | $195.01 | $1,069.13 | $197,182.67 |
| 16 | $196.06 | $1,068.07 | $196,986.61 |
| 17 | $197.13 | $1,067.01 | $196,789.49 |
| 18 | $198.19 | $1,065.94 | $196,591.29 |
| 19 | $199.27 | $1,064.87 | $196,392.03 |
| 20 | $200.35 | $1,063.79 | $196,191.68 |
| 21 | $201.43 | $1,062.70 | $195,990.25 |
| 22 | $202.52 | $1,061.61 | $195,787.73 |
| 23 | $203.62 | $1,060.52 | $195,584.11 |
| 24 | $204.72 | $1,059.41 | $195,379.39 |
| Term | Monthly | Total Interest |
|---|---|---|
| 10 years | $1,135.48 | $36,257 |
| 15 years | $871.11 | $56,800 |
| 20 years | $745.57 | $78,937 |
| 25 years | $674.58 | $102,374 |
| 30 years | $632.07 | $127,545 |
Formula
Monthly Payment = P × [r(1+r)^n] ÷ [(1+r)^n − 1]P = Principal loan amount
r = Monthly interest rate (annual rate ÷ 12)
n = Total number of monthly payments
Worked Example
$200,000 loan at 6.5% for 30 years
Did you know? On a 30-year mortgage at 6.5%, you pay more in total interest than the original loan amount. The Consumer Financial Protection Bureau estimates homeowners can save tens of thousands by refinancing when rates drop even 1% (source: CFPB Mortgage Resources).
Sources
Estimate monthly spousal support using income disparity and marriage length. Educational use only.
Calculate auto loan payments with down payment, trade-in, and amortization schedule.
Find break-even units and revenue. Analyze profit at any volume with contribution margin.
Calculate capital gains tax with short-term and long-term rates. Includes NIIT and residence exclusion.
Calculate expected returns using CAPM based on beta, risk-free rate, and market return.
Calculate cash flow from operations, investing, and financing to analyze business health.