This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Leonard uses Excel to track life insurance coverage and cost for his clients. Column B contains the ... (Read 129 times)

KimWrice

  • Hero Member
  • *****
  • Posts: 579
on: Jun 24, 2018
Leonard uses Excel to track life insurance coverage and cost for his clients. Column B contains the amount of coverage, and Column C contains the cost per thousand. What is the formula that he should key in Cell D9 to calculate the annual premium and in Cell E9 for the monthly premium?

Question 2

Reliable Car Rental purchases an 80 property coinsurance policy on their building, valued at 330,000. The company insures the business for 80 of the value. If there is a fire at Reliable which causes 300,000 worth of damage, how much will the insurance pay and how much will Reliable pay?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Rilsmarie951

  • Sr. Member
  • ****
  • Posts: 316
Reply #1 on: Jun 24, 2018
Answer to Question 1

=B9/1000C9; =D9/12

Answer to Question 2

264,000; 36,000
330,000  0.80 = 264,000
300,000 > 264,000 so 300,000 - 264,000 = 36,000


KimWrice

  • Member
  • Posts: 579
Reply 2 on: Jun 24, 2018
Great answer, keep it coming :)

ricroger

  • Member
  • Posts: 352
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

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?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

Every 10 seconds, a person in the United States goes to the emergency room complaining of head pain. About 1.2 million visits are for acute migraine attacks.

Did you know?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

Nitroglycerin is used to alleviate various heart-related conditions, and it is also the chief component of dynamite (but mixed in a solid clay base to stabilize it).

A Border Marks Life and Death A Border Marks Life and Death
The S-curve in the human vertebral column--a result of the evolution of bipedality--makes humans hig The S-curve in the human vertebral column--a result of the evolution of bipedality--makes humans hig
Gossip and ridicule increase the status insecurity of this time of life. Gossip and ridicule increase the status insecurity of this time of life.
Signs of Pregnancy: Preggo Life Signs of Pregnancy: Preggo Life
Remaining health-adjusted life expectancy (years) at age 25 Remaining health-adjusted life expectancy (years) at age 25
Life cycle of bacteriophage T4 Life cycle of bacteriophage T4
Video: Structures that affect circulation - heart and systolic/diastolic BP

For a complete list of videos, visit our video library