Retiree Portfolio Model

Non-investing personal finance issues including insurance, credit, real estate, taxes, employment and legal issues such as trusts and wills
gponym
Posts: 5
Joined: Mon Aug 18, 2014 11:37 am

Re: Retiree Portfolio Model

Post by gponym » Sat Feb 09, 2019 7:59 pm

mkedst wrote:
Sat Feb 09, 2019 11:11 am
gponym wrote:
Fri Feb 08, 2019 8:39 pm
Does RPM handle the rather byzantine rules that determine what percent of a taxpayer's Social Security income gets included into taxable income?
Yes, the calculate can be seen on the Details tab, section "SS benefits taxation calculation".
Thanks. I see it and the supporting calculations.

Bongleur
Posts: 2154
Joined: Fri Dec 03, 2010 10:36 am

Re: Retiree Portfolio Model

Post by Bongleur » Mon Feb 11, 2019 6:17 am

HOW TO ENTER & DISPLAY REAL INSTEAD OF NOMINAL? UNDERSTANDING THE PRESENT VALUE DISCOUNT RATE SETTING?
BigFoot48 wrote:
Sun Apr 15, 2018 3:09 pm
goGators wrote:
Sun Apr 15, 2018 1:42 pm
I assume RPM account balances are nominal (inflated dollars).
Is there an easy way to display them in real (non-inflated) dollars?
You can set the inflation rate to 0% (Section 5 - Expenses), and
the tax rate/bracket escalator to 0% (Rax Tables page), and
enter your earnings rates at real values (Section 3 - Return Rates).
That should do it - I think.
I think there may be some more items which need to be set to zero... has anyone else looked at this?

OR -- does cell I15 Present Value Discount Rate do this for you? Doesn't all the output turn into Real if this is set to your guess at Real?
I'm confused - is the sheet designed to show output as Real or Nominal?

