Investment Scenario Calculator

Scenario Analyser

Get a comprehensive verdict on a property with acquisition costs, cash flow, returns, and affordability.

How to Use the Scenario Calculator

Key Takeaways

  • Singapore condo prices have appreciated at roughly 2–4% per annum over the past two decades — but the spread between best-case and worst-case scenarios on a $1.5M purchase can exceed $400,000 in final proceeds.
  • The single biggest driver of investment returns is not rental yield but holding period: an extra 5 years at 3% appreciation adds roughly $240,000 in capital gain on a $1.5M property.
  • Cash-on-cash return and IRR tell very different stories — a property with a 4% gross yield but 75% LTV financing can deliver a 10%+ cash-on-cash return in early years while still being TDSR-constrained.
  • Vacancy assumptions matter more than most buyers realise: even a single month of vacancy per year reduces effective gross yield by roughly 8%, equivalent to shaving 0.3–0.4 percentage points off annual return.
  • CCR properties typically appreciate less but rent higher in absolute terms; OCR properties offer stronger yield but slower capital growth — modelling both side by side is the only way to see which suits your exit strategy.

What It Does

Model best-case, base-case, and worst-case investment scenarios side by side. Adjust appreciation, vacancy, interest rates, and rental growth to stress-test your property investment thesis before committing capital.

You can find this calculator in the Calculators tab on ShiokNest. It updates results instantly as you adjust inputs — no waiting, no page reloads.

Why It Matters

Buying a Singapore private property at $1.5 million is not just a housing decision — it is a capital allocation of between $375,000 and $525,000 in upfront cash (down payment, BSD, ABSD, legal fees, and renovation), plus a monthly loan commitment of $5,500–$7,000 over 25 years. At that scale, the difference between a well-structured scenario and a poorly stress-tested one can easily exceed $300,000 in final net proceeds. Yet most buyers make the decision after reading one agent-prepared comparison sheet that shows a single rosy outcome.

The number this calculator exists to surface is Internal Rate of Return (IRR) — not gross yield, not capital gain, not rental income. IRR is the annualised return on every dollar of your own cash deployed, taking into account the precise timing of each cash outflow (down payment, stamp duties, monthly loan top-ups) and each inflow (rental receipts, net sale proceeds). A property showing a headline 4% gross yield can deliver an IRR of 7% with 75% LTV financing, or barely 3% on an all-cash purchase. That gap is the entire argument for — and against — leverage, and only IRR captures it cleanly.

The most common mistake buyers make is running a single-point projection: one price, one appreciation rate, one rental assumption. The result looks precise but is actually meaningless, because every input is uncertain. A 1% difference in annual appreciation on a $1.5M property compounds to a $218,000 swing in exit value over ten years. A 0.5% rise in interest rates adds roughly $150 per month to a $1.1M loan — which is tolerable, but a 1.5% rise adds $450 per month and can turn a cash-flow-positive investment into a monthly drain of $800–$1,200. Modelling best-case, base-case, and worst-case simultaneously lets you see the full distribution of outcomes before you commit.

Once you have run your scenarios here, use the Cash Flow Calculator to project month-by-month net position across your holding period, and cross-check stamp duty costs with the Stamp Duty Calculator before finalising which scenario to pursue.

How It Works

  • Navigate to Calculators — Click the "Calculators" tab in the ShiokNest navigation bar. All 47 calculators are grouped by purpose for easy access.
  • Select the calculator — Choose "How to Build Investment Scenarios" from the calculator list. You will see default values already loaded so you can explore immediately.
  • ️ Enter your values — Replace the defaults with your own numbers. The key fields are:
  • Review the results — The calculator updates instantly as you change any input. Key results are displayed in KPI cards and charts that update as you adjust inputs.
  • Run what-if scenarios — This is where the real power lies. Change one variable at a time to see its impact. For example, try increasing the interest rate by 1% or extending your holding period by 5 years. Note how the results shift.
  • Compare and decide — Run 2-3 different scenarios and note the results. This gives you a range of outcomes to base your decision on, rather than relying on a single projection.

Examples

OCR Buy-to-Let: 2BR Condo at $1.2M

Inputs
Purchase Price
$1,200,000
LTV / Loan Amount
75% / $900,000
Interest Rate
3.5% p.a.
Monthly Rent
$3,200
Annual Appreciation
3% (base case)
Results
Gross Yield
3.2%
Cash-on-Cash Return
6.8% (yr 1)
Est. Exit Value (5yr)
$1,391,000
IRR (5-yr hold)
8.4%

How to read this: This OCR 2-bedder delivers a modest 3.2% gross yield — below the cost of debt at 3.5% — but leverage amplifies the equity return significantly. With $300,000 of own cash deployed (25% down + $60,000 in taxes and fees), the investor collects roughly $192,000 in rental income over five years and exits at an estimated $1.39M. After repaying the outstanding loan balance of approximately $810,000, net proceeds before tax are around $581,000 — a $281,000 gain on the $300,000 equity deployed, ...

