PLEASE HELP ME TO ANSWER THEM ALL CORRECTLY PLS. FOR AN UPVOTE AND POSITIVE RATINGS. THANK U. Activity 2. Spread my SalaryDirection: Using the spreadsheet, compute for the corresponding contributions of thefollowingemployees. Compute also their total deduction. (Show the formula)FINCOMEDEDUCTIONSSSSPHILHEALTH PAGIBIGTAXTotalBasic MonthlySalaryNameDeductions34%1.50%2%12%4 Magpayo, LynS Quiambao, Jhaz6 Cruz, Russel7 Garcia, Geth8 Nicdao, Maine9 Mendoza, Rhoda0 Mallari, Tes1 Santos, Paula2 Urbano, JaneenP20,000.00P25,000.00P30,000.00P40,000.00P45,000.00P50,000.00P55,000.00P60,000.00P65,000.00

Formula: Total deductions = SSS + Phil Health + Pagabig + Tax

Direction: Using the spreadsheet, compute for the corresponding contributions of the followingemployees. Compute also their total deduction. (Show the formula) A INCOME DEDUCTIONS Basic Monthly Sss PHILHEALTH PAGIBIG TAX Total Name Deductions

Direction: Using the spreadsheet, compute for the corresponding contributions of the followingemployees. Compute also their total deduction. (Show the formula) A INCOME DEDUCTIONS Basic Monthly Sss PHILHEALTH PAGIBIG TAX Total Name Deductions

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: Determine the tax liability, marginal tax rate, and average tax rate (rounded to two decimal places)…

A: Tax Schedule Used:

Q: According to the tax legislation, there are two main types of tax statuses regulated on the basis of…

A: Data given: Income Scales (TRY) Rate (%) Up to 14,800 15 14,801 - 34,000 20…

Q: Consider the following data extracted from an after-tax cash flow calculation. Before-Tax-and-Loan =…

A: Taxes are to be paid as per the applicable tax rate on the Taxable Income of any organization.…

Q: Use the Tax Rate Tables, Exhibit 18-3, to calculate the tax liability (in $) for the taxpayer. Name…

A: Income tax liability means every individual should pay taxes to government on amount of income…

Q: Consider the following data for 2019 from an after tax cash flow analysis.What is the after tax cash…

A: After tax cash flow: It can be defined as the cash generated by a business from its main operations…

Q: 3. What percent of the Nation's Income does the Total Tax Revenue represent?

A: Note: As Nation Income is not Given in question so we are taking Examples for Nation's Income.

Q: The following information applies to the questions displayed below.] Arndt, Inc. reported the…

A: please like the answer your response matters Requirement-1: a. Casualty insurance expense…

Q: consider the following accounts and determine if the account is a current liability, a noncurrent…

A: The balance sheet is the statement of financial position of the business.

Q: Calculating Social Security and Medicare Taxes Assume a Social Security tax rate of 6.2% is applied…

Q: calculate net income after the cooperate income tax is paid for quarter 2 from the following income…

A: Net income is the net profit or loss left after paying all expenses and allowances for an accounting…

Q: With the following data, compute the NET FUTA Tax. Gross FUTA Tax DUE $ 6,750 Credit against…

A: FUTA stands for Federal Unemployment Tax Act. This tax is imposed on employers whose employees leave…

Q: Procedure and Analysis: 1. For taxable incomes of $100,000 or less, the 1040 Forms & Instructions…

A: The income tax is the amount of tax to be paid on the taxable income and it is a liability until…

Q: This year AB Company has each of the following items in its income statement. Part A. Gross…

A: Deferred taxes are treated as per the Income Tax Rules. Deferred tax is a liability that is a tax…

Q: Calculate the Social Security and Medicare taxes for the following situations: If required, round…

A: Taxation is defined as the act which levies the tax upon the income earned by the taxpayer either…

Q: Use the Tax Rate Tables, Exhibit 18-3, to calculate the tax liability (in $) for the taxpayer. Name…

