Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, I need help coming up with an equation for this question inside the excel sheet please. Home Insert Draw Comments Arial Page Layout 10

image text in transcribedHi, I need help coming up with an equation for this question inside the excel sheet please.

Home Insert Draw Comments Arial Page Layout 10 A Formulas Data Review View AA = = = D E General D E Insert Delete Format Share A- 49- O ur? Sort & Find & X Filter Select 4 E $% 88 0 70 Ideas Formatting as Table Styles Paste 3 (23 BIU v fx x | L | M N O P Q R S T U | 1 Human Resources provides free term life insurance to its employees. The Insurance comes in $1,000 2 units. Thus, an individual's free life insurance is equivalent to one year's earnings rounded DOWN to the nearest 3 $1,000 of salary. The cost of the insurance is a function of each employee's age as indicated in the table below 4 Calculate the cost to the company of providing this insurance to each employee. Use a HLOOKUP function and format 5 the cost in dollars with zero decimals. For example, a 38-year old employee with a base salary of $35,700 would 6 be entitled to 35 units of $1,000 each) at a cost of $10.53 per unit, or a total cost of $369 No. of $1,000 units of Life Insurance Base Salary Total Cost for Units of Insurance Age 34.500 10 Doe, John 11 Garza. Esperanza 12 Hamandez, Joey 42.000 39.600 14 Smith, Sammy 49,500 15 16 17 Age 18 Cast per $1,000 unit of Insurance 17 8.34 18 8.34 19 8.34 20 8.34 21 8.34 22 8.34 23 8.34 24 8.34 25 8.34 26 8.34 27 8.34 28 8.34 29 8.34 30 8.34 31 8.34 32 8.34 33 8.81 34 .95 35 .31 8.34 8 9 19 Problemi Problem2 Problem3 +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions