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

sultana.d

  • Member
  • Posts: 320
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Stroke kills people from all ethnic backgrounds, but the people at highest risk for fatal strokes are: black men, black women, Asian men, white men, and white women.

Did you know?

Hypertension is a silent killer because it is deadly and has no significant early symptoms. The danger from hypertension is the extra load on the heart, which can lead to hypertensive heart disease and kidney damage. This occurs without any major symptoms until the high blood pressure becomes extreme. Regular blood pressure checks are an important method of catching hypertension before it can kill you.

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

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?

Alcohol acts as a diuretic. Eight ounces of water is needed to metabolize just 1 ounce of alcohol.

How to create a price index to calculate inflation for a basket of goods How to create a price index to calculate inflation for a basket of goods
How to calculate annuity when compounded semi-annually (Part 1) How to calculate annuity when compounded semi-annually (Part 1)
How to calculate monthly mortgage payments at varying amortization periods (Question 1) How to calculate monthly mortgage payments at varying amortization periods (Question 1)
Absorption Methods in the Small Intestine Absorption Methods in the Small Intestine
Business Math Business Math
A company that makes cell phones has the following cost structure. They have fixed costs of ... A company that makes cell phones has the following cost structure. They have fixed costs of ...
Video: hGH, Thyroid hormones & Aldosterone

For a complete list of videos, visit our video library