So the formulas seem to work OK in Excel?
I had no way to test it.
The formulas work great for me. I'm using OpenOffice Calc.
Kudos! Very nicely done!
Using your spreadsheet and the plans available in my state I've done 3 different scenerios with OMAGI of $30k, $35k and $40k. As expected the premium/subsidy varies but what surprised me was how much the deductible and oop varied for seemingly the same plan at different levels of OMAGI.
I can see where this could be a real reconciliation headache at tax time
should one grossly underestimate their OMAGI, gaining cost share benefits, only to have to pay them back at tax time.