CD Ladder Rungs Maturity Builder Tool

Build caller CD ladder maturities anchored independently to original start day with end-of-month clamping and exact principal remainder allocation; no rolling-clamp drift, business-day maturity adjustment, rates or reinvestment assumptions.

Description

A certificate of deposit (CD) ladder assigns maturity terms from a common start date.

A certificate of deposit (CD) ladder assigns maturity terms from a common start date. Anchoring each date independently avoids cumulative month-end drift.^[1]

The returned values include Rung maturity dates, Rung principal minor, Rung terms months. The How section below explains the calculation, input rules and interpretation.

When to use CD Ladder Rungs Maturity Builder Tool

Use CD Ladder Rungs Maturity Builder Tool when you need to evaluate the supplied records under the calculation and evidence rules below. No business-day adjustment, CD rates or reinvestment assumptions are supplied.

Prepare observed financial records and verified caller terms. Use one currency for integer minor-unit money and preserve leading zeros in identifier text. One basis point is 0.01 percentage points. Resolve dates, local clocks, counting rules and evidence flags as specified.

How to use CD Ladder Rungs Maturity Builder Tool and understand its results

Prepare observed financial records and verified caller terms. Use one currency for integer minor-unit money and preserve leading zeros in identifier text. One basis point is 0.01 percentage points. Resolve dates, local clocks, counting rules and evidence flags as specified.
Enter ladderStartDate, totalLadderPrincipalMinor, rungCount, firstTermMonths, termSpacingMonths using the field table and calculation rules, then run the tool.
Read rungMaturityDates, rungPrincipalMinor, rungTermsMonths. The explanation below defines the units, signs, ordering and any flags or placeholder values.
If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.

Input field	Meaning	Value type; see rules below	Requirement
ladderStartDate	Ladder start date	string	Required
totalLadderPrincipalMinor	Total ladder principal minor	number	Required
rungCount	Rung count	number	Required
firstTermMonths	First term months	number	Required
termSpacingMonths	Term spacing months	number	Required

Enter exact real Gregorian YYYY-MM-DD start in 1900–2199, nonnegative safe-integer principal, integer rung count 1–128 and first/spacing months 1–1200. Every derived term must also be at most 1200 and every generated date supported. Clamp each original day to its destination month end. Divide principal equally by integer floor and assign remaining minor units to earliest rungs. Return dates, exact allocated principals and terms.

term_i=firstMonths+i×spacing; date_i=addMonths(originalStart,term_i)

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output field	Meaning	Value type
rungMaturityDates	Rung maturity dates	list of string
rungPrincipalMinor	Rung principal minor	list of number
rungTermsMonths	Rung terms months	list of number

json

{
  "input": {
    "ladderStartDate": "2024-01-31",
    "totalLadderPrincipalMinor": 100,
    "rungCount": 3,
    "firstTermMonths": 1,
    "termSpacingMonths": 1
  },
  "output": {
    "rungMaturityDates": [
      "2024-02-29",
      "2024-03-31",
      "2024-04-30"
    ],
    "rungPrincipalMinor": [
      34,
      33,
      33
    ],
    "rungTermsMonths": [
      1,
      2,
      3
    ]
  }
}

Limitations and assumptions

No business-day adjustment, CD rates or reinvestment assumptions are supplied.

Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Extremely large text inputs are rejected. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use CD Early Withdrawal Penalty Months Lookup: A nominal-interest CD penalty scales principal by annual rate and penalty months. The supplied cap policy determines whether penalty can invade principal. For a complementary task, use Dormant Escheatment Years Lookup: A dormancy anniversary adds calendar years to qualifying activity. Leap-day clamping differs from multiplying years by a fixed day count.

References

CD Ladder Rungs Maturity Builder Tool — tool.io

Similar or alternative tools

CD Early Withdrawal Penalty Months Lookup
A nominal-interest CD penalty scales principal by annual rate and penalty months. The supplied cap policy determines whether penalty can invade principal.
Dormant Escheatment Years Lookup
A dormancy anniversary adds calendar years to qualifying activity. Leap-day clamping differs from multiplying years by a fixed day count.