What is the total amount for which Juan Martinez is personally responsible?

What is the total amount for which Juan Martinez is personally responsible?

ch0Tex03 [Modo de compatibilidad]- Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartr | Chapter 07 . Exercise 03 Chapter O7-Exel cise 03 4 Insured | Formula | Medical | Paid |injured #21 Amount s Hendrix, Lee 6 y Denia 7 Jeans, Robert5075/50 injured #11 Paid | Medical Ins. Co. |Pr Amount Amount Property Property Medical Tota Insurance Damage Expense Insured Company Medical | Ins. Co. | Expenses | fort Formula Expenses for #1 Ins. Co. Property Ins. Co. InsuredInsured for #2 | Dama Pays 40/50125 3030130 42,000 12000 19,000 15,000 | Martinez, Juan 20/25/10 9 Nelson Rich 11 Directions: t2 Company for Injured #1 65,000 Compare the Policy Formula's amount for one person's injury to Injured #1 s Medical Expenses and key in Column D the Amount Paid by the Insurance a b. Compare the maximum amount for one person's injuries to injured #2's expenses and key in Column F the Amount Paid by the Insurance Company for (The trst amount in Policy Formula is the manmum paid tor any one person injured.) . injured #2 (Be sure to consider what has been paid for #1 and the maximum allowable, which is the second figure in the Policy Formula.) Normally an equal 13 amount would be paid to the Injured, but for this exercise, pay the second Injured the difference C. Compare the Policy Formula's maimum for property damage and key in Column H the amount the insurance company will pay. In column I, calculate the amount the insured pays. (Subtract Column H from Column G.) d 14 Enter muitimath formulas in Column J to calculate the Amount insured Pays (Add injured #1's and #2's expenses and then subtract the Amount Paid by Insurance Company for each.) The difference is what the Insured must pay of the medical expenses e. Enter formulas in Column K to calculate Total insured Pays of property damages and medical expenses. 17 f. Enter formulas to calculate the total amount the Insurance Company Pays. 18 g Format Columns D, F, H andi for Currency,0 Decimal places, and no S. Format Columns J, K and L for Currency, 0 Decimal places, and S. 13 h. Save the file as chO7ex03a.xisx ch07ex03.xlsx + 75 O Type here to search d' ENC 12:47 PM 2/24/2019 ch0Tex03 [Modo de compatibilidad]- Excel Archivo inicio Insertar Diseo de pgina Frmulas Datos Revisar Vista Qu desea hacer? Empe Urbina Compartr | Chapter 07 . Exercise 03 Chapter O7-Exel cise 03 4 Insured | Formula | Medical | Paid |injured #21 Amount s Hendrix, Lee 6 y Denia 7 Jeans, Robert5075/50 injured #11 Paid | Medical Ins. Co. |Pr Amount Amount Property Property Medical Tota Insurance Damage Expense Insured Company Medical | Ins. Co. | Expenses | fort Formula Expenses for #1 Ins. Co. Property Ins. Co. InsuredInsured for #2 | Dama Pays 40/50125 3030130 42,000 12000 19,000 15,000 | Martinez, Juan 20/25/10 9 Nelson Rich 11 Directions: t2 Company for Injured #1 65,000 Compare the Policy Formula's amount for one person's injury to Injured #1 s Medical Expenses and key in Column D the Amount Paid by the Insurance a b. Compare the maximum amount for one person's injuries to injured #2's expenses and key in Column F the Amount Paid by the Insurance Company for (The trst amount in Policy Formula is the manmum paid tor any one person injured.) . injured #2 (Be sure to consider what has been paid for #1 and the maximum allowable, which is the second figure in the Policy Formula.) Normally an equal 13 amount would be paid to the Injured, but for this exercise, pay the second Injured the difference C. Compare the Policy Formula's maimum for property damage and key in Column H the amount the insurance company will pay. In column I, calculate the amount the insured pays. (Subtract Column H from Column G.) d 14 Enter muitimath formulas in Column J to calculate the Amount insured Pays (Add injured #1's and #2's expenses and then subtract the Amount Paid by Insurance Company for each.) The difference is what the Insured must pay of the medical expenses e. Enter formulas in Column K to calculate Total insured Pays of property damages and medical expenses. 17 f. Enter formulas to calculate the total amount the Insurance Company Pays. 18 g Format Columns D, F, H andi for Currency,0 Decimal places, and no S. Format Columns J, K and L for Currency, 0 Decimal places, and S. 13 h. Save the file as chO7ex03a.xisx ch07ex03.xlsx + 75 O Type here to search d' ENC 12:47 PM 2/24/2019