CDT Calculator — Net Return at Maturity

Easily estimate your CDT returns with our reliable Bancolombia CDT simulator tailored for Colombia’s market.

  • Instant result
  • No sign-up
  • Visible assumptions
  • Deterministic calculation

In 30 seconds: Accurately calculate your CDT investment growth and maximize your returns with ease. Deterministic calculation with auditable formulas. The result is indicative — adjust the assumptions to reflect your real operation.

Methodology

Capitalization factor = (1 + EAR / 100)^(days / 365)

Final gross amount = Capital × factor

Gross interest = Final gross − Capital

Withholding = Gross interest × (withholding % / 100)

Net interest = Gross interest − Withholding

Final net amount = Capital + Net interest

Annualized net return = ((Final net / Capital)^(365 / days) − 1) × 100

Variables

Capital
Amount deposited at CDT opening (in local currency).
Term in days
CDT duration. Common terms: 30, 60, 90, 180, 360, 540 days.
Effective Annual Rate (EAR)
Annualized rate published by the bank — distinct from nominal or monthly.
Withholding tax
% bank withholds on interest. Default 4% Colombia (DIAN art 379 ET).

Practical example

Capital $5,000,000 COP, 180 days at 11% EAR (Bancolombia).

Factor: (1 + 0.11)^(180/365) = 1.0521.

Final gross: 5,000,000 × 1.0521 = $5,260,750 COP.

Gross interest $260,750. Withholding 4%: $10,430.

Net interest: $250,320. Final net: $5,250,320.

Period return: 5.01% / annualized net ~10.3%.

Interpretation

CDTs are fixed-income — the bank guarantees the rate over the entire term regardless of market moves.

4% withholding applies only in Colombia. Other countries: adjust manually. Pension/exempt accounts: 0%.

Breaking a CDT before maturity usually penalizes with ~0% rate over elapsed days.

Compare net EAR vs expected inflation: 11% EAR with 8% inflation = real ~3% return.

Assumptions and limitations

  • Effective annual capitalization scaled to days. Some banks publish monthly capitalization.
  • Excludes opening fees. Most banks don't charge for retail CDTs.
  • Excludes auto-renewal. If you renew, the cycle resets with the rate at that moment.
  • Withholding assumes Colombia (4%); edit for other jurisdictions.

When to use this calculator

  • To compare offers from Bancolombia, Davivienda, BBVA, Itaú and digital banks.

  • To decide between CDT, mutual fund, or savings account.

  • To calculate how much to invest today to reach a target final amount.

  • To validate what the bank credits at maturity — demand a breakdown if it differs.

  • To compare different terms: 360d at 11% vs 90d at 9% × 4 renewals.

Common mistakes

  • Confusing EAR with nominal or monthly rate. EAR 11% is NOT 11/12 = 0.92% monthly.

  • Ignoring withholding. The amount the bank credits is always net post-tax.

  • Taking the published rate without verifying it's still in force at opening.

  • Believing breaking the CDT pays prorated interest.

  • Comparing CDTs of different terms without annualizing the return.

Industry use cases

Individual investor (Colombia)

$10M COP at 180 days at 11% EAR: net interest ≈ $521k COP. Net annualized ~10.7%.

SME cash surplus

$50M COP at 90 days at 9.5% EAR → $1.13M net interest. Liquidity preserved + return captured.

Tax-exempt account (AFC, voluntary pension)

$20M COP at 360 days at 11% EAR with 0% withholding: full $2.2M COP net interest.

CDT vs mutual fund

CDT 180d at 10.5% net ~5%. Fund expected 12% with 1.5% fee → real ~10%. CDT wins on certainty.

Auto-renewal vs active reinvestment

$5M COP auto-renewed 12mo at 9% may leave $80k less than manually reinvesting at each maturity.

Want to go beyond the quick calculation?

Sign up to access advanced simulators with multiple scenarios, data export, and detailed projections.

No spam. Just early access to the fixed-term deposit calculator simulator.

Financial disclaimerIndicative result — not professional financial advice. Consult a specialist before making investment or credit decisions.

View methodology

Complete guide

CDT Calculator: Gross Interest, Withholding Tax, Net Return, and Final Balance

