Skip to content
Camilo TiradoFixed income · Colombia
Español

Home › Calculators › CDT simulator

Free calculator

CDT simulator

How much you receive at maturity, how much is withheld and whether you really beat inflation. A CDT is a Colombian certificate of deposit; today the average 360-day CDT pays 12.02% E.A.

If your bank quotes a nominal rate, convert it with the rate converter.
90, 180, 365, 540…
Latest DANE figure; change it to the inflation you expect over the CDT’s term.
You receive at maturity—
Interest before taxes—
Withholding tax (4%)—
Net interest—
Net return—
Real return (after inflation)—

How it is calculated

Most Colombian CDTs are quoted as an effective annual rate. If the CDT pays everything at maturity, the interest is:

interest = amount × ((1 + E.A.)days/365 − 1)

The bank withholds 4% of that interest as withholding tax (retención en la fuente), an advance payment on your income tax. Finally the net return is compared with inflation: if inflation is higher, you earn pesos but lose purchasing power.

real return = (1 + net return) ÷ (1 + inflation) − 1

What this simulator does not include

  • CDTs that pay interest every month or quarter: if you spend the interest instead of reinvesting it, you earn slightly less than shown here.
  • The 4-per-thousand financial transactions tax when you withdraw the money, if your account is not marked as exempt.
  • What you finally pay on your income tax return: withholding is an advance, and part of the returns (the inflationary component) is not treated as taxable income. We explain it in taxes on a CDT in Colombia. Tax rules apply to individuals resident in Colombia.
CDTs are covered by Fogafín’s deposit insurance up to COP 50,000,000 per person and per institution. Collective investment funds, TES and bonds do not have that insurance.
In the course

Comparison sheet, real return and taxes, step by step

In Level 1 you compare CDTs, TES, bonds and funds in the same table, measure how much you really beat inflation by and work out what is left after taxes. Launch price with the coupon LANZAMIENTO20, already applied in the button, until November 8.

Related: How much a CDT really pays · CDT or collective investment fund? · Rates today