Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Healthcare expense modeling spreadsheet?
Old 06-21-2007, 07:45 PM   #1
Confused about dryer sheets
 
Join Date: Jan 2006
Posts: 6
Healthcare expense modeling spreadsheet?

Does anyone know where I can download a healthcare modeling spreadsheet? I would like to plug in various premium, coverage limits, deductibles and model what would be the best plan under different assumptions of medical expenses.

I have looked around the web and have not found anything.

Thanks.
__________________

__________________
BD1 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 06-21-2007, 09:05 PM   #2
Moderator Emeritus
Martha's Avatar
 
Join Date: Feb 2004
Location: minnesota
Posts: 13,212
One of my favorite websites on insurance is sponsored by Georgetown University at Health Insurance Consumer Guides. REWahoo pointed out to me not long ago that Georgetown now has a booklet on its site entitled Understanding Private Health Insurance. The booklet helps you evaluate different polices. http://www.healthinsuranceinfo.net/n..._Insurance.pdf

Page 12 of the booklet has a worksheet to complete for each policy you review to assist in comparing policies.

It is especially good in describing rights you have when navigating health insurance transistions, such as going from a group policy to an individual policy when you retire.
__________________

__________________
.


No more lawyer stuff, no more political stuff, so no more CYA

Martha is offline   Reply With Quote
Old 06-21-2007, 09:13 PM   #3
Full time employment: Posting here.
 
Join Date: Dec 2006
Posts: 860
Quote:
Originally Posted by BD1 View Post
Does anyone know where I can download a healthcare modeling spreadsheet? I would like to plug in various premium, coverage limits, deductibles and model what would be the best plan under different assumptions of medical expenses.

I have looked around the web and have not found anything.

Thanks.
I actually have one that I created for comparing a traditional copay plan to an HSA. I think I still have it. If you send me your email, I'll send it to you.
__________________
mykidslovedogs is offline   Reply With Quote
Old 06-21-2007, 09:20 PM   #4
Moderator Emeritus
Martha's Avatar
 
Join Date: Feb 2004
Location: minnesota
Posts: 13,212
Here is a pdf of the worksheet from the Georgetown site:

http://www.healthinsuranceinfo.net/nefe/worksheet.pdf
__________________
.


No more lawyer stuff, no more political stuff, so no more CYA

Martha is offline   Reply With Quote
Old 06-21-2007, 11:27 PM   #5
Confused about dryer sheets
 
Join Date: Jan 2006
Posts: 6
Martha, thanks!
mykidslove dogs, also thanks! and I sent you a pm
__________________
BD1 is offline   Reply With Quote
Old 06-22-2007, 11:27 AM   #6
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
TromboneAl's Avatar
 
Join Date: Jun 2006
Posts: 11,199
Click here for the XLS worksheet that I used a few years ago. It's very simple (disclaimer:and may have mistakes). You put in your premiums and a range of expenditures, and it shows you how much each of the two plans would cost.

For example, in this case if you had medical expenses of $4,500, the 2500 deductible plan would cost you $292 more than the 5000 deductible.
Spreadsheet.jpg
__________________

__________________
TromboneAl is offline   Reply With Quote
Reply


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
Portfolio tracking spreadsheet justin FIRE and Money 8 06-28-2010 05:01 AM
The REAL Cost of Healthcare Premium Caps ScaredtoQuit FIRE and Money 25 06-18-2007 08:46 PM
Spreadsheet for calculating life of retirement assets tlg501 FIRE and Money 2 03-12-2007 01:09 PM
Income portfolio modeling spreadsheet? BD1 FIRE and Money 1 05-29-2006 06:58 AM
Natural Limits to Healthcare Expense Growth? haha FIRE and Money 84 06-11-2005 06:59 PM

 

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