Annuity Payment Schedule Calculator

Calculator Inputs

Present Value (PV)

Starting balance or principal amount.

Annual Interest Rate (%)

Nominal APR, converted to periodic rate.

Payments Per Year

Used for both rate and dates.

Term (Years)

Total periods = years × payments per year.

Future Value (FV)

Target remaining balance (e.g., balloon).

Extra Principal Per Period

Applied after the regular payment each period.

Payment Timing

Due payments reduce interest by paying earlier.

Schedule Start Date

First row uses this date.

Rounding (Decimals)

Controls display rounding in the table.

Results appear above this form after submission.

Example Data Table

PV	APR	Payments/Year	Years	Timing	Extra	Typical Output
10,000	6%	12	5	End	0	Payment, total interest, and full schedule
25,000	4.5%	12	3	Beginning	50	Lower interest and faster balance reduction
50,000	7.2%	4	10	End	0	Quarterly schedule with long-term totals

These rows illustrate common setups for testing the calculator.

Formula Used

Let PV be present value, FV be future value, r be the periodic interest rate, and N be the number of payments.

r = (APR / 100) / paymentsPerYear
N = years × paymentsPerYear

Ordinary annuity payment: PMT = r × (PV × (1+r)^N + FV) / ((1+r)^N − 1)

Annuity due adjustment: PMT_due = PMT / (1+r)

When r = 0, the calculator uses PMT = (PV + FV) / N.

How to Use This Calculator

Enter the present value, APR, and payments per year.
Set the term in years, plus an optional future value.
Select payment timing and a start date for the schedule.
Add optional extra principal to model faster payoff.
Click “Calculate Schedule” to view results above the form.
Use the export buttons to download CSV or PDF.

FAQs

1) What is an annuity payment schedule?

A schedule lists each payment date and splits the payment into interest and principal. It also tracks the remaining balance after each period.

2) What does “payment timing” change?

End-of-period payments are ordinary annuities. Beginning-of-period payments are annuities due, which typically lower interest because money is paid earlier.

3) How does extra principal affect results?

Extra principal reduces the balance faster, which reduces future interest. Your schedule may pay off early if no future value target is set.

4) What is the future value input used for?

Future value represents a target remaining balance at the end, such as a balloon amount. A higher future value usually lowers the periodic payment.

5) Why do my dates look approximate for some frequencies?

Monthly, quarterly, and weekly increments are handled directly. Less common frequencies use a day-based approximation to keep the schedule consistent.

6) What rounding should I choose for currency?

Two decimals are typical for currency. If you are matching a lender’s statement, try different rounding settings because institutions can round per period.

7) Is the PDF identical to the table shown on screen?

The PDF export is a lightweight text summary for broad compatibility. It may truncate long schedules, while CSV includes all rows.

8) Can this model investment annuities too?

Yes, the same math applies. Interpret PV as the initial amount, PMT as deposits or withdrawals, and FV as the ending target value.