{"id":87,"date":"2026-07-21T16:29:45","date_gmt":"2026-07-21T16:29:45","guid":{"rendered":"https:\/\/cdrate-calculator.com\/blog\/?p=87"},"modified":"2026-07-23T08:47:07","modified_gmt":"2026-07-23T08:47:07","slug":"cd-calculator-in-excel","status":"publish","type":"post","link":"https:\/\/cdrate-calculator.com\/blog\/cd-calculator-in-excel\/","title":{"rendered":"CD Calculator in Excel: Build One in 5 Minutes (Formulas Included)"},"content":{"rendered":"

Excel is a perfectly good CD calculator \u2014 if you know which two formulas to type. This guide builds you a complete CD calculator in a blank spreadsheet in about five minutes: maturity value, interest earned, monthly income, and even a full CD ladder tracker. Every formula works identically in Google Sheets.<\/span><\/p>\n

Quick answer:<\/b> put your deposit in B1, APY in B2 (as 4.5%), and years in B3, then: =B1*(1+B2)^B3 gives your maturity value. Prefer zero setup? Our <\/span>online CD calculator<\/span><\/a> does it in one click \u2014 but the spreadsheet version is worth having for scenarios.<\/span><\/p>\n

\u2b07 Download the free CD Calculator Excel template<\/a><\/p>\n

Level 1: The Basic CD Calculator (One Formula)<\/b><\/h2>\n

Set up three input cells and two formulas:<\/span><\/p>\n\n\n\n\n\n\n\n\n\n
Cell<\/span><\/th>\nContents<\/span><\/th>\nExample<\/span><\/th>\n<\/tr>\n<\/thead>\n
B1<\/span><\/td>\nDeposit<\/span><\/td>\n10000<\/span><\/td>\n<\/tr>\n
B2<\/span><\/td>\nAPY (format as %)<\/span><\/td>\n4.50%<\/span><\/td>\n<\/tr>\n
B3<\/span><\/td>\nTerm in years<\/span><\/td>\n3<\/span><\/td>\n<\/tr>\n
B5<\/span><\/td>\n=B1*(1+B2)^B3<\/span><\/td>\n\u2192 $11,412 (maturity value)<\/span><\/td>\n<\/tr>\n
B6<\/span><\/td>\n=B5-B1<\/span><\/td>\n\u2192 $1,412 (interest earned)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Why this works with any compounding: banks quote APY with compounding already included, so the simple exponent gives the exact answer. For months instead of years, use =B1*(1+B2)^(B3\/12) with the term in months.<\/span><\/p>\n

Level 2: Excel’s Built-In FV Function<\/b><\/h2>\n

\"Building<\/p>\n

Excel’s future-value function does the same job with a standard signature:<\/span><\/p>\n

=FV(B2, B3, 0, -B1)<\/span><\/p>\n

The arguments are rate, periods, payment (0 \u2014 CDs take no monthly deposits), and present value (your deposit, entered negative because it’s money leaving your pocket). The result matches Level 1 to the cent. Use whichever reads better to you; FV becomes more useful when you graduate to products that <\/span>do<\/span><\/i> take monthly contributions, like the scenarios in our <\/span>compound interest calculator<\/span><\/a>.<\/span><\/p>\n

Level 3: A CD Ladder Tracker<\/b><\/h2>\n

The spreadsheet’s real superpower is tracking several CDs at once. Set up columns:<\/span><\/p>\n\n\n\n\n\n
A: Bank<\/span><\/th>\nB: Deposit<\/span><\/th>\nC: APY<\/span><\/th>\nD: Opened<\/span><\/th>\nE: Term (mo)<\/span><\/th>\nF: Matures<\/span><\/th>\nG: Value at Maturity<\/span><\/th>\n<\/tr>\n<\/thead>\n
Bank A<\/span><\/td>\n4000<\/span><\/td>\n4.50%<\/span><\/td>\n1\/15\/2026<\/span><\/td>\n12<\/span><\/td>\n=EDATE(D2,E2)<\/span><\/td>\n=B2*(1+C2)^(E2\/12)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Two formulas do the work: EDATE adds months to the open date to compute the exact maturity date, and the growth formula projects each rung’s value. Add a row per CD, and conditional formatting on column F (highlight dates within 30 days) gives you an automatic maturity-alarm dashboard \u2014 the exact discipline our <\/span>CD ladder guide<\/span><\/a> recommends.<\/span><\/p>\n

Useful Extras<\/b><\/h2>\n