A: For Year 2020 Head of Household 0 to $14100 10% tax 14101 to 53700 12% tax 53701 to 85500…

Q: For the year ended December 31, 2021, THREE Company reported pre-tax financial income of P7,500,000.…

A: Deductible Temporary difference = Pretax financial income - Taxable income = 7500000-6500000 =…

Q: Calculate Social Security taxes, Medicare taxes, and FIT for Jordon Barrett. He earns a monthly sala…

A: In the given case, Jordan Barrett has a monthly salary of $12,900, he is single and claims 1…

Q: Round your intermediate computations to nearest whole dollar. Calculate the amount of itemized…

A: Solution:- Given, Stuart and Pamela Gibson file a joint return reflecting AGI of $350,000.

Q: Priceton Salary income is $ 150000, STCG is $ 320000, Tax@20 % , Exemption from Income $ 170000…

A: Formula: Tax amount = Taxable income x Tax rate

Q: You have the following data: The net income after tax is 42000 OMR and income tax is 3000 OMR.…

A: Net income means the profit earned from sale of goods or services after deducting all expenses…

Q: Part A: This year, Gumowski Company has each of the following items in its income statement. 1.…

A: Since the student has posted multiple questions, we will answer only the first two.

Q: Compute for the tax due in each of the following cases. Show your computation and highlight your…

A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Q: With the following data, compute the NET FUTA Tax. Gross FUTA Tax DUE $6,750 Credit against FUTA…

A: Formula: Net FUTA tax = Gross FUTA tax due - Credit against FUTA

Q: Select the correct order of the line items listed below based on the sequence of their appearance on…

A: Form US 1040 is used by the residents of the US to file an income tax returns. The form calculates…

Q: With the following data, compute the NET FUTA Tax. Gross FUTA Tax DUE $ 6,750 Credit against FUTA…

A: Formula: Net FUTA tax = Gross FUTA tax due - Credit against FUTA

Q: Consider the following accounts and determine if the account is a current liability, a noncurrent…

A: Introduction: Current Liability: These also called as Short term liabilities. Which are in due and…

Q: weekly paycheck using the percentage method tables. Click the icon to view the IRS Table for…

A: Federal Tax withholding: It is the amount which is withheld from the wages of the employees which is…

Q: Use compute the income tux oved by the followrng Sing al male me the 2016 Marginal tax netes to…

A: The question is based on the concept marginal tax calculation for single status as per 2016. Tax…

Q: Required: For the taxation year ending December 31, 2020, calculate the maximum CCA that can be…

A: CCA- The capital cost allowance, that is the deduction allowed by the taxation authorities of Canada…

Q: Calculate the net income after tax

A: Net profit is also called the profit available to the shareholders or Profit available after meeting…

Q: peg. on to view the additional information.) e Income and Part I Federal Tax Payable for the Sebago…

A: Taxable income refers to the total sum of money earned by an entity that is subject to the mandatory…

Q: and ing taxes jointly. They have a gross income of 158,075, and they made the following tax-dec…

A: Income tax refer to the percentage of tax amount mandatorily imposed by the authoritative government…

Q: Complete the table below, and use the space provided in typing your answer. For PhilHealth…

Q: Base price Tax paid

A: Base price = Amount paid including tax * 100/(1 + Tax rate)

Q: Wage-bracketed tax tables are: Select one: Charts that list all of the deductions and credits…

A: Wage bracketed tax tables are charts that provide the amount to be deducted for income taxes based…

Q: Using the graduated tax table, compute the income tax due and/or income tax payable (refundable) of…

A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and…

Q: The following table shows tax due for the given taxable income level for a single taxpayer. Taxable…

A: Step wise detail is attached.

Q: Determine from the tax table provided the amount of the income tax (before any credits) for each of…

A: Introduction:- A taxpayer is a person or entity (such as a business) that is required to pay tax.…

