Answered step by step
Verified Expert Solution
Question
1 Approved Answer
write formula. In cell G25 of the CatastropheCoverageLowActivity worksheet calculate the Payment towards Deductible as the lesser (use the MIN function) of the Claim Amount
write formula. In cell G25 of the CatastropheCoverageLowActivity worksheet calculate the "Payment towards Deductible" as the lesser (use the MIN function) of the "Claim Amount" or the Deductible for the indicated "Type". You will need to use a VLOOKUP function to determine the deductible for the indicated "Type".
UnitedHealthcare Catastrophic Compass Plus 6600 Single Adult Age 22 - Monthly premium $160- Deductible$6,600-0ut-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 Lab Services- No charee after deductible Monthly premium Maximum out-ofpocket 160 $6,600 12 13 Type Deductible Co Pay Co-Ins Primary doctor Other doctors Emergency room Hospital services 50 100 Assignment Tasks Health Insurance In cell G25 of the CatastropheCoverageLowActivity worksheet calculate the "Payment towards Deductible as the lesser use the MIN function) of the "Caim Amount or the Deductible for the indicated "Type. You will need to use a VLOOKUP function to determine the deductible for the 15 16 C 5 6,600 D $ 6,600 18 19 Total Premium Expense Total Medical Payments Total Medical Cost indicated "Type". [1.25 points] Cost after limit to MAX out-of- Payment Claim Potentlal Cost 23 24 25 26 27 28 Month Description Type Amount Copayment Deductible Coinsurance tInsured January A S80 Primary Doctor Emerpency Room & Lab tests Dermatol st office visit Primary Doctor Urologist office visit Primary Doctor Eye Doctor cxam Primary Doctor Physical Therapist office visit Primary Doctor 50 C1,707 [$___. $ 366 100 80iS B $545 100 80 31 32 $ 175 S 100 June July August December 80 $ 250 : $ 100 50 34 35 36 37 80 i TotalsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started