Health Insurance Comparison Spreadsheet Reddit
Health insurance plan comparison spreadsheets recently we were choosing between a variety of health insurance plans.
Health insurance comparison spreadsheet reddit. Resulting cost out of pocket including premiums. Being the geek that i am i took the decision making process to the nth degree and decided to set up a little excel spreadsheet to compare the plans. Below is a spreadsheet i created for my own personal use.
Before i thought to look online i had already made my own but i guess that s all well and good because it was a nice eye opening experience to think through the ridiculous rules of each of the health insurance plans myself. Apologies if this gets asked around here. Yes we could pay as much as 15 000 yearly or as little as 3 000 depending on the insurance plan and health needs.
My so recently lost her job and her employer covered health insurance as a result. It s just a spreadsheet that you download to your local computer. It takes plan information such as premiums max out of pocket copays deductibles etc and information about your personal health habits numbers of prescriptions in each tier number of office visits cost of pump and cgm supplies etc.
Here s my only comment it assumes you do not have an existing hsa account with funds already in it. It currently compares 3 plans. This allows you to compare plans to see which one is the cheapest in total cost for the year.
I m looking to help her find another health insurance plan for continued coverage and found the plans available on https nystateofhealth ny gov however if i m understanding the charts correctly these plans start at 450 a month for individuals which to me seems. How to use a spreadsheet to compare health insurance plans march 14 2019 june 12 2020 by brynne conroy 8 minutes of reading twitter facebook linkedin reddit. May end up creating my own for my company but lots of people out there are way better at formulating aesthetically pleasing spreadsheets.
Open enrollment just hit my company and they got rid of my plan from last year. If there were a cell where you could plug in your hsa balance previously accrued and then that money could be used towards out of pocket costs for both the low and high deductible. I decided to plot each of the 3 plans on top of each other with potential yearly medical expenses vs.