A CDT (Certificado de Depósito a Término — fixed-term certificate of deposit) is Colombia’s most widely used bank savings instrument for capital preservation with predictable returns. You commit a fixed amount for a defined period, and the bank pays a fixed nominal interest rate. At maturity you receive principal plus net interest, after the bank automatically withholds 4% retención en la fuente (withholding tax on financial income, under DIAN Estatuto Tributario Art. 395).

This guide covers the exact calculation formulas, how Colombian rate conventions work, the 2026 rate environment, and how to compare CDTs across banks and digital platforms.

How CDT Interest Is Calculated

Colombian banks quote CDT rates in two ways:

EA (Efectiva Anual — Effective Annual Rate): The rate already incorporates compounding. Interest for any period is calculated directly:

Gross Interest = Principal × [(1 + EA)^(days/365) − 1]

NMV (Nominal Mensual Vencida — Nominal Monthly Rate, payable at end of month): A monthly nominal rate that must be converted before use. To find the EA equivalent: EA = (1 + NMV/12)^12 − 1

Once you have the gross interest using either convention, the net interest is:

Net Interest = Gross Interest × (1 − 0.04)

The bank retains 4% of gross interest and issues a certificate (certificado de retención) that you use in your annual Declaración de Renta as a tax credit.

Final balance at maturity = Principal + Net Interest

Worked Example: COP 50,000,000 / 12 Months / 13.5% EA

VariableValue
PrincipalCOP 50,000,000
Term365 days (12 months)
Rate13.5% EA
Gross interestCOP 50,000,000 × [(1.135)^1 − 1] = COP 6,750,000
Withholding tax (4%)COP 6,750,000 × 0.04 = COP 270,000
Net interestCOP 6,750,000 − COP 270,000 = COP 6,480,000
Final balance at maturityCOP 56,480,000
Effective net yieldCOP 6,480,000 ÷ COP 50,000,000 = 12.96% net EA

The effective net yield after withholding is 12.96% — which you can compare directly against alternatives (TES bonds, savings accounts, equity mutual funds).

The Colombian Rate Environment in 2026

The Banco de la República (BanRep) set its policy rate at a 23-year high of 13.25% in 2023 to combat inflation that peaked at 13.1%. By Q1 2026, the policy rate had declined to approximately 9.25% as inflation normalized toward the 3% target. CDT rates track the policy rate with a lag of 1–2 months.

Typical 2026 CDT rates for 90-day deposits:

  • Traditional banks (Bancolombia, Davivienda, Banco de Bogotá): 10.5%–12.0% EA
  • Cooperative/solidarity sector (Financoop, Cotelco): 11.0%–12.5% EA
  • Digital/fintech banks (Nequi CDT, Lulo Bank): 12.0%–13.5% EA

Rates for 180-day and 12-month CDTs are typically 0.5%–1.5 pp higher than 90-day rates, reflecting the additional liquidity commitment.

4×1000 Tax (GMF) — What It Is and Whether It Applies

The Gravamen a los Movimientos Financieros (GMF) — colloquially called the 4×1000 — is a 0.4% transaction tax on financial debits. It applies when money moves between bank accounts. For CDTs specifically:

  • Investment deposit (wire/transfer): 0.4% of the invested amount if coming from a taxable account. If your savings account is the exempted primary current account (exenta via Article 879), GMF does not apply.
  • Maturity payment: 0.4% of the maturity balance if paid to a non-exempt account.

Many investors open their CDT directly at the same bank as their primary current account and keep both exempt to avoid the GMF. Verify your account’s exempt status with the bank before investing.

Provider Comparison: Banks, Cooperatives, and Fintech

Provider typeExample institutionsRate advantageFogafín coverageLiquidity
Large banksBancolombia, Davivienda, Banco de BogotáModerate (10.5%–12%)Yes, up to COP 50MNone until maturity
Regional banksBanco Agrario, GNB SudamerisSlightly higherYes, up to COP 50MNone until maturity
Cooperativas / solidariasFinancoop, CotrafaHigher (11%–13%)FOGACOOP, not FogafínNone until maturity
Fintech/digital CDTsNequi, Lulo Bank, RappiPayHighest (12%–14%)Yes (via partner bank)None until maturity

