Calculate present value and future value of annuity payments with amortization schedule
Annuity Parameters
%
Payments at end of each period (e.g. most loans)
Present Value (PV)
$45,036.73
Lump sum today
Future Value (FV)
$81,939.67
Total accumulated
Payment Breakdown
Total Payments
120 × $500.00
$60,000.00
Total Interest (FV basis)
Interest earned on savings
$21,939.67
Total Interest (PV basis)
Interest cost over loan life
$14,963.27
Periodic Rate
Annual 6% ÷ 12
0.5000%
PV = PMT × [1−(1+r)^−n] / r
FV = PMT × [(1+r)^n−1] / r
r = 0.5000%, n = 120 periods
Amortization Schedule (first 24 periods)
| # | Payment | Interest | Principal | Balance |
|---|---|---|---|---|
| 1 | $500.00 | $225.18 | $274.82 | $44,761.91 |
| 2 | $500.00 | $223.81 | $276.19 | $44,485.72 |
| 3 | $500.00 | $222.43 | $277.57 | $44,208.15 |
| 4 | $500.00 | $221.04 | $278.96 | $43,929.19 |
| 5 | $500.00 | $219.65 | $280.35 | $43,648.84 |
| 6 | $500.00 | $218.24 | $281.76 | $43,367.08 |
| 7 | $500.00 | $216.84 | $283.16 | $43,083.91 |
| 8 | $500.00 | $215.42 | $284.58 | $42,799.33 |
| 9 | $500.00 | $214.00 | $286.00 | $42,513.33 |
| 10 | $500.00 | $212.57 | $287.43 | $42,225.90 |
| 11 | $500.00 | $211.13 | $288.87 | $41,937.03 |
| 12 | $500.00 | $209.69 | $290.31 | $41,646.71 |