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 130 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
Thanks for the timely response, appreciate it

duy1981999

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

« previous next »
 

Did you know?

Approximately 500,000 babies are born each year in the United States to teenage mothers.

Did you know?

Pubic lice (crabs) are usually spread through sexual contact. You cannot catch them by using a public toilet.

Did you know?

To prove that stomach ulcers were caused by bacteria and not by stress, a researcher consumed an entire laboratory beaker full of bacterial culture. After this, he did indeed develop stomach ulcers, and won the Nobel Prize for his discovery.

Did you know?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

These monolithic figures from Easter Island suggest the contemplative nature of philosophy, which ca These monolithic figures from Easter Island suggest the contemplative nature of philosophy, which ca
life life
Life cycle of Ascaris: Adult worms (1) live in the lumen of the small intestine. A female may ... Life cycle of Ascaris: Adult worms (1) live in the lumen of the small intestine. A female may ...
A spark plug thread chaser is a low-cost tool that hopefully will not be used often, but is ... A spark plug thread chaser is a low-cost tool that hopefully will not be used often, but is ...
Ligaments and Intervertebral Discs of the Spine Lateral View of the Spinal Column (Anterior to the R Ligaments and Intervertebral Discs of the Spine Lateral View of the Spinal Column (Anterior to the R
Half-life explained Half-life explained
Video: DNA Replication Factory and Protein

For a complete list of videos, visit our video library