This preview shows page 1. Sign up to view the full content.
Unformatted text preview: f. Enter a formula in Cell G20 to calculate the Amount of Loss the Insurance Will Pay. Copy the formula to down Column G. g. Format Column G for Currency, 0 Decimal places, and $. Cost per: Cost per $1,000 Annual Premium Replacement Value of Building Amount of Insurance Needed a. Enter multimath formulas in Column D to calculate the Annual Premium. Replacement Value of Building Face Value of the Policy Coinsurance Clause Percent Amount of Insurance Required Amount of Loss Percent of Loss Insurance Will Pay Amount of Loss Insurance Will Pay d. Enter a formula in all other cells in Column F to calculate the Percent of Loss Insurance Will Pay for the each of the buildings that do not meet the Amount of Insurance Required. Round to the nearest whole percent. h. Save the file as ch06qz02a.xls. A B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35...
View
Full
Document
This note was uploaded on 02/19/2012 for the course BUS bus 130 taught by Professor Munoz during the Winter '10 term at Everett CC.
 Winter '10
 Munoz
 Business

Click to edit the document details