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 114 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
Great answer, keep it coming :)

EAN94

  • Member
  • Posts: 307
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

In 2010, opiate painkllers, such as morphine, OxyContin®, and Vicodin®, were tied to almost 60% of drug overdose deaths.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

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?

Chronic marijuana use can damage the white blood cells and reduce the immune system's ability to respond to disease by as much as 40%. Without a strong immune system, the body is vulnerable to all kinds of degenerative and infectious diseases.

Gametic life cycle, as illustrated by diatoms Gametic life cycle, as illustrated by diatoms
European wildcat feeding its kittens, as illustrated in Brehm's Life of Animals European wildcat feeding its kittens, as illustrated in Brehm's Life of Animals
The Many Faces of Life The Many Faces of Life
Fossilized Remains of Former Life Fossilized Remains of Former Life
As their numbers grow and their resources and health improve, the elderly will enjoy life more and ... As their numbers grow and their resources and health improve, the elderly will enjoy life more and ...
Butterfly life cycle stages June 6 2023 Butterfly life cycle stages June 6 2023
Video: Virtual Tour of the Eye Animation

For a complete list of videos, visit our video library