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

alvinum

  • Member
  • Posts: 317
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

Did you know?

Liver spots have nothing whatsoever to do with the liver. They are a type of freckles commonly seen in older adults who have been out in the sun without sufficient sunscreen.

Did you know?

This year, an estimated 1.4 million Americans will have a new or recurrent heart attack.

Life-cycle of the Sun; sizes are not drawn to scale Life-cycle of the Sun; sizes are not drawn to scale
Vital signs for clients in metabolic alkalosis may reveal hypotension, bradycardia, and an irregular Vital signs for clients in metabolic alkalosis may reveal hypotension, bradycardia, and an irregular
The S-curve in the human vertebral column--a result of the evolution of bipedality--makes humans hig The S-curve in the human vertebral column--a result of the evolution of bipedality--makes humans hig
When the United States gets stuck over a controversial issue—usually something a divided Congress ca When the United States gets stuck over a controversial issue—usually something a divided Congress ca
Right lateral view showing low normal curves of the vertebral column Right lateral view showing low normal curves of the vertebral column
Video: Mycobacterium tuberculosis: Drug Resistance and Natural Selection

For a complete list of videos, visit our video library