Finance & Money
CD Interest Schedule Calculator
Convert the entered nominal rate and compounding frequency to an equivalent monthly rate, build a complete schedule, and retain cumulative deposits separately from cumulative interest.
Decision view
CD balance and interest schedule
| CD term (months) | Projected maturity value | Opening and additional deposits | Modeled interest earned | Average interest per term month | Interest as share of deposits | Effective monthly rate used for schedule |
|---|
Period-by-period detail
CD monthly interest and maturity schedule
How to use CD Interest Schedule Calculator
- Set additional deposits to zero unless the CD allows them.
- Confirm the quoted rate convention.
- Review the monthly and annual tables before exporting.
Calculator guide
Understanding CD Interest Schedule Calculator
A CD interest schedule exposes each month's opening balance, permitted addition, interest, and ending balance through maturity.
Calculation method
How the calculation works
Schedule audit
Reconcile the maturity value from monthly rows
Three totals should agree at the final month.
Worked situations
Practical examples
- A standard fixed CD commonly allows no later deposits.
- Interest compounds because each ending balance becomes the next opening balance.
- Cumulative interest equals ending balance minus cumulative deposits.
Better inputs
Useful tips
- Use the account disclosure's compounding method.
- Record the maturity date.
- Separate callable or add-on products from standard CDs.
Before relying on the result
Limitations and common mistakes
- The entered nominal compounding frequency is converted to an equivalent monthly rate; exact bank day-count and posting conventions can still differ.
- Taxes, withdrawals, rate changes, and intra-month posting dates are excluded.
- Additional deposits are permitted only when product terms allow.
Reference
Key terms
- Compounding frequency
- Number of nominal interest-crediting periods entered per year.
- Effective monthly rate
- Monthly rate equivalent to the entered nominal rate and compounding frequency.
- Cumulative deposits
- Opening deposit plus all modeled additions.
- Cumulative interest
- Ending balance above cumulative deposits.
- Maturity balance
- Final modeled ending balance.
Important note
Calculated from the entered values and stated financial terms. It is not a product quote, lending decision, tax filing, or investment recommendation.
Frequently asked questions
Do most CDs allow monthly additions?
No; enter zero unless the terms explicitly permit them.
Does compounding frequency change the result?
Yes. The nominal rate is converted through the entered frequency before the monthly schedule is calculated.
Why can bank interest differ?
Banks may use daily balances, exact day counts, posting dates, and different rounding.
Is tax shown in the schedule?
No.