An Excel Spreadsheet Is Being Used to Track Insurance Payments

Essay

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?