CCR Buy-to-Sell: 1BR at $1.8M, 3-Year Flip

Inputs
Purchase Price
$1,800,000
LTV / Loan Amount
75% / $1,350,000
Interest Rate
3.5% p.a.
Monthly Rent
$4,800
Annual Appreciation
4% (optimistic)
Results
Gross Yield
3.2%
Monthly Cash Flow
-$280 (negative)
Est. Exit Value (3yr)
$2,025,000
IRR (3-yr hold)
11.2%

How to read this: This CCR 1-bedder is a capital-growth play, not an income play. Monthly rental income of $4,800 is slightly below the interest-plus-maintenance cost of roughly $5,080, meaning the investor tops up about $280 per month — a total of $10,080 over three years. However, if the property appreciates at 4% annually it exits at $2.025M. After repaying $1.29M in outstanding loan, net proceeds are $735,000 against equity deployed of approximately $480,000 (down payment + stamp duties + top-ups), produ...

Tips & Pitfalls

Expert Tips

  • Use realistic assumptions — Singapore condo appreciation has historically averaged 2-4% per year. Avoid overly optimistic projections. When in doubt, use 3% as a baseline.

Common Pitfalls

  • Using the same appreciation rate for all districts. Buyers often plug a uniform 3% appreciation across every scenario regardless of location. CCR (Core Central Region) properties have historically appreciated at 1.5–2.5% per year while OCR properties averaged 3–4%. Applying a single rate masks the fundamental trade-off between yield and growth and will lead you to systematically over-value CCR buys or under-value OCR ones. Run your scenarios with district-appropriate benc...
  • Ignoring the SSD (Seller's Stamp Duty) on short holds. Properties sold within 1 year of purchase attract 12% SSD; within 2 years, 8%; within 3 years, 4%. A buyer planning a 3-year flip on a $1.8M property who forgets SSD will overshoot net proceeds by $72,000. Always set your holding period to at least 3 years in the calculator, or explicitly account for SSD in the exit cost fields if you plan to exit sooner.
  • Treating gross yield as the performance metric. Gross yield — annual rent divided by purchase price — looks clean but ignores maintenance fees, property tax, insurance, agent commissions, vacancy, and loan interest. A $1.2M condo yielding 3.2% gross typically delivers only 1.8–2.2% net yield after costs. When you model scenarios, use net yield (or let the cash-flow section do it for you) — otherwise your IRR will be overstated by 1.5–2 percentage points, enough to m...

Frequently Asked Questions

Is my data saved?
No. All calculations run entirely in your browser. Nothing you enter is transmitted to our servers or stored anywhere. You can close the tab and your inputs will be gone — so note down any scenario you want to keep.
What is IRR and why is it better than yield?
IRR (Internal Rate of Return) is the annualised return on every dollar of your own cash, accounting for the exact timing of each payment in and out. Gross yield only compares annual rent to purchase price and ignores capital gain, financing costs, and transaction timing. Two properties with identical 3.5% gross yields can have IRRs of 5% and 11% respectively if one is leveraged and held for five years while the other is bought all-cash and sold in two. Always use IRR when comparing investment...
How do I model a worst-case scenario?
Set appreciation to 0% or even -1%, increase the interest rate to 4.5–5% (reflecting a potential rate cycle), assume one month of vacancy per year (set effective rent to 91.7% of headline rent), and add 10–15% to your maintenance and holding costs. If the IRR is still positive under those conditions, the investment has a reasonable margin of safety. If it turns negative, you are relying on everything going right — a risky position on a multi-million dollar asset.
Does the calculator account for ABSD and SSD?
The acquisition cost section calculates BSD and ABSD based on your buyer profile and purchase price. SSD is factored into exit costs if your holding period is under three years. For a second-property Singaporean Citizen buying at $1.5M, ABSD alone adds $300,000 (20%) to upfront costs — a figure that meaningfully suppresses IRR in the early years and is the primary reason short holds are usually uneconomical for second-property buyers.
What appreciation rate should I use for Singapore condos?
Singapore private residential prices rose roughly 2.1% per year on average from 2000 to 2024 in real terms (inflation-adjusted), though nominal appreciation averaged closer to 3.5–4%. OCR properties have generally outpaced CCR on a percentage basis. For conservative planning, use 2–3% for base case, 0% for worst case, and 4–5% for best case. Avoid modelling above 5% per year for a sustained period — it implies doubling every 14 years, which has only happened once (2005–2013 run-up).

Related Resources

Article How to Calculate Capitalisation Rate Article How to Calculate Commercial Property Stamp Duty Article How to Calculate Commercial Property Yield Article How to Estimate Land Value Article How to Compare Landed vs Condo Investment Calculator How to Project Rental Property Cash Flow
Disclaimer: Figures shown are estimates for planning purposes only. Rates, rules, and grant quanta change frequently — verify with your bank, HDB, or a licensed financial advisor before acting.