Portfolio Case Study · Financial Modeling & Strategy

Buyer Decision Model —
Pre-Construction Real Estate

Pre-construction condo sales were stalling despite strong fundamentals. I built a financial model to find out why — and quantified a six-figure perceived disadvantage baked into the buyer's decision.

Independent project Financial modeling Decision framework Real estate strategy Interactive tool

Project at a glance

Key finding

$200k+

Perceived disadvantage

Timeline modeled

3–5 yr

Construction + delay

Tool type

Interactive

Real-time scenario sim

Built from

Scratch

No template used

The problem

A pre-construction residential development was underperforming on conversions. Rising interest rates were the easy explanation — but they didn't account for the inconsistency in buyer behavior or why well-qualified prospects were walking away.

Buyers weren't just comparing units. They were evaluating a multi-year financial commitment against liquid alternatives — stocks, savings, continued renting — while paying for housing the entire time and receiving nothing in return until completion.

That's not a marketing problem. That's a structural value proposition problem that no amount of branding fixes.

My role

I independently identified the gap between the pricing strategy and buyer decision behavior, then designed and built an interactive financial model to quantify it. No template. No off-the-shelf tool. Built from the ground up to simulate real buyer tradeoffs across variable inputs.

Key insight

When you model the true cost of a pre-construction purchase — capital locked for 3–5 years, opportunity cost on the deposit, ongoing housing expenses during the wait, and uncertain appreciation — buyers in certain scenarios face a $200k+ perceived financial disadvantage before they even move in.

That number reframes the entire conversation. The question isn't "why aren't buyers converting?" It's "what would actually make this worth it?"

The tool

Interactive Buyer Decision Model

Adjust price, deposit, timeline, and return assumptions in real time — the model updates instantly to show deal strength and break-even scenarios.

Try it live ↗

Feature breakdown

Scenario inputs

Modeling

Dynamic control over unit price, deposit, incentives, timeline, housing costs, and investment return assumptions — a fast what-if engine for sales and strategy teams.

Wait cost modeling

Analytics

Quantifies the hidden drag buyers feel but rarely articulate: lost returns on locked capital, continued rent, and the time cost of waiting for value to materialize.

Deal strength indicator

Output

Translates the full model output into a single actionable signal — Strong, Borderline, or Weak — so non-financial stakeholders can engage without getting lost in the math.

Buy vs. invest comparison

Visualization

Side-by-side projection of pre-construction purchase vs. deploying the same capital in an alternative investment — the exact mental model buyers use, now made visible.

Business impact

This model shifted the internal framing from "we have a demand problem" to "we have a misaligned value proposition." That's a meaningful strategic reframe — it changes what you do next.

Investor buyers are unlikely to convert without a clearer financial edge over alternatives

End-user / homeowner buyers are the better target — emotional utility offsets some wait cost

Incentive thresholds can be modeled to identify the minimum concession needed to move a deal from Weak to Strong

Appreciation assumptions are doing too much work in the current pricing strategy

What I'd build next

Price sensitivity curvesSegmented by buyer type — investor vs. end-user
Interest rate stress-testingAcross multiple completion timeline scenarios
Optimal incentive modelingConversion thresholds by buyer segment
Live market data integrationDynamic scenario updates with real-time inputs

Why this matters

Situation

A pre-construction development was underperforming on conversions with no clear explanation — macro factors didn't account for the inconsistency in buyer behavior.

Task

Independently identify and quantify the real barrier to conversion — without a brief, a template, or a team.

Action

Built an interactive financial model from scratch simulating the true buyer cost: locked capital, opportunity cost, ongoing housing expenses, delay scenarios, and appreciation sensitivity — surfacing a $200k+ perceived disadvantage.

Result

Reframed the strategic question entirely. Shifted the conversation from "demand problem" to "misaligned value proposition" — with a working tool that lets any stakeholder run their own scenario in real time.

Strategic takeaway

Pre-construction real estate behaves more like a long-term illiquid investment than a home purchase. Buyers are running an implicit IRR calculation every time they walk through a unit — whether they know it or not. The projects that convert aren't just well-located or well-designed. They're structurally compelling on the math, or emotionally irreplaceable enough that the math stops mattering. This model helps you know which one you have.