Version 18.0 for year 2018 says:
> The discount rate used to determine present value of future cash flows, is reduced to a real rate (after inflation) of 3% to provide a more realistic real-return result.
>
and the popup (which I don't know how to COPY) says "a real rate (after inflation) of 3.0% is used in the Example data. An alternative could be the portfolio forecast average real return rate."

I'm confused because the sheet doesn't explicitly let you enter nominal + real so they can be seen, in each of the items where "change % over time" is a factor.

SOME SETTINGS NEEDED, IN ORDER:
SETUP, MODELING OPTIONS: set Present Value Discount Rate to 0% ???
SETUP Section 3 Return Rates: Enter Real % rates.
SETUP, Section 4 Income: set Pension Change to the COLA.
SETUP, Section 4 Income: set SS Benefits COLA.
SETUP, Section 5 Living Expenses: set Inflation to Real ??? Don't understand how this interacts with PVDR
SETUP, Section 6, IRA Withdrawals -- would you set Yearly Change to equal Inflation if you want to withdraw an equal Real amount each year?

TAX RATE TABLES, set the tax rate/bracket escalator to ???
***

To start trying to understand this spreadsheet, which is phenominally complex, I want to simply ask "if income matches inflation, and spending remains the same (accounting for inflation), how long will it last?

EDIT: I really don't understand what the value of the Present Value Discount Rate does to the output.
I'm guessing that if I think the Real Return Rate is 1% then that is the value I put into the PVDR
Then the Taxable Return of govt bonds is now, say, 3% Nominal. So that goes into the Return Rates,Taxable.
Then 1% goes everywhere that represents a COLA (pension, Social Security... anywhere else?)
But after doing this I expect the graphs to be "flat" for account balance over time, not rising, when I set values for various Income = Expense.
Last edited by Bongleur on Mon Feb 11, 2019 7:35 am, edited 1 time in total.
Seeking Iso-Elasticity. | Tax Loss Harvesting is an Asset Class. | A well-planned presentation creates a sense of urgency. If the prospect fails to act now, he will risk a loss of some sort.

Bongleur
Posts: 2154
Joined: Fri Dec 03, 2010 10:36 am

Re: Retiree Portfolio Model

Post by Bongleur » Mon Feb 11, 2019 6:29 am

Is SETUP, 4 Income, Pensions -- presumed to be a COLA pension? Or do you enter a COLA in "Change" as your guess at inflation?
Seeking Iso-Elasticity. | Tax Loss Harvesting is an Asset Class. | A well-planned presentation creates a sense of urgency. If the prospect fails to act now, he will risk a loss of some sort.

Bongleur
Posts: 2154
Joined: Fri Dec 03, 2010 10:36 am

Re: Retiree Portfolio Model

Post by Bongleur » Mon Feb 11, 2019 7:42 am

It is REALLY bugging me that the Income & Expenses graph is BACKWARDS.
The Income should be blue & the bar graph, the same as the two charts above it.
Not red & line graph.

I'm guessing its because the two datum were entered in the opposite order vis a vis the previous graphs, when creating the graph.
Seeking Iso-Elasticity. | Tax Loss Harvesting is an Asset Class. | A well-planned presentation creates a sense of urgency. If the prospect fails to act now, he will risk a loss of some sort.

Bongleur
Posts: 2154
Joined: Fri Dec 03, 2010 10:36 am

Re: Retiree Portfolio Model

Post by Bongleur » Mon Feb 11, 2019 8:21 am

The pop up windows are too small. They are only "long" enough to show all the lines when viewed at 75% size.
I normally view at %200 size.
Can elevator bars be added to these?
Seeking Iso-Elasticity. | Tax Loss Harvesting is an Asset Class. | A well-planned presentation creates a sense of urgency. If the prospect fails to act now, he will risk a loss of some sort.

User avatar
Topic Author
BigFoot48
Posts: 2649
Joined: Tue Feb 20, 2007 10:47 am
Location: Arizona

Re: Retiree Portfolio Model

Post by BigFoot48 » Mon Feb 11, 2019 8:38 am

Lots of questions, I'll start with the easy one. The Present Value Discount Rate is ONLY used in a very few calculations to show the present value of a result, like Social Security income, so that different alternatives can be compared.

The model is designed to show nominal results. The percent factors provided are designed to adjust the nominal results to each user's choice, but if all of them are set to real values and escalation/inflation at 0%, I suppose it will show real results, but there's no "switch" to do this, so you're on your own.

Graphs should be generally consistent in appearance and I will check the one you noted. I'm not aware of an elevator feature for cell comments. The income factors, which could be a pension, can be annually escalated or reduced by the adjustment factor.

And all users should keep in mind that the model is open-source and users can change any feature or calculation they want to. Just unprotect the sheet and modify it.
Last edited by BigFoot48 on Mon Feb 11, 2019 11:12 am, edited 2 times in total.
Retired | Two-time in top-10 in Bogleheads S&P500 contest; 13-time loser

Bongleur
Posts: 2154
Joined: Fri Dec 03, 2010 10:36 am

Re: Retiree Portfolio Model

Post by Bongleur » Mon Feb 11, 2019 8:45 am

I think SETTINGS cells I56 & I66 which is Rates Being Used, should not come out to 54%.
I just blew up a 250K taxable start to $40 Million end amount, simply by changing from Account method to Asset Class method.
I56 is 3% using Account, but I66 stays at 56% after I have entered a % above zero for stocks, bonds, etc.

How do I get this thing to reflect a 2% Real return for Stocks, 1% Real for Bonds, and 0% Real for MM ?
I entered 1% in the Present Value Discount Rate and
Average Returns Calculator
Allocation Rates
20.0% 3.0% Stock
70.0% 2.0% Bond
0.0% Tax Exempt
10.0% 0.0% Money Mkt
0.0% Other
100.0% 2.0% Average

Rates Being Used
Beginning Change 2019
Taxable 54.0% 54.0%

class method: asset Money Mkt Calculated
allocation for each account Stocks Bonds Tax Exempt & Other Rates
Taxable 20.0% 70.0% 0.0% 10.0% 54.0%

without hand-adjusting its gibberish; how do I PASTE spreadsheet data & keep the formatting?
Seeking Iso-Elasticity. | Tax Loss Harvesting is an Asset Class. | A well-planned presentation creates a sense of urgency. If the prospect fails to act now, he will risk a loss of some sort.

User avatar
Topic Author
BigFoot48
Posts: 2649
Joined: Tue Feb 20, 2007 10:47 am
Location: Arizona

Re: Retiree Portfolio Model

Post by BigFoot48 » Mon Feb 11, 2019 9:01 am

Bongleur wrote:
Mon Feb 11, 2019 8:45 am
I think SETTINGS cells I56 & I66 which is Rates Being Used, should not come out to 54%.
The factors for each Asset Class must equal 100%. Check your Return Rates by Asset Class which are used to calculate the Calculated Rates in the Class Method section.

Use the Example data as an example and enter your settings in a similar fashion.
Last edited by BigFoot48 on Mon Feb 11, 2019 11:01 am, edited 2 times in total.
Retired | Two-time in top-10 in Bogleheads S&P500 contest; 13-time loser

User avatar
Zephavest
Posts: 28
Joined: Thu Jan 10, 2013 9:09 am
Location: Texas

Re: Retiree Portfolio Model

Post by Zephavest » Mon Feb 11, 2019 10:45 am

Boggedown wrote:
Sat Feb 02, 2019 2:42 pm
However, Microsoft Excel has a powerful optimizing add-in called 'Solver'. It also has 'Goal Seek' but AFAIK that can only handle one variable so won't apply to this case. Solver can theoretically handle large sets of variables, and provides several advanced methods of optimizing a 'results' cell by manipulating such sets of input cells.
Hi Boggedown,

Thanks so much for the heads up on Solver, I've never used it before, I tried it on my personal budget spreadsheet, where I was getting a circular reference, amazing, it did the trick. Then I wrote a macro for it to run on every column/year. Thanks again for sharing the tip.

Bongleur
Posts: 2154
Joined: Fri Dec 03, 2010 10:36 am

Re: Retiree Portfolio Model

Post by Bongleur » Mon Feb 11, 2019 11:00 am

BigFoot48 wrote:
Mon Feb 11, 2019 9:01 am
The factors for each Asset Class must equal 100%. I see I don't have a warning if over 100% is entered, as the Money Market factor is designed to set the total to 100%, but perhaps an error message is required.

Use the Example data as an example and enter your settings in a similar fashion.
Yes I noticed that MM is the "remainder." Very opaque, should just have all classes in blue.
My numbers DO add up to 100%.
I think the equation for those cells has a bad input cell somewhere. Can't figure out what its trying to do.
I don't see why it doesn't just copy the answer from the Average Returns Calculator
Seeking Iso-Elasticity. | Tax Loss Harvesting is an Asset Class. | A well-planned presentation creates a sense of urgency. If the prospect fails to act now, he will risk a loss of some sort.

User avatar
Zephavest
Posts: 28
Joined: Thu Jan 10, 2013 9:09 am
Location: Texas

Re: Retiree Portfolio Model

Post by Zephavest » Mon Feb 11, 2019 11:01 am

Hello to All RPM Users and to those kicking the tires,

RPM is an Open Source, Professional Grade Finance Modeling Tool, it is Free of Charge and ONLY made possible by the countless, untold hours, spent on it by it's author, BigFoot48. This tool exceeds the capabilities of almost all other Retirement Modeling Tools, free or commercially available. As such, it does take personal knowledge in Finance, Investments and Excel usage to use properly, as one forum member observed, it is intended for Professionals or Serious Hobbyists. It does have a very steep learning curve but that is only because of the power the tool has.

BigFoot has bent over backwards year after year, continually updating the tool, fixing bugs and adding features that meet most users needs and for that I'm very grateful. When you hit a situation that the tool does not address, be creative, you can find workarounds for your own personal situation. For example, I have a tax-free income stream that was hard to model, my solution, I entered it in the SPIA section with 100% exclusion. Being a retired engineer and being use to precision, instead of entering my Social Security as age 66 or 67, I simply prorated my starting rate at age 66.4 and used that, confirming my starting amounts at the projected start year. You will read here of other creative solutions other users have found for their unique situation.

I have learned a lot reading all the posts and seeing how other uses adopted the tool to their needs. For situations that are more personal and are specific questions for the author it may be best to send him a personal private message. For help on how to use Excel, if you are not already and intermediate to advanced user, there are dozens of excellent websites with Excel help. For example, two weeks ago, I wanted to learn VBA, to write a macro for Solver, on my personal budget, I now have two successful macros under my belt, when I got stuck I found excelforum.com very helpful.

User avatar
Topic Author
BigFoot48
Posts: 2649
Joined: Tue Feb 20, 2007 10:47 am
Location: Arizona

Re: Retiree Portfolio Model

Post by BigFoot48 » Mon Feb 11, 2019 11:03 am

Bongleur wrote:
Mon Feb 11, 2019 11:00 am

Yes I noticed that MM is the "remainder." Very opaque, should just have all classes in blue.
My numbers DO add up to 100%.
I think the equation for those cells has a bad input cell somewhere. Can't figure out what its trying to do.
I don't see why it doesn't just copy the answer from the Average Returns Calculator
I edited my reply: "Check your Return Rates by Asset Class which are used to calculate the Calculated Rates in the Class Method section." Blue is used to indicate a user-supplied value, which the Money Market amount is not in order to make having a 100% total automatic.

The Calculators throughout the model are just that - stand-alone calculators that have no impact on the model calculations.
Retired | Two-time in top-10 in Bogleheads S&P500 contest; 13-time loser

User avatar
Topic Author
BigFoot48
Posts: 2649
Joined: Tue Feb 20, 2007 10:47 am
Location: Arizona

Re: Retiree Portfolio Model

Post by BigFoot48 » Mon Feb 11, 2019 11:18 am

Zephavest wrote:
Mon Feb 11, 2019 11:01 am
Hello to All RPM Users and to those kicking the tires,
Many thanks for Zephavest for his description of RPM and advice for new users. All very accurate and useful. While it would be impossible for me to personally help each user, I will try when possible. If a user is having too much difficulty with it, I suggest the excellent ORP model, which is very easy to use and provides nearly identical results in calculating future portfolio results. https://www.i-orp.com/bequest/index.html
Retired | Two-time in top-10 in Bogleheads S&P500 contest; 13-time loser

Bongleur
Posts: 2154
Joined: Fri Dec 03, 2010 10:36 am

Re: Retiree Portfolio Model

Post by Bongleur » Mon Feb 11, 2019 11:34 am

BigFoot48 wrote:
Mon Feb 11, 2019 8:38 am
Lots of questions, I'll start with the easy one. The Present Value Discount Rate is ONLY used in a very few calculations to show the present value of a result, like Social Security income, so that different alternatives can be compared.

The model is designed to show nominal results. The percent factors provided are designed to adjust the nominal results to each user's choice, but if all of them are set to real values and escalation/inflation at 0%, I suppose it will show real results, but there's no "switch" to do this, so you're on your own.
So I can ignore PVDR... I only found in in Column D of RESULTS. I tried arrows for Dependant Cells, w/ some symbol, probably meaning "see other tab" but I don't know how to figure out WHICH tab.

But Nominal = Real + Inflation. How does the Black Box figure out what each is? Is there a "master" cell to show Inflation used for all calcs?
Seeking Iso-Elasticity. | Tax Loss Harvesting is an Asset Class. | A well-planned presentation creates a sense of urgency. If the prospect fails to act now, he will risk a loss of some sort.

Bongleur
Posts: 2154
Joined: Fri Dec 03, 2010 10:36 am

Re: Retiree Portfolio Model

Post by Bongleur » Mon Feb 11, 2019 11:45 am

A search yields no mention of Sequence of Returns.
Anyone found a Monte Carlo sheet to work on making sure the first 10 years don't kill it?
One with a similar way of inputting data so you can make sure the entries do the same thing.

OR
Maybe something like calculate the first 10 years expenses (above guaranteed income like Pension & SS) and then delete that amount from the portfolio, and let this sheet run for the first 10 years with zero expenses...

Kind of like starting the sheet 10 years before retirement age.

How can one turn TIPS into a line item Asset Class? Since TIPs will have a very different rate of return from other bonds.
Use the Other Income line, and specify starting to use the fund in a specific year... ?
Seeking Iso-Elasticity. | Tax Loss Harvesting is an Asset Class. | A well-planned presentation creates a sense of urgency. If the prospect fails to act now, he will risk a loss of some sort.

User avatar
munemaker
Posts: 3886
Joined: Sat Jan 18, 2014 6:14 pm

Re: Retiree Portfolio Model

Post by munemaker » Mon Feb 11, 2019 1:53 pm

I can answer your questions, but you need to make an adjustment in your thinking if you are going to successfully use RPM. RPM is a tool. You need to figure out how to use it. Stating how you think it should work or wish it would work is not going to help you. My advice is to study the documentation before you ask a bunch of questions that would be obvious if you had a basic understanding of finance and Excel, and if you read the documentation. RPM may not be the tool for you. As stated previously, iORP might be more suitable. It too is an excellent tool, and you don't need to understand all the details you are struggling with.
Bongleur wrote:
Mon Feb 11, 2019 11:45 am
A search yields no mention of Sequence of Returns.
Anyone found a Monte Carlo sheet to work on making sure the first 10 years don't kill it?
One with a similar way of inputting data so you can make sure the entries do the same thing.
OR
Maybe something like calculate the first 10 years expenses (above guaranteed income like Pension & SS) and then delete that amount from the portfolio, and let this sheet run for the first 10 years with zero expenses...

Kind of like starting the sheet 10 years before retirement age.
This is not what RPM is about. It doesn't operate this way.
Bongleur wrote:
Mon Feb 11, 2019 11:45 am

How can one turn TIPS into a line item Asset Class? Since TIPs will have a very different rate of return from other bonds.
Use the Other Income line, and specify starting to use the fund in a specific year... ?
Think about it and reason your way through it. Are TIPs closer to equity, bond or money market fund? What would a reasonable expectation be for a rate of return?

User avatar
munemaker
Posts: 3886
Joined: Sat Jan 18, 2014 6:14 pm

Re: Retiree Portfolio Model

Post by munemaker » Mon Feb 11, 2019 2:14 pm

Bongleur wrote:
Mon Feb 11, 2019 6:17 am
HOW TO ENTER & DISPLAY REAL INSTEAD OF NOMINAL? UNDERSTANDING THE PRESENT VALUE DISCOUNT RATE SETTING?
BigFoot48 wrote:
Sun Apr 15, 2018 3:09 pm
goGators wrote:
Sun Apr 15, 2018 1:42 pm
I assume RPM account balances are nominal (inflated dollars).
Is there an easy way to display them in real (non-inflated) dollars?
You can set the inflation rate to 0% (Section 5 - Expenses), and
the tax rate/bracket escalator to 0% (Rax Tables page), and
enter your earnings rates at real values (Section 3 - Return Rates).
That should do it - I think.
I think there may be some more items which need to be set to zero... has anyone else looked at this?

SOME SETTINGS NEEDED, IN ORDER:
SETUP, MODELING OPTIONS: set Present Value Discount Rate to 0% ???
SETUP Section 3 Return Rates: Enter Real % rates.
SETUP, Section 4 Income: set Pension Change to the COLA.
SETUP, Section 4 Income: set SS Benefits COLA.
SETUP, Section 5 Living Expenses: set Inflation to Real ??? Don't understand how this interacts with PVDR
SETUP, Section 6, IRA Withdrawals -- would you set Yearly Change to equal Inflation if you want to withdraw an equal Real amount each year?

TAX RATE TABLES, set the tax rate/bracket escalator to ???
***
Here's what I did to use REAL RATES, and it seems to be working.
- Present Value Discount Rate:
On the SETUP page, set cell I15 to 0.9%.
- Pension
On the SETUP page, set cell F93 to 0.0% if the pension is inflation adjusted. If not, set it to -2.1%.
- Social Security COLA
On the SETUP page, set cell E103 to 0.0%.
- Taxes Escalation Rate
On the TAX TABLE page, set cell D10 to 0.0%.

User avatar
munemaker
Posts: 3886
Joined: Sat Jan 18, 2014 6:14 pm

Re: Retiree Portfolio Model

Post by munemaker » Mon Feb 11, 2019 2:18 pm

Bongleur wrote:
Mon Feb 11, 2019 7:42 am
It is REALLY bugging me that the Income & Expenses graph is BACKWARDS.
Looking at the big picture, it is a very minor detail. Don't let it bug you.

User avatar
munemaker
Posts: 3886
Joined: Sat Jan 18, 2014 6:14 pm

Re: Retiree Portfolio Model

Post by munemaker » Mon Feb 11, 2019 2:23 pm

Bongleur wrote:
Mon Feb 11, 2019 8:45 am
without hand-adjusting its gibberish; how do I PASTE spreadsheet data & keep the formatting?
Not sure what you are referring to. What gibberish? What are you trying to cut/paste? From the calculator? All the items in the blue cells should be entered. Just type them in.

You might try "PASTE SPECIAL" and select "VALUES."
Last edited by munemaker on Mon Feb 11, 2019 2:27 pm, edited 1 time in total.

User avatar
Topic Author
BigFoot48
Posts: 2649
Joined: Tue Feb 20, 2007 10:47 am
Location: Arizona

Re: Retiree Portfolio Model

Post by BigFoot48 » Mon Feb 11, 2019 2:27 pm

munemaker wrote:
Mon Feb 11, 2019 2:14 pm
Here's what I did to use REAL RATES, and it seems to be working.
- Present Value Discount Rate:
On the SETUP page, set cell I15 to 0.9%.
- Pension
On the SETUP page, set cell F93 to 0.0% if the pension is inflation adjusted. If not, set it to -2.1%.
- Social Security COLA
On the SETUP page, set cell E103 to 0.0%.
- Taxes Escalation Rate
On the TAX TABLE page, set cell D10 to 0.0%.
A reminder, the Present Value Discount Rate is not used in any model calculations, only in several analyses of the resulting data. So it should be ignored when attempting to use real rates.
Retired | Two-time in top-10 in Bogleheads S&P500 contest; 13-time loser

User avatar
munemaker
Posts: 3886
Joined: Sat Jan 18, 2014 6:14 pm

Re: Retiree Portfolio Model

Post by munemaker » Mon Feb 11, 2019 3:35 pm

BigFoot48 wrote:
Mon Feb 11, 2019 2:27 pm
munemaker wrote:
Mon Feb 11, 2019 2:14 pm
Here's what I did to use REAL RATES, and it seems to be working.
- Present Value Discount Rate:
On the SETUP page, set cell I15 to 0.9%.
- Pension
On the SETUP page, set cell F93 to 0.0% if the pension is inflation adjusted. If not, set it to -2.1%.
- Social Security COLA
On the SETUP page, set cell E103 to 0.0%.
- Taxes Escalation Rate
On the TAX TABLE page, set cell D10 to 0.0%.
A reminder, the Present Value Discount Rate is not used in any model calculations, only in several analyses of the resulting data. So it should be ignored when attempting to use real rates.
I realize PVDR is not used in any calculations of outputs, only NPV calculations.

My understanding is that when discounting future income streams such as SS, that the NPV is viewed as being less than the simple sum of the payments discounted for inflation; the reasoning for this being the discount rate used in the NPV calculation needs to account for the return the investor would have realized if he/she had invested the money as a lump sum.

Not sure if I explained that very well. A better explanation is here:
https://www.kitces.com/blog/net-present ... breakeven/

Bongleur
Posts: 2154
Joined: Fri Dec 03, 2010 10:36 am

Re: Retiree Portfolio Model

Post by Bongleur » Tue Feb 12, 2019 1:05 am

"The model is designed to show nominal results."

It would be good to say that in the introduction so people first view it with the correct interpretation.
Why did you do it that way? What are the benefits of seeing an amount many years hence in inflated Nominal dollars?

So when it says I have a 100,000 dollars left after 40 years, its really just pocket change, because those are 40 year old dollars ?
It would be useful to be able to at least toggle that into Real dollars, to see how much value you are leaving to your heirs.

Another reason to work in Real dollars is that whan you change your expenses or income over time, that is impossible to "see" when the dollar amount in a year is shown as Nominal inflated money.
Seeking Iso-Elasticity. | Tax Loss Harvesting is an Asset Class. | A well-planned presentation creates a sense of urgency. If the prospect fails to act now, he will risk a loss of some sort.

Bongleur
Posts: 2154
Joined: Fri Dec 03, 2010 10:36 am

Re: Retiree Portfolio Model

Post by Bongleur » Tue Feb 12, 2019 1:12 am

munemaker wrote:
Mon Feb 11, 2019 2:14 pm
Bongleur wrote:
Mon Feb 11, 2019 6:17 am
HOW TO ENTER & DISPLAY REAL INSTEAD OF NOMINAL? UNDERSTANDING THE PRESENT VALUE DISCOUNT RATE SETTING?
Here's what I did to use REAL RATES, and it seems to be working.
- Present Value Discount Rate:
On the SETUP page, set cell I15 to 0.9%.
- Pension
On the SETUP page, set cell F93 to 0.0% if the pension is inflation adjusted. If not, set it to -2.1%.
- Social Security COLA
On the SETUP page, set cell E103 to 0.0%.
- Taxes Escalation Rate
On the TAX TABLE page, set cell D10 to 0.0%.
So the default for Pension IS COLA ? Nothing says that in the instructions. That cell says "to change annual income" -- how else does a Pension change over time, other than being COLA ??? Why is it titled "Change" instead of "COLA."

And if the Pension is NOT COLA, then setting to -2.1% is because 2.1 is the assumption of inflation that is baked-in to the Sheet, somewhere?
So if I want to use a 1% inflation rate for the COLA, I need to enter 2.1 - 1 = 1.1% ???
This makes NO sense.
Seeking Iso-Elasticity. | Tax Loss Harvesting is an Asset Class. | A well-planned presentation creates a sense of urgency. If the prospect fails to act now, he will risk a loss of some sort.

User avatar
Zephavest
Posts: 28
Joined: Thu Jan 10, 2013 9:09 am
Location: Texas

Re: Retiree Portfolio Model

Post by Zephavest » Tue Feb 12, 2019 7:09 am

Bongleur wrote:
Tue Feb 12, 2019 1:05 am
It would be good to say that in the introduction so people first view it with the correct interpretation.
Another item to be good to say in the the introduction is the tool assumes people have a good understanding of basic retirement financial concepts. There are many great posts on Bogleheads discussing these along with many great websites such as these I found in a quick Google search.

Your Retirement Plans Can't Ignore Inflation
https://money.usnews.com/money/blogs/th ... -inflation

How Inflation Eats Away at Your Retirement
https://www.investopedia.com/articles/r ... rement.asp

Inflation Impact on Retirement Planning
https://tritonfinancialgroup.com/inflat ... -planning/

Google is your friend, try doing searches such as this one:
understanding inflation effects on retirement budget
https://www.google.com/search?newwindow ... 84&bih=571
BigFoot48 wrote:
Mon Feb 11, 2019 11:18 am
If a user is having too much difficulty with it, I suggest the excellent ORP model, which is very easy to use and provides nearly identical results in calculating future portfolio results. https://www.i-orp.com/bequest/index.html

goGators
Posts: 53
Joined: Thu Apr 04, 2013 10:01 pm

Re: Retiree Portfolio Model

Post by goGators » Tue Feb 12, 2019 7:47 am

Zephavest wrote:
Mon Feb 11, 2019 11:01 am
...
BigFoot has bent over backwards year after year, continually updating the tool, fixing bugs and adding features that meet most users needs and for that I'm very grateful. When you hit a situation that the tool does not address, be creative, you can find workarounds for your own personal situation.
...
+1
I'm another VERY GRATEFUL user. RPM is #1 on my list. It's an amazing tool. Thank you BigFoot for all of your hard work!

smitcat
Posts: 2475
Joined: Mon Nov 07, 2016 10:51 am

Re: Retiree Portfolio Model

Post by smitcat » Tue Feb 12, 2019 8:11 am

goGators wrote:
Tue Feb 12, 2019 7:47 am
Zephavest wrote:
Mon Feb 11, 2019 11:01 am
...
BigFoot has bent over backwards year after year, continually updating the tool, fixing bugs and adding features that meet most users needs and for that I'm very grateful. When you hit a situation that the tool does not address, be creative, you can find workarounds for your own personal situation.
...
+1
I'm another VERY GRATEFUL user. RPM is #1 on my list. It's an amazing tool. Thank you BigFoot for all of your hard work!
+1 we are very thankful for this tool, it has been very vauable for us.
Thank you for your work!

User avatar
munemaker
Posts: 3886
Joined: Sat Jan 18, 2014 6:14 pm

Re: Retiree Portfolio Model

Post by munemaker » Tue Feb 12, 2019 8:22 am

smitcat wrote:
Tue Feb 12, 2019 8:11 am
goGators wrote:
Tue Feb 12, 2019 7:47 am
Zephavest wrote:
Mon Feb 11, 2019 11:01 am
...
BigFoot has bent over backwards year after year, continually updating the tool, fixing bugs and adding features that meet most users needs and for that I'm very grateful. When you hit a situation that the tool does not address, be creative, you can find workarounds for your own personal situation.
...
+1
I'm another VERY GRATEFUL user. RPM is #1 on my list. It's an amazing tool. Thank you BigFoot for all of your hard work!
+1 we are very thankful for this tool, it has been very vauable for us.
Thank you for your work!
+1 Nothing else remotely like it. It is my go-to tool for retirement planning and Roth conversions. I am very appreciative for your work and for making this available to us.

User avatar
munemaker
Posts: 3886
Joined: Sat Jan 18, 2014 6:14 pm

Re: Retiree Portfolio Model

Post by munemaker » Tue Feb 12, 2019 9:30 am

Bongleur wrote:
Tue Feb 12, 2019 1:12 am
[Why is it titled "Change" instead of "COLA."
You say Tomatoe, I say Tomato
https://www.youtube.com/watch?v=zZ3fjQa5Hls
Bongleur wrote:
Mon Feb 11, 2019 6:17 am
And if the Pension is NOT COLA, then setting to -2.1% is because 2.1 is the assumption of inflation that is baked-in to the Sheet, somewhere?
The inflation rate is not "baked into the Sheet." It is baked into the numbers that you enter into the sheet. For example, if you enter a pension that does not have inflation adjustment, it is not going to maintain its real value year after year. It is going to decline every year due to inflation.

eg. 2.1% inflation, $1000 pension inflation adjusted, nominal values:

2019 - $1,000
2020 - $1,021
2021 - $1,042
etc.

eg. 2.1% inflation, $1,000 pension inflation adjusted, real values:

2019 - $1,000
2020 - $1,000
2021 - $1,000
etc.

eg. 2.1% inflation, $1,000 pension non-inflation adjusted, nominal values:

2019 - $1,000
2020 - $1,000
2021 - $1,000

e.g. 2.1% inflation, $1,000 pension, non-inflation adjusted, real values:

2019 - $1,000
2020 - $979
2021 - $959
etc.
Bongleur wrote:
Mon Feb 11, 2019 6:17 am
So if I want to use a 1% inflation rate for the COLA, I need to enter 2.1 - 1 = 1.1% ???
By "inflation rate for the COLA," I assume you mean the annual change of the pension. If you are working in nominal terms, enter 1.0%. If you are working in real terms, then input as a negative number: -1.1%. It is a negative number because the increase is not keeping up with the 2.1% inflation rate.

Hope this helps.
Last edited by munemaker on Tue Feb 12, 2019 12:32 pm, edited 2 times in total.

User avatar
Topic Author
BigFoot48
Posts: 2649
Joined: Tue Feb 20, 2007 10:47 am
Location: Arizona

Re: Retiree Portfolio Model

Post by BigFoot48 » Tue Feb 12, 2019 9:59 am

Thanks for all the appreciation of the model! It is my contribution to the Boglehead forum and members, who have done so much to improve my and other forum visitors financial lives for many years. And it wouldn't be where it is today without the valuable suggestions for improvements and corrections from Bogleheads, with 20 of the most significant currently listed on the Readme page (and there are many more).

I also want to thank all of you who jump in to help answer user questions. If I don't reply it's because the answers are exactly right, and I couldn't have said it better.
Retired | Two-time in top-10 in Bogleheads S&P500 contest; 13-time loser

User avatar
Zephavest
Posts: 28
Joined: Thu Jan 10, 2013 9:09 am
Location: Texas

Re: Retiree Portfolio Model

Post by Zephavest » Tue Feb 12, 2019 10:50 am


Post Reply