Sandy gross pay and net pay

Assignment Help Finance Basics
Reference no: EM131401856

You are the payroll manager at Widgets R Us. You need to calculate an employee's gross and net pay based on the table below. Sandy worked overtime this past week and would like to know what her gross and net pay will be. Your job is to calculate this using the following data.Note: The company policy is that she is entitled to time and a half for any hours worked over 40.Using Excel, calculate Sandy's gross pay and net pay. You must use a function or formula.

Pay Rate: $10.00/Hour

Federal Tax Rate: 20%

Hours Worked: 50

State Tax Rate: 10%

FICA 5%

Sandy's Gross Pay

Sandy's Net Pay

Reference no: EM131401856

Questions Cloud

How much is the car worth today : Your car lease requires a down payment of $1,500 and payments of $450 per month for 36 months. The APR is 6% compounded monthly and payments are made at the end of the month. At the end of the lease, you have the option to buy the vehicle for $20,..
Present value and multiple cash flows : Investment X offers to pay you $4,700 per year for eight years, whereas Investment Y offers to pay you $6,700 per year for five years. Which of these cash flow streams has the higher present value if the discount rate is 5 percent? If the discount..
Is diet or exercise effective in combating insomnia : Is diet or exercise effective in combating insomnia?- Some believe that cutting out desserts can help alleviate the problem, while others recommend exercise.
Describe the types of law libraries and their uses : Legal professionals widely agree that there is no single "right" path to take in conducting legal research. As such, each paralegal must devise his or her own strategy. Imagine that your supervising attorney has asked you write a report detailing ..
Sandy gross pay and net pay : Your job is to calculate this using the following data.Note: The company policy is that she is entitled to time and a half for any hours worked over 40.Using Excel, calculate Sandy's gross pay and net pay. You must use a function or formula.
What it mean to say that we live in gender binary system : What does it mean to say that we live in a gender binary system? How does the gender binary system work? What are its limitations? How can we deconstruct it
Calculate the stock price : Starting in 5 years, a stock will make a $5/share dividend payment. They will grow their dividend payments by 5% every year, forever.  R=11%. Calculate the stock price.
Develop a rhetorical structure of an essay : COR160 - Essential Academic Writing Skills - Family violence laws under review after spate of abuse cases and Evaluate information critically from various sources to respond to a task and synthesise information from various sources in writing in resp..
How things would change if organism were to be transplanted : Explain how things would change if the organism were to be transplanted to a significantly different environment: Would their organ system still be as efficient? Why or why not?

Reviews

Write a Review

Finance Basics Questions & Answers

  Has the after-tax cost gone up or down

Assume that the yield on the bonds goes up by 1 percentage point and that the tax rate is now 39%.

  Simple interest and compound interest

Illustrate out the difference between simple interest and compound interest? What are some examples of where might each be employed?

  Compute amount which you will need to deposit

You have budgeted which you will need to be capable to withdraw $2,000 per month from your account at start of each month of your holiday. The nominal interest rate on your savings account is 4.5 percent per annum compounded monthly.

  The cases hinge around illegal or unethical practices

Most of the cases hinge around illegal or unethical practices. In the Initial write-up detail the illegal or unethical behavior underlying the case chosen. Explain who sought to benefit from this behavior and who was hurt by the behavior. Provide at ..

  Evaluate the required return for an asset

Evaluate the required return for an asset with a beta of .90 when the risk-free rate and market return are 6% and 10% respectively and fine the risk-free rate for a firm with a required return of 12% and a beta of 1.25

  Define aggressive financing strategy

What is an aggressive financing strategy? What are components of aggressive finance strategies?

  Concern regarding royalty income

What is a potential concern regarding royalty income from a retiring musician that may need to be addressed? What investment class (equity, fixed income, real estate etc.) do the royalty payments mimic? Why?

  Determine the yearly dividend per share

The earnings for Crystal Cargo Corporation have been predicted for the next 5 years and are as follows. There is 1 million shares outstanding.

  Statement of cash flows for gulp-it-down coffee co

Based on the information provided below, prepare the statement of cash flows for the Gulp-it-Down Coffee Co.

  The common stock of plymouth shippers

Over the last four years, the common stock of Plymouth Shippers has had an arithmetic average return of 9.3 percent. Three of those four years produced returns of 14.1 percent, 15.6 percent, and 3.4 percent, respectively. What is the geometric av..

  What alternatives would you suggest to solve ethical dilemma

In your essay, discuss the agency problem in Enron and how the motives were originated. What alternatives and solutions would you suggest to solve this ethical dilemma?

  What are some of the common barriers to entry for a firm

What are some of the common barriers to entry for a firm entering a new country for business? How does this vary from country to country?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd