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 108 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
Excellent

adammoses97

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

« previous next »
 

Did you know?

It is important to read food labels and choose foods with low cholesterol and saturated trans fat. You should limit saturated fat to no higher than 6% of daily calories.

Did you know?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

In most climates, 8 to 10 glasses of water per day is recommended for adults. The best indicator for adequate fluid intake is frequent, clear urination.

Did you know?

All adverse reactions are commonly charted in red ink in the patient's record and usually are noted on the front of the chart. Failure to follow correct documentation procedures may result in malpractice lawsuits.

Did you know?

A headache when you wake up in the morning is indicative of sinusitis. Other symptoms of sinusitis can include fever, weakness, tiredness, a cough that may be more severe at night, and a runny nose or nasal congestion.

Notice the small motor gear on the left drives a larger plastic gear (black), which then drives ... Notice the small motor gear on the left drives a larger plastic gear (black), which then drives ...
Inflammation of the oropharynx and petechiae (small red spots) on the soft palate caused by strep ... Inflammation of the oropharynx and petechiae (small red spots) on the soft palate caused by strep ...
Structure of a small nuclear RNA (snRNA) Structure of a small nuclear RNA (snRNA)
How to calculate simple interest (Part 5; r = I/Pt) How to calculate simple interest (Part 5; r = I/Pt)
Small local hydroelectric power generators have more future potential Small local hydroelectric power generators have more future potential
Rapidly decreasing sequence costs have enabled the rapid expansion Rapidly decreasing sequence costs have enabled the rapid expansion
Video: The 4 steps of translation Animation

For a complete list of videos, visit our video library