Financial Modelling with Google Sheets & Google Drive

Rent or Buy decision

Buying a home may be the biggest 'investment' decision many of us make. But is it always an investment? Below are 2 buy scenarios (100% bond & 100% cash purchase) as well as renting and investing the full bond amount in a fixed deposit. Feel free to explore different rate/price scenarios by changing the green cells.
In order to compare apples with apples I present the answer as your Present Value (PV) position. Positive would indicate a net profit position and negative a loss. Most the time you may be merely avoiding the worst loss!


Technical discussion