Instructions
Complete all the yellow cells in the table. The latest inflation figure can be found on the Reserve Bank of Australia (RBA) website. You can also look up your marginal tax rate on the Australian Tax Office (ATO) website.
The chart in the spreadsheet will automatically update as you complete the details. The 'Cash balance' shown represents the actual dollars that will be in cash after adding interest and deducting tax for each year. The 'Relative value' shows what those actual future dollars will really be worth after accounting for inflation. The 'Total invested' shows the cumulative amount that has been invested, less any withdrawals. The exact values can be read by hovering your mouse over the bars on the chart.
Hub Advisory Group - Cash vs inflation
.xlsx
Download XLSX • 28KB