Can someone help me with this assignment, please?

Course Name: Prometheus Exel and Access

Lesson 7: Advanced Modeling

Assignment: Insurance 8

7 In I25 of the CatastropheCoverageLowActivity worksheet calculate the Potential Cost to the Insured for the individual claim. This is the sum of the Copayment, the Payment towards the Deductible, and the Coinsurance.

8 Reuse your formula in cell I25 and paste it down to complete the "Potential Cost" column.

9 In Cell J25 of the CatastropheCoverageLowActivity worksheet calculate the running total of the cost to the insured after considering the annual maximum out-of-pocket cost by adding the current claim potential cost to the previous total and taking the lesser of that, and the annual maximum out-of-pocket.

10 Reuse your formula in cell J25 and paste it down to complete the "Total Cost..." column.

11 Use the Sum function in cell E36 of the CatastropheCoverageLowActivity worksheet to calculate the total of claim amounts.

12 In cell J36 of the CatastropheCoverageLowActivity worksheet, calculate the total of costs after limit to MAX out-of-pocket. Since the values in this field are a running total, the total cost is the value in column J for the last claim.

13 Calculate the total premium cost in cell E19 of the CatastropheCoverageLowActivity worksheet. The total premium cost is the monthly premium amount times 12.

14 Calculate the total medical payments in cell E20 of the CatastropheCoverageLowActivity worksheet. The total medical payments are equal to the total cost after limit to MAX out-of-pocket.

15 Calculate the total medical cost in cell E21 of the CatastropheCoverageLowActivity worksheet. The total medical cost is equal to the sum of the total premium expense and the total medical payments.

16 Copy the range F25:J25 from the CatastropheCoverageLowActivity worksheet and paste it into the same range on the CatastropheCoverageWithSurgery worksheet. You will be using the same logic for handling claims on the two worksheets, but the claims themselves will be different.

17 Reuse your formulas in cells F25:J25 of the CatastropheCoverageWithSurgery worksheet and paste them down to row 41 to complete the "Copayment" through "Cost after limit..." columns of the table.

File Home Insert Page Layout Formulas Data Review View Help Power Pivot Tell me what you want to do Instruction Task Submit View Report Sheet Guide Show Instructions Automatic Scoring F25 UnitedHealthcare Catastrophic Compass Plus 6600 Single Adult Age 22-Monthly premium $160- Deductible $6,600-Out-of-pocket maximum $6,600 Copayment Primary doctor-$50 Copayment Specialist Doctor $100 Emergency Room-No charge after deductible Hospital Services- No charge after deductible Monthly premium Maximum out-of-pocket $160 $ 6,600 13 Type Deductible Co-Pay Co-Ins Primary doctor Other doctors Emergency room B S0100 $ 6,600 $ D S 6,600$ 15 17 ital services 20 21 Total Premium Expense Total Medical Payments Total Medical Cost Cost after limit Budget CashFlow Summary CatastropheCoverageLowActivty CatastropheCoverageWithSun Ready Average: $1,669 Count: 13 Sum: $13,350 - + 100% File Home Insert Page Layout Formulas Data Review View Help Power Pivot Tell me what you want to do Instruction Task Submit View Report Sheet Guide Show Instructions Automatic Scoring F25 UnitedHealthcare Catastrophic Compass Plus 6600 Single Adult Age 22-Monthly premium $160- Deductible $6,600-Out-of-pocket maximum $6,600 Copayment Primary doctor-$50 Copayment Specialist Doctor $100 Emergency Room-No charge after deductible Hospital Services- No charge after deductible Monthly premium Maximum out-of-pocket $160 $ 6,600 13 Type Deductible Co-Pay Co-Ins Primary doctor Other doctors Emergency room B S0100 $ 6,600 $ D S 6,600$ 15 17 ital services 20 21 Total Premium Expense Total Medical Payments Total Medical Cost Cost after limit Budget CashFlow Summary CatastropheCoverageLowActivty CatastropheCoverageWithSun Ready Average: $1,669 Count: 13 Sum: $13,350 - + 100%