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 86 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

rachel

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

« previous next »
 

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

Eating carrots will improve your eyesight. Carrots are high in vitamin A (retinol), which is essential for good vision. It can also be found in milk, cheese, egg yolks, and liver.

Did you know?

Most childhood vaccines are 90–99% effective in preventing disease. Side effects are rarely serious.

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Multiple sclerosis (MS). (a) A disease characterized by the gradual development of small areas of ha Multiple sclerosis (MS). (a) A disease characterized by the gradual development of small areas of ha
Basic sliding effleurage using the thumb gets into the small spaces between the metatarsals of the ... Basic sliding effleurage using the thumb gets into the small spaces between the metatarsals of the ...
Guidelines for Creating Small Plates Guidelines for Creating Small Plates
How to calculate the gain and loss gene numbers with low bootstrap of phylogenetic tree? How to calculate the gain and loss gene numbers with low bootstrap of phylogenetic tree?
homework help health studies homework help health studies
calculate the quantities required to make 5 lb of hydrophilic ointment: calculate the quantities required to make 5 lb of hydrophilic ointment:
Video: Requirements for nervous signals

For a complete list of videos, visit our video library