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 106 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

sultana.d

  • Member
  • Posts: 320
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

Illicit drug use costs the United States approximately $181 billion every year.

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Elle and associates investigated the cost to Datura wrightii of producing sticky leaf trichomes. Elle and associates investigated the cost to Datura wrightii of producing sticky leaf trichomes.
These species are all at risk of extinction. Species with “slow” life-h These species are all at risk of extinction. Species with “slow” life-h
These species are all at risk of extinction. Species with slow life-h These species are all at risk of extinction. Species with slow life-h
Primates exhibit prolonged life histories, spending more time in each stage of life than most other Primates exhibit prolonged life histories, spending more time in each stage of life than most other
Stressful Life Events, 5-HTT, and Depression Stressful Life Events, 5-HTT, and Depression
Cellular basis of life. Cellular basis of life.
Video: Frequency of stimulation and force (Recruitment of motor units and force)

For a complete list of videos, visit our video library