Treatment Report | Tangle | Original Excel | |

Solving Medicare Through Compromise

Short version:


With US GDP growth of % , Medicare inflation of %, Medicare age of , effective tax rate increase of % on top 1%, and tax increase of the bottom 50% the resulting Medicare budget shortfall over ten years is:


Detailed version:

In order to come up with a solution to Medicare, three players need to compromise.

This model of Medicare allows experimentation with assumptions about Medicare age and inflation, GDP growth, and effective tax rates. Notice that Medicare taxes for part A do not include changes brought about by healthcare law in 2013 which would increase tax rate by 0.9% and would apply to about 50% of 3 trillion of income (approximately). I decided not to include it as it was difficult to come up with a good formula to match government projections into 2020 which seem overly optimistic.

Choose from scenarios below or create your own by manipulating blue variables anywhere you see them
Model Scenario Medicare Age Medicare inflation GDP growth Effective Tax Rate Increase on top 1%
(starting in 2013)
Effective Tax Rate Increase on bottom 50%
(starting in 2013)
Slow increase (to 67 by 2020) Slower than 2010 (below 2%) Normal (2.8%) 3.3% 0%
Slow increase (to 67 by 2020) Same as 2010 (2.78%) Normal (2.8%) 5.4% 0%
No increase Much slower than 2010 (0.5%) Slow (1.5%) 3.0% 0.8%

Medicare Budget Projections Based on Medicare Age, GDP Growth, Medicare Inflation, and New Tax Revenues
2010
Medicare Age
Total Medicare Outlays at % inflation rate
GDP at % growth rate
Medicare as % of GDP
Shortfall of revenue(spending at the same % of GDP as in 2010)
Increase the effecitve tax rates
on top 1% (over 380K): current 23% + % = %
on bottom 50% (less than 33K ): current 1.8% + % = %
(These increases will take place starting in 2013)
Effective tax rate is on federal income tax (not SS or Medicare taxes)
Shortfall over ten years (accounting for gdp, inflation, and Medicare age):
New tax revenue from top 1%:
New tax revenue from bottom 50%:
Shortfall after new tax revenue:


Medicare Spending adjusted for Medicare population
Medicare PartServiceInflation Rate2010



Medicare Tax Revenues and Shortfall
Revenue Source2010
Medicare Tax (for Part A)
General fund tax collected (for parts B, C, D) at 2010 % of GDP
Total taxes collected
Shortfall of tax
Income earned by top 1%
Income tax paid by top 1% at 23.2% effective tax rate
Rate Increase necessary for a given year for top 1% (from 2010 rate)
New tax revenue generated by increasing
the effecitve tax rate of 23% by on top 1% (over 380K)
Income earned by bottom 50%
Income tax paid by bottom 50% at 1.84% effective tax rate
Rate Increase necessary for a given year for bottom 50% (from 2010 rate)
New tax revenue generated by increasing
the effecitve tax rate of 1.8% by on bottom 50% (less than 33K)



