Retirement: how to forecast where you’re at?
Retirement: how to forecast where you’re at?
Is there a tool or worksheet that will help us make estimates / forecasts on what our current investments might look like by the time we retire?
I am imagining being able to specify a portfolio balance, average conservative return per year until retirement.
Basically a way to keep track of whether we are realistically going to hit the number we decide we want by then.
EDIT:
I am looking for a forecast based on human inputs.
ie if you have $X in portfolio assets today and plan on retiring in say 27 years, assuming a “conservative” 8%/year return, how much will your current portfolio be worth in that time?
I am imagining being able to specify a portfolio balance, average conservative return per year until retirement.
Basically a way to keep track of whether we are realistically going to hit the number we decide we want by then.
EDIT:
I am looking for a forecast based on human inputs.
ie if you have $X in portfolio assets today and plan on retiring in say 27 years, assuming a “conservative” 8%/year return, how much will your current portfolio be worth in that time?
Last edited by pepperz on Mon Nov 27, 2017 6:44 pm, edited 1 time in total.
 TheTimeLord
 Posts: 5284
 Joined: Fri Jul 26, 2013 2:05 pm
Re: Retirement: how to forecast where you’re at?
Have you tried either
FIRECalc®: How long will your money last?
Firecalc.com
Optimal Retirement Planner
IORP.com
FIRECalc®: How long will your money last?
Firecalc.com
Optimal Retirement Planner
IORP.com
IMHO, Investing should be about living the life you want, not avoiding the life you fear. 
Run, You Clever Boy! [9085]
Re: Retirement: how to forecast where you’re at?
Iorp seems simple enough. I was hoping for something where values could be saved / updated for the future but I suppose it’s not a big deal to run it manually once or twice per year.
Thank you.
Thank you.
 TheTimeLord
 Posts: 5284
 Joined: Fri Jul 26, 2013 2:05 pm
Re: Retirement: how to forecast where you’re at?
If you have an account with Fidelity they have a Retirement Planner that saves the values. I am sure you will get several other good suggestions from the BH.
IMHO, Investing should be about living the life you want, not avoiding the life you fear. 
Run, You Clever Boy! [9085]
Re: Retirement: how to forecast where you’re at?
Sorry  I don’t see where / how IORP estimates your future return. It only asks for age / account balances. Am I missing something?
TheTimeLord wrote: ↑Mon Nov 27, 2017 5:06 pmHave you tried either
FIRECalc®: How long will your money last?
Firecalc.com
Optimal Retirement Planner
IORP.com

 Posts: 12276
 Joined: Tue Mar 23, 2010 1:45 pm
 Location: Reading, MA
Re: Retirement: how to forecast where you’re at?
Tools like those mentioned cannot forecast what Mr. Market will be doing in coming years, sorry.
You are basically on your own with this issue...
You are basically on your own with this issue...
Attempted new signature...
Re: Retirement: how to forecast where you’re at?
The question was what one's investments would "look like" at some future time. A natural assumption is that the OP wants to know what his portfolio will be worth at a future time. To get there the method of calculation has to assume what the returns are going to be all along the way, so, yes returns are in the model but may not be displayed in the output. In the case of FireCalc the model proceeds by looking at what would have happened to the investor if he starts his history in each of over a hundred historical years and uses the actual returns that did occur.pepperz wrote: ↑Mon Nov 27, 2017 5:36 pmSorry  I don’t see where / how IORP estimates your future return. It only asks for age / account balances. Am I missing something?
TheTimeLord wrote: ↑Mon Nov 27, 2017 5:06 pmHave you tried either
FIRECalc®: How long will your money last?
Firecalc.com
Optimal Retirement Planner
IORP.com
Does that address what you are asking?
 Peter Foley
 Posts: 4538
 Joined: Fri Nov 23, 2007 10:34 am
 Location: Lake Wobegon
