Question: i need the formulas for the missing values thank you! The company has a 401k program. If an employee has worked for the company 2

i need the formulas for the missing values thank you!

The company has a 401k program. If an employee has worked for the company 2 years or more they have their annuat salary time the match in R 19 Put a formiula in M14.M113 that calculates the value of the 401 contribution based on columns K and 1 and the value in R19. If any of the values change the formula needs to still work correctly. Put a formula in N14.N113 that caluclates the employees bonus values based on the values in R14:R113 and the and tanges in 014:Q17. Put a formula in 014:0113 to dispalay Health Cost by taking the employees selection in column I for a health plan and looks up the Monthly Premium in V24:V26 based on the name in 024:U26 matchine the value in column J. The company has a 401k program. If an employee has worked for the company 2 years or more they have their annuat salary time the match in R 19 Put a formiula in M14.M113 that calculates the value of the 401 contribution based on columns K and 1 and the value in R19. If any of the values change the formula needs to still work correctly. Put a formula in N14.N113 that caluclates the employees bonus values based on the values in R14:R113 and the and tanges in 014:Q17. Put a formula in 014:0113 to dispalay Health Cost by taking the employees selection in column I for a health plan and looks up the Monthly Premium in V24:V26 based on the name in 024:U26 matchine the value in column J

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

the company has a 401k program. if an employee has worked for the company 2 years or more they have their annual salary time the match in R 19. put a formula in capital M14: M113 that calculates the...

the text in red is what we have to figure out. please help pribi service as of 7/1/2013 Man Monkiv Premion 1 The compary has a 401K propram. If an employe has worked for the company 2 vears or mote...

The company has a 401K program. If an employee has worked for the company 2 years or more they have their annual salary time the match in R19. Put a formula in M14:M113 that calculates the value of...

Employee Turnover Analytics Project Statement: Portobello Tech is an app innovator who has devised an intelligent way of predicting employee turnover within the company. It periodically evaluates...

How can you summarize the compensation and reward system of the three organizations? What do they all have in common, if anything? Look up everything you can find that has been written about Lincoln...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

Pretty simple just answer the questions below its only 2 of them attached are the reference materials you'll need to site apa style format from Chapter 11: 11.2 #2 (p. 276) Also answer this question...

). For this question, refer to the article The Inside Story of Wawa The manager of a newly opened store asks you to advise her on an optimal pricing scheme for specialty sandwiches, signature...

Assignment 5 - Interactive Forms using JavaScript This assignment will show you how to make the HTML form your created last week interactive by adding in JavaScript. It will calculate the correct...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Prepare the complete audit report with corresponding recommendations on the above findings cited in the case. Mr. Ahmed leader auditor of D&Z Accounting and auditing Firm together with his team:...

By the second decade of the 19th century Thomas Jefferson wrote that slavery would be a permanent institution on the American landscape The French were preparing to mount an attack on New Orleans The...

which type of audit test would utilize the white - box approach

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...