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

Getting Started

Start by creating a copy of the spreadsheet as this