How to Build Investment Scenarios

How-To Updated 19 min read Last reviewed

Before committing to a Singapore property purchase, build three financial scenarios — bear, base, and bull — that flex your purchase price, financing rate, rental income, capital growth, holding period, and exit costs. Running all three side by side reveals the spread of outcomes and stops a single optimistic assumption from distorting your decision. (as of 2026-06)

Most property buyers run one set of numbers: the best-case version where rents hold, prices rise, and interest rates stay low. That single-scenario approach is exactly how investors end up cash-flow negative in year two with no plan. A proper scenario model forces you to answer the harder question: can I absorb the worst case and still meet my financial obligations? If the bear case does not break you, everything above that is upside. This guide walks through every variable you need to stress-test, shows a worked three-scenario table for a S$1.5 million condominium in Singapore, and points to the calculators that automate the arithmetic.

Why scenario planning matters more now

Singapore's private residential market sits at an inflection point as of mid-2026. SORA-linked mortgage rates have moderated from the 2023–2024 peaks but remain materially above the near-zero environment of 2020–2021, meaning financing costs are a far larger share of total return than buyers were accustomed to in the previous decade. At the same time, the Additional Buyer's Stamp Duty (ABSD) regime — detailed on the IRAS website — means that for many buyers, the entry cost alone (ABSD plus BSD plus legal fees) can equal 18–20% of the purchase price, fundamentally changing how quickly capital is returned. Against that backdrop, URA's published price and rental transaction data shows district-level rental yields ranging from around 2.8% to 4.2% gross for private condominiums, a band narrow enough that a small change in vacancy assumptions can flip a nominally positive cash-flow position into a negative one. Running a single base-case projection under these conditions is not conservative — it is negligent financial planning. A three-scenario framework acknowledges that your growth assumption and your financing cost are the two variables you control least, so those are exactly the levers to stress.

You can cross-reference district-level price and rental trends using the price heatmap and rental yield map before settling on your input assumptions.

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.

What This Calculator 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 This Matters

What You Will Discover

