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

laurnthompson

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

« previous next »
 

Did you know?

Atropine, along with scopolamine and hyoscyamine, is found in the Datura stramonium plant, which gives hallucinogenic effects and is also known as locoweed.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

Egg cells are about the size of a grain of sand. They are formed inside of a female's ovaries before she is even born.

Did you know?

Normal urine is sterile. It contains fluids, salts, and waste products. It is free of bacteria, viruses, and fungi.

Osteoporosis. (a) A section through normal spongy bone. (b) A section through a bone with osteoporos Osteoporosis. (a) A section through normal spongy bone. (b) A section through a bone with osteoporos
(a) The relative age ranges of different dating techniques depend upon the half-life of the system u (a) The relative age ranges of different dating techniques depend upon the half-life of the system u
Educate clients about products related to massage therapy and the clients’ health goals without ... Educate clients about products related to massage therapy and the clients’ health goals without ...
Still Life, House of The Stags (Cervi) Still Life, House of The Stags (Cervi)
Psychology and Life Psychology and Life
I Am The Bread of Life Suzanne Toolan with Lyrics Catholic Hymn Song Sunday 7pm Choir I Am The Bread of Life Suzanne Toolan with Lyrics Catholic Hymn Song Sunday 7pm Choir
Video: Membrane transport proteins - pores, gated channels and pumps

For a complete list of videos, visit our video library