Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
FYI, Health Insurance Options comparison model
Old 10-30-2014, 01:34 PM   #1
Recycles dryer sheets
 
Join Date: Jan 2010
Posts: 183
FYI, Health Insurance Options comparison model

I created an Excel model that we used for comparing our Health Insurance options as part of 2015 Annual Enrollment.
I wanted to share it on this forum in case others find it useful in analyzing their options.
Note, the numbers are not actuals (but sample).
Let me know if you have any questions.
Attached Files
File Type: xls Compare Health Insurance Options Model.xls (127.5 KB, 192 views)
__________________

__________________
pixelville is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 10-30-2014, 01:46 PM   #2
Moderator
MichaelB's Avatar
 
Join Date: Jan 2008
Location: Rocky Inlets
Posts: 24,492
Interesting. Thanks for sharing the spreadsheet.
__________________

__________________
MichaelB is offline   Reply With Quote
Old 11-01-2014, 03:26 PM   #3
Dryer sheet aficionado
Capwest28's Avatar
 
Join Date: Mar 2014
Location: The Woodlands
Posts: 40
Thanks.


Sent from my iPhone using Early Retirement Forum
__________________
Capwest28 is offline   Reply With Quote
Old 11-01-2014, 07:05 PM   #4
Recycles dryer sheets
 
Join Date: Sep 2010
Posts: 233
Thanks, but I tried to open your spreadsheet and get some weird message that it's a "php" file and asks me whether I want to open this file or save it. When I click on "open" I get another weird message telling me that it can't. This all confuses me because it sure looks like it's an "xls" file. Anybody else have any ideas on what this is about and how to circumvent?
__________________
Corporate ORphan is offline   Reply With Quote
Old 11-01-2014, 07:37 PM   #5
Moderator
rodi's Avatar
 
Join Date: Apr 2012
Location: San Diego
Posts: 8,817
The file opened for me.
It's very interesting - I like the consideration of the tax treatment of HSA/FSA spending.
I may modify it for my own purposes for a Kaiser HMO model (copays rather than deductibles.)
__________________
Retired June 2014. No longer an enginerd - now I'm just a nerd.
micro pensions 7%, rental income 18%
rodi is offline   Reply With Quote
Old 11-02-2014, 02:44 PM   #6
Recycles dryer sheets
 
Join Date: Jan 2010
Posts: 183
Quote:
Originally Posted by Corporate ORphan View Post
Thanks, but I tried to open your spreadsheet and get some weird message that it's a "php" file and asks me whether I want to open this file or save it. When I click on "open" I get another weird message telling me that it can't. This all confuses me because it sure looks like it's an "xls" file. Anybody else have any ideas on what this is about and how to circumvent?
OP here. Works for me. Maybe something to do with your browser settings. You can try right-click and save in case that works.
I also uploaded it to filedropper. Try downloading here
http://www.filedropper.com/comparehe...optionsmodel_1
__________________
pixelville is offline   Reply With Quote
Old 11-03-2014, 07:38 AM   #7
Recycles dryer sheets
Kaufmanrider's Avatar
 
Join Date: Jun 2013
Location: Forney
Posts: 120
Quote:
Originally Posted by pixelville View Post
OP here. Works for me. Maybe something to do with your browser settings. You can try right-click and save in case that works.
I also uploaded it to filedropper. Try downloading here
http://www.filedropper.com/comparehe...optionsmodel_1
That worked for me.

I was getting the same error message on the "php" file as Corporate Orphan with your previous link/file.
__________________
Kaufmanrider is offline   Reply With Quote
Old 11-03-2014, 11:25 AM   #8
Recycles dryer sheets
 
Join Date: Jun 2014
Posts: 406
Nice spreadsheet thanks. I'm not sure I have all the inputs right but I'll take a longer look later on and see how things work.

This should be helpful for me as I transition from work paid to self paid insurance.
__________________
If money is the root of all evil I want to be a bad man
nuke_diver is offline   Reply With Quote
Old 11-03-2014, 07:23 PM   #9
Recycles dryer sheets
 
Join Date: Sep 2010
Posts: 233
Quote:
Originally Posted by pixelville View Post
OP here. Works for me. Maybe something to do with your browser settings. You can try right-click and save in case that works.
I also uploaded it to filedropper. Try downloading here
http://www.filedropper.com/comparehe...optionsmodel_1
Thanks again!
It downloaded when I right clicked to save it as a php file. When I tried to open it, Windows asked me what application I wanted to use (I tried MS Excel, even though I've never seen a spreadsheet with a PHP extension before) and it worked perfectly.

Now all I need to do is read/study it. Thanks again (this time for all the work you've put into creating this spreadsheet and for being patient with the technically slow among us).
__________________
Corporate ORphan is offline   Reply With Quote
Old 11-03-2014, 08:16 PM   #10
Recycles dryer sheets
Theseus's Avatar
 
Join Date: Aug 2013
Posts: 484
Quote:
Originally Posted by pixelville View Post
I created an Excel model that we used for comparing our Health Insurance options as part of 2015 Annual Enrollment.
Thanks pixel -

Very similar to a model I had been using to compare employer subsidized plans for several years, but a bit more elaborate. 2015 will be our first year of ACA shopping, right now looking at a $4k deductible HSA eligible plan with no co-pays. Had to tweak the copay to a crazy low % to make the formulas not err out on first run, but output is great - thanks!
__________________

__________________
Theseus is offline   Reply With Quote
Reply

Tags
comparison, health insurance, hsa, model, ppo


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
FYI: Cost for 5 days of health care in Thailand ItDontMeanAThing Health and Early Retirement 4 03-21-2011 11:31 AM
Now here's your health role model spncity Other topics 2 04-20-2009 07:53 PM
Side by side comparison of Dem candidates' health care blueprint Olav23 Health and Early Retirement 55 02-28-2008 10:29 PM
Comparison Shopping for Health Services REWahoo FIRE and Money 4 01-01-2006 06:23 PM

 

 
All times are GMT -6. The time now is 12:57 PM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.