This sheet will distribute surchargeable contributions
between two members to give the minimum surcharge while
meeting, where possible, the super guarantee and age-based
deduction limits. Alternatively, the sheet can calculate
the surcharge for one or two members given the contribution(s)
and other input data.
Features:
Calculations take into account Super Guarantee requirements and age-based deduction limits while minimising surcharge payable between two members
Warning are provided if Super Guarantee Requirements or age-based limits are breached
Minimisation can be over-ridden if required
If minimisation is over-ridden, the difference between the surcharge calculated and the minimum surcharge is displayed
Can be used to calculate surcharge for a single member
Calculations include adjustments to taxable income to arrive at adjusted taxable income
Super Surcharge Minimiser
