Activity 1. Pay Sheet Direction: Indicate the needed formula in solving for the specified cell by completing the statements below. Write your answers on your answer sheet. A B 14 EY EL PI COMPANY 02/14/2020 15 16 17 Name: Bianca U. Guevarra 18 Employee Number : 014344 19 Employment Status: Regular 20 21 GSIS Personal Share 22 PHILHEALTH 23 PAGIBIG Fund 24 BIR Withholding Tax 25 Total Deduction: 26 NET PAY: Pay Slip Month of February 2020 Basic Salary: P50,000.00 P1,500.00 Allowance: Gross Compensation: 1. DEDUCTIONS 9% 2. 1.50% 3. P100.00 to m P5,329.16 4. 5. 1. In F19, press_ then enter to solve for the gross compensation. 2. In press =E21*F17 or =E21*.09, then enter to solve for GSIS share 3. In F23, press_ 4. Press. 5. For net pay, press. to solve for. _to compute for the total deduction. Lon cell in cell
Activity 1. Pay Sheet Direction: Indicate the needed formula in solving for the specified cell by completing the statements below. Write your answers on your answer sheet. A B 14 EY EL PI COMPANY 02/14/2020 15 16 17 Name: Bianca U. Guevarra 18 Employee Number : 014344 19 Employment Status: Regular 20 21 GSIS Personal Share 22 PHILHEALTH 23 PAGIBIG Fund 24 BIR Withholding Tax 25 Total Deduction: 26 NET PAY: Pay Slip Month of February 2020 Basic Salary: P50,000.00 P1,500.00 Allowance: Gross Compensation: 1. DEDUCTIONS 9% 2. 1.50% 3. P100.00 to m P5,329.16 4. 5. 1. In F19, press_ then enter to solve for the gross compensation. 2. In press =E21*F17 or =E21*.09, then enter to solve for GSIS share 3. In F23, press_ 4. Press. 5. For net pay, press. to solve for. _to compute for the total deduction. Lon cell in cell
Chapter20: Corporations And Parterships
Section: Chapter Questions
Problem 27CE
Related questions
Question
100%
PLEASE ANSWER THEM ALL CORRECTLY FOR AN UPVOTE AND POSITIVE RATINGS.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Individual Income Taxes
Accounting
ISBN:
9780357109731
Author:
Hoffman
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Individual Income Taxes
Accounting
ISBN:
9780357109731
Author:
Hoffman
Publisher:
CENGAGE LEARNING - CONSIGNMENT