Assumptions
The inputs that drive the whole model. Percentages are stored as decimals (0.2485 = 24.85%).
Editing these recalculates every schedule, the ledger and the summary.
Save assumptions
Salary
Old annual base salary
money
New annual base salary
money
Salary increase effective date
date
Old base pay per fortnight (76h)
money
New base pay per fortnight (76h)
money
Rolled-in Rate Allowance (% of base)
percent
Base hours per fortnight
hours
Tax & levies
PAYG withholding rate
percent
ATO quarterly instalment / credit
money
Extra tax deductions (at tax time)
money
Deductions
Union fees (% of base pay)
percent
Super salary sacrifice (% of gross)
percent
Capped salary-sacrifice cap
money
Capped sacrifice per pay after cap
money
Planned capped sacrifice, pays 1-4
money
Planned capped sacrifice, pays 5-8
money
Planned capped sacrifice, pays 9+
money
Tax brackets
Resident tax threshold 1
money
Resident tax threshold 2
money
Resident tax threshold 3
money
Tax payable at threshold 2
money
Rate: threshold 1 to 2
percent
Rate: threshold 2 to 3
percent
Rate: above threshold 3
percent
Medicare levy rate
percent
Medicare levy surcharge
money
Schedule
Commence leave without pay at pay # (0=off)
int
First primary job pay date
date
First second job pay date
date
Financial year start
date
Financial year end
date
Second job
Second job hourly rate
money
Savings
Default monthly savings interest
money
Save assumptions