Re: Retirement: how to forecast where you’re at?
One of our MN Bogleheads did a review of retirement calculators and presented the results at a quarterly meeting.
Firecalc came out on top with respect to planning for retirement. The Retiree Portfolio Model (RPM) and IORP were the two best planners for "spending" in retirement. IMHO RPM does a better job with Roth conversions if you have significant tax deferred assets.
An additional advantage of the RPM is that it is a downloadable Excel spreadsheet. The output is quite complex and it takes a little while to fully appreciate what is there but I think it is worth it.
Firecalc came out on top with respect to planning for retirement. The Retiree Portfolio Model (RPM) and IORP were the two best planners for "spending" in retirement. IMHO RPM does a better job with Roth conversions if you have significant tax deferred assets.
An additional advantage of the RPM is that it is a downloadable Excel spreadsheet. The output is quite complex and it takes a little while to fully appreciate what is there but I think it is worth it.

 Posts: 62
 Joined: Tue Oct 11, 2016 8:47 am
Re: Retirement: how to forecast where you’re at?
Take a look at Personal Capital (www.personalcapital.com).
It lets you link your accounts and they have a retirement planner that claims to run 5,000 monte carlo projections whenever you want. They let you input a few assumptions, but not as many as Firecalc.
Good Luck!
It lets you link your accounts and they have a retirement planner that claims to run 5,000 monte carlo projections whenever you want. They let you input a few assumptions, but not as many as Firecalc.
Good Luck!
Re: Retirement: how to forecast where you’re at?
I am looking for a forecast based on human inputs.
ie if I have $X in portfolio assets today and plan on retiring in 30 years, assuming a “conservative” 8%/year return, how much will our portfolio be worth in that time?
Does that make more sense?
ie if I have $X in portfolio assets today and plan on retiring in 30 years, assuming a “conservative” 8%/year return, how much will our portfolio be worth in that time?
Does that make more sense?
The Wizard wrote: ↑Mon Nov 27, 2017 5:37 pmTools like those mentioned cannot forecast what Mr. Market will be doing in coming years, sorry.
You are basically on your own with this issue...
Re: Retirement: how to forecast where you’re at?
$x invested for 30 years at 8%/year will grow to $10.0266x. Are you sure this is what you meant to ask? Note 10.0266=1.08^30.pepperz wrote: ↑Mon Nov 27, 2017 6:41 pmI am looking for a forecast based on human inputs.
ie if I have $X in portfolio assets today and plan on retiring in 30 years, assuming a “conservative” 8%/year return, how much will our portfolio be worth in that time?
Does that make more sense?
The Wizard wrote: ↑Mon Nov 27, 2017 5:37 pmTools like those mentioned cannot forecast what Mr. Market will be doing in coming years, sorry.
You are basically on your own with this issue...
Re: Retirement: how to forecast where you’re at?
Yes that’s basically what I was thinking. Every 6 months or so, plugging in current portfolio numbers and estimating what our portfolio may look like by retirement.
Is there a better approach to checking in to make sure you’re on track?
Is there a better approach to checking in to make sure you’re on track?
$x invested for 30 years at 8%/year will grow to $10.0266x. Are you sure this is what you meant to ask? Note 10.0266=1.08^30.
Re: Retirement: how to forecast where you’re at?
Yes, a better approach is to look at what is done in models like FireCalc because investment returns are randomly variable from year to year and it is hard to know what numbers best to use for the distribution of returns. The answer will be a range of possible outcomes at various probabilities of occurring. You could indeed compare your actual accumulated wealth against the expectations and against your goal.pepperz wrote: ↑Mon Nov 27, 2017 7:00 pmYes that’s basically what I was thinking. Every 6 months or so, plugging in current portfolio numbers and estimating what our portfolio may look like by retirement.
Is there a better approach to checking in to make sure you’re on track?
$x invested for 30 years at 8%/year will grow to $10.0266x. Are you sure this is what you meant to ask? Note 10.0266=1.08^30.

 Posts: 58
 Joined: Sat Mar 08, 2014 7:50 pm
 Location: Pennsylvania
