This topic contains a solution. Click here to go to the answer
« previous next »

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

V@ndy87

  • Hero Member
  • *****
  • Posts: 571
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


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

nguyenhoanhat

  • Sr. Member
  • ****
  • Posts: 332
Reply #1 on: Jun 24, 2018
Answer to Question 1

B

Answer to Question 2

D


V@ndy87

  • Member
  • Posts: 571
Reply 2 on: Jun 24, 2018
Gracias!

alexanderhamilton

  • Member
  • Posts: 334
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

The calories found in one piece of cherry cheesecake could light a 60-watt light bulb for 1.5 hours.

Did you know?

The human body produces and destroys 15 million blood cells every second.

Applying the FITT Principle to Each Exercise Component of Health-Related Physical Fitness Applying the FITT Principle to Each Exercise Component of Health-Related Physical Fitness
A dual turbocharger system installed on a small block Chevrolet V-8 engine. A dual turbocharger system installed on a small block Chevrolet V-8 engine.
How to calculate simple interest (Part 3) How to calculate simple interest (Part 3)
Population and Community Health Nursing, 6th Edition Population and Community Health Nursing, 6th Edition
A company that makes environmental measuring devices has calculated their revenue and costs as ... A company that makes environmental measuring devices has calculated their revenue and costs as ...
Benefits and costs of herbicide applications Benefits and costs of herbicide applications
Video: Brain Anatomy Animation (Part 1 of 2)

For a complete list of videos, visit our video library