Ledgerline
All calculators Plans Activate plan See plans

All calculators / Time value of money

Loan and mortgage payment

Regular payment, total interest and a yearly amortization schedule.

$
%
yrs

Payment each period

$1,319.59

Total paid
$395,878
Total interest
$145,878
Number of payments
300

Amortization by year

YearInterestPrincipalBalance
1$9,892$5,943$244,057
2$9,650$6,185$237,871
3$9,398$6,437$231,434
4$9,135$6,700$224,734
5$8,862$6,973$217,762
6$8,578$7,257$210,505
7$8,283$7,552$202,952
8$7,975$7,860$195,092
9$7,655$8,180$186,912
10$7,322$8,514$178,398
11$6,975$8,860$169,538
12$6,614$9,221$160,317
13$6,238$9,597$150,720
14$5,847$9,988$140,731
15$5,440$10,395$130,336
16$5,017$10,819$119,518
17$4,576$11,259$108,258
18$4,117$11,718$96,540
19$3,640$12,195$84,345
20$3,143$12,692$71,653
21$2,626$13,209$58,443
22$2,088$13,748$44,696
23$1,527$14,308$30,388
24$944$14,891$15,497
25$338$15,497$0

The formula

PMT = P × i ÷ [1 − (1 + i)⁻ⁿ]

i is the interest rate per payment period and n is the number of payments. Early payments are mostly interest, later ones mostly principal.

Analyst
Get step-by-step worked solutions for every formula and save your calculations.

See the plans