CIS

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.

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-

Decision view

CD balance and interest schedule

CD balance and interest scheduleMonth is shown on the horizontal axis; total balance, cumulative deposits, and cumulative interest are shown in dollars.
Exact scenario comparisonCD term (months) changes while all other entered assumptions remain constant.
CD term (months)Projected maturity valueOpening and additional depositsModeled interest earnedAverage interest per term monthInterest as share of depositsEffective monthly rate used for schedule

Period-by-period detail

CD monthly interest and maturity schedule

The entered nominal compounding frequency is converted to an effective monthly rate; recurring additions are included only when the product permits them.

How to use CD Interest Schedule Calculator

  1. Set additional deposits to zero unless the CD allows them.
  2. Confirm the quoted rate convention.
  3. 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.

Schedule is complete Every month responds to inputs.
Deposits are conditional Most standard CDs do not allow additions.
Interest stays separate Growth is not confused with contributed cash.
Export preserves detail The report includes the updated schedule.

Calculation method

How the calculation works

Convert the nominal annual rate and entered compounding frequency to effective monthly CD interest, then build the month-by-month balance and permitted-addition schedule. Derive the effective monthly rate as (1 + nominal rate / compounds per year)^(compounds per year / 12) - 1, apply it to each opening balance, and add any permitted end-of-month deposit.

Schedule audit

Reconcile the maturity value from monthly rows

Three totals should agree at the final month.

Deposits Opening cash plus permitted additions.
Interest Sum of monthly modeled interest.
Balance Deposits plus cumulative interest.
Maturity Final row equals the summary result.

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.