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
- Winter '10
- Business, Decimal, decimal places, annual premium