<prompt> Human: Hi, Im RedRedditRabbit. You might remember me from previous posts such as Why Invest in Bonds at All? and Can a Middle Class Worker Really Retire in Their 50s?. Today Im here to tell you about my most recent calculations. Lets jump into them.Like all of my posts, were going to start with a set of assumptions. These are made to allow for these equations to apply to the broadest market possible: the median male US worker bee with a Bachelors degree.First assumption: You will stop getting real raises in your early 40s. Lots of studies have been conducted on this, the conclusion is that eventually youll get to a point where your raises each year are only barely keeping up with inflation. For some people it happens in their 30s for some it doesnt happen until their 50s, were going to use a nice median age of 45.Second assumption: You started working, and saving, in your early 20s. You dont have to be saving a lot, but hopefully you were saving something.Third assumption: You wont be getting any social security. This will probably be the most debatable of the assumptions, but were going to go ahead and plan ahead as if you wont be getting anything from SS. You can adjust these numbers if you feel like youll be getting a certain amount, but what it boils down to is that it was a lot easier to assume you wouldnt get anything instead of doing a ton of complicated calculations to find how much you might get.Final assumption: Your investments will return a solid 5 real APR over the entirety of your working career. Again, if you dont agree with this, feel free to adjust up or down your final numbers.Lets lay out some math.Were going to use a safe withdrawal rate of 4 to plan your retirement years. There are lots of good arguments for and against using a 4 SWR, but, like above, were going to use this one because it has good data behind it, and its simple.A 4 SWR means that is you want to live on 80k per year, you would need 25x that saved up: 2,000k. Only need 30k per year? Multiply by 25 again and you get 750k.Another good multiplier to keep in mind is 80. Generally speaking retirees spend about 80 of what they would have spent during their working years. So, if youre 65 years old and making 100k and saving 20 of that for retirement, that means youre spending 80k, that means that in retirement youll only need 64k.So what does this all boil down to? Time for some tables!If you work for 40 years youll need to save about 17 of your salary every year. Heres an example of someone that starts working at age 26, and wants to retire at age 65. He should have the following amount saved:AgeSalary Multiple:----:311x372x413x444x475x51.57x559x5811x60.513x6517xSo if youre currently 45 years old, and planning on retiring by 65, you should be saving around 17 of your salary, and have about 4-4.5x your salary saved up. If you make 100k, you should have 400-450k saved. If youre under that, time to start contributing more!What if we shorten that time period down? How much should you save if you want to retire in 30 years? You need to save an average of 30 of your income. Lets start at 22 this time and work until were 51:AgeSalary Multiple:----:251x282x313x344x375x417x459x47.511x5013x5114xAt the age of 51, youd be making 100k, but only spending 70k of that, meaning youd only need 56k in retirement, which means you need 1400k saved up 56k 25 14 100k.Heres the formulas you can drop into excel or google to run some simulations yourself Just dont copy the header part where it says A B C...:A B C D E F G:-- :-- :-- :-- :-- :-- :-- Starting Age 22 Age Salary Estimate Saving Savings EstimateCurrent Age 45 22 ROUNDIFD245,D2-212 -0.0014D2-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD2B1,0,1 IFD2B3,0,1,0 IFD2B1,0,IFD2B1,B8,0 IFD2B3,E2 F2,0Retiring Age 55 23 ROUNDIFD345,D3-212 -0.0014D3-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD3B1,0,1 IFD3B3,0,1,0 IFD3B1,0,IFD3B1,B8,IFF2B9,F2,F20.01 IFD3B3,E3 F3G2 1B7,0 24 ROUNDIFD445,D4-212 -0.0014D4-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD4B1,0,1 IFD4B3,0,1,0 IFD4B1,0,IFD4B1,B8,IFF3B9,F3,F30.01 IFD4B3,E4 F4G3 1B7,0Current Salary 100000 25 ROUNDIFD545,D5-212 -0.0014D5-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD5B1,0,1 IFD5B3,0,1,0 IFD5B1,0,IFD5B1,B8,IFF4B9,F4,F40.01 IFD5B3,E5 F5G4 1B7,0 26 ROUNDIFD645,D6-212 -0.0014D6-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD6B1,0,1 IFD6B3,0,1,0 IFD6B1,0,IFD6B1,B8,IFF5B9,F5,F50.01 IFD6B3,E6 F6G5 1B7,0Real Investment Gains 0.05 27 ROUNDIFD745,D7-212 -0.0014D7-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD7B1,0,1 IFD7B3,0,1,0 IFD7B1,0,IFD7B1,B8,IFF6B9,F6,F60.01 IFD7B3,E7 F7G6 1B7,0Start Saving 0.2 28 ROUNDIFD845,D8-212 -0.0014D8-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD8B1,0,1 IFD8B3,0,1,0 IFD8B1,0,IFD8B1,B8,IFF7B9,F7,F70.01 IFD8B3,E8 F8G7 1B7,0Max Saving 0.25 29 ROUNDIFD945,D9-212 -0.0014D9-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD9B1,0,1 IFD9B3,0,1,0 IFD9B1,0,IFD9B1,B8,IFF8B9,F8,F80.01 IFD9B3,E9 F9G8 1B7,0 30 ROUNDIFD1045,D10-212 -0.0014D10-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD10B1,0,1 IFD10B3,0,1,0 IFD10B1,0,IFD10B1,B8,IFF9B9,F9,F90.01 IFD10B3,E10 F10G9 1B7,05 SWR: MAXG2:G45 0.05 31 ROUNDIFD1145,D11-212 -0.0014D11-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD11B1,0,1 IFD11B3,0,1,0 IFD11B1,0,IFD11B1,B8,IFF10B9,F10,F100.01 IFD11B3,E11 F11G10 1B7,04 SWR: MAXG2:G45 0.04 32 ROUNDIFD1245,D12-212 -0.0014D12-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD12B1,0,1 IFD12B3,0,1,0 IFD12B1,0,IFD12B1,B8,IFF11B9,F11,F110.01 IFD12B3,E12 F12G11 1B7,03 SWR: MAXG2:G45 0.03 33 ROUNDIFD1345,D13-212 -0.0014D13-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD13B1,0,1 IFD13B3,0,1,0 IFD13B1,0,IFD13B1,B8,IFF12B9,F12,F120.01 IFD13B3,E13 F13G12 1B7,0Desired Retirement Salary MAXE2:E45 1-MAXF2:F45 0.8 34 ROUNDIFD1445,D14-212 -0.0014D14-21 0.09610.834,2.375 B5IFB245,B2-212 -0.0014B2-21 0.09610.834,2.375 IFD14B1,0,1 IFD14B3,0,1,0 IFD14B1,0,IFD14B1,B8,IFF13B9,F13,F130.01 IFD14B3,E14 F14G13 1B7,0Simply drag those 4 right-most columns down to fill in the formulas up to age 65 or wherever you want to stop, and change the values in column B to whatever you want. You can adjust your saving schedule to increase in percentage every year as well.A couple of things to keep in mind. If youre married, these calculations are for a single person. If your family only needs 60k a year in retirement, you dont need to save that all up yourself unless your spouse doesnt work. If youre female, your salary is more likely to cap out when youre in your late 30s, instead of mid 40s. Sorry, thats just what the research shows happens. If you want to tailor this to your own real expected salary values instead of using the estimates go ahead, just change the numbers in the Salary Estimate column to whatever you want, just remember that this is in real values, so if youre going to use the salary you actually made 20 years ago dont forget the inflation.Once you drop everything into excel, it should look something like this:What do you guys think? Im hoping this will be useful to people to help them estimate out into the unknown. Dont treat this as a roadmap, its more of a compass. It should give you an idea of whether or not youre heading in the right direction, but wont be able to tell you exactly how far you have to go.  <response>: Im so screwed. 