Colombia Prestamo Hipotecario & Mi Casa Ya Calculator
Simulate your monthly mortgage installments in Colombia: compare subsidized social housing programs (Mi Casa Ya down payment grants and FRECH interest relief) against commercial non-VIS bank loans, insurance, and 30% - 40% DTI limits.
Monthly Mortgage Installment Breakdown
Statutory Framework: Housing Finance in Colombia (Ley 546)
Under Colombia's housing law (Ley 546 de 1999) and government decree guidelines:
Mi Casa Ya & FRECH Subsidies
- VIS Threshold: 135 to 150 SMLMV (~$191M to $213M COP).
- Cuota Inicial Subsidy: 30 SMLMV (~$42.6M COP) for Sisben groups A1-C8, or 20 SMLMV (~$28.4M COP) for C9-D20.
- FRECH Coverage: The Ministry of Housing covers 4.0% to 5.0% of the loan interest rate for the first 7 years (84 months).
Debt-to-Income (DTI) Ratios
- VIS Housing: The monthly installment cannot exceed 40% of verifiable family income.
- Non-VIS Housing: The monthly installment cannot exceed 30% of verifiable family income.
Colombia Prestamo Hipotecario & Mi Casa Ya Calculator: Technical Scope, Deductions & Methodology
Under Colombia's housing law ( Ley 546 de 1999 ) and government decree guidelines: Built strictly in alignment with official technical specifications, this engine decomposes input parameters into transparent line-item deductions and auditable intermediate components.
Calculation Methodology, Edge Cases & Verification
Input modeling incorporates Property Value (Valor Comercial del Inmueble en COP), Financing Program (Línea de Credito), Down Payment Required (Cuota Inicial %), Sisben IV Classification (Subsidio Mi Casa Ya), Amortization Term (Plazo en Anos) so baseline assumptions match real-world filing or workload records. Selectable classifications (Vivienda VIS + Mi Casa Ya & Cobertura FRECH (Interest Subsidy ~4%); Vivienda VIS Standard (Bank Commercial Rate without FRECH); Vivienda No VIS (Medium / High Range - Bancolombia, Davivienda, BBVA); Custom Interest Rate & Terms) automatically switch underlying statutory brackets, caps, or divisor multipliers without manual lookup. Intermediate breakdown figures preserve visibility into effective marginal impact versus final net totals.
Edge-case handling covers zero-income thresholds, partial-period pro-rata scaling, statutory deduction caps, and ceiling limits prescribed under the applicable governing standard. Denominated figures remain calibrated in USD. When cross-checking official payroll vouchers or tax assessments, verify whether local exemptions, medical allowances, or municipal surcharges override base default schedules.
❓ Preguntas Frecuentes (FAQ) • Normativa Laboral y Tributaria de Colombia
Engr. Muhammad Shahzad
Auditor Certificado de Sistemas & Cumplimiento TributarioArquitecto principal de sistemas de software y especialista en normativa laboral colombiana (CST, Ley 50, Ley 2101) y tributaria DIAN. Diseñador de modelos matemáticos de alta precisión sin telemetría.