Spreadsheet: 148928d1333620127-tax-computation-tax-computation
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STATUS | BASE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z | 0 | 1 | 0 | 417 | 1250 | 2917 | 5833 | 10417 | 20833
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | 50 | 1 | 2083 | 2500 | 3333 | 5000 | 7917 | 12500 | 22917
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ME | 50 | 1 | 2083 | 2500 | 3333 | 5000 | 7917 | 12500 | 22917
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S1 | 75 | 1 | 3125 | 3542 | 4375 | 6042 | 8958 | 13542 | 23958
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S2 | 100 | 1 | 4167 | 4583 | 5417 | 7083 | 10000 | 14583 | 25000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S3 | 125 | 1 | 5208 | 5625 | 6458 | 8125 | 11042 | 15625 | 26042
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STATUS | [NAME] | value1 | EXCESS | value2 | value3 | TAX FOR A3 | TAX TOTAL |  | [NAME] | 150 | 1 | 6250 | 6667 | 7500 | 9167 | 12083 | 16667 | 27083
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 14000 | 12083 |  | 937.5 | 0.25 |  |  |  | M1 | 75 | 1 | 3125 | 3542 | 4375 | 6042 | 8958 | 13542 | 23958
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M2 | 100 | 1 | 4167 | 4583 | 5417 | 7083 | 10000 | 14583 | 25000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M3 | 125 | 1 | 5208 | 5625 | 6458 | 8125 | 11042 | 15625 | 26042
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | legend | base |  |  |  |  |  |  | M4 | 150 | 1 | 6250 | 6667 | 7500 | 9167 | 12083 | 16667 | 27083
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | needs formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXEMPTION |  | 0 | 0 | 20.83 | 104.17 | 354.17 | 937.5 | 2083.33 | 5208.33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % OVER |  | 0 | 0.05 | 0.1 | 0.15 | 0.2 | 0.25 | 0.3 | 0.32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ***COMPUTATION
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total taxable compensation                    P 14,000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Less: compensation level
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | value1 | (line ai6)                                          12,083 |  |  |  |  |  | 14000 | 12083
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Excess                                                                P 1,917
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | value2 | Tax on P12,083                                               P 937.50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tax on excess (P1,917 x 25%)                      479.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Semi-monthly withholding tax          P1,416.75