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
Assumptions
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
Getting Started
Start by creating a copy of the spreadsheet as this...