Re: Retirement: how to forecast where you’re at?
I like to use the calculator at MarketWatch:
https://www.marketwatch.com/retirement/ ... calculator
You can include your spouse and Social Security if you choose. Change the estimates under advanced settings.
https://www.marketwatch.com/retirement/ ... calculator
You can include your spouse and Social Security if you choose. Change the estimates under advanced settings.

 Posts: 12276
 Joined: Tue Mar 23, 2010 1:45 pm
 Location: Reading, MA
Re: Retirement: how to forecast where you’re at?
No it doesn't.pepperz wrote: ↑Mon Nov 27, 2017 6:41 pmI am looking for a forecast based on human inputs.
ie if I have $X in portfolio assets today and plan on retiring in 30 years, assuming a “conservative” 8%/year return, how much will our portfolio be worth in that time?
Does that make more sense?
The Wizard wrote: ↑Mon Nov 27, 2017 5:37 pmTools like those mentioned cannot forecast what Mr. Market will be doing in coming years, sorry.
You are basically on your own with this issue...
You need to take into account your additional contributions in the latter decades of your working years.
Mine were a LOT bigger than my early contribs...
Attempted new signature...
Re: Retirement: how to forecast where you’re at?
So how do you know if you’re on track to hit your retirement goal number by the time you’re retired?No it doesn't. You need to take into account your additional contributions in the latter decades of your working years. Mine were a LOT bigger than my early contribs...
Re: Retirement: how to forecast where you’re at?
Hi, I constructed my own Excel spreadsheet and use the future value function so I can play what if. Included are assumptions on future yield, yearly contributions, and what my portfolio will look like next few years. Since I'm getting closer to retirement, I also add in SS by age so I can see what my cash flow will look like. I like the ability to customize the spreadsheet based on my/our needs although it is a bit more work than plugging numbers online.pepperz wrote: ↑Mon Nov 27, 2017 6:41 pmI am looking for a forecast based on human inputs.
ie if I have $X in portfolio assets today and plan on retiring in 30 years, assuming a “conservative” 8%/year return, how much will our portfolio be worth in that time?
Does that make more sense?
The Wizard wrote: ↑Mon Nov 27, 2017 5:37 pmTools like those mentioned cannot forecast what Mr. Market will be doing in coming years, sorry.
You are basically on your own with this issue...
Bogleheads Wiki: https://www.bogleheads.org/wiki/Main_Page

 Posts: 4
 Joined: Mon Oct 02, 2017 9:55 pm
Re: Retirement: how to forecast where you’re at?
I've tried most of the available calculators, and the most effective for me is OnTrajectory: https://www.ontrajectory.com/welcome.html
Good luck.
Good luck.

 Posts: 12276
 Joined: Tue Mar 23, 2010 1:45 pm
 Location: Reading, MA
Re: Retirement: how to forecast where you’re at?
Good question.pepperz wrote: ↑Mon Nov 27, 2017 8:44 pmSo how do you know if you’re on track to hit your retirement goal number by the time you’re retired?No it doesn't. You need to take into account your additional contributions in the latter decades of your working years. Mine were a LOT bigger than my early contribs...
Best thing to do in the early going is to work on increasing your retirement savings rate and kick the rest of the question down the road. Putting 2530% of gross income into longterm savings should eventually be feasible.
Then once you get to age 50, you can start projecting where your various retirement income streams will come from and what your desired retirement income is.
If another year like 2008 comes along, it will impact your planning, no way around it...
Attempted new signature...

 Posts: 19173
 Joined: Thu Apr 05, 2007 8:20 pm
 Location: New York
