The calculator lets you set the down payment as a percentage of the purchase price or as a fixed COP amount — the two stay in sync. For new construction, that down payment is typically split into monthly installments paid during construction, while the mortgage itself only starts disbursing once the property is delivered.

New construction usually spreads the down payment over several months during the build, and the loan term doesn't start until delivery. Used properties are financed immediately: the down payment is paid upfront and the mortgage starts amortizing right away. The calculator models both schedules.

The calculator totals notary fees, registration tax, and the GMF financial transaction tax (4x1000), plus the recurring annual property tax (predial) and monthly admin fee (cuota de administración). Each rate is editable so you can match your specific transaction.

Cap rate is the year-1 annual rent divided by the purchase price — it ignores financing entirely, treating the property as a pure asset. Cash-on-cash return divides your net rental cash flow (after mortgage payment, predial and admin fee) by the actual cash you put in (down payment + closing costs), so it reflects your real leveraged return.

Rates are pulled from a manually curated list of Colombian bank reference rates, pre-filled when you pick a bank and fully editable afterward. They're estimates, not live offers — always confirm final terms with your lender.