Useful Financial
Calculators

Many of us wonder where our money went at the end of each month. Drawing up a monthly budget can help us take control of our expenses. Keeping to a budget can go a long way in growing our savings. This budget spreadsheet can help us keep track of our expenses.

Comparing the Planned and Actual columns will give you an idea how far your actual expenditure has deviated from your planned one. It will allow you to see where you have to re-evaluate and where you can reallocate your resources.

Use this to prepare a budget when income stream has become uncertain, interrupted and cashflow is under strain.

The Effective Interest Rate (or “EIR”) of a loan reflects the true cost of taking a loan, taking into account how the interest is computed on the borrowed amount and the frequency of loan repayments. Use this calculator to determine the true interest rate of your loan ideally before taking it, so you can determine your best financing options.

Use this to estimate how much your monthly savings can grow to meet your financial goal(s). This calculator breaks down how much you will need to save monthly, weekly and even daily to meet your financial goal. This enables you to get into the habit of saving regularly which is the bedrock for building financial assets especially during working years.

Use this spreadsheet to summarise and get an overview of your insurance policies to identify types of insurance you have and their key coverage features. This will help you identify gaps (both in terms of type of coverage as well as amounts) as you undertake your insurance planning.

This planner helps you to estimate your monthly loan repayments, interest charges and payoff date. Your monthly payment for a loan amount will depend on the amount, term and interest rate of the loan.

Use this calculator to have an overview of all your loan repayments. It enables you to plan your cashflow, budget and in the event of a budget crisis, prioritise repayment to avoid default interest and late fees.

Use this to calculate your Net Cash Flow. You should use this to review your annual and monthly cashflow as well as to support your budget planning process. If you have a regular cash surplus, you can then consider investing in a regular investment plan that aligns with your risk profile, to generate better returns.

If you identify cash deficits, you can then review your spending / budget to identify if the cause(s) is one-off or recurring and make necessary changes if recurring. Persistent deficits mean you are at risk becoming dependent on debt.

This Net Worth Calculator can help you in your planning towards increasing your net worth over time. Assessing your current financial situation and calculating your net worth is an important step in financial planning. Net worth is the difference in value between your assets and liabilities. Work towards increasing your net worth over time.

Use this to estimate your retirement income needs based on your current expenses, anticipated rate of inflation, expected returns on savings & investments and other nest egg. It enables you to identify the gap between the future value of current savings against the future retirement sum needed and offers options available to meet this gap. With this we can then work out which option works best for us today and act on them to ensure we will meet our future retirement income needs.

This tool helps you evaluate how much your total current retirement savings (CPF and other cash savings) as well as regular investments will be worth upon retirement. The tool will also show you how long these savings/investment nest egg will last upon retirement, based on your input of desired retirement income per year. This enables you to plan the decumulation of retirement savings and investments and manage the draw down according to your needs yet ensure adequate income for retirement years. Using this tool together with the Retirement Calculator will provide a holistic and sustainable retirement income plan.

Use this to estimate how much your monthly savings can grow to meet your financial goal(s). This calculator breaks down how much you will need to save monthly, weekly and even daily to meet your financial goal. This enables you to get into the habit of saving regularly which is the bedrock for building financial assets especially during working years.

Use this to plan, track and identify your spending items and patterns. Do this monthly to compare between the actual and targeted expenses. Tracking and identification enable you to know and tell your money where it should go.

Use this to estimate local tertiary education fees that you will need when considering how much endowment insurance to purchase as well as building investment plan(s) for your/your children’s future education.