{"id":31157,"date":"2012-07-31T05:49:40","date_gmt":"2012-07-31T09:49:40","guid":{"rendered":"http:\/\/valorguardians.com\/blog\/?p=31157"},"modified":"2015-02-07T12:59:03","modified_gmt":"2015-02-07T17:59:03","slug":"a-free-current-and-qrmc-reserve-retired-pay-estimator","status":"publish","type":"post","link":"https:\/\/www.azuse.cloud\/?p=31157","title":{"rendered":"A Current and QRMC Reserve Retired Pay Estimator"},"content":{"rendered":"<p>It occurred to me that the spreadsheet I prepared to produce estimates for my <a href=\"https:\/\/www.azuse.cloud\/?p=31113\">previous article about the QRMC recommendations<\/a>\u00a0 could be modified to serve as a simple, general-purpose retirement pay calculator for Reserve personnel under both options.\u00a0 While others Reserve retirement pay calculators exist (most notably<a href=\"https:\/\/www.hrc.army.mil\/Calculators\/RetirementCalc.aspx\"> this one<\/a> at US Army Human Resources Command), they appear to make various assumptions concerning future pay raises and inflation that may or may not be accurate.\u00a0 They also don&#8217;t seem to attempt to convert their calculated future value to current dollars, thus making interpretation of the result difficult.\u00a0 And they and also don&#8217;t seem that easy to use for &#8220;what if&#8221; drills concerning future correspondence work, voluntary active duty, mobilizations, and the like.\u00a0 So I decided I&#8217;d make this spreadsheet available.\u00a0 You\u2019ll need software that can use a MicroSoft Excel (97-2003) format workbook in order to use it.<\/p>\n<p>The spreadsheet calculates, under both current and QRMC rules, the Reserve pension that a reservist will earn under each system, plus the percentage reduction under the QRMC proposal.\u00a0 Users must enter their actual and estimated yearly retirement points and selected other data.\u00a0 The procedures which follow describe that other data and tell the user how to obtain or calculate it.<!--more--><\/p>\n<p><strong>\u00a0Procedure for Use<br \/>\n<\/strong><\/p>\n<p>1.\u00a0 Download the <a href=\"https:\/\/www.azuse.cloud\/wp-content\/uploads\/2015\/02\/RC_Retired_Pay_Estimator_Current_and_QRMC.xls\">spreadsheet found here<\/a>.<\/p>\n<p>2.\u00a0 Find or download your latest retirement points statement.\u00a0 For the Army, that would be ARPC Form 249-2-E (for Army Reserve) or the NGB equivalent (for National Guard).\u00a0 Don&#8217;t know what the other services&#8217; reserve components call theirs.<\/p>\n<p>3.\u00a0 Enter your retirement points earned to date each year into the corresponding years of the spreadsheet &#8211; e.g., your first year of service is year 1, the next is year 2, etc . . . .\u00a0 Include all retirement points earned \u2013 points from \u201cbad\u201d (non-qualifying) years also count towards retired pay, even though those years don&#8217;t count towards the 20 qualifying years needed for Reserve retirement.<\/p>\n<p>4.\u00a0 Take your best guess as to how many retirement points you\u2019ll earn each year during the rest of your Reserve career.<\/p>\n<ul>\n<li>&#8220;Normal&#8221; Reserve Years (drill weekends plus AT):\u00a0 A \u201cquick and dirty\u201d method for drilling reservists for current rules is to start with 77 points per year (48 points for drills plus 14 days AT plus 15 membership points) and add to that any points you expect to earn yearly from correspondence courses.\u00a0 Enter this total for the year in question.\u00a0 For QRMC rules, use 53 points (24 points for drills plus 14 days AT plus 15 membership points) and add to that any points expected for correspondence courses, then enter that for the year in question.<\/li>\n<li>Years With Active Duty Other than AT:\u00a0 This is more complex, but still not terribly difficult to estimate.\u00a0 Write down the number of\u00a0 the number of days you expect to serve on active duty during that year (1 point per day of active duty &#8211; don\u2019t forget to count your AT if you perform it).\u00a0 Add to that 15 membership points, any points expected from drills (you may drill part of the year before or after serving on active duty), plus any points expected for correspondence courses. Enter that total for the year in the spreadsheet.\u00a0\u00a0 Repeat for both options &#8211; current rules and QRMC proposal.\u00a0 Remember to use 4 points for a drill weekend under current rules and 2 points for a drill weekend under the QRMC proposal.\u00a0 \u00a0 Also remember that total retirement points cannot exceed the number of days in a year &#8211; 365, or 366 if a leap year.<\/li>\n<\/ul>\n<p>5.\u00a0 Enter zeros for retirement points for those years after you plan to request either movement to the Retired Reserve list or discharge.\u00a0 GOs, W5s, and CSMs can serve well beyond 30 years; medical personnel and Chaplains generally can also serve longer as well.\u00a0 I\u2019ve extended the spreadsheet to cover up to a 40-year career possibility \u2013 not that I expect many GOs\/W5s\/CSMs to use the spreadsheet.\u00a0 (smile)<\/p>\n<p>6.\u00a0 Take your best guess at the grade at which you\u2019ll retire.\u00a0 There\u2019s a place to enter that on the spreadsheet, but it\u2019s not mandatory to enter it; the spreadsheet works whether you enter a rank or not.<\/p>\n<p>7.\u00a0 Determine when you\u2019d be eligible to receive retired pay under QRMC recommendations. \u00a0That could be as early as age 47 or as late as age 60 (or even later), depending on when you first entered the military.\u00a0 It\u2019s the earlier of (a) 30 years after first entry into the military, OR (b) age 60 \u2013 provided you have 20 qualifying years service at that point.\u00a0 (If\u00a0 you don&#8217;t have 20 years of qualifying service at your 30 year anniversary, it\u2019s whenever you achieve 20 qualifying years of service.\u00a0 Getting 20 qualifying years could technically happen after the 30-year anniversary \u2013 or even after age 60 \u2013 given the proper combination of breaks in service\/age at initial entry\/number of \u201cbad\u201d years).\u00a0 You\u2019ll need this info later to determine your years of service for pay purposes.\u00a0 For most Reservists, though, this will be simple &#8211; it&#8217;s the date you first entered the military plus 30 years.<\/p>\n<p>8.\u00a0 Look up the value of a retirement point corresponding to your projected retired grade and years of service for pay purposes <a href=\"https:\/\/www.hrc.army.mil\/Calculators\/ValueOfAPoint.aspx\">under current rules here<\/a>.\u00a0 Enter the appropriate value in the corresponding spreadsheet block, \u201cValue of Retired Point \u2013 Current Rules\u201d.\u00a0 <em>This value must be entered for the spreadsheet to calculate current rules pensions.<\/em>\u00a0 Make sure you enter all 3 decimal places. \u00a0This gives you today\u2019s value of your estimated Reserve retirement pension under current rules.\u00a0 Don\u2019t forget that time on the retired list counts for pay purposes; this generally puts you in the \u201cmaxed out\u201d part of the table (almost everyone who goes into the Retired Reserve will end up with more than 30 years of service for pay purposes under current rules).\u00a0 I\u2019m pretty sure the tables of retirement point values assume transfer to the Retired Reserve, so they may not work well (or at all) if you opt for discharge. \u00a0(More about opting for discharge in the remarks at the end.)<\/p>\n<p>9.\u00a0 The point values from step 8 won\u2019t work to calculate retired pay under QRMC rules (the QRMC rules use a different number of days for an equivalent year and earlier receipt of Reserve retired pay further complicates things).\u00a0 For this case, you\u2019ll need to estimate your highest 3 years of base pay and enter that into the spreadsheet.\u00a0 For the vast majority of folks, that will be the base pay corresponding to your retired grade during the 3 years prior to your receiving retired pay.\u00a0 You\u2019ll also need to determine the number of years of service for pay purposes you have during each of these years,<\/p>\n<ul>\n<li>H<a href=\"http:\/\/www.dfas.mil\/militarymembers\/payentitlements\/militarypaytables.html\">istorical pay charts can be found here<\/a>.\u00a0 Look up the pay charts for your projected retired grade for last year, and the 2 years prior to that.<\/li>\n<li>Determine your number of years for pay purposes under the QRMC recommendation you&#8217;d have during the last 3 years before you start drawing retired pay.\u00a0 To do this, start with 30 (this assumes you have at least 20 good years on your 30th anniversary of initial entry \u2013 if not, you\u2019ll need to add enough years to adjust this number to correspond to the year you expect to achieve your 20th year qualifying for Reserve retirement).\u00a0 Subtract the duration of any breaks in service \u2013 e.g., if you were completely out of the military, including the \u00a0Reserve Components, for 5 years you&#8217;d subtract 5.<\/li>\n<li>\u00a0From the resulting number, subtract 1, 2, and 3 and disregard any fraction.\u00a0 This gives the number of years of service for pay purposes you\u2019d have for the last 3 years before you begin drawing retired pay on the 30th anniversary of your initial entry into the military.<\/li>\n<li>Look up the appropriate values for years of service for pay in the pay tables for the 3rd year prior, 2nd year prior, and the year prior to starting to draw retired pay.<\/li>\n<\/ul>\n<p>Here&#8217;s an example.\u00a0 For someone who has no break in service and has 20 good years on his\/her 30-year anniversary of first joining the military, you&#8217;d start with 30.\u00a0 Subtract zero (no breaks in service).\u00a0 Now subtract 1, 2, and 3.\u00a0 This yields 27, 28, and 29 &#8211; the number of years of service for pay purposes for each of the last 3 years before the individual could start receiving Reserve Retired pay.\u00a0 (These values will generally be the case under the QRMC proposal).\u00a0 With a 5 year break in service, you&#8217;d subtract 5 in place of zero above; this would yield 22, 23, and 24 years.\u00a0 Those are the years of service for pay purposes you\u2019d look up in the pay tables for 3 years\/2 years\/1 year prior to receiving retired pay.<\/p>\n<p>Remember to use base pay only &#8211; no allowances or special pays.<\/p>\n<p>10.\u00a0 Enter the pay values from step 10 for base pay at 3 years prior\/2 years prior\/1 year prior into the spreadsheet in the QRMC High-3 Calculations \u2013 Base Pay area.<\/p>\n<p>&nbsp;<\/p>\n<p>The spreadsheet will now calculate the retired pay estimate under both scenarios \u2013 e.g., current rules and QRMC recommendations.\u00a0 It&#8217;s obviously not the easiest calculator in the world to use, but hey &#8211; it&#8217;s free.\u00a0 And it doesn&#8217;t assume anything about the future other than annual military pay raises being about equal to inflation (historically they have since the early 1970s).\u00a0 What you get is the current value, in today&#8217;s dollars, of your estimated Reserve Retirement pension.\u00a0 Personally, I find current values easier to understand and compare than an inflated value for some future date.\u00a0 I know what things cost today; mentally adjusting for multiple years of future inflation and pay raises is a bit trickier.<\/p>\n<p>&nbsp;<\/p>\n<p>Since it&#8217;s a reasonably common one, I\u2019ve also preloaded the spreadsheet with the following scenario.\u00a0 Replace it with your own data if you use the spreadsheet, of course.<\/p>\n<p>1. \u00a0An individual joins the Active Component and serves a 4-year initial enlistment.<\/p>\n<p>2.\u00a0 He\/she then leaves active duty and goes directly into the Reserve Component (no break in service).<\/p>\n<p>3.\u00a0 The individual joins a drilling unit immediately, makes all scheduled drills and Annual Training periods for the next 16 years, and earns an average of 10 correspondence points per year while drilling.<\/p>\n<p>4.\u00a0 His\/her unit is mobilized once during the next 16 years for one year.<\/p>\n<p>5.\u00a0 In addition to their mobilization, the individual serves a 1-year tour of voluntary active duty at some point before retirement.<\/p>\n<p>6.\u00a0 The individual is promoted to E7 before retirement and retires at that rank.<\/p>\n<p>7.\u00a0 He\/she elects to move to the Retired Reserve list immediately on completing 20 years of service.<\/p>\n<p>Under current rules, the individual would &#8220;max out&#8221; the E7 pay scale due to continuing service for pay purposes while on the retired list and would draw retired pay between ages 58 and 60 (depending on whether their later active duty was contingency support service or not).\u00a0 Under QRMC proposals, their retired points (and pay) would be lower, and would be based on pay tables for 27, 28, and 29 years of service.\u00a0 (For E7, those years of service are also &#8220;maxed out&#8221; on the pay scale; however, that&#8217;s not true for all grades.)\u00a0 However, they&#8217;d get that pay starting on the 30th anniversary of joining the military &#8211; in their late 40s, most likely.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Remarks<\/strong><\/p>\n<p>1.\u00a0 Retired Reserve vs. Discharge. \u00a0 I\u2019d <em>very strongly<\/em> recommend anyone think twice before opting for discharge.\u00a0 Under the \u201chigh 3\u201d system, Reserve Retired retired pay is calculated at time of final retirement or discharge.\u00a0 If you move to the Retired Reserve list, that means retired pay is determined when you start drawing retired pay, using the pay tables in effect for the previous 36 months (assuming those are the highest 36 months of base pay during your career).\u00a0 However, if you elect dischargethat calculation <em>occurs immediately and is based on actual high-three average at that time<\/em>.\u00a0 You thus likely won\u2019t \u201cmax out\u201d the pay tables through additional service credit for pay purposes for time spent on the Reserve retired list.\u00a0 You also won\u2019t get the benefit of any future pay raises that might happen between discharge and your receipt of retired pay. Under current rules, that can <span style=\"text-decoration: underline;\">really<\/span> hurt &#8211; because you won\u2019t start drawing retired pay until between ages 55 and 60 (usually closer to 60).\u00a0 That means you&#8217;ll miss out on up to 22 years worth of\u00a0 annual pay raises between discharge and the date you start drawing retired pay.\u00a0 (It also hurts under the QRMC recommendations too if you don\u2019t stay for 30 \u2013 just not as much, since under that proposal you&#8217;re typically waiting for 10 years or less to start drawing retired pay.)<\/p>\n<p>2.\u00a0 Inflation.\u00a0 The spreadsheet calculates what a Reserve pension would be worth if it were starting today.\u00a0 We don\u2019t have a clue as to what future inflation and\/or annual military pay raises are, so this implicitly assumes that pay raises will equal inflation.\u00a0 Reality may be either better or worse, but history indicates that military pay raises will probably track CPI reasonably closely (they have since the early 1970s).\u00a0 If that continues, future pensions should have roughly the same purchasing power as those calculated by this spreadsheet.<\/p>\n<p>3. Estimation Error.\u00a0 The use of prior-year pay tables in calculating the high-3 average for QRMC recommendations pensions introduces a minor source of potential error.\u00a0 Depending on precisely when you start receiving retired pay, this will be either very close to actual (if one starts receiving retired pay early in the year) or a slight underestimate (if one starts receiving retired pay late in the year).\u00a0 The max error should be 1\/3 of the annual cost-of-living raise received in January of the year during which one begins receiving Reserve retired pay.<\/p>\n<p>4.\u00a0 Comparing the Two Pensions.\u00a0 The pensions under current rules and QRMC recommendations are only directly comparable if one were to begin receiving them at the same time (e.g., an individual joined at age 30 and served 30 years with no breaks in service).\u00a0 Otherwise, it\u2019s difficult to compare the two.\u00a0 Current rules yield a higher pension and generally higher annual pay, but make you wait until near age 60 to receive a pension.\u00a0 The QRMC proposal yields less annual pay and a lower pension &#8211; but the pension also starts up to 13 years earlier.\u00a0 Is less annual pay and a lower pension received for more years a better deal than more annual pay and a somewhat higher pension starting at or near age 60?\u00a0 Dunno; that&#8217;s an individual call.\u00a0 YMMV from mine.<\/p>\n<p>5.\u00a0 Base Pay Loss under QRMC.\u00a0 Not addressed here since this is a retirement pay calculator.\u00a0 As noted in the previous article, a drilling reservist will see nearly a 39% reduction in pay for &#8220;normal&#8221; years (drill plus AT) under the QRMC proposal.<\/p>\n<p>&nbsp;<\/p>\n<p>If you note any errors,please indicate in the comments section and I&#8217;ll revise the instructions and\/or spreadsheet.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It occurred to me that the spreadsheet I prepared to produce estimates for my previous article &hellip; <a title=\"A Current and QRMC Reserve Retired Pay Estimator\" class=\"hm-read-more\" href=\"https:\/\/www.azuse.cloud\/?p=31157\"><span class=\"screen-reader-text\">A Current and QRMC Reserve Retired Pay Estimator<\/span>Read more<\/a><\/p>\n","protected":false},"author":623,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[84,206],"tags":[],"class_list":["post-31157","post","type-post","status-publish","format-standard","hentry","category-military-issues","category-reserve-issues"],"_links":{"self":[{"href":"https:\/\/www.azuse.cloud\/index.php?rest_route=\/wp\/v2\/posts\/31157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.azuse.cloud\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.azuse.cloud\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.azuse.cloud\/index.php?rest_route=\/wp\/v2\/users\/623"}],"replies":[{"embeddable":true,"href":"https:\/\/www.azuse.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=31157"}],"version-history":[{"count":0,"href":"https:\/\/www.azuse.cloud\/index.php?rest_route=\/wp\/v2\/posts\/31157\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.azuse.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=31157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.azuse.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=31157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.azuse.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=31157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}