I require an excel based calculator to determine tax advantages of debt-recycling in Australia. I have a debt recycling calculator already but it requires modificiation. My calculator will be provided to the successful applicant and should do most of the calculations already.
Debt recycling is the process of paying off non-deductible interest (i.e. home loan) as soon as possible by capitalising or raising deductible interest (i.e. investment property) in other lines of credit.
I require a user friendly front sheet in the excel calculator that asks for relevant inputs and produces the following outputs:
1. Net position using debt-recycling
2. Net position without using debt-recycling
3. Difference between 1. and 2. as money saved.
4. A graph that plots the difference in 3 over time.
It will also require the following functionality:
1. Ability to produce different outputs for different time frames (up to 10 years)
2. Ability to tailor outputs to up to 10 investment properties (plus principal place of residence).
3. (already in) Ability to amend output based on input of single/dual incomes.
4. (although this is already built in) the outputs are to take account of different tax rates due to taxable income.
Put simply I'd like a sleek GUI in the excel spreadsheet that will produce easy to input and easy to understand output.
There is scope for more work in the future for right applicant.