What rate should I use for a Colombian personal loan?

Colombian banks quote the tasa efectiva anual (E.A.) for a crédito de libre inversión, typically between roughly 18% and 35% E.A. depending on your profile. Enter the rate your lender quotes; the calculator converts it to an equivalent monthly rate for the amortisation.

Why convert the annual rate to a monthly rate?

An effective annual rate already compounds over the year, so you cannot simply divide it by 12. The correct monthly rate is (1 + annual)^(1/12) − 1, which preserves the effective annual cost. Using a plain division would understate the true monthly interest.

What is the tasa de usura?

The tasa de usura is the maximum legal interest rate for consumer credit, certified each month by the Superintendencia Financiera (SFC) at 1.5 times the current rate. A loan priced above it is usurious and illegal. The calculator flags when your entered rate exceeds the ceiling you set.

How is the monthly payment calculated?

The tool uses the standard amortising-loan formula: payment = P × r ÷ (1 − (1 + r)^−n), where P is the principal, r is the monthly rate and n is the number of months. Each payment is the same; early payments are mostly interest and later ones mostly principal.

Does this include fees or insurance?

No. It models pure principal-and-interest repayments. Colombian loans often add charges such as seguro de vida deudores, comisiones, and the 4x1000 financial-transaction tax, which raise the true cost. Ask your lender for the tasa total and CAT for the all-in figure.

Colombia Personal Loan Calculator

Email me this result

Get this tool's output sent to your inbox, plus one useful tool a week. No spam, unsubscribe any time.

A Colombia personal loan calculator for a crédito de libre inversión. It converts the lender’s tasa efectiva anual into the correct monthly rate, computes a fixed monthly repayment, totals the interest you will pay, and builds a full amortisation schedule — all in pesos. It also flags when a quoted rate breaches the tasa de usura ceiling.

How it works

Colombian lenders quote an effective annual rate (E.A.), which already compounds over the year. Because the rate compounds, you cannot divide by 12 — the true monthly rate is:

monthly rate r = (1 + annualEA)^(1/12) − 1

The fixed monthly payment then comes from the standard amortising-loan formula:

payment = P × r / (1 − (1 + r)^(−n))

where P is the principal and n the number of months. Each month, interest is charged on the outstanding balance and the rest of the payment reduces the principal, so early payments are mostly interest and later ones mostly principal.

The tasa de usura, certified monthly by the Superintendencia Financiera at 1.5× the current rate, is the legal ceiling for consumer credit. If your entered rate exceeds the ceiling you set, the tool warns you.

Example and notes

Borrow COP 10,000,000 over 36 months at 24% E.A. The monthly rate is (1.24)^(1/12) − 1 ≈ 1.81%, giving a payment of roughly COP 370,000 and total interest near COP 3.3m. Lower the rate or shorten the term to cut total interest. The figure excludes seguros, comisiones and the 4x1000 tax, so ask the lender for the all-in CAT before signing.