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 120 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
YES! Correct, THANKS for helping me on my review

flexer1n1

  • Member
  • Posts: 373
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

Adults are resistant to the bacterium that causes Botulism. These bacteria thrive in honey – therefore, honey should never be given to infants since their immune systems are not yet resistant.

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

a pocket mouse, Perognathus sp., a small granivor a pocket mouse, Perognathus sp., a small granivor
Adults in late adulthood may need to adapt to a new environment as they age and their health status Adults in late adulthood may need to adapt to a new environment as they age and their health status
When operating your own business, it is wise to know your cost of capital and that of the ... When operating your own business, it is wise to know your cost of capital and that of the ...
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
Structure of the small intestine. Structure of the small intestine.
Video: Dissociative Disorders (Part 3)

For a complete list of videos, visit our video library