Fogafín (Fondo de Garantías de Instituciones Financieras) insures deposits up to COP 50,000,000 per depositor per entity. If you hold COP 100,000,000 at a single bank, only half is insured — spread across entities to maximize coverage.

Cooperatives are supervised by the Superintendencia de Economía Solidaria (not the Superintendencia Financiera) and covered by FOGACOOP, a separate guarantee fund. Understand the difference before committing large capital to a cooperative-sector CDT.

CDTs vs Alternative Colombian Fixed-Income Instruments

Instrument2026 yield (approx)LiquidityTax treatmentMinimum
CDT 90 days (traditional bank)10.5%–12% EANone until maturity4% withholdingCOP 1,000,000
CDT 12 months (digital bank)12%–14% EANone until maturity4% withholdingCOP 100,000
TES (government bonds, 1-year)~10%–11%Secondary market (variable)4% withholdingCOP 1,000,000 (via broker)
Cuenta de ahorros (savings account)3%–6% EAImmediate4% withholdingNone
Fondos de inversión colectiva9%–12% EA (variable)T+1 or T+34% withholdingCOP 50,000

The CDT’s advantage is its fixed, locked-in rate for the entire term — in a declining-rate environment, locking a 13% EA CDT for 12 months before BanRep’s next rate cut is an explicit choice to preserve a high rate.

Early Withdrawal: What to Expect

CDTs are contractually locked until maturity. Early withdrawal (rescate anticipado) is at the bank’s discretion and typically involves:

  • Full or partial loss of accrued interest (typically 30–50% forfeiture)
  • A minimum lock-in period (usually 30 days) before any early withdrawal is permitted
  • Formal written request process

Some digital platforms advertise "liquidity windows" or secondary market features for their CDTs. Verify the terms in the contract — not the marketing.

How to Use the Simúlalo CDT Calculator

Enter the principal (COP, USD, EUR, or the currency of your CDT), the annual nominal rate as EA, and the term in days. The calculator outputs:

  1. Gross interest — before withholding
  2. Withholding tax amount (4%)
  3. Net interest — what you actually receive
  4. Final balance at maturity
  5. Effective net yield (annualized) for comparison with other instruments

Run the calculator for 90-day, 180-day, and 12-month terms at the same rate to understand the compounding effect of rolling shorter-term CDTs versus committing to a full year.

Tax Planning: How the 4% Withholding Fits into Your Declaración de Renta

The 4% retención en la fuente withheld by the bank at CDT maturity is not a final tax — it is an advance payment on your annual income tax obligation. When you file your Declaración de Renta, the withheld amount appears as a deductible tax credit against your total income tax liability.

For declarantes in the second income bracket (approximately COP 85M–300M annual income), the marginal income tax rate is 28%. The 4% withholding covers only a fraction of the actual tax due on CDT returns — you will owe additional tax at settlement. For low-income investors who are below the declarante threshold, the 4% withholding is the effective final tax cost, and the net yield is as calculated.

The practical implication: high-income investors comparing a CDT (12% EA before 4% withholding = ~11.5% post-withholding but pre-renta) against a tax-exempt investment (such as a primary-residence mortgage interest deduction or a pension fund contribution with tax deduction) must account for the full marginal tax rate, not just the 4% withholding.

From theory to calculation

The calculator on this page runs with your numbers — no forms, no login. Scroll up and try it.

Try the calculator

Frequently asked questions

1What is a Calculadora de CDT?
A Calculadora de CDT is an online tool used to estimate the returns on a Certificate of Time Deposit (CDT) in Colombia. It helps users calculate interest earnings based on investment amount, term, and current rates, simplifying financial planning.
2How does the Simulador CDT Bancolombia work?
The Simulador CDT Bancolombia allows users to input the investment amount, term length, and interest rate to simulate potential earnings. It provides an estimated return, helping users make informed decisions before investing in a CDT with Bancolombia.
3Can I use the Calculadora CDT to compare different terms?
Yes, the Calculadora CDT lets you input various term lengths to compare potential earnings. By adjusting the investment period, you can see how longer or shorter terms affect your final returns, aiding in choosing the best CDT duration for your needs.
4Is the Simulador CDT accurate for current market rates?
Simulador CDT tools generally use up-to-date interest rates offered by banks like Bancolombia. However, rates can vary and are subject to change, so it’s advisable to verify the current rates directly with the bank before making investment decisions.
5How can I calcular CDT returns using the online calculator?
To calcular CDT returns, enter the amount you plan to invest, select the term period, and input the applicable interest rate into the online calculator. The tool will then display the estimated total return, including the principal and interest earned over the period.

