Yep I have created a spreadsheet for calculating eligibility for the pension in Australia. This calculates based on income and assets and works out firstly if you are eligible for the pension based on the basic tests and then also based on the income using the deeming rules.
Deeming is calculated on savings and other "liquid" type assets including shares and managed funds. This is an amount that the government calculates you earn as income from these investments. It doesn't matter if you actually earn more from those assets than the deemed amount.
I have only created it for Home Owners both as a Single applicant and a Couple.
You can download it from the Geared website. Link is below
Read more at geared.net.au/products....