Author Question: A small business owner uses an Excel spreadsheet to calculate the costs of various health insurance ... (Read 98 times)

V@ndy87 · **on:** Jun 24, 2018

A small business owner uses an Excel spreadsheet to calculate the costs of various health insurance options for her employees. The individual annual premium is in cell B5. The employers monthly contribution is in Cell D9 and the monthly cost of the family option is in cell B6. Which multimath formula should be entered in Cell E9 to calculate the monthly premium for an employee who selects the individual-only healthcare?
A) =(B5/12)+B6
B) =(B5/12)-D9
C) =B5-D9
D) =B5+B6-D9

Question 2

A barbershop suffers 65,000 in fire damage. The shop is insured for 145,000 and has a value of 225,000. There is an 80 coinsurance fire policy. How much will the insurance company pay?
A) 225,000
B) 145,000
C) 65,000
D) 52,650