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 105 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 :)

sailorcrescent

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

« previous next »
 

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

Vaccines prevent between 2.5 and 4 million deaths every year.

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

Did you know?

The training of an anesthesiologist typically requires four years of college, 4 years of medical school, 1 year of internship, and 3 years of residency.

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

A web of life A web of life
The life cycle of a typical fern. The life cycle of a typical fern.
Landmarks in the evolution of life on Earth Landmarks in the evolution of life on Earth
Half-life formula Half-life formula
When operating your own business, it is wise to know your cost of capital and that of the ... When operating your own business, it is wise to know your cost of capital and that of the ...
Drosophila life cycle Drosophila life cycle
Video: Effect of the environment on coat color in the Himalayan rabbit Animation

For a complete list of videos, visit our video library