Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write formula. Coinsurance is a percentage applied to the amount of the claim in excess of the deductible. In cell H25 of the CatastropheCoverageLowActivity worksheet
Write formula. Coinsurance is a percentage applied to the amount of the claim in excess of the deductible. In cell H25 of the CatastropheCoverageLowActivity worksheet use VLOOKUP to find the applicable percentage for the "Type" of claim. Multiply that percentage times the greater of the claim amount less the deductible, or zero. 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 Copayment Primary doctor-$50 Copayment Specialist Doctor $100 Emergency Room -No charge after deductible Hospital Services No charge after deductible Lab Services-No charpe after deductible Out-ol-pocket maximurm $6,60D $160 6,600 10 Monthly premium Maximum out-of-pocket 12 13 14 15 16 17 18 19 20 21 Type Deductible Co-Pay Primary doctor Other doctors Emergency room Hospital services Assignment Tasks Health Insurance 100 C S6,600 D $ 6,600 $ Coinsurance is a percentage applied to the amount of the claim in excess of the deductible. In cell H25 of the CatastropheCoverageLowActivity worksheet use VLOOKUP to find the applicable 5 percentage for the Type" of claim. Multiply that percentage times the greater of the claim amount Total Premium Expense Total Medical Payments Total Medical Cost less the deductible, or zero. You will need to use a VLOOKUP function to determine the deductible for the indicated Type". [1.25 points] Cost after limit to MAX out-of- claim Potential Cost 23 24 25 26 27 28 29 Month Type Amount Copayment Deductible Coinsurance to Insured A S80 $ C $1,707 S January Primary Doctor Energency Room & Lab tests Dermatologist office visit Primary Doctor Urologist office visit Primary Doctor Eye Doctor exam Primary Doctor Physical Therapist office visit 1,7050 B S 366 ___100___--_-f---- 5D 80 B $545 80 175 50 80 $ 31 100 July August B S250 100 December Primary Doctor 50 35 Totals 37 38 39Step 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