We want to share with you a simple property financing spreadsheet model that we’ve built for anyone looking to purchase your own property in the near to medium term. 

Download a copy from the link here (use excel instead of google spreadsheets for the best experience). This model took extensive hours of research to curate. Do consider joining our telegram channel and mailing list if you find such content beneficial - it will mean a lot to us!

What this model will do:

1. Determine whether you are able to afford the property in mind at your current financial position 
2. Compute your monthly mortgage payment amount 
3. Illustrate your mortgage amortisation/repayment schedule 
4. Table illustrating affordability of the property based on various purchase prices and interest rates
5. Approximate the additional income required and the duration needed to afford the property you have in mind

How is this different from other calculators like HDB’s Budget Calculator? 

1. You will be able to trace the logic of the model to really understand the meaning behind the numbers 
2. Significant flexibility in tweaking assumptions to align with your own circumstances

How to use this model? 

1. Input assumptions in “1. Assumptions – Input” Tab 
2. Analyze output in “2. Calculations – Output” Tab. Key cells are coloured in green. 

Some additional screenshots below:

Enjoy!