TOOLS · RENTAL SCREEN
Furnished-Monthly Deal Screen
Model the year-one cash math for a furnished monthly rental in Medellín. Replace the starting rent and occupied-month assumptions with figures for the actual unit. Extended projections stay inside Pro.
Ranges are market reference, recalibrated June 2026 from real project cost data, not quotes. First budgets drift: structure surprises and carpentry routinely push real projects 30 to 50% over. Get multiple bids and a written scope before you budget.
The rent figures are rounded, modeled starting cases from FlipMedellín’s public Rental Signal, not quoted rent or a guarantee for this unit. Occupied months are planning inputs, not observed occupancy. Replace both.
What La Lonja recorded for your zone. Not a forecast for this listing.
La Lonja’s 265 Edition reported Zona 5 (Poblado, Envigado, Sabaneta) apartment valorization at 7.82% in 2024. The 2025 land study (published April 2026) recorded 7.5% real for Envigado municipality, consistent with a sustained mid-single-digit-to-high pace.
Lonja groups Poblado, Envigado, and Sabaneta as Zona 5 (sub-market variance is real). Figures are nominal COP; real appreciation in high-inflation years (~13% in 2022, ~5% in 2024) is lower.
Appreciation figures: La Lonja de Propiedad Raíz de Medellín y Antioquia (2024 zone-level apartment index, 2025 land study). Context from Camacol Antioquia (trade group) and DANE / Banco de la República. We show the range. We do not predict which one happens.
This 6.9% result still uses the editable starting rent and occupied-month case. Replace both before comparing the property.
Modeled yield on cost = first-year modeled operating income before maintenance divided by total cash invested: purchase plus renovation plus closing costs. The cap rate beside it uses the same modeled income over purchase price only.
⚠ This year-one model deducts the management and leasing reserves you set, plus HOA and predial. It does not deduct maintenance, utilities, insurance, financing, vacancy beyond your occupied-month input, or sale costs. It is a comparison tool, not an investment grade or forecast.
A useful year-one screen, or a model that holds up over time?
Year one is the first pass. Pro carries the same assumptions through exit: annual modeled cash flow, modeled IRR, and projected sale value.
The extended model unlocks:
- ●Annual modeled cash flow. Every year to exit using the stated cost assumptions.
- ●Modeled peso IRR. One comparable output for this assumption set, not a guarantee or a full-cost return.
- ●Projected exit value. Final-year modeled operating income divided by your exit-yield assumption.
- ●Modeled cash outcome. Purchase to sale in COP, before the excluded costs listed below.
- ●Key assumptions are editable. Adjust appreciation, rent growth, and hold period. Excluded costs remain listed below.
On a $236K purchase, pressure-testing the assumptions is worth more than the price of this tool.
Unlock extended model →