Staggered maturity tiles, released cash, renewed principal, and liquidity gapsLive current inputs
Finance & Money
Certificate of Deposit Cash Flow Calculator
Design a staggered CD maturity calendar with rung values, released cash, renewals, and liquidity coverage.
Principal per rung—
First maturity cash—
First-year maturity liquidity—
Projected first-cycle interest—
Principal renewed per rung—
Cash released per rung—
Maturities covering planned need—
Ladder liquidity—
CD maturity calendar
Staggered maturity tiles, released cash, renewed principal, and liquidity gaps
Each tile is dated by spacing rather than displayed as an undifferentiated total balance.
Live decision table
CD maturity and renewal calendar
See each rung's maturity month, value, withdrawal, released cash, and renewed principal.
| Rung | Maturity month | Maturity value | Planned need | Cash released | Renewed |
|---|
Cash-flow schedule
Annual and monthly cash-flow schedule
How to use
Build the ladder from actual liquidity dates
- Use current account or security documents.
- Keep rates, timing, taxes, and cash flows explicit.
- Change one assumption at a time.
- Compare the result with a practical liquidity need.
Calculation logic
Staggering converts locked cash into scheduled access
Equal rungs simplify planning, but each term earns for a different duration and produces different maturity value.
The live table preserves intermediate values instead of reducing the decision to one headline number.
Calculation method
Divide capital into rungs and calculate each maturity cash decision
Equal principal is assigned to staggered maturities. Each rung grows for its own term, then splits between released cash and renewal.
Detailed calculation process and general formulas
P_r=C/NV_k=P_r(1+APY)^(m_k/12)Released_k=max[V_k(1-q),W] subject to cashRenewed_k=V_k-Released_kCoverage=count(Released_k≥W)Symbols, meanings, and units
- C
- total allocated cashcurrency
- N
- number of rungscount
- m_k
- months to rung k maturitymonths
- q
- renewal sharedecimal
- W
- planned cash needcurrency/maturity
The live substitution below follows formula order and reconciles the current result with the decision table and visual.
Decision audit
Check constraints the arithmetic cannot guarantee
- Confirm contractual dates and penalties.
- Stress rates and reinvestment assumptions.
- Separate taxable and protected accounts.
- Preserve emergency liquidity.
Decision anatomy
What controls ladder liquidity
The diagnostic cards isolate the drivers most likely to change the decision.
Rung principal
—Initial cash allocated to each maturity slot.
Released cash
—Amount available instead of renewed.
Need coverage
—Rungs whose released cash meets the planned need.
Decision takeaway: Choose rung spacing from cash needs before optimizing yield.
Practical applications
Decisions this calculator is designed to support
Quarterly liquidity ladder
A saver wants regular access without keeping all cash idle.
What the result clarifies: The calendar exposes the months with and without maturity cash.
Rolling annual expense fund
Each maturity pays a known expense and renews the rest.
What the result clarifies: Released and renewed amounts stay separate.
Worked example
Current-input substitution and reconciliation
Important note
Real CD ladders may use unequal principals, different APYs, callable products, penalties, tax timing, and deposit-insurance limits.
Certificate of Deposit Cash Flow Calculator FAQ
Why are rung values different?
Later rungs compound for longer.
Does interest payout reduce maturity value?
When selected, interest is treated as external cash rather than renewed principal.
Can I use unequal rungs?
This model uses equal starting principal; adjust total cash or rung count for a first-pass plan.