Deposit Ladder with Entered Yields
Calculate using the labelled inputs: Deposit Ladder with Entered Yields.
Enter a finite value within the formula’s domain and supported numeric range.
| Principal amount | Term in whole months | Effective annual yield, APY (%) | Interest at maturity | Amount at maturity |
|---|
Calculation and assumptions
interest_i=round(principal_i·((1+APY_i/100)^(months_i/12)−1),2); maturity_i=principal_i+interest_i; weighted_months=Σprincipal_i·months_i/Σprincipal_i.
Each row is a separately funded deposit with its own effective annual yield, not a nominal rate. Unequal amounts are allowed. No reinvestment after maturity, taxes or fees. The sum of payments across different dates is not a portfolio balance on one date or an annualized yield. Interest uses floating-point exponentiation and rounds per deposit to cents; results near half-cent boundaries are approximate. At most 50 deposits, 1–1200 months, APY 0–100% (six decimals), principal up to 1e12 with two decimals; per-deposit interest up to 1e12. Use decimal points and spaces between columns. In one chosen two-decimal currency; no taxes or current market rates are supplied.
Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.
Frequently asked questions
How is the result calculated?
interest_i=round(principal_i·((1+APY_i/100)^(months_i/12)−1),2); maturity_i=principal_i+interest_i; weighted_months=Σprincipal_i·months_i/Σprincipal_i.
What assumptions apply?
Each row is a separately funded deposit with its own effective annual yield, not a nominal rate. Unequal amounts are allowed. No reinvestment after maturity, taxes or fees. The sum of payments across different dates is not a portfolio balance on one date or an annualized yield. Interest uses floating-point exponentiation and rounds per deposit to cents; results near half-cent boundaries are approximate. At most 50 deposits, 1–1200 months, APY 0–100% (six decimals), principal up to 1e12 with two decimals; per-deposit interest up to 1e12. Use decimal points and spaces between columns. In one chosen two-decimal currency; no taxes or current market rates are supplied.
How precise are the results?
Monetary totals use two decimal places with the stated rounding rule; other numbers show up to ten significant digits. Display precision does not improve input accuracy. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.