Scribd Logo
Upload

Welcome to Scribd!

  • 72 views

    Tax Calculator Formula

    Uploaded by

    Taeeeee tae
    This document provides information and calculators for computing Philippine taxes, including a tax calculator, SSS/PhilHealth/Pag-IBIG contribution calculator, and tax tables. The document shares the template and formulas to allow users to understand and create their own tax calculators. Credits are given to the owner of the original template for sharing the framework.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Tax Calculator Formula

    Uploaded by

    Taeeeee tae
    72 views5 pages
    This document provides information and calculators for computing Philippine taxes, including a tax calculator, SSS/PhilHealth/Pag-IBIG contribution calculator, and tax tables. The document shares the template and formulas to allow users to understand and create their own tax calculators. Credits are given to the owner of the original template for sharing the framework.

    Original Title

    TAX CALCULATOR FORMULA.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides information and calculators for computing Philippine taxes, including a tax calculator, SSS/PhilHealth/Pag-IBIG contribution calculator, and tax tables. The document shares the template and formulas to allow users to understand and create their own tax calculators. Credits are given to the owner of the original template for sharing the framework.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    72 views5 pages

    Tax Calculator Formula

    Uploaded by

    Taeeeee tae
    This document provides information and calculators for computing Philippine taxes, including a tax calculator, SSS/PhilHealth/Pag-IBIG contribution calculator, and tax tables. The document shares the template and formulas to allow users to understand and create their own tax calculators. Credits are given to the owner of the original template for sharing the framework.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    TRAIN LAW TAX CALCULATOR

    Effective January 1, 2018 to December 31, 2022


    INSTRUCTION: Input amounts in the Monthly Basic Salary field
    & other fields that apply.

    REMARKS *Basic Salary


    I JUST WANTED TO GIVE YOU THE IDEA AND FREEDOM Taxable Allowances
    HOW TO MAKE THIS TAX CALCULATOR ON YOUR OWN Overtime Pay
    Night Differential
    THIS IS NOT THE SAME FORMULA WITH THE OWNER I JUST USE Holiday Pay
    THE TEMPLATE SO THAT IT IS EASIER FOR YOU TO UNDERSTAND GROSS INCOME
    AND MAKE YOUR OWN TEMPLATE IN NEAR FUTURE
    SSS Contribution

    FCJ EXCEL MAGIC PhilHealth Contribution


    PagIBIG Contribution
    HMO
    Absences
    Tardiness
    Undertime
    TOTAL DEDUCTIONS
    CREDITS TO THE OWNER OF TEMPLATE

    NOTE: THE FORMULA USE IN THIS TEMPLATE IS DIFFERENT FROM


    THE OWNER I JUST MAKE MY OWN FORMULA TO SHOW YOU HOW
    TO LINK THE VALUES TAXABLE INCOME

    WITHHOLDING TAX
    REMARKS

    SHARING YOU THE FORMULA BY: FERNANDO CRUZ JR :) NET INCOME


    TAX CALCULATOR

    SEMI-MONTHLY MONTHLY

    - -

    - -

    - - -

    - -
    - -

    - -

    - -

    - -
    EXEMPT EXEMPT
    - -
    - -
    SSS/PhilHealth/Pag-IBIG CONTRIBUTION CALCULATOR
    Input your monthly salary credit.

    Monthly Salary (input amount in monthly *Basic Salary) -

    Employee SSS Contribution -


    Employer SSS Contribution -
    TOTAL CONTRIBUTION -

    Employee PhilHealth Contribution -


    Employer PhilHealth Contribution -

    TOTAL CONTRIBUTION -

    Employee Pag-IBIG Contribution -


    Employer Pag-IBIG Contribution -
    TOTAL CONTRIBUTION -
    TAX TABLE Effective January 1, 2018 to December 31, 2022

    Semi-Monthly Rate Monthly Rate


    - - - - - -
    10,417.00 - 0.20 20,833.00 - 0.20
    16,667.00 1,250.00 0.25 33,333.00 2,500.00 0.25
    33,333.00 5,416.67 0.30 66,667.00 10,833.33 0.30
    83,333.00 20,416.67 0.32 166,667.00 40,833.33 0.32
    333,333.00 100,416.67 0.35 666,667.00 200,833.33 0.35
    IMPORTANT: Do not delete or alter this schedule so as not to distort the tax calculator.

    SSS Contribution Schedule


    1,000.00 36.30 83.70 110.00
    1,250.00 54.50 120.50 165.00
    1,750.00 72.70 157.30 220.00
    2,250.00 90.80 194.20 275.00
    2,750.00 109.00 231.00 330.00
    3,250.00 127.20 267.80 385.00
    3,750.00 145.30 304.70 440.00
    4,250.00 163.50 341.50 495.00
    4,750.00 181.70 378.30 550.00
    5,250.00 199.80 415.20 605.00
    5,750.00 218.00 452.00 660.00
    6,250.00 236.20 488.80 715.00
    6,750.00 254.30 525.70 770.00
    7,250.00 272.50 562.50 825.00
    7,750.00 290.70 599.30 880.00
    8,250.00 308.80 636.20 935.00
    8,750.00 327.00 673.00 990.00
    9,250.00 345.20 709.80 1,045.00
    9,750.00 363.30 746.70 1,100.00
    10,250.00 381.50 783.50 1,155.00
    10,750.00 399.70 820.30 1,210.00
    11,250.00 417.80 857.20 1,265.00
    11,750.00 436.00 894.00 1,320.00
    12,250.00 454.20 930.80 1,375.00
    12,750.00 472.30 967.70 1,430.00
    13,250.00 490.50 1,004.50 1,485.00
    13,750.00 508.70 1,041.30 1,540.00
    14,250.00 526.80 1,078.20 1,595.00
    14,750.00 545.00 1,135.00 1,650.00
    15,250.00 563.20 1,171.80 1,705.00
    15,750.00 581.30 1,208.70 1,780.00
    YEARLY
    - -
    250,000.00 -
    400,000.00 30,000.00
    800,004.00 130,000.00
    2,000,004.00 490,000.00
    8,000,004.00 2,410,000.00

    You might also like