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 128 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
Excellent

samiel-sayed

  • Member
  • Posts: 337
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

The most common childhood diseases include croup, chickenpox, ear infections, flu, pneumonia, ringworm, respiratory syncytial virus, scabies, head lice, and asthma.

Did you know?

It is important to read food labels and choose foods with low cholesterol and saturated trans fat. You should limit saturated fat to no higher than 6% of daily calories.

Did you know?

Everyone has one nostril that is larger than the other.

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

The life cycle of a flowering plant, illustrated by the genus Polygonum The life cycle of a flowering plant, illustrated by the genus Polygonum
Salt glands as an adaptation for marine life. Salt glands as an adaptation for marine life.
The Increasing Cost of Health Care, 1960–2010 The Increasing Cost of Health Care, 1960–2010
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
Integrals for Life Integrals for Life
Nils Hoffmann feat. Dustin Tebbutt - Next Life Nils Hoffmann feat. Dustin Tebbutt - Next Life
Video: Glycolysis Animation

For a complete list of videos, visit our video library