Last updated: April 30, 2026 · Reviewed by the Simúlalo editorial team. Figures and benchmarks are indicative; verify with your own data before deciding.

View methodology

How this simulator was reviewed

What you'll see, what it prevents, and where you shouldn't trust it

Every simulator on Simúlalo ships with the same editorial structure: two hypothetical worked examples with numbers, the errors it helps you avoid, the model's declared limitations, and a visible financial disclaimer. The review is signed and dated.

Hypothetical caseCase A

Investor in Colombia placing $10M COP at 180 days and comparing two rates

An investor places $10,000,000 COP in a CDT. Rate A: 11% effective annual at 180 days. Rate B: 10.5% effective annual at 360 days. The calculator shows: Rate A generates approximately $526,820 gross at maturity; Rate B generates $1,050,000 at the 360-day maturity. However, option A allows renewal at the new rate at maturity — useful if rates rise. Decision: the choice depends on rate expectations; to diversify duration, split the amount across two terms.

Illustrative figures. Does not represent a real company or an investment recommendation.

Hypothetical caseCase B

Net return comparison before and after withholding tax

An investor places $5,000,000 COP at 90 days with 10.8% effective annual rate. Gross return at maturity: approximately $135,000. If withholding tax of 7% applies on the return (illustrative rate that varies by regime), net drops to approximately $125,500. Decision: when comparing CDTs, always look at net return after withholding and after taxes per your regime. For specific situations validate with an accountant.

Illustrative figures. Does not represent a real company or an investment recommendation.

Common mistakes it helps you avoid

Things a team or decision-maker might assume that this simulator forces you to verify before committing.

  • Comparing effective annual rate with nominal rate without converting. A 11% nominal can yield 11.5% effective depending on compounding frequency.
  • Forgetting withholding tax. In Colombia, CDT returns are subject to withholding that varies by tax regime and amount.
  • Auto-renewing without comparing rates. Some banks renew at maturity at the prevailing rate, which may be lower than the initial.
  • Using the CDT as emergency liquidity. Early withdrawal penalty or impossibility of withdrawal means a CDT does not substitute a liquid emergency fund.

Model limitations

What the simulator does not do, and where you need a professional or a specialized tool.

  • Does not query real rates from Colombian banks or other jurisdictions. You declare the rate at the start.
  • Does not apply withholdings automatically. For exact net calculation, consult the tax regime applicable to your situation.
  • Does not project inflation. Real return (return − inflation) can be zero or negative if inflation exceeds the rate.
  • Does not replace a bank quote or investment advice. It is a mathematical estimate of gross return.

When NOT to use this simulator

Don't use this calculator as an investment recommendation. Comparing CDTs requires also evaluating issuing entity risk, deposit insurance coverage in your country (Fogafín in Colombia, IPAB in Mexico, FGD in Spain), your liquidity horizon, and your tax regime. For decisions that move significant capital, consult a registered financial advisor in your jurisdiction.

Financial notice

Results are illustrative estimates and do not constitute financial, tax, accounting, or legal advice. Use the results as a reference point and validate important decisions with a certified professional.

Editorial review

Reviewed by the Simúlalo editorial team

This simulator was reviewed by the people listed below before being published. The review covers the declared formula, the model's assumptions, the explicit limitations, and the absence of unsupported financial claims.

They are part of the Simúlalo editorial team, focused on building financial tools that are clear, educational, and easy to interpret.

Last updated: We update this page when the methodology, sources used, or simulator structure change.

This tool uses standard financial formulas and user-supplied data. To explain concepts like rates, credit, risk, or cash flow we consult public and official sources (Banxico, SAT, CONDUSEF, CNBV, Banco de España, IFRS, BIS, among others). Simúlalo is not affiliated with, sponsored by, or endorsed by these institutions.