Q: (To help answer this question, create an Income Taxes Payable T-account and insert the beginning…

A: Income tax payable is a type of account in the current liabilities section of a company's balance…

Q: The following case is applicable to 4 consecutive questions: Nueva Ecija Company received a bill for…

A: SOLUTION VAT IS THE CONSUMPTION TAX ASSESSED ON THE VALUE ADDED ON GOODS AND SERVICES.

Q: Find the amounts that are missing from this summary of an income tax return: a. Gross income $42,685…

A: Missing amounts in the summary of income rax return:- Adjusted gross income= Gross income+…

Q: With the following data, compute the NET FUTA Tax. Gross FUTA Tax DUE $ 6,750 Credit against…

A: FUTA Tax :— It is payroll tax imposed on wages of employees in United States to help fund the…

Q: Use the Tax Rate Tables, Exhibit 18-3, to calculate the tax liability (in $) for the taxpayer. Name…

A: Given that, filing status = head of the household Total taxable income = $185300 The given…

Q: Which of the following would be included in the journal entry to record the payment of accrued sales…

A: Journal Entry: Journal entry is the act of keeping records of transactions in an accounting journal.…

Q: Calculating Social Security and Medicare Taxes Assume a Social Security tax rate of 6.2% is applied…

A: Social security tax rate = 6.2% subject to maximum earnings of $ 118500 Medicare tax rate = 1.45% (…

Question

100%

PLEASE HELP ME TO ANSWER THEM ALL CORRECTLY PLS. FOR AN UPVOTE AND POSITIVE RATINGS. THANK U.

Activity 2. Spread my Salary
Direction: Using the spreadsheet, compute for the corresponding contributions of the
followingemployees. Compute also their total deduction. (Show the formula)
F
INCOME
DEDUCTIONS
SSS
PHILHEALTH PAGIBIG
TAX
Total
Basic Monthly
Salary
Name
Deductions
3
4%
1.50%
2%
12%
4 Magpayo, Lyn
S Quiambao, Jhaz
6 Cruz, Russel
7 Garcia, Geth
8 Nicdao, Maine
9 Mendoza, Rhoda
0 Mallari, Tes
1 Santos, Paula
2 Urbano, Janeen
P20,000.00
P25,000.00
P30,000.00
P40,000.00
P45,000.00
P50,000.00
P55,000.00
P60,000.00
P65,000.00

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions

Assume an employee has a gross pay of $500 and vacation pay is paid out at 4%. How much extra gross pay does the employee receive on their paycheque? Select one: a. $500 O b. $0 c. $20 d. $480
1. Create the following spreadsheet 'Payroll' below. Add a new column Net Pay and calculate the net pay for each student. At bottom calculate Average, MAX, MIN (do not use these three items for graph). PAYROLL FOR THE WEEK ENDING JUNE 30 ID ΕMPLOYEΕ NAME HOURLY RATE HOURS WORKED NUMBER 110 FORD 7.89 37.00 111 MINO 8.00 50.00 112 BELL 7.50 34.50 113 AARON $ 9.00 47.50 114 DAVIS 11.00 36.00 115 TURRO $ 10.50 45.00 2. Use the data on the payroll spreadsheet to create a column graph that shows the net pay for all employees. (Include employee names). 3. Insert the column chart onto your spreadsheet under your data. %24 %24 %24 %24
1) the total equal to part 1 is $5,924, calculate what percent of your monthly take-home salary you spend each of your monthly expenses show your work below add these percentages to the third column of the table.
PRACTICAL EXERCISE 1.4 A Payroll consists of Basic Pay, Allowances, Gross Salary, Deduction ang Net Salary. The Allowances are 23% of the Basic Pay while the Deduction are 12% of the Gross Salary. In the given worksheet, indicate in each cell what will be inserted, that is a value or a formula. In the case of a formula, write down the formula in the cell. A E F Stationery Supplies Ltd Deductions Net Salary 3. Name Basic Allowances Gross Рay Salary 4 Lewis Francis Edwin 13 Totals 4
2. Calculate the EI and CPP for the following employees. Find the employer portion as well. a. Biweekly salary of 2000 b. Weekly salary of 1100
3. Complete the table. Round all amounts to the nearest dollar. Approximate Net Pay as Percent of Gross Pay Approximate Net Earnings Per Week Weekly Earnings Hours Per Hourly Wage Week a) $12.55 40 b) $20.25 35 -shirt. J.3 Understanding Incentives • MHR 75
he journal entry to record the payroll from Figure 6.1, on pages 6-2 and 6-3, would be: Debit Credit Wages Expense 24,762.70 FICA Taxes Payable—OASDI 1,535.29 FICA Taxes Payable—HI 359.06 FIT Payable 3,714.00 SIT Payable 55.25 Group Insurance Payments W/H 54.70 Cash 19,044.40 Example 6-7 The journal entry to record the payroll tax entry from Figure 6.1 on pages 6-2 and 6-3 would be (assume a SUTA tax rate of 3.0%): Debit Credit Payroll Taxes 2,785.81 FICA Taxes Payable—OASDI 1,535.29 FICA Taxes Payable—HI 359.06 FUTA Taxes Payable 148.58 SUTA Taxes Payable 742.88 a. Cal Ruther, an employer, is subject to FICA taxes but exempt from FUTA and SUTA taxes. During the last quarter of the year, his employees earned monthly wages of $9,600, all of which is taxable. The amount of federal income taxes withheld each month is $1,250. Journalize the payment of wages, and record the payroll tax on November 29. For a compound…
Gross Income Compute how much will be included and excluded in the gross income given the following scenarios. 1. A call center agent receiving a monthly salary of P21,000 with mandatory annual deductions of P15,166, which includes SSS, PhilHealth, and Pag-Ibig contributions. What will be the amount for his annual gross income?
Use the table to calculate the total retirement savings of each employee based on the following instructions. - In column D write an IF function that uses the contribution guidelines noted in the general information section (customers over 30 years of age and up = 7% all others 5%) and customer age (column B) to calculate each monthly contribution value in column D. Format the results using accounting number format. - In column E Calculate the total savings at retirement based on the quarterly percentage rate (QPR) of 1.25% and the precalculated monthly contributions based on the prior step. Format the results using accounting number format.
Use (a) the percentage method and (b) the wage-bracket method to compute the federal income taxes to withhold from the wages or salaries of each employee. Enter all amounts as positive numbers. Round your calculations and final answers to the nearest cent. Amount to BeWithheld Employee MaritalStatus No. of WithholdingAllowances Gross Wageor Salary PercentageMethod Wage-BracketMethod Corn, A. S 2 $675 weekly $fill in the blank 1 $fill in the blank 2 Fogge, P. S 1 1,960 weekly fill in the blank 3 Felps, S. M 6 1,775 biweekly fill in the blank 5 fill in the blank 6 Carson, W. M 4 2,480 semimonthly fill in the blank 7 fill in the blank 8 Helm, M. M 9 5,380 monthly fill in the blank 9
Complete the following table. Note: Round your "gross pay" to the nearest cent. Employee Donna Swan Monday Tuesday Wednesday Thursday Friday 5 8 12 9 6 Hours Rate per hour $ 9.75 Gross pay
Calculate Little Pear Administration Pty Ltd’s superannuation expense for the month of September using the following information: (Show your workings for superannuation). For month of September Employee Salary Annual Leave Sick Leave Overtime Allowance Superannuation (Show your workings) David Reed $6,100 $469 $300 $600 $180 dry cleaning Carol Wright $3,732 - $144 $250 $50 first aid Debra Foy $2,180 - - $445 - Michael Green $4,920 $378 - - $250 car allowance John Mills $11,600 $892 $446 $125 $350 travel allowance Peter Black $400 - $15 - - Total