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

apple

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

« previous next »
 

Did you know?

The cure for trichomoniasis is easy as long as the patient does not drink alcoholic beverages for 24 hours. Just a single dose of medication is needed to rid the body of the disease. However, without proper precautions, an individual may contract the disease repeatedly. In fact, most people develop trichomoniasis again within three months of their last treatment.

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

Elderly adults are at greatest risk of stroke and myocardial infarction and have the most to gain from prophylaxis. Patients ages 60 to 80 years with blood pressures above 160/90 mm Hg should benefit from antihypertensive treatment.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

The life cycle of a zygomycete, the black bread mould Rhizopus stolonifer. The life cycle of a zygomycete, the black bread mould Rhizopus stolonifer.
The life cycle of a flowering plant, illustrated by the genus Polygonum The life cycle of a flowering plant, illustrated by the genus Polygonum
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
Tornado Destruction - Loss of Life Tornado Destruction - Loss of Life
Half-life formula Half-life formula
A generalized life cycle of a basidiomycete. A generalized life cycle of a basidiomycete.
Video: Acid-base imbalances - respiratory acidosis and alkalosis

For a complete list of videos, visit our video library