Spreadsheet: 862270d1710011201-how-to-apply-a-row-calculation-up-to-a-limit-threshold-and-caps-v1-andymatt-
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Income Tax Bands
 |  |  |  |  |  |  |  |  |  |  |  |  |  | From | To | Tax Rate
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 125900 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 125900.01 | 1000000 | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000000.01 |  | 0.3
 |  |  |  |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
Income (Mexican Dollars) |  |  |  |  | 680000 | 680000 | 680000 | 680000 | 680000 | 680000 | 680000 | 680000 | 680000 | 680000 | 680000 | 680000 | 8160000
Social Security Contributions |  |  |  |  | 10625.488 | 10370 | 10370 | 10370 | 10370 | 10370 | 10370 | 10370 | 10370 | 10370 | 10370 | 10370 | 124695.488
Taxable Income |  |  |  |  | 669374.512 | 669630 | 669630 | 669630 | 669630 | 669630 | 669630 | 669630 | 669630 | 669630 | 669630 | 669630 | 8035304.512
Income Tax Due
Total Deductions
Salary After Tax
Employer Social Security Contributions |  |  |  |  | 91597.56700000001 | 36810.37 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 165369.3370000001
Cost of Employment
 | Threshold | [NAME] | Rate
Employee Solcial Security Contributions
Work Risk Insurance |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Disease and Maternity Insurance |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Disease and Maternity Insurance Surplus Fee | 113523 |  | 0.004 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32185.908
Disablement and Life Insurance |  | 709.58 | 0.00625 |  |  |  |  |  |  |  |  |  |  |  |  |  | 709.58
Retirement for Old Age | 113532 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Retirement Advanced Age Severeance |  |  | 0.01125 |  |  |  |  |  |  |  |  |  |  |  |  |  | 91800
Nursery and Social Benefits |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
INFONAVIT (National Worker's Housing Fund Institute |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | 10625.488 | 10370 | 10370 | 10370 | 10370 | 10370 | 10370 | 10370 | 10370 | 10370 | 10370 | 10370 | 124695.488
Employer Solcial Security Contributions
Work Risk Insurance |  |  | 0.0054355 |  |  |  |  |  |  |  |  |  |  |  |  |  | 44353.68
Disease and Maternity Insurance |  | 7720.18 | 0.204 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7720.18
Disease and Maternity Insurance Surplus Fee | 113523 | 10407.1 | 0.011 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10407.097
Disablement and Life Insurance |  | 16556.75 | 0.0175 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16556.75
Retirement for Old Age |  | 18922 | 0.02 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18922
Retirement Advanced Age Severeance |  | 10643.63 | 0.01125 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10643.63
Nursery and Social Benefits |  | 9461 | 0.01 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9461
INFONAVIT (National Worker's Housing Fund Institute |  | 47305 | 0.05 |  |  |  |  |  |  |  |  |  |  |  |  |  | 47305
 |  |  |  |  | 91597.56700000001 | 36810.37 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 165369.337
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 2265.908 | 2720 | 2720 | 2720 | 2720 | 2720 | 2720 | 2720 | 2720 | 2720 | 2720 | 2720
 |  |  |  |  | 709.58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 7650 | 7650 | 7650 | 7650 | 7650 | 7650 | 7650 | 7650 | 7650 | 7650 | 7650 | 7650
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14 | 3696.14
 |  |  |  |  | 7720.18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 6231.246999999999 | 4175.85 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 11900 | 4656.749999999998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 13600 | 5322 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 7650 | 2993.629999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 6800 | 2661 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 34000 | 13305 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0