Re: Retirement: how to forecast where you’re at?
There is nothing conservative about 8 percent, nominal or real. Best to use a range of inputs, say 4, 6, 8 percent. Returns rarely work out as a straight line, one bad set of sequence risk can set you back years and if you deviate from course when markets decline such as we saw in 2008/2009, you may cause irreparable harm.
"One should invest based on their need, ability and willingness to take risk  Larry Swedroe" Asking Portfolio Questions
Re: Retirement: how to forecast where you’re at?
Gee. Just use excel.
Current value
=above *(1+expected interest)+annual contribution.
I’d recommend you use interest  inflation to keep everything in todays dollars ($1mill 2047 dollars will not buy nearly as much as $1mill 2017 dollars) 83=5% or 0.05 (I use about 0.055 but there are threads on what number to use)
Then you can copy the formula down and see how much you’ll have at target date and also what date you’ll have what you want.
Current value
=above *(1+expected interest)+annual contribution.
I’d recommend you use interest  inflation to keep everything in todays dollars ($1mill 2047 dollars will not buy nearly as much as $1mill 2017 dollars) 83=5% or 0.05 (I use about 0.055 but there are threads on what number to use)
Then you can copy the formula down and see how much you’ll have at target date and also what date you’ll have what you want.

 Posts: 3027
 Joined: Mon May 26, 2008 10:20 am
 Location: Second star on the right and straight on 'til morning
Re: Retirement: how to forecast where you’re at?
Back in the Stone Age, I did it with a piece of paper and a pencil. OK, I cheated; I used a set of PV, FV tables and set the yearly benchmarks toward the "my number for retirement" goal. But, if you can add and multiply, you can do it by hand. Then every year, I compared the portfolio values against the goal.
Don't know if the method was correct; but, somehow, I retired roughly on time with the amount I targeted 20+ years before.
Don't know if the method was correct; but, somehow, I retired roughly on time with the amount I targeted 20+ years before.
FI is the best revenge. LBYM. Invest the rest. Stay the course.  PS: The Calvary isn't coming, kids. You are on your own.
 AtlasShrugged?
 Posts: 589
 Joined: Wed Jul 15, 2015 6:08 pm
Re: Retirement: how to forecast where you’re at?
pepperz....I highly recommend that you find the thread from Bobcat on 'Funding ratio'. It makes a lot of sense. I use that to figure out where I stand, so to speak. Fair warning: It can be hugely depressing when you first calculate your funded ratio!
As for tools, Firecalc is great. Flexible Retirement Planner is also very good. I use those in conjunction with an excel workbook I created for myself.
As for tools, Firecalc is great. Flexible Retirement Planner is also very good. I use those in conjunction with an excel workbook I created for myself.
“If you don't know, the thing to do is not to get scared, but to learn.”
Re: Retirement: how to forecast where you’re at?
I second just using Excel.
A few rows for your various investments, a row for contributions, then put in formulas to do the math. I have a spreadsheet that I've been playing with for the past 16 years (and it's grown quite a bit to be fairly sophisticated for lots of calculations....)
A few rows for your various investments, a row for contributions, then put in formulas to do the math. I have a spreadsheet that I've been playing with for the past 16 years (and it's grown quite a bit to be fairly sophisticated for lots of calculations....)

 Posts: 3252
 Joined: Wed Dec 28, 2011 9:56 am
 Location: North Carolina
