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 67 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
:D TYSM

hollysheppard095

  • Member
  • Posts: 339
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

Did you know?

More than 20 million Americans cite use of marijuana within the past 30 days, according to the National Survey on Drug Use and Health (NSDUH). More than 8 million admit to using it almost every day.

Did you know?

Asthma is the most common chronic childhood disease in the world. Most children who develop asthma have symptoms before they are 5 years old.

Did you know?

Studies show that systolic blood pressure can be significantly lowered by taking statins. In fact, the higher the patient's baseline blood pressure, the greater the effect of statins on his or her blood pressure.

Did you know?

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

In 1891 William Dean Howells championed the poetry of Emily Dickinson: “This poetry is as characteri In 1891 William Dean Howells championed the poetry of Emily Dickinson: “This poetry is as characteri
The spinal column. The spinal column.
Symptoms and Signs Associated with Damage to Nerves in Different Areas of the Spinal Column Symptoms and Signs Associated with Damage to Nerves in Different Areas of the Spinal Column
Clouds: Cloud Coverage and Observation Clouds: Cloud Coverage and Observation
Age-standardized disability-adjusted life year (DALY) rates from hepatitis B by country (per 100 000 ... Age-standardized disability-adjusted life year (DALY) rates from hepatitis B by country (per 100 000 ...
Marine Life Zones "الحياة في أعماق البحار" Marine Life Zones "الحياة في أعماق البحار"
Video: Blood Pressure Measurement

For a complete list of videos, visit our video library