Off-Plan Property ROI Spreadsheet for Itajaí 2026
In June 2026, with Brazil's Selic policy rate still in double digits and the CDI interbank benchmark yielding close to 10.5% a year net of short-term inflation, buying an off-plan apartment on the Brazilian coast has stopped being an emotional decision and turned into a discounted-cash-flow problem. The launch price per square meter in Balneário Camboriú remains among the three highest in the country according to the FipeZap index, and Itajaí — the booming port city next door — has pushed into the BRL 12,000 to BRL 14,000 range per usable square meter at beachfront addresses. Those numbers look unbeatable until someone opens a spreadsheet and discovers that without the INCC construction-cost index correctly embedded in the installments, and without capital-gains tax discounted on the resale, the internal rate of return falls below what a plain Brazilian government bond pays with zero operational risk.
That gap is exactly what separates the amateur investor from the professional: not market "feel," but the spreadsheet each one has built for themselves. Online calculators answer the wrong questions. Sales-stand presentations show nominal appreciation with no deflator. Anyone deploying upwards of BRL 500,000 — roughly USD 90,000 to 100,000 at mid-2026 exchange rates — knows the only reliable tool is a hand-modeled Excel workbook. This article dissects the template now circulating among family offices and wealth managers who treat the northern coast of Santa Catarina as a distinct asset class.
Why online calculators fail in a high-rate cycle
The trouble with off-the-shelf calculators starts at the input layer. Almost all of them ask three things — sticker price, down payment, term — and return an "expected appreciation" that is, at heart, a moving average of some national index. That approach ignores at least five distortions which can flip the sign of the investment.
The first is the INCC-M, Brazil's national construction-cost index. Every installment paid during the construction phase is indexed to the INCC, which has historically run between 6% and 8% a year and has crossed 10% in cycles of input-price pressure. A calculator that assumes fixed installments understates the real cash outlay by double-digit percentages over a 36-month build. The second distortion is the treatment of balloon payments: the key-handover payment, semi-annual booster installments, and the post-completion reinforcement are not linear outflows and dramatically reshape the capital-tied-up schedule. The third is the 15% capital-gains tax that Brazilian law levies on resale profit — with a narrow exemption for properties sold for under BRL 35,000 a month and a reinvestment exemption (Law 11.196) that requires rolling the proceeds into another residential property within 180 days.
The fourth is the confusion between nominal and real appreciation. A property that climbs 8% in twelve months while IPCA inflation registers 4.5% delivered a real gain of just 3.3% — and that real number is what should be compared to the CDI net of taxes, not the headline figure. The fifth is the cost of trapped capital: every real locked into an installment could have been earning Selic in Tesouro Selic, the floating-rate Brazilian Treasury bond. That opportunity cost is the true measuring stick. Online calculators capture none of the five. A real spreadsheet does.
In a neutral-rate cycle this would be a side detail. With Brazil's real interest rate hovering near 6% and the CDI competing head-to-head with quality real-estate assets, the measurement error becomes the result itself. The buyer who walks into the showroom believing he is purchasing 12% annual appreciation is frequently, after everything is netted out, simply purchasing expensive fixed income with construction risk attached.
The six mandatory tabs of the professional template
The model passed around by Brazilian wealth managers has six tabs — never more — because each one answers a distinct class of question. Mixing everything into a single table is the most common rookie mistake.
Tab 1 — Assumptions. The only tab where numbers are typed in. Everything else is a formula referencing this sheet. It holds the sticker price, down-payment percentage, the number and value of monthly installments, intermediate balloons, construction term, projected INCC (use the median of the Focus central-bank survey for construction), projected IPCA inflation, projected Selic, the applicable income-tax bracket, the municipal ITBI transfer tax (Itajaí charges around 2% of the higher of sale price or assessed value), brokerage on resale (5% to 6%), estimated condominium fee and IPTU (the annual municipal property tax). Change a number here and the whole model recalculates — that is what enables proper sensitivity analysis.
Tab 2 — Monthly cash flow with INCC. Column A: month 0 through payoff. Column B: base installment. Column C: cumulative INCC factor up to that month. Column D: corrected installment (B × C). Column E: balloon, if any. Column F: total outflow. Column G: indexed outstanding balance. This is the tab where the real cash outlay surfaces — almost always 8% to 15% above what the brochure showed.
Tab 3 — Segmented appreciation. Rather than assuming a single annual rate, the curve is split into three windows: from launch to 50% complete (where the pre-launch discount dissolves), from 50% to the occupancy certificate or habite-se (where the construction-progress premium materializes), and post-keys (where the asset starts competing with finished resale stock in the same neighborhood). Each window gets its own assumption, ideally calibrated against FipeZap series for the specific district.
Tab 4 — Exit scenarios. Three parallel scenarios: sale at handover, long-term residential rental, and short-term vacation rental with seasonality. Each scenario carries its own revenue stream, expected occupancy, management fee, operating expenses, and terminal disposal. Letting the asset speak for itself in each use is the only way to choose intelligently.
Tab 5 — Forgotten costs. ITBI plus deed plus registry fees (roughly 1% combined on top of the transfer tax), capital-gains tax on resale, IRPF income tax on rental via the monthly carnê-leão self-assessment, advisory fees, the potentially severe distrato (cancellation) penalty under Law 13.786, condominium and IPTU for the months between keys and resale, and furniture if the strategy is short-term rental. This tab alone usually shaves 150 to 300 basis points off the IRR.
Tab 6 — CDI benchmark. Build the alternative investment: the same cash outlay, on the same calendar, deployed into Tesouro Selic or a mid-tier bank CDB at 100% of CDI, net of the regressive Brazilian withholding-tax table. At the end of the horizon, compare terminal wealth against the real-estate scenario. This is the sanity check most amateurs skip — and the one that most often kills a sales pitch.
The formulas that matter — and a worked example of BRL 800,000 in Itajaí
Four functions solve 90% of the problem. XIRR (internal rate of return with irregular dates) and XNPV (net present value with irregular dates) are preferable to the standard IRR and NPV because an off-plan cash flow has monthly installments, semi-annual balloons, and a terminal sale — dates that don't fit a fixed period. Cap Rate (annual net operating income divided by market value) validates the rental scenario. And the formula for real appreciation — compounded nominal divided by compounded inflation, minus one — is the only one that allows an honest comparison against fixed income.
Consider the base case: an BRL 800,000 apartment in Itajaí, launched two blocks from Praia Brava beach, with a 36-month construction term. The down payment is 30% (BRL 240,000) split into signing and month 6. The balance is paid in 36 monthly installments of BRL 11,111, plus three intermediate balloons of BRL 30,000 (months 12, 24, and 30), everything indexed to a projected INCC-M of 6.5% a year. Assume nominal appreciation of 9% a year during construction and 5% a year for the two years that follow. IPCA inflation is projected at 4.2% a year. Exit strategy: sale 24 months after the occupancy certificate.
Once modeled in the workbook, the total nominal outlay (down payment + indexed installments + balloons + ITBI + deed + brokerage on resale + capital-gains tax) climbs to roughly BRL 1.02 million. The projected resale value lands around BRL 1.28 million nominal. The XIRR of the complete cash flow, using actual dates, comes in near 11.4% a year. The CDI on the same horizon, deployed against the same payment calendar, returns approximately 10.1% a year net. The risk premium of the property over fixed income is therefore around 130 basis points. In real terms, stripping out projected IPCA, the property delivers about 6.9% a year — against roughly 5.7% real on the CDI. There is a gain, but it is smaller than the sales pitch suggests and it requires the buyer to accept construction risk, liquidity risk, and regional market risk.
| Item | Value / Assumption | Impact on IRR |
|---|---|---|
| Sticker price | BRL 800,000 | Base |
| Down payment (30%) | BRL 240,000 | — |
| 36 installments indexed to INCC-M (6.5% p.a.) | BRL 11,111 base | Cuts IRR by ~180 bps vs uncorrected case |
| Semi-annual balloons | 3 × BRL 30,000 | Concentrates outflows, cuts IRR by ~60 bps |
| Weighted nominal appreciation | ~7.5% p.a. | Main driver |
| Projected IPCA inflation | 4.2% p.a. | Defines real appreciation |
| ITBI Itajaí + deed + registry | ~3% of value | Cuts IRR by ~50 bps |
| Capital-gains tax (15%) | On net profit | Cuts IRR by ~120 bps |
| Final XIRR | ~11.4% p.a. | Result |
| CDI over same calendar | ~10.1% p.a. net | Benchmark |
| Premium over fixed income | ~130 bps | Compensation for risk |
The exercise is uncomfortable because it asks a blunt question: do 130 basis points of premium justify the construction risk, the cancellation risk, the resale liquidity risk, and the regional market cycle? For some investors the answer is yes — particularly when the asset enters a portfolio as patrimonial diversification rather than as a pure absolute-return bet, and when the buyer values exposure to BRL-denominated hard assets against currency volatility. For others, the answer is no. The spreadsheet does not resolve the philosophical question; it merely forbids the question from being answered without information.
Regional data 2026 — Itajaí, Balneário Camboriú, and the northern-coast cycle
Modeling the base case without anchoring to regional numbers is fantasy. The 9%-a-year appreciation assumption does not appear out of thin air — it is only defensible if it is calibrated against a historical series for the specific neighborhood, tipology, and cycle. In practice the professional investor cross-references four sources: FipeZap for advertised price per square meter in Itajaí and Balneário Camboriú, the ABRAINC/CBIC joint reports for sales velocity and inventory (the VSO indicator and months-of-stock), the CUB-SC published by Sinduscon-SC (the regional builders' union) to validate the ratio of sales price to construction cost, and Secovi-SC for rental prices and absorption in the secondary market.
The 2026 picture across northern Santa Catarina shows a coast still in a heavy-supply cycle, with Itajaí launches clustered in Cabeçudas, Brilhante, Fazenda, and the Centro-Atalaia strip, and Balneário Camboriú launches still dominated by the beach front and Barra Sul. The launch price per square meter in Balneário hovers above BRL 18,000 in high-end beachfront towers, while Itajaí delivers comparable-tier launches in the BRL 12,000 to BRL 14,000 range — a gap that historically narrows as Itajaí matures from a port city into a full residential destination. That gap-closing thesis is exactly what sustains the appreciation assumptions on tab 3.
Vacation-rental seasonality is the other regional variable that demands hard anchoring. Daily rates between December and February can reach BRL 1,500 to BRL 3,000 — roughly USD 270 to USD 540 — for well-located two- and three-bedroom apartments, but the average annual occupancy across the northern Santa Catarina coast historically runs between 35% and 50%, depending on product and management. An investor who models the short-term-rental scenario at 70% occupancy is building a crooked spreadsheet — and the number that comes out of it has zero analytical value.
"The difference between the investor who makes money on a launch and the one who loses it is almost always in the quality of the assumptions, not in the luck of the building. The one who walks in with a calibrated spreadsheet spots the mistake before signing; the one who walks in with an online calculator spots it only after the keys are in his hand."
The five mistakes that destroy IRR — and how to harden the spreadsheet
Auditing dozens of workbooks circulating among coastal investors, five errors repeat with enough frequency to qualify as doctrine. The first is forgetting INCC on the installments. In a 36-month build with INCC running at 6.5% a year, the present value of the real outlay is roughly 8% higher than the nominal contract suggests. A spreadsheet missing that column delivers an IRR overstated by 150 to 200 basis points — a number that fits entirely within the premium over the CDI.
The second is applying linear appreciation. An off-plan apartment does not appreciate on a straight line; it has three distinct phases — the initial pre-launch discount that dissolves in the first 18 months, the real gain during construction driven by the scarcity of finished product, and the post-handover regime in which the asset competes with resale stock. Treating it all as 9% a year hides risk and exaggerates return. Splitting into three windows, as tab 3 does, is the minimum correction.
The third is ignoring tax. Capital gains pay 15% in Brazil (with progressive scaling above BRL 5 million). Rental income pays the regular IRPF income-tax brackets through the carnê-leão monthly self-assessment. Short-term vacation rentals fall under a different regime depending on the business-activity registration. A spreadsheet that compares gross real-estate IRR with net CDI is comparing apples to oranges, always tilting the verdict toward the property.
The fourth is failing to model the cancellation scenario. Brazil's Law 13.786 of 2018 sharply limited what the developer can retain in case the buyer walks away — up to 25% of what has been paid, or up to 50% under the patrimonial-affectation regime. That is a downside scenario, but the workbook still needs to carry it in the risk analysis, particularly for buyers whose personal cash flow may tighten during the construction phase. Knowing the exit cost before signing is part of the decision.
The fifth is comparing gross with gross. A mid-tier-bank CDB pays, say, 110% of CDI gross, which becomes roughly 88% of CDI net after the regressive withholding-tax table. Property pays 15% on the gain. Comparing the property's nominal appreciation with the gross CDI is an honest distortion — and a typical one. Tab 6 is only meaningful if both sides are converted to the same regime: net of taxes, net of transaction costs, over the same payment calendar.
How to validate the template before trusting it
Every financial spreadsheet must pass a sanity test before it becomes a decision tool. The simplest method — and the most ignored — is to run the model against a closed historical case. Take a 2019 or 2020 launch that has already been delivered, already been resold by an acquaintance, or has a public record of launch and post-completion price. Feed the spreadsheet the assumptions that were available at the launch date (realized INCC, realized Selic, realized IPCA) and compare the model's projected IRR against the actual outcome.
If the absolute IRR error stays under 100 basis points, the spreadsheet is calibrated. If it lands between 100 and 300 basis points, there is a structural assumption out of place — usually the appreciation curve or the treatment of transaction costs. Above 300 basis points, the model is broken and should not drive any real decision.
This back-testing exercise is what separates a spreadsheet from a banner. A workbook calibrated against two or three historical cases in the same neighborhood and tipology becomes a reliable instrument. A "theoretical" workbook — no matter how elegant its formulas — remains a bet dressed up as arithmetic.
Note that the template does not have to be unique. Investors who track the northern Santa Catarina coast regularly tend to maintain two or three workbooks calibrated by tipology — two-bedroom apartments for short-term rental, three-bedroom apartments for long-term residential, high-end penthouses — because the appreciation curves and income behaviors are structurally different. Forcing a single workbook to cover every class makes the model generalize where it loses precision.
What to watch from here
Three variables should dominate the investor's spreadsheet over the next 18 months. The first is the trajectory of the Selic policy rate. If Brazil's Copom monetary-policy committee ends the cutting cycle in restrictive territory (above 9.5%), the CDI will remain competitive and the property premium over fixed income will stay tight. Every 100 basis points of Selic move roughly 80 basis points on the comparative IRR.
The second is INCC. Input-price shocks — steel, copper, structural glass — can push the index higher and reshape the real payment schedule. A conservative assumption today is to work with INCC between 6.5% and 8% a year for the next 24 months, with a stress scenario at double digits.
The third is sales velocity on the northern coast. Absorption remains healthy, but finished inventory in Balneário Camboriú is starting to appear in volumes that deserve attention. The buyer who plans to exit at handover needs to model the possibility of primary-market product competing against his resale at the very moment of sale. That depresses the exit price and stretches the time to sell — both of which hit XIRR directly.
Currency is the fourth variable for the international investor specifically. The BRL/USD exchange rate at the moment of buying determines the dollar cost of the down payment; the rate at the moment of selling determines the dollar return. A buyer hedged through BRL-denominated assets locked at favorable rates can capture a meaningful uplift; a buyer who funds in USD and exits in USD lives with the currency cycle as an additional layer of risk that the spreadsheet must model explicitly.
Conclusion
The rentability spreadsheet is not a luxury for professional managers; it is the technical floor for any commitment above half a million reais. In a high-Selic cycle, measurement error becomes the result itself — and ready-made calculators are systematically wrong on at least five fronts that matter. Building the template across six tabs, calibrating against regional series from FipeZap, ABRAINC, and CUB-SC, and validating against a closed historical case is what turns intuition into thesis.
On the northern coast of Santa Catarina, where SIDE Empreendimentos operates with products positioned on the Itajaí-to-Balneário gap-closing thesis, this analytical rigor is especially welcome: the buyer who arrives with a calibrated spreadsheet asks sharper questions and closes firmer decisions. International investors evaluating Brazilian coastal real estate as a portfolio diversifier should layer in the currency dimension on top of the local mechanics — and treat the workbook as the entry ticket to a serious conversation, not the conversation itself. To follow technical analyses of the Santa Catarina real-estate cycle with the same quantitative depth as this article, the portal's newsletter is the recommended next step.