In my previous article, I did some calculations on the interest gained from various scenarios when it comes to paying down your housing loan.
In this post, I would like to share the sheet which I have created, explain how it works and explain how you may use it.
I have since updated and improved my sheet from the previous post.
Google Spreadsheet: Loan & CPF Interest Calculator Final Template
Before using this spreadsheet, here are some assumptions:
- Your CPF contribution remains constant over the loan duration
- The loan interest remains fixed over the loan duration
- I had excluded all other fees and charges, i.e. late payment charges, prepayment penalties etc.
Table of Content
Explanation of the spreadsheet
How to use the spreadsheet
Start by creating a copy of the spreadsheet as this