ch06qz02a - f. Enter a formula in Cell G20 to calculate the...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
BUSINESS MATH USING EXCEL Name  ______________________________ Date ______________________________ + A. Calculate annual premium for homeowner’s insurance. $1,000 $145,000 $145,000 $2.20 $319.00 $156,000 $156,000 $2.30 $358.80 $175,800 $175,800 $2.55 $448.29 $190,300 $190,300 $2.70 $513.81 $221,000 $221,000 $2.80 $618.80 $188,000 $188,000 $3.00 $564.00 Directions: b. Format Column D for Currency, 2 Decimal places, and $. B. Calculate amount of loss insurance will pay with coinsurance clause. $125,000 $80,000 80% $100,000 $56,000 80% $44,800 $135,000 $100,000 80% $108,000 $45,000 93% $41,667 $110,000 $90,000 90% $99,000 $70,000 91% $63,700 $105,000 $75,000 80% $84,000 $60,000 89% $53,571 $118,000 $75,000 60% $70,800 $50,000 100% $70,800 Directions: a. Enter a formula in Cell D20 to calculate the Amount of Insurance Required. Copy the formula down Column D. b. Format Column D for Currency, 0 Decimal places, and $. c. Key in 100% in each cell in Column F for every building that meets the coinsurance requirement and needs no calculation. e. Format Column F Percentage. Set Decimal places to 0.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online