Excel Calculations

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.

Evner: Regnskab, Finans

Se mere: scope for accounting, principal of accounting, income tax accounting, income in accounting, future of accounting, excel frames, calculator for accounting, accounting work in australia, accounting for income tax, tax rates, home based work without investment, income tax work, home loan, excel calculator, excel based, calculations, australia property, time sheet calculator excel, recycling spreadsheet, investment sheet, excel inputs, excel property, excel investment, gui loan calculator, excel user input gui

Om arbejdsgiveren:
( 1 bedømmelse ) Nerang, Australia

Projekt ID: #5997208

Tildelt til:


Hired by the Employer

$150 USD in 4 dage
(39 bedømmelser)