After running this calculator with your personal numbers, you will know:

    Key Inputs Explained

    Here are the inputs you will configure, along with their default values. Each default is calibrated to a realistic Singapore condo scenario so you can explore results immediately.

    FieldDescriptionDefault Value
    Purchase PriceThe total property price before additional costs.$1,500,000
    Monthly RentExpected monthly rental income or rent you would pay.$3,800
    Annual Appreciation (%)Expected yearly increase in property value.3.0%

    Step-by-Step Guide

    1. 🏠 Navigate to Calculators — Click the "Calculators" tab in the ShiokNest navigation bar. All 47 calculators are grouped by purpose for easy access.
    2. 🔍 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.
    3. ✏️ Enter your values — Replace the defaults with your own numbers. The key fields are:
      • Purchase Price — The total property price before additional costs.
      • Monthly Rent — Expected monthly rental income or rent you would pay.
      • Annual Appreciation (%) — Expected yearly increase in property value.
    4. 📊 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.
    5. 🔄 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.
    6. 💾 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.

    Worked Example

    Real-World Scenarios to Try

    Here are some realistic scenarios you can plug into the calculator right now. Each one reflects a common situation Singapore property buyers face.

    ScenarioSettings to TryWhat You Will Learn
    Bull market5% appreciation, 3% rental growth, 5% vacancyBest-case returns — how quickly the investment pays off
    Base case3% appreciation, 2% rental growth, 8% vacancyRealistic expected returns using historical averages
    Bear market0% appreciation, 0% rental growth, 15% vacancyStress-test — can you survive a prolonged downturn?

    Expert Tips and Common Pitfalls

    💡 Pro 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

      🤔 What-If Scenarios to Explore

      Get the most value from this calculator by testing these scenarios:

      • Run at least 3 scenarios — best case, base case, and worst case — to understand the full range of outcomes.

      Related Calculators

      Your property journey involves many interconnected decisions. These calculators work hand-in-hand with this one:

      Ready to Crunch Your Numbers?

      Build three investment scenarios with different assumptions and see them side by side. The ultimate stress-test before committing to a property investment.

      Try the Build Investment Scenarios Calculator Now →

      Official Sources

      This how-to guide is auto-generated using ShiokNest's calculator defaults. All worked examples use default values — adjust inputs to match your personal scenario for accurate results.

      The six variables that drive every scenario

      1. Purchase price and entry costs. Your total capital deployed at entry is not just the purchase price — it includes Buyer's Stamp Duty (BSD), ABSD where applicable, legal fees, and any renovation spend. BSD is tiered: 1% on the first S$180,000, 2% on the next S$180,000, 3% on the next S$640,000, and 4% on the remainder up to S$1.5 million (with higher rates for amounts above that threshold — verify the current schedule at IRAS Buyer's Stamp Duty). For a second residential property, ABSD for Singapore Citizens is 20% (as of 2026-06); for Permanent Residents it is 30%; for foreigners it is 60%. These are not small rounding errors — for a S$1.5 million condo, Singaporean Citizen BSD alone is approximately S$44,600, and a second-property ABSD adds another S$300,000. Your scenario model must treat total entry cost, not just purchase price, as the denominator when computing returns.

      2. Financing rate and loan quantum. The Total Debt Servicing Ratio (TDSR) caps monthly debt obligations at 55% of gross income. The Loan-to-Value (LTV) for a first property is 75% for bank loans. Your stress rate should be set at least 150–200 basis points above your initial rate to simulate a rate cycle. The MAS domestic interest rates page publishes current and historical SORA data. In your bear case, apply the stressed rate from year one; in your base case use the prevailing rate with a modest mid-period increase; in the bull case assume rates fall 50 basis points from today.

      3. Gross rental income and vacancy. Vacancy is the input most buyers underestimate. Even in a healthy market, expect one to two months of vacancy between tenants per year, plus a letting agent fee of one month's gross rent for annual leases. Your effective annual rental income is therefore: (monthly rent × 10 or 11 months) minus agent fee. In the bear case, model 2.5 months' vacancy; base case 1.5 months; bull case 0.5 months.

      4. Annual capital growth assumption. This single variable has the biggest effect on total return for holding periods above five years, yet it is the hardest to forecast. Historical URA data for the Core Central Region averages roughly 3–4% per annum over a 10-year horizon, but individual districts vary widely and shorter holding periods show far wider dispersions. In the bear case use 1% per annum; base case 3%; bull case 5%.

      5. Holding period. Singapore's Seller's Stamp Duty (SSD) applies if you sell within three years of purchase: 12% in year one, 8% in year two, 4% in year three, nil from year four onwards. This creates a hard floor on how short your holding period should realistically be. Model a minimum five-year hold for private residential.

      6. Exit costs. Add agent commission (typically 1–2% of sale price for the seller's agent) plus legal fees on sale (approximately S$2,500–S$4,000) and any outstanding renovation depreciation. These reduce your net sale proceeds and therefore your net return.

      Worked three-scenario table: S$1.5 million condo, 5-year hold (as of 2026-06)

      The table below uses a first-property purchase (no ABSD), 75% LTV bank loan, monthly rent of S$4,200 (gross), and a 25-year loan tenor. All figures are approximate and for illustration only.

      VariableBearBaseBull
      Purchase priceS$1,500,000S$1,500,000S$1,500,000
      Entry costs (BSD + legal)S$47,100S$47,100S$47,100
      Loan quantum (75% LTV)S$1,125,000S$1,125,000S$1,125,000
      Mortgage rate (stressed)4.5% p.a.3.5% p.a.3.0% p.a.
      Monthly mortgage~S$6,230~S$5,620~S$5,330
      Effective annual rent (vacancy adj.)S$41,650S$46,200S$50,400
      Annual capital growth assumed1%3%5%
      Estimated sale price (year 5)~S$1,576,000~S$1,739,000~S$1,914,000
      Net proceeds after exit costs (2%)~S$1,545,000~S$1,704,000~S$1,876,000
      Estimated total return on equity~2%~18%~38%

      The spread between bear and bull in this worked example is substantial — a difference of 36 percentage points on equity return over five years. The primary driver is the combination of capital growth assumption and financing cost. A 150-basis-point difference in mortgage rate (4.5% vs 3.0%) changes annual debt service by roughly S$10,900, which compounds materially over five years. The capital growth delta (1% vs 5%) changes exit proceeds by over S$330,000. These two levers together explain virtually all of the outcome spread. Use the ROI calculator and cash flow calculator to run your own figures, and the total cost calculator to verify your entry cost assumptions against your specific buyer profile.

      Step by step

      1. Confirm your buyer profile and ABSD liability first. Establish whether ABSD applies and at what rate before modelling anything else. Log in to the IRAS ABSD page and verify the current rate for your citizenship status and property count. Enter the precise ABSD and BSD figures into your model — they are not estimates to be rounded.
      2. Set your three financing-rate assumptions. Visit the MAS interest rates page to read the current 1-month and 3-month compounded SORA. Add your bank's spread (typically 0.8–1.0% above SORA for a standard package). For the bear rate, add 150–200 bps to your base rate. For the bull rate, subtract 50 bps. Run all three through the mortgage calculator to get exact monthly payments for each scenario.
      3. Gather district-level rental benchmarks. Use the rental yield map to verify current gross yields in your target district. Then apply vacancy haircuts: bear = 2.5 months, base = 1.5 months, bull = 0.5 months. Add one month's rent as a letting agent fee in all scenarios (this is a real recurring cost, not an optional one).
      4. Set your capital growth assumptions conservatively. Cross-reference URA's published price index data for the district and property type. Use the 10-year compound annual growth rate as your base case, not the most recent two-year figure (which may reflect an unusual cycle). Then cut that rate by two-thirds for the bear case, and increase it by two-thirds for the bull case.
      5. Build a five-year cash flow table in a spreadsheet. Rows: rental income, mortgage payments, property tax, maintenance fees, insurance. Columns: year 1 through year 5. Compute annual net cash flow for each scenario. Negative years in the base or bull case are a warning sign; negative years in the bear case are information, not necessarily a veto — you need to know whether you can fund the shortfall from other income.
      6. Compute total return on equity for each scenario. Total return = (net sale proceeds + cumulative net rental income − total equity deployed at entry) ÷ total equity deployed at entry. Run this through the ROI calculator. If the bear-case total return on equity is deeply negative and you cannot fund interim cash shortfalls, the property fails the stress test regardless of how attractive the bull case looks.
      7. Run a sensitivity table on just two variables. Hold everything else at base-case values and vary: (a) capital growth ±2% in 0.5% increments, (b) mortgage rate ±1.5% in 0.25% increments. The resulting 5×5 or 7×7 grid shows how quickly returns deteriorate as one or both levers move against you. If most of the grid is positive, you have a robust investment. If returns turn negative as soon as one variable moves half a step in the wrong direction, the margin of safety is insufficient.
      8. Document your assumptions and date them. Scenario models go stale quickly. Record the SORA rate you used, the rental benchmark, the URA district price index level, and the date — all as of 2026-06. Revisit and update the model every six months or when macro conditions change materially. Use the cash flow calculator and total cost calculator for quick updates when input assumptions shift.

      Frequently asked questions

      How many scenarios do I actually need — is three enough?

      Three scenarios — bear, base, and bull — is the standard minimum for property investment planning because it forces you to articulate a downside, a realistic midpoint, and an upside, rather than anchoring on a single figure. Some investors run five scenarios by splitting the bear into a mild-stress and severe-stress case, but for most individual buyers three is sufficient provided the bear case uses genuinely conservative inputs: a mortgage rate 150–200 bps above today, vacancy of 2.5 months per year, and capital growth of only 1% per annum. The discipline is not in the number of scenarios but in the honesty of your worst-case assumptions. If your bear case still uses 3% growth, it is not actually a bear case.

      What is the single most important variable to stress-test?

      For most Singapore condominium investments at the S$1–2 million price point, the capital growth assumption dominates total return over a five-to-ten-year hold — a 4% difference in annual growth (1% vs 5%) can change exit proceeds by over S$300,000 on a S$1.5 million purchase. However, the financing rate is the variable that most directly affects annual cash flow, which determines whether you can hold through a downturn. The two interact: if rates rise sharply at the same time that prices stagnate (the 2023–2024 pattern), both levers move against you simultaneously. This is exactly why your bear case must stress both together, not independently.

      How should I account for ABSD in my scenario model?

      ABSD must be treated as an upfront sunk cost that increases your effective entry price and therefore reduces your return on equity. For a Singapore Citizen purchasing a second residential property, ABSD is currently 20% of the purchase price — S$300,000 on a S$1.5 million condo (as of 2026-06). This amount is paid in cash (it cannot be financed via a bank loan), increases your total capital deployed, and is not recoverable on sale. The practical effect is that break-even on a second-property purchase requires materially higher capital growth or a longer hold to overcome the ABSD drag. Always verify the current rate schedule on the IRAS stamp duty page before finalising your model.

      Should I compare across districts before committing to one?

      Yes — running your scenario model across two or three candidate districts before committing is one of the highest-value steps you can take, because gross yield and historical price growth vary meaningfully across Singapore's 28 districts. A district with a higher gross yield but lower historical capital appreciation may produce a better bear-case outcome (stronger cash flow to fund holding costs) while underperforming in the bull case. Use the rental yield map to compare district-level gross yields and the price heatmap for relative price momentum. You can also use the property comparison tool to put specific condominiums side by side before finalising your inputs.

      At what point does a scenario model say I should not proceed?

      A scenario model is a decision-support tool, not an automatic veto or approval. The clearest red flag is a bear case where annual cash outflows exceed your ability to fund the shortfall from other income for a sustained period — typically two or more consecutive years — with no realistic plan to refinance or exit without realising a material loss. A secondary red flag is a total return on equity in the base case that is lower than a comparable risk-free instrument (Singapore Savings Bonds or a short-duration SGS bond), because you are taking on liquidity risk, leverage risk, and single-asset concentration risk for a return that does not compensate for those risks. If the base case barely beats risk-free and the bear case involves a significant loss, the risk-reward is unfavourable regardless of how attractive the bull case appears.