× Didn't find what you were looking for? Ask a question
  
  
Top Posters
Since Sunday
18
13
7
r
6
u
5
5
V
4
b
4
r
4
o
4
d
4
n
4
Home Q & A Board Other Fields Homework Help Business
New Topic  
oloka oloka
wrote...
Go to Answer
Posts: 365
Rep: 0 0
5 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 39 times
2 Replies
Replies
Answer verified by a subject expert
ljcwilliams07ljcwilliams07
wrote...
#1
Posts: 242
Rep: 3 0
5 years ago
Sign in or Sign up in seconds to unlock everything for free
Ans. #1

#VALUE!

Ans. #2

1.) Highlight Cells G12, H12, I12, and J12 and click the AutoSum button. This will place the sum in J12.
2.) Type the formula =G12+H12+I12 into Cell J12.

Ans. #3

=B9/1000C9; =D9/12

Ans. #4

264,000; 36,000
330,000  0.80 = 264,000
300,000 > 264,000 so 300,000 - 264,000 = 36,000

Ans. #5

Grant: 12,500; Malcolm: 25,000; Sarah: 10,000; Grant's vehicle: 17,000
1

Related Topics

oloka Author
wrote...
#2
5 years ago
Thank you for answering
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  346 People Browsing
 222 Signed Up Today
Start New Topic Take the Tour Study Tips Study ToolsNew Topics Trending Browse by Textbook
Related Images
  
 240
  
 193
Your Opinion
How often do you eat-out per week?
Votes: 70
Previous poll results: Which country would you like to visit for its food?