CD Ladder Calculator & Cash Access Planner

Compare two certificate-of-deposit plans built from the same starting cash. Enter each CD's APY, maturity and quoted early-closure terms. Follow the step-by-step release of cash, then choose a day and dollar amount you need. The calculator shows which plan meets your need with cash on hand, which CDs would have to close early and the earliest date each plan can cover the goal without closing an account.

Savings planning

Compare two CD ladders

See when cash becomes available and which whole deposits can cover a dated need at the lowest early-closure fee.

Cash need

Day 200 · $7,000.00 needed. Plan A: covered without early closure. Plan B: covered with early closure.

Plan A

Covered without early closure
$7,092.81
Available without closing a CD
Maximum with eligible closures
$17,231.99
Locked face value
$10,000.00
First day with cash alone
Day 180
Value at full maturity
$17,711.22

Plan B

Covered with early closure
$2,000.00
Available without closing a CD

Close CD 1 · $149.79 total fee

$15,192.20 in net early proceeds, leaving $10,192.20 after the cash need.

$944.47 in modeled future interest surrendered.

Maximum with eligible closures
$17,192.20
Locked face value
$15,000.00
First day with cash alone
Day 730
Value at full maturity
$18,286.46
Cash released at each maturity
  • Plan A solid
  • Plan B dashed
  • Cash need dotted
Unrestricted cash by days after openingDay 200. The target is $7,000.00. Plan A has $7,092.81 available without early closure. Plan B has $2,000.00.$19.7K$00730

Horizontal axis is days since opening. Vertical axis is USD. The vertical marker is the selected cash-need day.

Day 200. The target is $7,000.00. Plan A has $7,092.81 available without early closure. Plan B has $2,000.00.

Edit Plan A deposits

CD 1

CD 2

CD 3

Edit Plan B deposits

CD 1

Maturity and closure ledger

Open maturity and closure worksheet
AccountMaturityAPYScheduled proceedsAccrued at need dayEarly feeNet early proceedsStatus on need day
Plan A CD 1Day 1803.8%$5,092.81$5,092.81——Matured
Plan A CD 2Day 3654%$5,200.00$5,108.62$32.05$5,076.57Can close
Plan A CD 3Day 7304.1%$5,418.41$5,111.31$48.70$5,062.61Can close
Plan B CD 1Day 7304.2%$16,286.46$15,341.99$149.79$15,192.20Can close
Download CD comparison CSV
Show selectable CSV

How to use this calculator

  1. Enter Starting cash, Cash needed and Need day after opening. Day 0 is the day both plans place their deposits.
  2. Edit the CD rungs for Plan A and Plan B. Use the quoted maturity in days and the disclosed APY. Any amount left unallocated remains available.
  3. Enter whether each CD can close early, the earliest day, and the disclosed fixed or days-of-interest fee. Choose the fee limit stated in the disclosure.
  4. Compare each plan's available cash, first day without early closure and any minimum-fee closure choice. Use the maturity-step buttons to inspect earlier or later dates.
  5. Open the maturity ledger and download the CSV to see each scheduled maturity and the terms behind the selected date's funding decision.

The Formula

The mathematical logic powering this calculation is:

Both plans start on day 0 with the same dollar amount. Enter up to eight direct fixed-rate CDs per plan. Uncommitted cash stays available and earns no interest in this worksheet. Each full maturity releases its principal and modeled interest as unrestricted cash at the start of its entered maturity day. Unrestricted cash accumulates as CDs mature, with no reinvestment.

For principal P, APY y as a decimal and elapsed whole days t, the estimated balance is P × (1 + y)^(t/365) with half-up rounding to cents. This is an Actual/365 projection with all interest left in the account. It estimates midterm accrued interest from APY. Confirm the bank's actual term, posting and early withdrawal treatment from the account disclosure.

Each early closure is a whole-CD withdrawal. Unavailable means the terms provide no early closure in this scenario. A fixed fee uses the entered dollars. A days-of-interest fee is P × quoted annual nominal rate × penalty days ÷ 365, rounded half up to cents. The selected fee limit caps the modeled fee at the accrued interest or the gross accrued proceeds according to the stated terms. Net early proceeds are accrued proceeds less the fee. A CD is eligible only from its first permitted day up to the day before maturity.

At the cash-need day, compare unrestricted cash with the target first. If cash is short, the calculator checks every eligible combination of whole CDs and selects the smallest total penalty that covers the gap. It breaks ties with the smallest excess cash, then the fewest closed CDs and the entered order. Future interest surrendered is the sum of selected maturity proceeds less their accrued amounts. It is displayed separately from the early charge and does not enter the fee sort. When the largest available amount is below target, the result shows that shortfall. The maturity chart and first day with enough unrestricted cash follow the original schedule before any proposed early closure.

Opening cash is $0.01–$10 million. Deposits and fee inputs accept cents. Maturity is 7–3,650 whole days. APY and annual penalty rates are from 0–30% with up to six decimals. The scenario assumes fixed-rate retained-interest CDs and scheduled receipt on the stated days. Use separate calculations for partial withdrawals, renewal or brokerage, callable or variable-rate deposits, interest paid out, taxes, fees other than the entered closure terms and deposit-insurance coverage.

Worked Example

If you input:

  • Starting cash ($): $17,000
  • Cash needed ($): $7,000
  • Need day after opening: 200 days
  • Plan A CDs: $5,000 each at 3.8%, 4.0% and 4.1% APY for 180, 365 and 730 days
  • Plan B CDs: $15,000 at 4.2% APY for 730 days with a quoted penalty of 90 days at 4.05% nominal

Result:

Plan A releases $5,092.81 on day 180. Adding the $2,000 reserve gives $7,092.81 on day 200, enough for the $7,000 need. Plan B still has $2,000. Closing its one CD early gives $15,192.20 after a $149.79 fee. The early closure also gives up $944.47 of modeled future interest. If both plans follow their full maturity schedules, the totals are $17,711.22 for Plan A and $18,286.46 for Plan B.

Frequently Asked Questions

How does a CD ladder make cash available at different times?

A ladder places separate deposits with different maturity days. Each deposit releases its principal and interest at its own maturity. In this worksheet those proceeds join the cash reserve, so they can cover a later need without closing another account.

Can I use APY as the rate for the early withdrawal fee?

Use APY for projected growth and the rate stated in your bank's fee calculation for the days-of-interest penalty. A fee may instead be a fixed amount. The disclosure specifies its basis and whether it may come out of principal.

Does the smallest fee also give the least loss of future interest?

The fee and future interest describe different costs. The worksheet chooses the least immediate fee that covers the target and reports interest surrendered separately. Compare that second amount and the funds you are unlocking before choosing a closure.

What happens if I need cash on the maturity day?

The model releases the full scheduled amount at the start of the maturity day, before applying the early-closure comparison. Confirm with the institution when the funds can be transferred and whether the CD renews.

How should I model a CD that cannot close early?

Set Early closure terms to Unavailable. It will count as accessible after maturity only. For an allowed closure, enter the first eligible day and the quoted fee rule.

Why can the account's actual payout differ from the projection?

Actual interest depends on the disclosure, day-count and crediting schedule. The model interpolates a fixed APY across a 365-day year, projects full interest retained and rounds each inspected accrued amount to cents.

Similar Calculators