Re: Retirement: how to forecast where you’re at?
I have had good success using Excel to do retirement planning. If you have basic Excel knowledge and can use the PV, FV and annuity functions, you can do this yourself with Excel. I do a linear spreadsheet and then crosscheck by using one of the financial functions in Excel. Always crosscheck yourself because errors in spreadsheets are not always self evident. You can change returns, inflation, contributions, etc easily and see what different scenarios look like. The only thing I cannot do is Monte Carlo analysis but you can use of the online calculators for that.
I have tried some of the online calculators but prefer the Excel approach for myself. It gives me more flexibility and I can easily see changes year by year.
I have tried some of the online calculators but prefer the Excel approach for myself. It gives me more flexibility and I can easily see changes year by year.
Re: Retirement: how to forecast where you’re at?
"Am I missing something?"pepperz wrote: ↑Mon Nov 27, 2017 5:36 pmSorry  I don’t see where / how IORP estimates your future return. It only asks for age / account balances. Am I missing something?
TheTimeLord wrote: ↑Mon Nov 27, 2017 5:06 pmHave you tried either
FIRECalc®: How long will your money last?
Firecalc.com
Optimal Retirement Planner
IORP.com
The full IORP calculator provides a few pages of output that shows account balances and returns as well as associated charts for each balance, income and also for taxes.
You can vary the inflation rate to offset any growth from that to look at real dollars and vary return by account type as well.
In addition you can 'save' each run or document as well as easily print it out.
The RPM spreadsheet and calculator can also do all this in more detail but it is a bit harder to load and utilize.
Re: Retirement: how to forecast where you’re at?
Again, if people are happy with modeling return as a simple average return applied every year then the computations are simple to do in a spreadsheet. If one wants to account for the uncertainty that annual returns randomly vary by a lot and see the resultant range of possible outcomes, then that is what the statistical models like FireCalc are for.
Re: Retirement: how to forecast where you’re at?
The funded ratio is a metric that can be used to monitor your retirement investment plan. It is simply the ratio of assets to liabilities, where the assets are the size of your portfolio and the liabilities are the present value of your targeted retirement income stream. A relatively easy and straightforward way to estimate the liabilities in the denominator is to price a deferred real life annuity that has payouts that match your targeted retirement income and begins payments in your expected retirement year.JCE66 wrote: ↑Tue Nov 28, 2017 8:22 ampepperz....I highly recommend that you find the thread from Bobcat on 'Funding ratio'. It makes a lot of sense. I use that to figure out where I stand, so to speak. Fair warning: It can be hugely depressing when you first calculate your funded ratio!
As for tools, Firecalc is great. Flexible Retirement Planner is also very good. I use those in conjunction with an excel workbook I created for myself.
Link to funded ratio thread.
viewtopic.php?f=10&t=219878
I use ESPlanner for retirement planning.
Link to ESPlanner website http://www.esplanner.com/
ESPlanner is fairly expensive. Try their free stripped down version, ESPlanner Basic, first.
Link to free version  https://basic.esplanner.com/
The Center for Retirement Research at Boston College recommends three free retirement calculators, including ESPlanner Basic.
The other two are New Retirement and Target Your Retirement.
Here is the link to the New Retirement website. https://www.newretirement.com/
Here is the link to the Target Your Retirement website. http://crr.bc.edu/specialprojects/inte ... etirement/
Here is the article where the researchers at The Center for Retirement Research at Boston College explain why they recommend these three retirement calculators. http://squaredawayblog.bc.edu/squareda ... doptions/
A review of retirement income calculators by financial planner Dana Anspach earlier this month.
https://www.thebalance.com/websbestr ... rs2388842
Retirement researcher Olivia Mitchell of the Pension Research Council of the Wharton School discusses some drawbacks of many retirement income calculators.
https://www.forbes.com/sites/pensionres ... 5494e37bd5
BobK
In finance risk is defined as uncertainty that is consequential (nontrivial). 
The two main methods of dealing with financial risk are the matching of assets to goals & diversifying.
Re: Retirement: how to forecast where you’re at?
I use the Fidelity Retirement Planner. It will provide you everything your looking plus more.
 ruralavalon
 Posts: 13955
 Joined: Sat Feb 02, 2008 10:29 am
 Location: Illinois
Re: Retirement: how to forecast where you’re at?
I usually suggest www.firecalc.com .pepperz wrote: ↑Mon Nov 27, 2017 5:02 pmIs there a tool or worksheet that will help us make estimates / forecasts on what our current investments might look like by the time we retire?
I am imagining being able to specify a portfolio balance, average conservative return per year until retirement.
Basically a way to keep track of whether we are realistically going to hit the number we decide we want by then.
EDIT:
I am looking for a forecast based on human inputs.
ie if you have $X in portfolio assets today and plan on retiring in say 27 years, assuming a “conservative” 8%/year return, how much will your current portfolio be worth in that time?
The most important human input after current portfolio size will be the level of contributions.
An 8% annual return is not conservative.
"Everything should be as simple as it is, but not simpler."  Albert Einstein 
Wiki article link:Getting Started

 Posts: 200
 Joined: Tue Nov 11, 2014 2:28 pm
