Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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! image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Wealth Inequality Asset Redistribution And Risk Sharing Islamic Finance

Authors: Tarik Akin , Abbas Mirakhor

1st Edition

3110583739, 3110583887, 9783110583885

More Books

Students also viewed these Finance questions