Savings & Investment Planner

Savings template. Personal expenses spreadsheet to enter all your expenses as they occur. Use + values for really essential expense items and ? values for non essential expenses. Excel works out the exact amounts of essential/non essential expenses, monthly savings if you eliminate all non essential costs and the percentage spent on non essentials.

Check Savings, Credit card and Bank accounts. Excel is an absolutely perfect tool for being able to check account balances and for retracing calculations carried out by your bank or lender. Templates make this process really easy for you as well as verifying the interest credits or charges on your savings and card accounts.

Credit card account templates. Track your credit card interest and protection insurance charges using this spreadsheet which calculates the real annual interest rate charged . Any previous late payment or overdue balance can shift your interest rate into the stratosphere. Keep a close watch on your credit card rates with these spreadsheets.

Savings account template. Track your savings interest rate using this spreadsheet which calculates the real annual interest rate credited to your account. Find a higher savings rate and keep checking. Similarly keep a close watch on your savings account interest rate because they can be changed without notice.

Bank account template. Track your bank charges and interest using this spreadsheet which correct your daily balances when over zealous bank charges deplete your account balances.

Accelerate your mortgage repayments. Use this spreadsheet to calculate how much your net worth increases by applying your monthly savings to faster repayment of your mortgage loan and reducing the financing charges.

The Guidance edition leads by example. By reallocating income into accelerated repayment of a 25 year fixed rate (5.95% p.a.) $255,000 mortgage will yield savings of $100,259.

You can test whether investing in a Mutual fund increases your net worth more than paying down your mortgage.
The Managed Investment Funds spreadsheets calculate returns from alternative investment opportunities covering a ten year investment period for up to four different investment plans.