Re: Retirement: how to forecast where you’re at?
+1TheTimeLord wrote: ↑Mon Nov 27, 2017 5:33 pmIf you have an account with Fidelity they have a Retirement Planner that saves the values. I am sure you will get several other good suggestions from the BH.
Re: Retirement: how to forecast where you’re at?
It is not a retirement calculator but for a basic savings/investment calc I like the planning tips savings calc. Just enter your current balance, monthly contribution and expected rate of return and number of years.
http://www.planningtips.com/cgibin/savings.pl
http://www.planningtips.com/cgibin/savings.pl
Re: Retirement: how to forecast where you’re at?
A review of retirement income calculators by financial planner Dana Anspach earlier this month.
https://www.thebalance.com/websbestr ... rs2388842
Wow  I really do not agree with that article rating the AARP tool over TRP and Fidelity after viewing/using all of them.
https://www.thebalance.com/websbestr ... rs2388842
Wow  I really do not agree with that article rating the AARP tool over TRP and Fidelity after viewing/using all of them.
Re: Retirement: how to forecast where you’re at?
I built my own spreadsheet for this.
For my estimates, I used my asset allocation with real returns based upon the 50year results from the CSRI Global Returns yearbook  others prefer to use the results since 1900.
I suggest you decide whether you want a "conservative" return or an 8% return  those aren't synonymous...
For my estimates, I used my asset allocation with real returns based upon the 50year results from the CSRI Global Returns yearbook  others prefer to use the results since 1900.
Re: Retirement: how to forecast where you’re at?
For what it's worth, the SEC has a very simple and useful compound interest calculator that allows you to input interest rate sensitivities...
https://www.investor.gov/additionalres ... calculator
https://www.investor.gov/additionalres ... calculator
Re: Retirement: how to forecast where you’re at?
charriso1973, can you clarify why you like OnTrajectory? I have played with it for a few minutes but couldn't get very far without signing up for a subscription. I'm okay with paying them money if it's valuable but I'm not inclined to pay without understanding how it will be better than Fidelity's retirement planning tool. Fidelity's tool is free, is pretty powerful, and I have spent quite a bit of time inputting data into and tinkering with.charriso1973 wrote: ↑Mon Nov 27, 2017 8:57 pmI've tried most of the available calculators, and the most effective for me is OnTrajectory: https://www.ontrajectory.com/welcome.html
Good luck.
Re: Retirement: how to forecast where you’re at?
+1TheTimeLord wrote: ↑Mon Nov 27, 2017 5:33 pmIf you have an account with Fidelity they have a Retirement Planner that saves the values. I am sure you will get several other good suggestions from the BH.
Before retirement, I ran several hundred thousand calculators, maybe even several million. They all gave estimates pointing in the right direction. Post retirement, I'm only using Fidelity because it suits my needs, because I can, and because simplicity eats complexity for lunch.

 Posts: 12276
 Joined: Tue Mar 23, 2010 1:45 pm
 Location: Reading, MA
