Spreadsheet: 774255d1648334752-create-a-reference-formula-impact_statement
Sheet: input

Impact Statement model |  |  | input
Last Edit: | 2022-03-10 00:00:00 |  | calculations |  | Press Ctrl+Alt+F9 to populate form
Screen | Field | [table]field | Values | Comments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | help debt | pay_cycles |  |  |  | employer [NAME] types | Concessional | Meal/Accom | Total [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021–22 repayment income thresholds and rates for HELP, SSL, ABSTUDY SSL and TSL |  |  |  | yes | Weekly | 52 |  |  | full-fbt-payable | 0 | 0
Fleet / Administration / Drivers → Contact | Pay Cycle | [gb_pay_cycles]description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | min | [NAME] | Repayment rate |  | no | Weekly2 | 52 |  |  | concessional-30000-exempt | 30000 | 5000 |  | Proposed Benefits Exceed [NAME]
Setup / Reference Data → gb_controls | Gross up rate Type 1 | [gb_controls]fbt_type1_gross_up_factor | 2.0802 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 47014 | 0 |  |  | Fortnightly | 26 |  |  | concessional-17000-exempt | 17000 | 5000 |  | Proposed Benefits Exceed [NAME]
Setup / Reference Data → gb_controls | Gross up rate Type 2 | [gb_controls]fbt_type2_gross_up_factor | 1.8868 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47014 | 54282 | 0.01 |  |  | Fortnightly2 | 26 |  |  | rebatable | 30000 | 5000 |  | Proposed Benefits Exceed [NAME]
Setup / Reference Data → gb_controls | FBT Tax Rate | [gb_controls]fbt_tax_rate | 0.47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54283 | 57538 | 0.02 |  |  | Monthly | 12 |  |  | not-applicable | 0 | 0
Setup / Reference Data → gb_controls | GST Rate | [gb_controls]gst_rate | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57539 | 60991 | 0.025 |  |  | Monthly2 (Fort) | 12
Setup / Reference Data → gb_controls | Rebatable | [gb_controls]fbt_rebate_rates | 0.47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60992 | 64651 | 0.03 |  |  | Monthly3 (Week) | 12
Fleet / Administration / Clients → Contract Defaults | Employer FBT Type | [fm_clients]employer_fbt_type |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64652 | 68529 | 0.035 |  |  | Bi-Monthly | 24
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68530 | 72641 | 0.04 |  |  | Quarterly | 4
 | HELP Debt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72642 | 77001 | 0.045 |  |  | Semi-Annual | 2
Fleet / Administration / Drivers → Contact | Salary | [fm_drivers]annual_salary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77002 | 81620 | 0.05 |  |  | Annual | 1
 | Allowances | [fm_drivers]allowances |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81621 | 86518 | 0.055 |  |  | 4-Weekly | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86519 | 91709 | 0.06 |  |  | Month-End | 12
 | Employer Superannuation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91710 | 97212 | 0.065 |  |  | Twice-Monthly | 24
 | Employee Superannuation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97213 | 103045 | 0.07 |  |  | Month-Day | 12
 |  |  | Not packaged |  | Current Package |  | New Package |  |  | HELP Debt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103046 | 109227 | 0.075
 |  |  |  |  |  |  |  |  |  | Not packaged |  | New Packaged |  | New Packaged |  |  |  |  |  |  |  |  |  |  |  |  |  | 109228 | 115781 | 0.08 |  |  | pay_cycle_billing_periods
 | Less Employee Superannuation |  |  |  |  |  |  |  | Taxable Salary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115782 | 122728 | 0.085
 |  |  |  |  |  |  |  |  | Grossed up benefit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 122729 | 130092 | 0.09 |  |  | pay cycles to determine cap
 | Less GST on EC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 130093 | 137897 | 0.095
 | Plus Employer paid GST |  |  |  |  |  |  |  | Assessible Salary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 137898 |  | 0.1
 | Less FBT Payable |  |  |  |  |  |  |  | HELP Rate
 |  |  |  |  |  |  |  |  | Annual HELP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Resident tax rates 2021–22
 | Salary Before Tax |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Packaged
 | Less Tax to be paid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | salary |  | 52
 | Less HELP to be paid
 | Net Pay
 | Employee Contribution Post Tax
 | Cost to you without packaging |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly earnings (x) less than | a | b
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 359 | 0 | 0
 |  |  |  |  | Annual Cash Benefit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 438 | 0.19 | 68.3462
 |  |  |  |  | Annual HELP Benefit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 548 | 0.29 | 112.1942
 |  |  |  |  | Annual Total Benefit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 721 | 0.21 | 68.3465
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 865 | 0.219 | 74.8369
 | Status | Addback Benefit | FBT Value | Employee Contribution | Total deductions |  | proposed deductions per pay cycle | proposed addback | proposed package ec | proposed gst payable | proposed ecm gst | proposed fbt | current package | current package | current package ec | current gst payable | current ecm gst | current package addback | current fbt | fbt payable | fbt for [NAME] | gst payable | HECS assessible current | HECS assessible new | cap assessible | gross up |  | 1282 | 0.3477 | 186.2119
Childcare | active | sp |  | 0.00 | 384.61 | 384.61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2307 | 0.345 | 182.7504
Home Office Expenses | active | sp |  | 0.00 | 23.07 | 23.07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3461 | 0.39 | 286.5965
Portable Electronic Devices | active | sp |  | 0.00 | 96.15 | 96.15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 999999 | 0.47 | 563.5196
Superannuation | active | sp |  | 0.00 | 230.76 | 230.76
Novated Lease - Salary Packaged | active | sp |  | 0.00 | 461.53 | 461.53
Administration Fee | active | sp |  | 0.00 | 24.46 | 24.46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current Package
Delete any shaded items you don't want to use in the Impact Statement i.e. one off deductions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | salary |  | 52
Monthly Packaged Items | FBT Payable? | GST Payable? | Increases HECS assessible? | Subject to cap? | Gross up rate | Monthly Sacrifice - total | Grossed up value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly earnings (x) less than | a | b
Childcare | exempt | no | yes | yes |  | 110 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 359 | 0 | 0
Home Office Expenses | exempt | yes | yes | yes |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 438 | 0.19 | 68.3462
Portable Electronic Devices | exempt | yes | yes | yes |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 548 | 0.29 | 112.1942
Superannuation | exempt | no | yes | yes |  | 110 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 721 | 0.21 | 68.3465
Novated Lease - Salary Packaged | type-1 | yes | yes | yes |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 865 | 0.219 | 74.8369
Administration Fee | exempt | yes | yes | yes |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1282 | 0.3477 | 186.2119
 |  |  | yes | yes |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2307 | 0.345 | 182.7504
 |  |  | yes | yes |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3461 | 0.39 | 286.5965
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 999999 | 0.47 | 563.5196
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Packaged
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | salary |  | 52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly earnings (x) less than | a | b
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 359 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 438 | 0.19 | 68.3462
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 548 | 0.29 | 112.1942
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 721 | 0.21 | 68.3465
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 865 | 0.219 | 74.8369
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1282 | 0.3477 | 186.2119
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2307 | 0.345 | 182.7504
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3461 | 0.39 | 286.5965
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 999999 | 0.47 | 563.5196