Put the key property numbers on one screen and inspect the trade-offs.
Use your own figures. You can change any assumption and recalculate.
Enter your figures and calculate.
Model the purchase price, closing costs, achievable rent, vacancy, operating expenses and any debt service. If you include future resale value, mark it as a scenario assumption rather than a fact. Compare the property’s expected cash yield and liquidity with alternatives, noting that property transactions can be slow and expensive.
Listings do not guarantee achievable rent or a quick resale. Inspect vacancy history, maintenance liabilities, title and encumbrances, neighbourhood supply, transport access and any society restrictions. The planner cannot replace legal or structural due diligence, and positive projected cash flow does not guarantee investment profit.
Estimate rent after vacancy, then account for recurring property costs and the EMI. A property can have positive expected long-term appreciation but negative monthly cash flow, so keep the cash requirement separate from any hoped-for resale gain.
Use conservative rent, vacancy and maintenance assumptions and include transaction costs that are not represented in the inputs. The worksheet is not a property valuation, title check or guarantee of tenant demand; compare the result with keeping sufficient liquid funds for unexpected costs.