× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
8
5
z
4
n
4
t
4
k
3
x
3
r
3
m
3
j
3
c
3
l
3
New Topic  
oloka oloka
wrote...
Posts: 365
Rep: 0 0
6 years ago
An Excel spreadsheet is being used to track insurance payments for homeowners insurance with a coinsurance clause. The following are the column headings: A is Replacement Value of the Building, B is Face Value of the Policy, C is Coinsurance Clause Percent, D is Amount of Insurance Required, E is Amount of Loss, F is Percent of Loss Insurance Will Pay, and G is Amount of Loss Insurance Will Pay. What is the formula to determine the percent of loss insurance will pay in Row 15?

Q. 2

In Column J of a spreadsheet, an insurance agent wants to sum the amounts his company owes for medical expenses for two parties and for property damage. These amounts are in Columns G, H, and I. Explain two ways to sum these cells using Row 12.

Q. 3

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?

Q. 4

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?

Q. 5

Alicia drives a company-owned car. Her company carries 25/50/25 automobile liability coverage. Alicia has an accident, which is her fault, during the business day. In the accident, Grant Thomas has 12,500 in injuries, Malcolm James has 27,000 in injuries, and Sarah White has 10,000 in injuries. The damage to Grant's automobile is 17,000. Determine the amount that the insurance company will pay for each person's injuries and for the damage to Grant's vehicle.
Read 96 times
2 Replies
Replies
Answer verified by a subject expert
ljcwilliams07ljcwilliams07
wrote...
Posts: 242
Rep: 3 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

oloka Author
wrote...
6 years ago
Thank you for answering
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  876 People Browsing
 119 Signed Up Today
Related Images
  
 225
  
 299
  
 360
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 484

Previous poll results: Who's your favorite biologist?