Modelling a buy-to-rent property investment requires four distinct stages: entry costs (purchase price, BSD, ABSD, legal fees, downpayment), holding costs (mortgage, property tax, MCST, vacancy), exit proceeds (sale price minus loan, CPF refund with accrued interest, agent fees), and total return (net proceeds plus cumulative rent divided by cash invested). Miss any stage and your numbers will mislead you. (as of 2026-06)
Most investors price a property by looking at the mortgage payment and the asking rent, then stopping there. That two-line model omits the Buyer's Stamp Duty, the Additional Buyer's Stamp Duty, the CPF accrued interest you owe on exit, the vacancy buffer, and the Seller's Stamp Duty if you sell inside three years — together these items can turn a paper profit into a real loss. This guide walks you through the full four-stage lifecycle calculation, stage by stage, with a worked example using figures current as of 2026-06. By the time you finish reading, you will be able to build your own model in a spreadsheet and cross-check it against the ROI Calculator, the Total Cost of Ownership Calculator, and the Cash Flow Calculator.
Why Singapore property math is more complex than it looks
Singapore's residential property regime layers multiple transaction taxes on top of the base purchase price. For a Singapore Citizen buying a second residential property, the Additional Buyer's Stamp Duty (ABSD) alone is 20% of the purchase price as at 2026-06 (source: IRAS ABSD guidance). Buyer's Stamp Duty (BSD) adds a further 1–6% on a marginal basis. The Monetary Authority of Singapore caps the Loan-to-Value ratio at 75% for a first housing loan and 45% for a second, meaning the cash-and-CPF downpayment alone can exceed 25% of the purchase price before stamp duties are counted (source: MAS LTV explainer). On the exit side, the CPF Board requires you to refund the full CPF principal used for the purchase, plus accrued interest at the Ordinary Account rate (currently 2.5% p.a.), before you may pocket any cash sale proceeds (source: CPF selling your property). Together, entry costs and exit obligations can absorb 30–40% of the purchase price on a second property, which is why a rigorous four-stage model is not optional — it is the minimum standard for any serious investment decision. Use the Price Heatmap and the Rental Yield Map to ground your assumptions in district-level market data before you begin.
You are about to invest $400K+ of your hard-earned money into a condo. Do you know your expected IRR? Your monthly cash burn? Your break-even occupancy rate? If the answer to any of these is "not exactly," then you need this calculator before you sign anything.
The End-to-End Investment Calculator is the most comprehensive property analysis tool on ShiokNest. It models every single cost from Day 1 acquisition to final exit sale — and tells you whether the investment actually makes financial sense.
What This Calculator Does
The most comprehensive property investment calculator in Singapore. Analyse every cost from Day 1 to exit — acquisition, stamp duty, financing, renovation, monthly carrying costs, rental income, tax, and projected IRR. See exactly what your net profit will be before you invest a single dollar.
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
Property investment is not a spreadsheet exercise — or at least, it should not be done with a simple spreadsheet. There are dozens of interconnected variables, and getting just one wrong (rental income, occupancy, interest rate, exit timing) can turn a projected profit into a real loss. The End-to-End calculator matters because it:
- Models every cost — nothing is hidden or forgotten
- Calculates IRR, the gold standard for investment comparison
- Shows monthly cash flow so you know if you need to top up each month
- Lets you stress-test assumptions to find the break-even point
What You Will Discover
After running this calculator with your personal numbers, you will know:
- Total cash outlay needed on Day 1 (down payment + all fees)
- Monthly carrying costs vs rental income (cash-flow positive or negative?)
- Projected IRR — the true annualised return on your invested capital
- Break-even occupancy rate and minimum rent needed
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.
| Field | Description | Default Value |
|---|---|---|
| Purchase Price | The total property price before additional costs. | $1,500,000 |
| Floor Area (sqft) | The unit floor area in square feet. | 1,000 sqft |
| Buyer Profile | Your residency status (SC/PR/Foreigner). | SC 1st |
| Loan-to-Value (%) | Maximum loan as percentage of property value. | 75.0% |
| Interest Rate (%) | Annual loan interest rate. | 3.5% |
| Loan Tenure (Years) | Duration of the mortgage loan. | 25 years |
| Monthly Rent | Expected monthly rental income or rent you would pay. | $3,800 |
Step-by-Step Guide
- 🏠 Navigate to Calculators — Click the "Calculators" tab in the ShiokNest navigation bar. All 26 calculators are grouped by purpose for easy access.
- 🔍 Select the calculator — Choose "How to Use the End-to-End Investment Calculator" 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:
- Purchase Price — The total property price before additional costs.
- Floor Area (sqft) — The unit floor area in square feet.
- Buyer Profile — Your residency status (SC/PR/Foreigner).
- Loan-to-Value (%) — Maximum loan as percentage of property value.
- Interest Rate (%) — Annual loan interest rate.
- Plus 2 more fields for fine-tuning your scenario.
- 📊 Review the results — The calculator updates instantly as you change any input. A comprehensive dashboard shows cash outlay, loan amount, monthly cash flow, rental income, carrying costs, and projected IRR — everything an investor needs.
- 🔄 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.
Worked Example
Meet Alex, a seasoned investor analysing a $1,500,000 condo as a pure rental investment. He wants to know everything: how much cash he needs upfront, what the monthly carrying costs are, and what his projected IRR looks like over 10 years.
Day 1 cash needed: Alex needs $419,600 upfront (25% down payment + BSD of $44,600). Add legal fees, valuation, and renovation, and the true cash outlay could be $473,100 or more.
Monthly cash flow: With rent at $3,800 and mortgage at $5,632, plus condo fees and property tax, the calculator shows exactly whether this property generates positive cash flow or requires monthly top-ups. The End-to-End calculator is the most comprehensive tool on ShiokNest — it leaves nothing to guesswork.
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.
| Scenario | Settings to Try | What You Will Learn |
|---|---|---|
| OCR cash-flow play | Price: $1.2M, Rent: $3,200, 75% LTV | Whether an affordable OCR condo generates positive monthly cash flow |
| RCR balanced investment | Price: $1.8M, Rent: $4,500, 75% LTV | The trade-off between higher rent and higher carrying costs in the city fringe |
| CCR premium play | Price: $3.0M, Rent: $8,000, 75% LTV | Whether prime district properties deliver returns or just prestige |
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.
- Stress-test everything — Run the calculator with 90% occupancy, 4.5% interest rate, and 2% appreciation simultaneously. If it still works, you have a resilient investment.
- Factor in income tax — Rental income is taxable. At a 15% marginal rate, this reduces your net yield noticeably.
- IRR is king — Forget gross yield. The internal rate of return (IRR) accounts for the timing of all cash flows and gives you the true annualised return.
⚠️ Common Pitfalls
- Cherry-picking assumptions — Optimistic rent + optimistic appreciation + low expenses = fantasy returns. Use conservative numbers and be pleasantly surprised.
- Ignoring exit costs — Agent fees (1-2%), legal fees, and potential SSD at exit can wipe out years of rental profit.
🤔 What-If Scenarios to Explore
Get the most value from this calculator by testing these scenarios:
- What is the minimum rent needed to break even on monthly cash flow?
- What if occupancy drops to 85% (roughly 2 months vacant per year)?
- What is your IRR if you exit after 5 years vs 10 years?
- 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:
- How to Calculate Buy-to-Rent ROI
- How to Calculate total acquisition cost
- How to Use the mortgage calculator
- Buy vs Rent: Finding Your Break-Even Point
Ready to Crunch Your Numbers?
Enter your property details and let the calculator do the heavy lifting. From acquisition to exit, every dollar is accounted for. This is how professional investors analyse deals.
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.
Worked example: S$1.5 million condominium unit, 30-year horizon compressed to 7 years
The following worked example uses a S$1,500,000 purchase price, a Singapore Citizen buyer who already owns one property, a 30-year loan tenor at 3.5% p.a., and a 7-year hold before sale. All figures are illustrative as of 2026-06; use actual quotes from your bank and lawyer before committing.
Stage 1 — Entry costs. BSD on S$1.5 m is computed on a marginal scale: 1% on the first S$180,000, 2% on the next S$180,000, 3% on the next S$640,000, 4% on the next S$500,000 — total BSD ≈ S$39,600 (verify with the IRAS BSD calculator). ABSD at 20% for a SC second property = S$300,000. Legal fees and conveyancing ≈ S$3,500. Total acquisition cost = S$1,843,100. LTV 75% means the bank finances S$1,125,000; the buyer must fund S$718,100 from cash and CPF. Assume S$250,000 from CPF and S$468,100 cash. Cash invested at entry = S$468,100 + S$39,600 BSD + S$300,000 ABSD + S$3,500 legal = S$811,200 total cash out-of-pocket (CPF is also equity committed, tracked separately).
Stage 2 — Holding costs and net cash flow. Monthly mortgage on S$1,125,000 at 3.5% over 30 years ≈ S$5,050 (verify with the Mortgage Calculator). Gross monthly rent for a similar unit in the same district: assume S$5,800, sourced from the Rental Yield Map and cross-checked against URA median data. Operating costs: property tax (non-owner-occupier rate on AV of roughly S$36,000/year) ≈ S$2,880/year = S$240/month; MCST / maintenance fees ≈ S$350/month; landlord insurance ≈ S$50/month; vacancy allowance at 8% of gross rent ≈ S$464/month. Total monthly operating costs ≈ S$1,104. Net cash flow = S$5,800 − S$5,050 mortgage − S$1,104 costs = −S$354/month, i.e. slightly cash-flow negative. Over 7 years that equals −S$29,736 cumulative. This is not unusual for a high-ABSD second property — the investment thesis relies on capital appreciation, not yield alone. Use the Cash Flow Calculator to run sensitivity on rent and interest rate.
Stage 3 — Exit proceeds. Assume the property appreciates at 3% p.a. compound: S$1,500,000 × (1.03)^7 ≈ S$1,843,000 sale price. Outstanding loan balance after 7 years of amortisation ≈ S$985,000. CPF refund required: S$250,000 principal + 7 years of 2.5% p.a. accrued interest compounding ≈ S$295,800 total (check your CPF statement via cpf.gov.sg). SSD does not apply (hold > 3 years). Agent commission at 2% = S$36,860. Legal fees on sale ≈ S$2,500. Net cash proceeds = S$1,843,000 − S$985,000 loan − S$295,800 CPF refund − S$36,860 agent − S$2,500 legal = S$522,840.
Stage 4 — Total return. Cash invested = S$811,200. CPF equity committed = S$250,000; returned = S$295,800 (you get back your CPF — it goes back into your account, not your pocket). Total return on cash = (S$522,840 cash proceeds − S$29,736 cumulative negative cash flow − S$811,200 cash invested) ÷ S$811,200 = −S$318,096 ÷ S$811,200 = −39% nominal return on cash outlay in this scenario. This negative outcome illustrates why ABSD dramatically constrains second-property returns and why the ROI Calculator and Total Cost of Ownership Calculator should be run before any offer is made. Compare districts with different yield profiles at District 5 or explore the Property Comparison tool to find units with better entry economics. Adjusting the scenario — e.g. a lower ABSD category, stronger appreciation, or higher rent — can flip the result to positive. The model's power is in stress-testing assumptions, not in validating a predetermined conclusion.
Step by step
- Stage 1 — Calculate your full entry cost. Start with the purchase price. Add BSD (compute on the IRAS marginal scale at iras.gov.sg), then ABSD at your applicable rate (confirm your citizenship and ownership count at iras.gov.sg ABSD table), then legal and conveyancing fees (typically S$2,500–S$4,000). Apply the MAS LTV limit (75% first loan, 45% second loan — see mas.gov.sg) to determine your minimum downpayment. Allocate between CPF and cash; track them separately. Run the Total Cost of Ownership Calculator to validate your entry subtotal.
- Stage 2 — Model monthly holding cash flow. Compute your monthly mortgage instalment (principal + interest) using the Mortgage Calculator at your bank's offered rate. Estimate gross monthly rent from the Rental Yield Map or recent URA median data. Subtract: non-owner-occupier property tax (IRAS progressive scale on Annual Value), MCST / maintenance fee, landlord insurance, and an 8–10% vacancy allowance. The result is your monthly net cash flow — negative is not fatal but must be funded from existing cash reserves. Multiply by the intended hold period to get cumulative cash-flow impact. Stress-test rent down 10% and interest rate up 1% using the Cash Flow Calculator.
- Stage 3 — Project your exit proceeds. Estimate the sale price using a conservative appreciation assumption (historical URA private residential price index growth has averaged roughly 2–4% p.a. over 10-year periods — check URA price trends). From the gross sale price, subtract: the outstanding loan balance (request an amortisation schedule from your bank), the CPF refund obligation (principal + accrued interest at 2.5% p.a. — calculate at cpf.gov.sg), SSD if selling within 3 years of purchase (12% Year 1, 8% Year 2, 4% Year 3 — verify at IRAS), and agent commission (typically 1–2%) plus legal fees (≈ S$2,000–S$3,000). The remainder is your net cash proceeds.
- Stage 4 — Compute total return and cross-check IRR intuition. Total nominal return on cash = (net cash proceeds + cumulative net rent − total cash invested) ÷ total cash invested. For an annualised figure, apply the IRR formula in Excel (
=IRR()) using the cash-flow stream: negative cash outflows at entry and each monthly top-up, positive inflows from rent and the net sale proceeds in the terminal period. A healthy buy-to-let in Singapore typically targets an IRR of 5–8% after all costs on a 7–10 year hold; lower ABSD exposure (e.g. first-property purchase) meaningfully improves this range. Validate your output with the ROI Calculator and compare across districts using the comparison tool.
Frequently asked questions
What is the correct order to subtract costs when calculating net sale proceeds?
Subtract costs in this order from the gross sale price: (1) outstanding loan balance, (2) CPF principal refund plus accrued interest at 2.5% p.a., (3) Seller's Stamp Duty if applicable, (4) agent commission, (5) legal and conveyancing fees. Getting the order wrong does not change the arithmetic sum, but separating loan repayment from CPF refund matters because CPF goes back into your retirement account rather than your bank account — it is returned equity, not liquid cash in hand.
Why does the CPF accrued interest matter so much on exit?
When you use CPF Ordinary Account funds for a property purchase, the CPF Board charges notional interest at 2.5% p.a. compounding on the amount withdrawn, as if those funds had remained in your account earning interest. On exit, you must refund both the principal and this accrued interest before receiving any cash. On a S$250,000 CPF withdrawal held for 7 years, the total refund obligation grows to roughly S$295,800 — a S$45,800 cost that does not appear in any monthly bank statement but directly reduces your net proceeds. Always model this explicitly; the CPF calculator at cpf.gov.sg can give you the precise figure for your withdrawal history.
When does the Seller's Stamp Duty apply, and how much is it?
As at 2026-06, SSD applies when you sell a residential property within 3 years of purchase. The rates are 12% of the sale price if sold in Year 1, 8% in Year 2, and 4% in Year 3. There is no SSD for sales in Year 4 and beyond. On a S$1.5 million property, an SSD exit in Year 1 costs S$180,000 — enough to wipe out several years of rental income. This is why most buy-to-rent investors plan a minimum 4-year hold from the outset. Confirm current SSD rates with IRAS at iras.gov.sg before any transaction.
How should I account for vacancy in the cash-flow model?
Vacancy is the item investors most commonly ignore when projecting rental income. A realistic vacancy allowance for a Singapore condominium is 1–1.5 months per year, which translates to approximately 8–12% of gross annual rent. Build this into your monthly model by multiplying gross monthly rent by 0.90 (10% vacancy buffer) before subtracting operating costs. During actual vacancies you still owe the full mortgage, property tax, and MCST fees — so a negative cash-flow position becomes more negative. Run a downside scenario where vacancy rises to 15–20% to stress-test whether your cash reserves can sustain a prolonged void period.
What is the difference between gross yield, net yield, and IRR for property investment analysis?
Gross yield is simply annual rent divided by purchase price, expressed as a percentage — it ignores all costs. Net yield deducts operating costs (property tax, maintenance, insurance, vacancy) from rent and divides by the all-in acquisition cost including stamp duties; this is a more honest measure of ongoing income return. IRR (Internal Rate of Return) is the most complete metric: it accounts for the timing and magnitude of every cash flow across the full investment lifecycle, from the upfront equity outlay through annual net rental income to the final net sale proceeds. For Singapore second properties where ABSD is a large upfront cost, gross yield is particularly misleading — use the ROI Calculator and the Cash Flow Calculator to model net yield and approximate IRR instead.