Medicare population based on Census data and accounting for disabled and unenrolled
Age20102011201220132014201520162017201820192020
Total number of people on Medicare
Total number of people at and above age
Disabled (at 2% growth)
Grandfathered in
Data below is from Census. Each cell show the number of people alive at that age
043545474393553442765044575154483378450610445266634546394456659345876594609539
143207234363860440298644372074467202449319945160684536777455665745770044598219
242854374330091437330844125164446819447690045029854525948454675445667314587174
342495964293204433792643812094420487445485944849964511139453416045550234575059
442158604256129429980543445964387948442729644617244491904451809145411584562065
541840884222766426311543068724351742439517444345784469050449927245255024548615
641553494191672423044142708804314727435968644031974442652447717745074544533736
741324574163288419971742385934279138432309143681134411676445118644857634516095
841146664140996417195342085064247506428817443322364377325442095344605304495175
941192854123352414980441808844217561425668342974434341580438674544304524470105
1039616844129472413366441602374191435422823342674624308300435251643977554441542
1139218743973859414175441460744172773420409642410004280326432125743655704410900
1239085473935356398746841554734159926418675342181944255196429462143356504380063
1339414003923756395070340029484171066417566242026104234158427126743107974351932
1440337863958691394121539683214020719418896441937014220769425243542896604329305
1540998744052688397780039605113987788404034942087014213574424077142725664309918
1641647414120045407307639984163981328400878540614974229931423495942623024294239
1742675974186827414237740956584021266400440340320414084899425341342586184286125
1843550624291807421135441671904120758404667740300584057890411092142795304284945
1944492014375920431299342328824189029414290940691494052782408083441340644302789
2044848224466985439405843314724251717420818741623604088900407278641010554154484
2143715084499594448205544094694347208426779542245434178963410576840898744118327
2243045604384668451290644956474423383436143142823114239288419394241209994105310
2342486984320669440097745293764512404444046943788054299957425717542120734139393
2442667854267530433972644202534548832453216344605494399163432060942780884233253
2542579484289436429047643629024443654457241945560524484761442368343454544303224
2642224994282360431409443154074388044446900145979414581868451091444501614372272
2742667754245713430578643377544339327441216044933184622429460665145360364475612
2842861864287844426706043273404359539436136944344004515759464503446295454559263
2943418094305564430746042869484347422437984243819324455162453671246661374650929
3043025744361914432594143280714307830436849344011414403502447693045586724688245
3141304664321789438131443456104347970432799643888424421708442432044979264579839
3240207644145725433707043967574361303436387343441454405152443820444410354514784
3339349954034126415915043504884410317437509443778574358361441951344527364455771
3438825243946896404609541711634362470442242243874244390368437109444323754465758
3539373713892703395716740564154181505437275844328154398034440114443820804443472
3638520763946415390197839665204065801419089443820774442234440766244109324392071
3739294363860100395446339102573974871407417941992694390371445062844162664419698
3840981293935964386689639612753917299398197940813064206386439739044577384423580
3943196294103241394150038727043967097392335439880824087407421245244033324463750
4044013144323550410769039463813877858397225839287443993506409281642178104408546
4141866144403873432642141110903950213388195539763413933044399784140971324222071
4240912394188308440532043281914113410395298238849863979340393625940010824100341
4340966014092070418911744058784329086411487739549063887175398149139386294003475
4442084004095016409065841876624404133432768641140733954574388712339813913938759
4544733964205178409224640880724185026440117743250904112112395311938859663980177
4645379234468712420138440889354084964418187443976834321962410964139511713884321
4745270994531864446303841966314084675408090041777474393178431783941062093948290
4845410954519473452442544559864190544407909140754984172249438726343123314101439
4945746844531380451001445151284447069418263440717054068288416491243794494304933
5046469284563315452033944992294504498443682941734804063118405989641563874370417
5144754814633010454994845073314486501449194244247324162584405284840498534146222
5244581744459992461705345345694492321447177644774184410711414983440407544037992
5343576314441060444308645996344517755447589244556614461524439532641357824027377
5442343744338929442216244244134580409449918644577524437874444395243782844120164
5542157994213921431814144011564403647455903844785364437576441806844243674359261
5640205184193160419156442954064378170438090045356264455889441541743962844402800
5738928473996792416850841672004270616435309543560914510107443118743912334372495
5837598503867606397104541417574140753424370443258864329179448243644044014365007
5936178683733523384073339436614113339411267542151714297073430068344531494376047
6036018253589872370486638115163913924408252240822474184276426588042698324421452
6134557083570684355922436735033779546388139140488164048953415046242317254236031
6234512313422729353690135259793639498374489938461354012297401287941138324194732
6333954683414271338655734998673489541360224537069443807514397230439733704073719
6427744733354971337398933470693459396344965735614413665343376516739284473930012
6526037152737692331034033295113303373341454534053903516109361909437180543879632
6625745802565565269778332619823281277325594433658483357291346681735687723666755
6725597352533611252506826554353210744323016632056943314278330634234146013515458
6823187832515636249035024823192610778315685431764313152876326009232528093359759
6921152572275729246924224448762437423256394931004353120160309753032033003196666
7020136362071649222919624191642395814238901225134493039645305951730378633142073
7119072291968140202532521797882366018234374223375972459804297517329952422974657
7218236751860382192029119765972127825231013222889332283432240331429073622927645
7317082871774619181084318696771925038207284022509652230851222601523434332835530
7416446121658450172334717590641816776187114820153832189158217020621660952280984
7516020481592670160659716699961705182176172018150551955557212481021070992103772
7614658851546636153819515522031614010164862217038981756112189264620570912040656
7714189001410210148846914809911495068155519415891691643085169409018264291985792
7813686641360081135237514280541421565143571014940561527334157981416295381757503
7913307321306289129881412921141365095135961313737901430249146278215137481562119
8012859781264174124165812352871229591129973912952421309398136388213956221444995
8111960411216349119647711758951170622116592512331431229597124370612961531327057
8211385481126021114596311280281109386110520711014641165663116304311770731227425
8310611901065578105467510741881058176104146310383281035501109658010948721108789
84982760987094991990982657100167198753697270397055096862810265251025716
85916930908335913132918487910672929137916818903807902598901550956223
86826149841382834329839535845290838930856781846214834976834659834439
87730490752194766937761326766864772937767949785127776245766717767235
88663034659446679901694084689810695607701918698199714648707360699454
89576339593042590666609836623403620362626339632808630241645895640080
90490324510454526029524710542546555420553483559555566097564563579369
91403858429674448012462417461997478460490576489599495688502220501599
92334928349815372846389426402648402987418060429366429196435208441634
93274491286502299832320190335047347072348023361709372162372655378507
94223689231716242345254154271966285145295973297387309706319285320310
95181599186193193301202608212959228383239953249601251334262305270984
96141217148902153024159238167288176252189462199510208005209927219583
97108326113932120426124058129410136276143949155134163763171162173175
987940285876905639597699126103671109453115941125294132611138973
9958343617706700470866753147800381814866269202999741105858
100114339125245136043148188160345173024184815196875209962224328241485

Data sources used for this model
Organization Title and Link
Census Personal Income and Its Disposition: 1990 to 2009
US Department of Health and Human Services Fiscal Year 2010 Budget in BriefMedicare
IRS Individual Statistical Tables by Tax Rate and Income Percentile
Standard and Poors US Healthcare Costs Continue to Rise, But At Declining Rates According to the S&P Healthcare Economic Indices/td>
Tax Foundation Summary of Latest Federal Individual Income Tax Data


v3.0 - January 20th, 2012 - added short version

v2.0 - November 10th, 2011