Reference no: EM13951545
1.The Orange colored cells on the worksheet indicate places where you will put in the formulas and functions.
2.Calculate the total Gross Pay for each employee. Keep in mind that employees are paid time and a half for all over-time hours. Here is an example formula that demonstrates how you would make such a calculation: =b4*d4+b4*c4*1.5 These must be formulas and will be entered into the range E11:E14.
3.In #5, #6, and #7 below you must include an absolute reference cell in each formula!!! Imagine while you are completing these steps that there were 150 employees at the company.
4.Calculate the total amount each employee must pay in Federal Taxes in the range F11:F14. These calculations must be completed using formulas. These formulas MUST contain an absolute reference to the cell holding the percentage amount. The percentage is above Federal in cell F9.
5.Calculate the total amount each employee must pay in State Taxes in the range G11:G14. These calculations must be completed using formulas. These formulas MUST contain an absolute reference to the cell holding the percentage amount. The percentage is above State in cell G9.
6.Calculate the total amount each employee must pay in Social Security Taxes in the range H11:H14. These calculations must be completed using formulas. These formulas MUST contain an absolute reference to the cell holding the percentage amount. The percentage is above Social in cell H9.
7.Calculate the total Net Pay for each employee in the range: I11:I14. These calculations must be completed using a formula.
8.Calculate the totals for all of the employee hours and pay categories in the range: B16:I16. These calculations must be completed using SUM functions.
9.Format all of the cells that represent a dollar amount as Currency with 2 decimal places.
Attachment:- IP 5 Computer.zip
|
What are the differential cash flows over the projects life
: Gammy is considering building a facility to manufacture cupcakes to distribute nationally. Your assignment involves both the calculation of cash flows associated with the new investment under consideration and the evaluation of several mutually exclu..
|
|
Response about accrual accounting
: Accrual accounting "is an accounting method that measures the performance and position of a company by recognizing economic events regardless of when cash transactions occur" (Investopedia, 2016)
|
|
Theoretical minimum number of stations
: An assembly line must be designed to produce 40 containers per hour. The following data in give the necessary information.
|
|
What is the face value of a zero coupon bond
: What is the face value of a zero coupon bond that has a yield of 8.5%, matures in 6 years, and is currently selling for $404.54? Round your answer to the nearest dollar. Show your work.
|
|
Calculate the total gross pay for each employee.
: Calculate the total Gross Pay for each employee. Keep in mind that employees are paid time and a half for all over-time hours. Here is an example formula that demonstrates how you would make such a calculation: =b4*d4+b4*c4*1.5 These must be formu..
|
|
At what contract price will you get a margin call
: On Friday, December 12, the March 2016 S&P Index futures contract (i.e., the S&P contract which expires in March of next year) closed at 2000, down 40 points on the day. The value of the contract is set at 250 × the index. How much value did each con..
|
|
What is the expected return on the market
: Assume the CAPM holds, and you are given the following values. Expected return on Malware stock = 12% What is the expected return on the market? Show your calculation.
|
|
Considering the purchase of bond due to mature
: Suppose that an investor is considering the purchase of a bond due to mature in 30 years, carrying an 8 percent coupon rate (coupons are paid semi-annually). This security is available for purchase at a current market price of $975. The bond has a pa..
|
|
Net present value and internal rate of return
: Calculate the following values for a project that requires an initial investment of $38,370 and has equal annual cash inflows of $10,000 each year for the next 8 years. Assume a cost of capital of 14%.
|