1.25 Tak Points Task Description 1 1 Use a VLOOKUP function in cell 75 of the CatastropheCoverage onctivity worksheet to determine the proplan Copayment for the first vice to Primary Doctor The Owen cel 025 s one of the printers Use absolute and relative references when appropriate 2 05 Here your formula in cel 72 and paste it down to complete the Comert column of the table 3 125 cel 25 of the Catastrophe Coverage wity worksheet calculate the Otters Deductible as the ser use the main function) of the com Amount or the Deductible for the indicated typed. You will need to use a VLOOKUP function to determine the deductible for the indicated Type 4 0.5 Reuse your formula in cel 25 and paste down to complete the payment towards Deduc cum 5 Constance is a percentage applied to the amount of the dam in eos of the deductible. In cells of the CastropheCoverage letvity worksheetse VLOOKUP to find the applicable perontage for the typed of dam. Multiply that percentage times the greater of the claim amountless the deductible, crner You will need to use a VLOOKUP function to determine the deductible for the indicated Type 6 05 Reuse your formula in cells and paste it down to complete the Coinsurance com 7 0.5 In 125 of the Castrophe Coveragelow Activity worksheet calculate the potential Cost to the bored for the individual cam. This is the sum of the Copyment, the Payment towards the Deductible, and the Constance 0.25 Reuse your formula in cell 125 and paste down to complete the potential Costco. 1.25 In Cell 125 of the Catastrophe Coverage loctivity worksheet calculate the running to the cost to the insured the considering them to podiet cost by adding the current cum potential costo the previous total and taking the of that, and the annual maximum out-of-pocket 10 05 Reuse your formula in 25 and paste down to complete the lo Costo column. 11 os Use the Sum function in cel E36 of the Catastrophe Coveraget.owActivity worksheet to calculate the total of daim amounts 12 0.5 In cell 36 of the Castrophe Coveraget.onctivity worksheet, calculate the total of costs ferimit to Max out of pocket. Since the values in this field are a running to the cost is the wie in column) for the tast dem 13 Calculate the total premium cost incl 19 of the Catastrophecoverage Lowity worksheet. The total premium cost is the monthly premium amount times 12 14 OS Calculate the total medical payments in cel E20 of the CatheCoveragetowy worksheet. The total medical payments are equal to the total cost after it to MAX out of poort 15 0.75 Calculate the total medical cost in cell 21 of the CatastropheCoverage outcome worksheet. The total medical cost is equal to the sum of the total peenin perde and the total medical payments. 1:25 Copy the 25.325 from the Catastrophe Coverageolety worksheet and peste into the wrong on the Catastrophe Coverage wurgery worth You will be using the same logic for hiding cam on the two worksheets, but the aims them wir be different 17 125 Reuse your formen els 25:325 of the Catastrophe Coveragerpery worksheet and paste them down to row 41 to complete the Copayment through cost after a columns of the title LS 05 the the Sum function in cell 43 of the CatastropheCoveragirry worksheet to calculate the total of commounts OS In cel of the Goveritgery worksheet te fonts after it to MAX out of pocket. Since the values in this field are a running total, the total cost is the value in column) for the 05 Chit Com 100 el Monte A400 Output Cinay10 Contato whether | 4 Te Cow Primary 500 Ener ON ON 13 tu 21 Pleast Contato MAKO Month Type 24 wy Meth A C. 20 Way A 1. BOY 164 10 545 10 175 30 HO 30 Hiwy potre doctor There Primary 11 11 bebe As 35 Te 41 DB. insurance-r-Bryan_inney Home insert Page Layout Formules Data Review View Assignment Report TV Duide : x F . UR vo-www- # + wer 1 KA A G om SE . www D ON HT Com Com . LP # Ney 11 A. WE w A . Pry LL 1 DOC 48 1 OF Budo Cures Catastrophew Catastrophe Wirgery Provosowy arm Waray Insurance-t-Bryan_Kinney me Insert Page Layout Formulas Data View Assignment port Oui : AI D o 1 God com 100 525-5500-600 Canon CO-54 co 20 23 OP Team C 5 R99 cs D 20 Medical MO Am CDC MAR M Pro Inway con Dit LOT CS 5 45 My 145 AS Drago Pro w Print July A 290 5 5 Caturtstaury Copy Prenowy Pembe 100% Dead DB9 = Home BE Page Layout insurancer-Bryar_Kinney Formules Data Review View Assignment SON She Oce 43 - H 11 5 UCH - 10 D-51 . . 23 . NE NO 31 Hamm 1 TM Pay Me A fy DEVE ) 1. 4 5 AB IT A. ma Do w 1 Dosto 11 CS A5 Clow mang Gatsbohoven CatastropheCover Wang Povractivity Pragery 1 2 4 5 7 10 1 The MOCKUP An In els of the Gottrophecoveragetowicthey worksheet to determine the propriate Copament Dor the first visz a Primary Doctor. The pencil 25 in one of the parameters Use and relative when appropriate 05 Reuse your formula in cel 25 and paste down to complete the "Copayment column of the table 1.25 need to to determine the for In cel at the Catastrophe coverage owActhy worksheet caldate the payment towards Deductible as the lesser (ie the Min function of the Cam Amount or the Deductible for the indicated Type 05 Reuse your formula in cell 35 and paste it down to complete the payment towards Deductible column 1.25 Colunane percentage applied to to the amount of cam in excess of the deductible. In cel Hos of the CatastropheCoveraget.ow Activity worksheet use VLOOKUP to And the applicable peromtage for the Type of claim Multiply Brat percentage times the greater of the claim amount as the deductible, errero. You will need to use a VLOOKUP function to determine the deductible for the indicated Type. 05 Reuse your man cell 05 and paste down to complete the conclum 0.5 in 125 of the CatastrocheCoveragelowkcivity worksheet calculate the potential Cost to the browed for the individual client. This is the sum of the Comment, the Purment towards the Deductible, and the Coinsurancon 0.25 Reuse your formula in cel 25 and paste it down to complete the potential Cont colum. 1.25 in Cell 125 of the Centro Covers metty Workshort coate the running total of the cost to the moured after considering the annual e out of pocket cost by adding the current com poterit cost to the previous tal ard taking the ser oftrat, and the annual run out of pocket as Reuse your formula in cell 125 and paste it down to complete the Total Conto column. 05 Use the Sum function in coll E36 of the Catastrophe Coverage.owActivity worksheet to calonate the total of calm amounts In ord 196 of e CastropheCoverageLowActivity worksheet, calculate the roof os he limit to MAX out of pocket. Since the values in this field are a running to the total cost is the value in column) for the est daim 05 Calculate the total premium costincell 19 of the CatastropheCoveragectivity worksheet. The total premium cost is the monthly premium amount times 12. 05 Calculate the total medicaments el 20 of the Catastrophe Coverage on the worksheet. The total medical payments are equal to the total cost after into MAX out of pocket. 0.75 Catetemedical contin cell 01 of the Catastrophe CoiragelowActivity worect. The total medical cost is equal to the sum of the total premium expense and the total medical payments. 125 Copy the range 25:125 from the catastropheCovergelowActivity worksheet and paste it into the same range on the Castrophe Coverage Surgery worksheet. You will be using the same logic for handing com on the two worksheets, but the claims themselves will be different 1.25 Rose your formen in als 2.35 of the Catastrophe Coveragewitturgery worksheet and parte tren down to row 41 to complete the Copayment through con after into columns of the table. Use the function in all 3 of the Catastrophe Coveragery worksheet cake the total of cam amount In c363 of the Gastrophevery worksheet calculate the total of conferint to MaxonocetSince the values in this field are a running to the total cost is the value in conforme dim Calculate the total premium cost cel 19 of the Catastrophecoverage wie Sargery worsheet. The total premium is the more remum amount times 12 OS Calculate the total medical payments incl 2 of Catastrophe Coverage Surgery worksheet. The total medical payments are to the total cost to MAX outof-pocket 0.75 Cate the medical continet of the Catastrophe Coverage Surgery worksheet. The total medical conto the sum of the premium expense and the total medical payments Copy the range F25:22 hrom the Castrophe Coverage.Activity worksheet and paste into the same ringe on the Premiwelow Activity worksheet. You will be using the same logic forhandling claims on 12 05 13 14 15 16 17 19 15 20 21 22 23 24 25 5 27 28 29 30 31 32 - 35 1.25 Hose your formes notes P25:325 of the Premium Coveragetowicy worksheet and paste them down to rows to complete the "Cupayment through cost aftur tinado coherwerf het 05 Use the Sum function in E36 of the PremiumCoveragelowactivity worksheet to calculate the total of cam amounts. the 16 of the Premium Coverage Activity worksheet, calculate the total of costs in to MAX out of pocket. Since the values in this field are aming total the total cost is the value in column for the last Calculate the total premium cost in cell 19 of the Premium CoveragelowActivity worksheet. The total premium cost is the monthly premium amount times 12 0.5 Calculate the total medical payment in 20 of the PremiumCoverwacity workshost. The total medical payments we equal to the total cost after it to MAX out of pocket 0.75 Calculate the total medical contince 21 of the Premium CoveragetowActivity worksheet. The total medical cost is equal to the sum of the total premium expense and the total medicaments 1.25 Copy the range 25 from the CastropheCovertowctivity worksheet and paste it into the same range on the PremiumCorage Surgery worksheet. You will be using the same logic for handing damon the two worksheets, but the claims themselves will be different 1.25 Reuse your formulas. In cele 2225 of the Premium CoverageWith Surgery worksheet and paste them down to row At to complete the "Cepayment trough Cost after into columns of the table 0.5 Use the Sun function in all of the Premium Coverage with Surgery works to calculate the total of can amounts 0.5 In cell 3 of the Premium Coverage With Surgery worksheet, cal the total of combater it to MAX Out-of-pocket. Since the values in this field are a running to the total cost is the value in columns for the last claim 0.5 Calculate the total premium cont in cell 19 of the Premium Coverage they worksheet. The total premium cost is the monthly premium amoure times 12. 0.5 Chloe the total medical payments in cod 20 of the Premium Coverage Witry worksheet. The te medical payments are equal to the total cost after it to Max out of pocket 0.75 Calculate the total medical contin cel E21 of the PremiumCoverageWithogery worksheet. The total medical cost is equal to the sum of the total premium experse and the total medical payments. In cel of the Summary worestert enter you buy no insure and have no health activity, you have spent nothing 0.5 In orl of the summary worksheet cue the total cost an individual would pay they had low medical activity and no Insurance by referencing the correct call on me Catastrophe Coveragelow.ctivity worksheet where you have already calculated the total cost of medical dins for the relative low activity scenario 05 In cell to the summary worksheet cakulate the most cost an individual would pay they had high medical twity and no insurance by referencing the corect call on the Catastrophe Coverage Surgery worksheet where you have already calculated the total cost of all medical cams for the relative high activity scenario 1 In cells of the Summary worksheet calculate total cost an individual would pay hey had catastrophe coverage and no city by referending the total premium expense you ready calculated on the CatastropheCoverage on Activity worksheet if you don't have any medical activity, the only costs would be the medical premium) In oals of the summary woristeet calculate the total cost an individual would pay if they had tow medical activity and catastrophe insurance by referencing the correct call on the Catastrophecoverage.Activity worksheet where you have already calculated the total medical expense for the relative wadivity scenario and catastrophe insurance 1 Inces of the summary worksheet calculate the total cost an individual would pay if they had high medicative and catastrophe imunince by referending the correct cell on the catastrophe Coverage with Surgery worksheet where you have already calculated the bal medical expense for the relative high activity scenario and catastrophe insurance In cells of the Summary worsheet noutate to cost on individual would pay if they had premium coverage and no activity by referencing the total premium expete you already acted on the Premium Coverage lowActivity worksheet (if you don't have any medical activity, the only costs would be the medical premium) 1 In cel 6 of the survary worksheet te the total cost on individust would say they had low medical activity and premium Insurance by referencing the comect cell on the Premium Coverage Low.city worksheet where you have already hated the total medical expense for the eve low activity and premium Insurance 1 Inces of the summary worksheet calculate the total cost an individual would pay if they had high medikal activity and premium Insurance by referencing the comect cell on the Premium Coverage with Surgery worsheet where you have already coated the total medical expense for the relative activity scenario and premium Insurance 36 37 0.3 38 19 40 41 43 1 45 40 43 44 5 38 0.5 to on pof the summer words cantate the total cost an now would pay they had low medical activity and so murance by referencing the correct cet on the Catastrophe Commige vaketity worksheet where you already the total cost of medical dam for . 39 OS In cel Bof the summy worksheet calculate the total cost on navidual would pay if they had high medical active and no insurance by referencing the correctoel on the Castrophe CoonenSurgery worksheet where you have already calculated the total cost of al medical claims for the high activity scenenia 1 In cut of the Summary worksheet cake total cost an inal would they had catastrophe coverage and to activity by referencing the tota prema pense ou Pays on the Catastrophe Coverageovly worksheet you don't have any medical activity, the only costs would be the medical prote) 41 1 Dools of the summary worksheet Coate the total cost an individus would pay they had tow medical actity and catastrophe insurance by refermare come colonne Catastrophecovat worbert where you have ready Galiated the medical expense for the live low activity Sortie and costrophen 42 Inces of the summary worked at the total cost an individus would say they had a medical activity and catastrophe insurance by referending the correct cel on the catastrophectory worket where you have ready calculated the total medical experte for the relativity and contrahe murace 1 In cell of the Summary worksheet caute total cost an individual would pay if they had premium coverage and no activity by referencing the total print pere you ready on the Premium Coverage activity worksheet you don't have any medical ty, the only costs would be the medical premium) 1 In cells of the summary worksheet criciate the cost an individual would pay they had low medical activity and premium insurance by referencing the corrector on the Premium Coverage where you have already called the medical care for the relative low activity Karlo and prima 1 In cel Ef of the summer she calculate the total cost cannot would park they had high nedical advity and premium insurance by referencing the correct sel on the PremiumCowrotury worksheet where you have already calculated the total medical expense for the relative high atviysmario and prome 46 0.5 In cells 10:20 of the Summary worksheet enterThe me profit to the insurance company an individual as neince, regardless of the level of medical In cet Cul of the Summary worsheet cause the proft to the insurance company an individud tas catastrophe coverage and to medical abycia proprie certified on the Catastrophe Coverage.cact worde. Since there is no medical active therance company without for medical care. Therefore, the profit to the company is the total premis peid by the Individual In color of the Summary worksheet calculate the profit to the more company an individual has trophe rage and low medical activity by referencing appropriate (s) en the 1 Corchecoragen Ketty Worchest. The profit to the company the total premune paid by the individuel met the amount of the total damped by the notare company. The amount of the to come paid by the many is the difference between the tal cost of all claims and the total cost of the pod by the individu The Ent of the Summary worksheet cate the proft to the interce company an individu has the coverage and high medical city by referencing appropriate contre CatastropheCovers wery worksheet. There to the company Destal pred by the individ street cand ped by the company. The amount of the team paid by the company is the difference between the cost of arms and the cost of their paid by the dich 50 1 In cell to the way worth the profits the nice comportamentas pro co do twy by referencing rate () on the Premium Coverage wire there is omdat hinance company wil ingroot for medical came. Therefore, the to the company is the total premium pod Wie Incl 12 of the Summary were come protone company an individual assung and low medical activity by referending appropre col) on the coverage 51 work. The profit to the company reprend paid by the Individuals the most of the total cames ped by the insurance company. The other camped by se me copy the die beween the total cost of and the cost of campaid by the individual In 12 of the worksheet aloitettore companyif an individuals premium coverage and medical activity by referencing aeropen the Premium Coverage worst. The role to the contreprenapoid by the individuals amount of the total claims and by the company. The neurt of the body by the company is the deference between the total cost das and the total cost of the claimspod by the India 47 1 46 49 1 1 52 1 To 40 1.25 Tak Points Task Description 1 1 Use a VLOOKUP function in cell 75 of the CatastropheCoverage onctivity worksheet to determine the proplan Copayment for the first vice to Primary Doctor The Owen cel 025 s one of the printers Use absolute and relative references when appropriate 2 05 Here your formula in cel 72 and paste it down to complete the Comert column of the table 3 125 cel 25 of the Catastrophe Coverage wity worksheet calculate the Otters Deductible as the ser use the main function) of the com Amount or the Deductible for the indicated typed. You will need to use a VLOOKUP function to determine the deductible for the indicated Type 4 0.5 Reuse your formula in cel 25 and paste down to complete the payment towards Deduc cum 5 Constance is a percentage applied to the amount of the dam in eos of the deductible. In cells of the CastropheCoverage letvity worksheetse VLOOKUP to find the applicable perontage for the typed of dam. Multiply that percentage times the greater of the claim amountless the deductible, crner You will need to use a VLOOKUP function to determine the deductible for the indicated Type 6 05 Reuse your formula in cells and paste it down to complete the Coinsurance com 7 0.5 In 125 of the Castrophe Coveragelow Activity worksheet calculate the potential Cost to the bored for the individual cam. This is the sum of the Copyment, the Payment towards the Deductible, and the Constance 0.25 Reuse your formula in cell 125 and paste down to complete the potential Costco. 1.25 In Cell 125 of the Catastrophe Coverage loctivity worksheet calculate the running to the cost to the insured the considering them to podiet cost by adding the current cum potential costo the previous total and taking the of that, and the annual maximum out-of-pocket 10 05 Reuse your formula in 25 and paste down to complete the lo Costo column. 11 os Use the Sum function in cel E36 of the Catastrophe Coveraget.owActivity worksheet to calculate the total of daim amounts 12 0.5 In cell 36 of the Castrophe Coveraget.onctivity worksheet, calculate the total of costs ferimit to Max out of pocket. Since the values in this field are a running to the cost is the wie in column) for the tast dem 13 Calculate the total premium cost incl 19 of the Catastrophecoverage Lowity worksheet. The total premium cost is the monthly premium amount times 12 14 OS Calculate the total medical payments in cel E20 of the CatheCoveragetowy worksheet. The total medical payments are equal to the total cost after it to MAX out of poort 15 0.75 Calculate the total medical cost in cell 21 of the CatastropheCoverage outcome worksheet. The total medical cost is equal to the sum of the total peenin perde and the total medical payments. 1:25 Copy the 25.325 from the Catastrophe Coverageolety worksheet and peste into the wrong on the Catastrophe Coverage wurgery worth You will be using the same logic for hiding cam on the two worksheets, but the aims them wir be different 17 125 Reuse your formen els 25:325 of the Catastrophe Coveragerpery worksheet and paste them down to row 41 to complete the Copayment through cost after a columns of the title LS 05 the the Sum function in cell 43 of the CatastropheCoveragirry worksheet to calculate the total of commounts OS In cel of the Goveritgery worksheet te fonts after it to MAX out of pocket. Since the values in this field are a running total, the total cost is the value in column) for the 05 Chit Com 100 el Monte A400 Output Cinay10 Contato whether | 4 Te Cow Primary 500 Ener ON ON 13 tu 21 Pleast Contato MAKO Month Type 24 wy Meth A C. 20 Way A 1. BOY 164 10 545 10 175 30 HO 30 Hiwy potre doctor There Primary 11 11 bebe As 35 Te 41 DB. insurance-r-Bryan_inney Home insert Page Layout Formules Data Review View Assignment Report TV Duide : x F . UR vo-www- # + wer 1 KA A G om SE . www D ON HT Com Com . LP # Ney 11 A. WE w A . Pry LL 1 DOC 48 1 OF Budo Cures Catastrophew Catastrophe Wirgery Provosowy arm Waray Insurance-t-Bryan_Kinney me Insert Page Layout Formulas Data View Assignment port Oui : AI D o 1 God com 100 525-5500-600 Canon CO-54 co 20 23 OP Team C 5 R99 cs D 20 Medical MO Am CDC MAR M Pro Inway con Dit LOT CS 5 45 My 145 AS Drago Pro w Print July A 290 5 5 Caturtstaury Copy Prenowy Pembe 100% Dead DB9 = Home BE Page Layout insurancer-Bryar_Kinney Formules Data Review View Assignment SON She Oce 43 - H 11 5 UCH - 10 D-51 . . 23 . NE NO 31 Hamm 1 TM Pay Me A fy DEVE ) 1. 4 5 AB IT A. ma Do w 1 Dosto 11 CS A5 Clow mang Gatsbohoven CatastropheCover Wang Povractivity Pragery 1 2 4 5 7 10 1 The MOCKUP An In els of the Gottrophecoveragetowicthey worksheet to determine the propriate Copament Dor the first visz a Primary Doctor. The pencil 25 in one of the parameters Use and relative when appropriate 05 Reuse your formula in cel 25 and paste down to complete the "Copayment column of the table 1.25 need to to determine the for In cel at the Catastrophe coverage owActhy worksheet caldate the payment towards Deductible as the lesser (ie the Min function of the Cam Amount or the Deductible for the indicated Type 05 Reuse your formula in cell 35 and paste it down to complete the payment towards Deductible column 1.25 Colunane percentage applied to to the amount of cam in excess of the deductible. In cel Hos of the CatastropheCoveraget.ow Activity worksheet use VLOOKUP to And the applicable peromtage for the Type of claim Multiply Brat percentage times the greater of the claim amount as the deductible, errero. You will need to use a VLOOKUP function to determine the deductible for the indicated Type. 05 Reuse your man cell 05 and paste down to complete the conclum 0.5 in 125 of the CatastrocheCoveragelowkcivity worksheet calculate the potential Cost to the browed for the individual client. This is the sum of the Comment, the Purment towards the Deductible, and the Coinsurancon 0.25 Reuse your formula in cel 25 and paste it down to complete the potential Cont colum. 1.25 in Cell 125 of the Centro Covers metty Workshort coate the running total of the cost to the moured after considering the annual e out of pocket cost by adding the current com poterit cost to the previous tal ard taking the ser oftrat, and the annual run out of pocket as Reuse your formula in cell 125 and paste it down to complete the Total Conto column. 05 Use the Sum function in coll E36 of the Catastrophe Coverage.owActivity worksheet to calonate the total of calm amounts In ord 196 of e CastropheCoverageLowActivity worksheet, calculate the roof os he limit to MAX out of pocket. Since the values in this field are a running to the total cost is the value in column) for the est daim 05 Calculate the total premium costincell 19 of the CatastropheCoveragectivity worksheet. The total premium cost is the monthly premium amount times 12. 05 Calculate the total medicaments el 20 of the Catastrophe Coverage on the worksheet. The total medical payments are equal to the total cost after into MAX out of pocket. 0.75 Catetemedical contin cell 01 of the Catastrophe CoiragelowActivity worect. The total medical cost is equal to the sum of the total premium expense and the total medical payments. 125 Copy the range 25:125 from the catastropheCovergelowActivity worksheet and paste it into the same range on the Castrophe Coverage Surgery worksheet. You will be using the same logic for handing com on the two worksheets, but the claims themselves will be different 1.25 Rose your formen in als 2.35 of the Catastrophe Coveragewitturgery worksheet and parte tren down to row 41 to complete the Copayment through con after into columns of the table. Use the function in all 3 of the Catastrophe Coveragery worksheet cake the total of cam amount In c363 of the Gastrophevery worksheet calculate the total of conferint to MaxonocetSince the values in this field are a running to the total cost is the value in conforme dim Calculate the total premium cost cel 19 of the Catastrophecoverage wie Sargery worsheet. The total premium is the more remum amount times 12 OS Calculate the total medical payments incl 2 of Catastrophe Coverage Surgery worksheet. The total medical payments are to the total cost to MAX outof-pocket 0.75 Cate the medical continet of the Catastrophe Coverage Surgery worksheet. The total medical conto the sum of the premium expense and the total medical payments Copy the range F25:22 hrom the Castrophe Coverage.Activity worksheet and paste into the same ringe on the Premiwelow Activity worksheet. You will be using the same logic forhandling claims on 12 05 13 14 15 16 17 19 15 20 21 22 23 24 25 5 27 28 29 30 31 32 - 35 1.25 Hose your formes notes P25:325 of the Premium Coveragetowicy worksheet and paste them down to rows to complete the "Cupayment through cost aftur tinado coherwerf het 05 Use the Sum function in E36 of the PremiumCoveragelowactivity worksheet to calculate the total of cam amounts. the 16 of the Premium Coverage Activity worksheet, calculate the total of costs in to MAX out of pocket. Since the values in this field are aming total the total cost is the value in column for the last Calculate the total premium cost in cell 19 of the Premium CoveragelowActivity worksheet. The total premium cost is the monthly premium amount times 12 0.5 Calculate the total medical payment in 20 of the PremiumCoverwacity workshost. The total medical payments we equal to the total cost after it to MAX out of pocket 0.75 Calculate the total medical contince 21 of the Premium CoveragetowActivity worksheet. The total medical cost is equal to the sum of the total premium expense and the total medicaments 1.25 Copy the range 25 from the CastropheCovertowctivity worksheet and paste it into the same range on the PremiumCorage Surgery worksheet. You will be using the same logic for handing damon the two worksheets, but the claims themselves will be different 1.25 Reuse your formulas. In cele 2225 of the Premium CoverageWith Surgery worksheet and paste them down to row At to complete the "Cepayment trough Cost after into columns of the table 0.5 Use the Sun function in all of the Premium Coverage with Surgery works to calculate the total of can amounts 0.5 In cell 3 of the Premium Coverage With Surgery worksheet, cal the total of combater it to MAX Out-of-pocket. Since the values in this field are a running to the total cost is the value in columns for the last claim 0.5 Calculate the total premium cont in cell 19 of the Premium Coverage they worksheet. The total premium cost is the monthly premium amoure times 12. 0.5 Chloe the total medical payments in cod 20 of the Premium Coverage Witry worksheet. The te medical payments are equal to the total cost after it to Max out of pocket 0.75 Calculate the total medical contin cel E21 of the PremiumCoverageWithogery worksheet. The total medical cost is equal to the sum of the total premium experse and the total medical payments. In cel of the Summary worestert enter you buy no insure and have no health activity, you have spent nothing 0.5 In orl of the summary worksheet cue the total cost an individual would pay they had low medical activity and no Insurance by referencing the correct call on me Catastrophe Coveragelow.ctivity worksheet where you have already calculated the total cost of medical dins for the relative low activity scenario 05 In cell to the summary worksheet cakulate the most cost an individual would pay they had high medical twity and no insurance by referencing the corect call on the Catastrophe Coverage Surgery worksheet where you have already calculated the total cost of all medical cams for the relative high activity scenario 1 In cells of the Summary worksheet calculate total cost an individual would pay hey had catastrophe coverage and no city by referending the total premium expense you ready calculated on the CatastropheCoverage on Activity worksheet if you don't have any medical activity, the only costs would be the medical premium) In oals of the summary woristeet calculate the total cost an individual would pay if they had tow medical activity and catastrophe insurance by referencing the correct call on the Catastrophecoverage.Activity worksheet where you have already calculated the total medical expense for the relative wadivity scenario and catastrophe insurance 1 Inces of the summary worksheet calculate the total cost an individual would pay if they had high medicative and catastrophe imunince by referending the correct cell on the catastrophe Coverage with Surgery worksheet where you have already calculated the bal medical expense for the relative high activity scenario and catastrophe insurance In cells of the Summary worsheet noutate to cost on individual would pay if they had premium coverage and no activity by referencing the total premium expete you already acted on the Premium Coverage lowActivity worksheet (if you don't have any medical activity, the only costs would be the medical premium) 1 In cel 6 of the survary worksheet te the total cost on individust would say they had low medical activity and premium Insurance by referencing the comect cell on the Premium Coverage Low.city worksheet where you have already hated the total medical expense for the eve low activity and premium Insurance 1 Inces of the summary worksheet calculate the total cost an individual would pay if they had high medikal activity and premium Insurance by referencing the comect cell on the Premium Coverage with Surgery worsheet where you have already coated the total medical expense for the relative activity scenario and premium Insurance 36 37 0.3 38 19 40 41 43 1 45 40 43 44 5 38 0.5 to on pof the summer words cantate the total cost an now would pay they had low medical activity and so murance by referencing the correct cet on the Catastrophe Commige vaketity worksheet where you already the total cost of medical dam for . 39 OS In cel Bof the summy worksheet calculate the total cost on navidual would pay if they had high medical active and no insurance by referencing the correctoel on the Castrophe CoonenSurgery worksheet where you have already calculated the total cost of al medical claims for the high activity scenenia 1 In cut of the Summary worksheet cake total cost an inal would they had catastrophe coverage and to activity by referencing the tota prema pense ou Pays on the Catastrophe Coverageovly worksheet you don't have any medical activity, the only costs would be the medical prote) 41 1 Dools of the summary worksheet Coate the total cost an individus would pay they had tow medical actity and catastrophe insurance by refermare come colonne Catastrophecovat worbert where you have ready Galiated the medical expense for the live low activity Sortie and costrophen 42 Inces of the summary worked at the total cost an individus would say they had a medical activity and catastrophe insurance by referending the correct cel on the catastrophectory worket where you have ready calculated the total medical experte for the relativity and contrahe murace 1 In cell of the Summary worksheet caute total cost an individual would pay if they had premium coverage and no activity by referencing the total print pere you ready on the Premium Coverage activity worksheet you don't have any medical ty, the only costs would be the medical premium) 1 In cells of the summary worksheet criciate the cost an individual would pay they had low medical activity and premium insurance by referencing the corrector on the Premium Coverage where you have already called the medical care for the relative low activity Karlo and prima 1 In cel Ef of the summer she calculate the total cost cannot would park they had high nedical advity and premium insurance by referencing the correct sel on the PremiumCowrotury worksheet where you have already calculated the total medical expense for the relative high atviysmario and prome 46 0.5 In cells 10:20 of the Summary worksheet enterThe me profit to the insurance company an individual as neince, regardless of the level of medical In cet Cul of the Summary worsheet cause the proft to the insurance company an individud tas catastrophe coverage and to medical abycia proprie certified on the Catastrophe Coverage.cact worde. Since there is no medical active therance company without for medical care. Therefore, the profit to the company is the total premis peid by the Individual In color of the Summary worksheet calculate the profit to the more company an individual has trophe rage and low medical activity by referencing appropriate (s) en the 1 Corchecoragen Ketty Worchest. The profit to the company the total premune paid by the individuel met the amount of the total damped by the notare company. The amount of the to come paid by the many is the difference between the tal cost of all claims and the total cost of the pod by the individu The Ent of the Summary worksheet cate the proft to the interce company an individu has the coverage and high medical city by referencing appropriate contre CatastropheCovers wery worksheet. There to the company Destal pred by the individ street cand ped by the company. The amount of the team paid by the company is the difference between the cost of arms and the cost of their paid by the dich 50 1 In cell to the way worth the profits the nice comportamentas pro co do twy by referencing rate () on the Premium Coverage wire there is omdat hinance company wil ingroot for medical came. Therefore, the to the company is the total premium pod Wie Incl 12 of the Summary were come protone company an individual assung and low medical activity by referending appropre col) on the coverage 51 work. The profit to the company reprend paid by the Individuals the most of the total cames ped by the insurance company. The other camped by se me copy the die beween the total cost of and the cost of campaid by the individual In 12 of the worksheet aloitettore companyif an individuals premium coverage and medical activity by referencing aeropen the Premium Coverage worst. The role to the contreprenapoid by the individuals amount of the total claims and by the company. The neurt of the body by the company is the deference between the total cost das and the total cost of the claimspod by the India 47 1 46 49 1 1 52 1 To 40