Re: Retirement: how to forecast where you’re at?
I see...2015 wrote: ↑Tue Dec 19, 2017 4:15 pm+1TheTimeLord wrote: ↑Mon Nov 27, 2017 5:33 pmIf you have an account with Fidelity they have a Retirement Planner that saves the values. I am sure you will get several other good suggestions from the BH.
Before retirement, I ran several hundred thousand calculators, maybe even several million...
*stroking beard*
Attempted new signature...
Re: Retirement: how to forecast where you’re at?
Long before I discovered Bogleheads, I created a fairly simple Excel spreadsheet to track actual and projected growth of my portfolio. I had pairs of columns. Each pair assumed a specific amount invested per year. The columns in each pair assumed an average rate of return. For example $15k+6% and $15k+7%; $20k+6% and $20k+7%. The first row was current value of the portfolio and there was a row for each year forward to planned retirement.kaudrey wrote: ↑Tue Nov 28, 2017 8:22 amI second just using Excel.
A few rows for your various investments, a row for contributions, then put in formulas to do the math. I have a spreadsheet that I've been playing with for the past 16 years (and it's grown quite a bit to be fairly sophisticated for lots of calculations....)
Each January I would compare my portfolio value against where I anticipated I would be in each scenario. Then I would copy the formulas to a new worksheet and start over in the current year with the updated actual $ in the first row. Because I was pretty conservative with the numbers I put in, my portfolio growth outstripped the forecast every year except 2008 and 2009. During a rough time at my company, when I wasn't sure whether I'd have a job much longer, I added a pair of columns to see what the effect would be if I never made any more contributions to the portfolio. Seeing the totals in those columns calmed me down regarding what my future might look like.
 tennisplyr
 Posts: 1798
 Joined: Tue Jan 28, 2014 1:53 pm
 Location: Sarasota, FL
Re: Retirement: how to forecast where you’re at?
Those who move forward with a happy spirit will find that things always work out.
Re: Retirement: how to forecast where you’re at?
I wanted to be "sure". Maybe I still do. Unfortunately, that's never gonna happen.The Wizard wrote: ↑Tue Dec 19, 2017 4:57 pmI see...2015 wrote: ↑Tue Dec 19, 2017 4:15 pm+1TheTimeLord wrote: ↑Mon Nov 27, 2017 5:33 pmIf you have an account with Fidelity they have a Retirement Planner that saves the values. I am sure you will get several other good suggestions from the BH.
Before retirement, I ran several hundred thousand calculators, maybe even several million...
*stroking beard*
Re: Retirement: how to forecast where you’re at?
Thanks for the great list of options! Very much appreciated!
(And FTR, I have an Excel spreadsheet  I may have gotten the basic one from a BH post  that I've tweaked and edited over the past 7 years. It has a row for each January 1, and a column for amount contributed, expected rate of return, amount withdrawn, pension income, SS income, etc. I find it very comforting).
(And FTR, I have an Excel spreadsheet  I may have gotten the basic one from a BH post  that I've tweaked and edited over the past 7 years. It has a row for each January 1, and a column for amount contributed, expected rate of return, amount withdrawn, pension income, SS income, etc. I find it very comforting).
bobcat2 wrote: ↑Tue Nov 28, 2017 9:47 am
The funded ratio is a metric that can be used to monitor your retirement investment plan. It is simply the ratio of assets to liabilities, where the assets are the size of your portfolio and the liabilities are the present value of your targeted retirement income stream. A relatively easy and straightforward way to estimate the liabilities in the denominator is to price a deferred real life annuity that has payouts that match your targeted retirement income and begins payments in your expected retirement year.
Link to funded ratio thread.
viewtopic.php?f=10&t=219878
I use ESPlanner for retirement planning.
Link to ESPlanner website http://www.esplanner.com/
ESPlanner is fairly expensive. Try their free stripped down version, ESPlanner Basic, first.
Link to free version  https://basic.esplanner.com/
The Center for Retirement Research at Boston College recommends three free retirement calculators, including ESPlanner Basic.
The other two are New Retirement and Target Your Retirement.
Here is the link to the New Retirement website. https://www.newretirement.com/
Here is the link to the Target Your Retirement website. http://crr.bc.edu/specialprojects/inte ... etirement/
Here is the article where the researchers at The Center for Retirement Research at Boston College explain why they recommend these three retirement calculators. http://squaredawayblog.bc.edu/squareda ... doptions/
A review of retirement income calculators by financial planner Dana Anspach earlier this month.
https://www.thebalance.com/websbestr ... rs2388842
Retirement researcher Olivia Mitchell of the Pension Research Council of the Wharton School discusses some drawbacks of many retirement income calculators.
https://www.forbes.com/sites/pensionres ... 5494e37bd5
BobK