You have just accepted your first full-time job as assistant manager. You will be earning a salary of $625 per week. That sounds like a lot of money, but you know there will be deductions from your paycheck, such as federal income tax, Social Security tax, and medical insurance. Let’s find out how much you will actually make. 1.You are single and claim no allowances. How much is deducted from your weekly paycheck for federal income taxes?

2.Your state tax income rate is 4.2% on all gross income. How much is deducted from your weekly paycheck for state income taxes?

3.Your local tax rate is 2.1% on all gross income. How much is deducted from your weekly paycheck for local tax?

4.Social security tax is deducted at the standard rate of 6.2%. How much will you pay into Social Security each week?

5.Medicare is deducted at the standard rate of 1.45% on all earnings. How much will your pay into Medicare each week?

6.You know it’s a good idea to have medical insurance. Since your employer is offering to pay 70% of the annual cost, you decide to participate in the company’s plan. If the plan has an annual cost of $4000, how much is deducted from your weekly paycheck for your share of the medical plan?

7.Given all of the above deductions, what will your net pay be each week?

Can anyone answer the 7 question with a spread sheet or answer all 7 questions another way