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 121 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
Thanks for the timely response, appreciate it

AngeliqueG

  • Member
  • Posts: 343
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

The effects of organophosphate poisoning are referred to by using the abbreviations “SLUD” or “SLUDGE,” It stands for: salivation, lacrimation, urination, defecation, GI upset, and emesis.

Did you know?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

Digestion and absorption of carbohydrates in the small intestine. Digestion and absorption of carbohydrates in the small intestine.
Increasing Costs of Natural Disasters Increasing Costs of Natural Disasters
Mucosal surface of the small intestine. Mucosal surface of the small intestine.
How to calculate monthly payments at varying amortization periods (Question 3) How to calculate monthly payments at varying amortization periods (Question 3)
How Health Interacts with Income How Health Interacts with Income
Lakeridge Health Oshawa is a 423 beds hospital with 463 doctors and 4058 staff comprised of ... Lakeridge Health Oshawa is a 423 beds hospital with 463 doctors and 4058 staff comprised of ...
Video: Decubitus Ulcer

For a complete list of videos, visit our video library