Search found 2614 matches

by BigFoot48
Sat Jan 19, 2019 9:26 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

A couple of notes... 1) yes, the spreadsheet can have a steep learning curve, because it does have lots of options. But I found I learned a lot by trying out things and looking to see what it was doing. So I encourage you to keep trying, and coming back for help if needed, just for the education fa...
by BigFoot48
Thu Jan 17, 2019 10:22 am
Forum: Personal Consumer Issues
Topic: Anyone with experience with Carmax?
Replies: 74
Views: 23649

Re: Anyone with experience with Carmax?

Two year ago, four years after I posted a comment in this thread that I planned to use CareMax, I did! My 90-year old MIL decided she should not be driving anymore, a good decision after some strange long distant trips, and wanted to sell her car, a 2007 Buick. We took it to CarMax and had a very go...
by BigFoot48
Wed Jan 16, 2019 6:24 pm
Forum: Investing - Theory, News & General
Topic: John Bogle has died at age 89
Replies: 828
Views: 41360

Re: John Bogle is dead at 89

A truly great man. Just think for a moment what he did that improved the financial lives of tens of millions.

Rest in peace.
by BigFoot48
Wed Jan 16, 2019 5:47 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

well I cleared the sample entries, and started with no entries, and did as you suggested .... starting with 7. Special Events -> future events -> 1 & 2 include in portfolio "y" taxable account blank (as no idea what this means) , then entered the two IIRAs dollar amounts, and my current beneath bot...
by BigFoot48
Wed Jan 16, 2019 9:38 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

The model calculates the difference between these two numbers, and if the Base case final portfolio balance is larger, produces a "don't convert" conclusion. But the balance in the Full case portfolio, which is mostly Roth funds, is actually worth significantly more than an equivalent final balance...
by BigFoot48
Wed Jan 16, 2019 7:30 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

I can enter some of the information, but I can't see how it all is suppose to tie together , nor fit what goes where with the terms being used , I do see something about the ACA in there, but there is no where to enter the subsidy for example, and any roth conversion I would do now, would greater i...
by BigFoot48
Tue Jan 15, 2019 5:44 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Hello, thx for the RPM SS, however, I find it rather complex how to start or if it is even intended for an early retiree? eg I am in my mid 50s, I have 2 parents IIRA RMDs every year, in Summary Section 1 it says "Inherited IRA at age 77" then the blue box I have entered 55 my age , It looks like t...
by BigFoot48
Tue Jan 15, 2019 5:27 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Regarding the state tax calculation issue, I am using version 19. To double-check, I did a clean download today and see that the formulas on the "Details" sheet for rows 219 and 220 appear to be incorrect. Also, cell F218 appears incorrect. Thanks. PM sent UPDATE: jaytrain52 was using an old versio...
by BigFoot48
Tue Jan 15, 2019 12:30 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

It appears that state taxes are not being calculated correctly when using state tax brackets. In particular, taxes are not being calculated for the 2 highest tax brackets. Am I wrong or is there an issue? Thanks. Are you using version 19.0, because that was fixed last year and appears to be working...
by BigFoot48
Mon Jan 14, 2019 10:57 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Just want to report there seems like a minor error on the "Balances by Account at Year End" graph on the RESULTS sheet. For my situation, the graph shows for colors: red, orange, yellow and green. However, there are only 3 labels: Blue = Taxable, Green = IRA, Red = Inherited IRA. The Blue and Green...
by BigFoot48
Sat Jan 12, 2019 6:34 pm
Forum: Investing - Theory, News & General
Topic: Schwab SWSXX going away
Replies: 37
Views: 2616

Re: Schwab SWSXX going away

BobDaBlob wrote:
Sat Jan 12, 2019 6:27 pm
BigFoot...
What part of these returns is under-whelming?
Seems right on par with 2+% per year...
If you find a vehicle that pays 2+ per month...please let us all know :beer

Bob
Thank you! I got myself confused there. I think I'll keep it!
by BigFoot48
Sat Jan 12, 2019 6:14 pm
Forum: Investing - Theory, News & General
Topic: Schwab SWSXX going away
Replies: 37
Views: 2616

Re: Schwab SWSXX going away

I bought $10,000 of Schwab Value Advantage MM (SWVXX) in August based on a similar discussion. I must say the returns are under-whelming. A short term bond fund might be much better. Dividends paid: Sep $17.14 Oct $15.12 Nov $17.50 Dec $27.98 SWVXX is a money market fund with a yield of about 2.3%....
by BigFoot48
Sat Jan 12, 2019 5:58 pm
Forum: Investing - Theory, News & General
Topic: Schwab SWSXX going away
Replies: 37
Views: 2616

Re: Schwab SWSXX going away

I bought $10,000 of Schwab Value Advantage MM (SWVXX) in August based on a similar discussion. (Comment edited for accuracy.)
Aug 13 - bought
Actual dividends paid:
Sep 17: $17.14
Oct 15: $15.12
Nov 15: $17.50
Dec 31: $27.98
by BigFoot48
Sat Jan 12, 2019 10:07 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Where do I enter my VA disability benefit in the model? It is not taxable at the federal or local levels, and is indexed for inflation. Enter it as an Other Income item then use the AGI user adjustment in Section 8 to remove the income from taxes. This requires entering the inflated amounts (as neg...
by BigFoot48
Wed Jan 09, 2019 10:12 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Sorry if this is a naive question. Are the dollar amounts that are modeled in this tool based on future dollars or represented in today's dollars? If my plan shows that I will have $1M in my retirement accounts in twenty years is that saying the actual value will be $1M at that point in time, or ju...
by BigFoot48
Wed Jan 09, 2019 9:32 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Many thanks to Zephavest for his insightful review of RPM. The model has evolved significantly since its introduction in 2012 as a simple Roth Conversion tool. Over the years it has had invaluable contributions from dozens of Bogleheads, with many suggestions for new features that have been implemen...
by BigFoot48
Fri Jan 04, 2019 11:35 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

On the DETAILS sheet: - Cells E8, E11, E14, E17, E18, E19 are in green (suspected wrong) and do not agree with the actual Final Balance cells, which in my case are AN8, AN11, AN14, AN17, AN18, AN19. Cells AU8, AU11, AU14, AU17, AU18, AU19 (also in green) agree with the incorrect values in column E....
by BigFoot48
Fri Jan 04, 2019 10:36 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

This "formula reference" problem may be related to the new graphs in 19.0. As a test, I've removed them and the names that had to be created to make them work. For those having the problem, download this version where I have deleted these new names and the graphs that used them, and see if this fixe...
by BigFoot48
Fri Jan 04, 2019 4:11 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Sorry you are getting an error message. Using Excel 2013 or Libre Office Calc 6.1, when I clear macros in 19.0 and load from either 18.2 or 17.0 I don't get any error message. If either of you that are seeing the macro want to send me a PM we can arrange to let me test the load models you are using....
by BigFoot48
Tue Jan 01, 2019 10:54 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Thanks Zephavest! I will add those instructions to the post.
by BigFoot48
Tue Jan 01, 2019 10:32 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

vest74 wrote:
Tue Jan 01, 2019 10:23 am
what if you do not have drop box and do not care to "enroll" i use open office
The download should not require a membership. Can this be confirmed?
by BigFoot48
Tue Jan 01, 2019 10:12 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

A user reported a situation not covered by the model - the purchase of an annuity in an earlier year, and the need to show the income in the current and future years. While this income could be shown in the existing Other Income settings, there is no provision in them for income in IRA 1 or Roth IRA...
by BigFoot48
Tue Jan 01, 2019 7:55 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Version 19.0 of the Retiree Portfolio Model model is available as of Jan 1, 2019 and can be downloaded from Dropbox via this link: https://www.dropbox.com/s/cjkyy4wpce4wfmr/Retiree%20Portfolio%20Model%20v19.0.xlsm?dl=0 Changes in version 19.0 include: 2019 Federal tax rates, brackets and standard de...
by BigFoot48
Fri Dec 28, 2018 10:07 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

I am single. I download the spreadsheet, enable Editing and Content, go to the Setup tab. Spouse age is set to default 61. Instructions say "Leave blank if single". I tried Delete and Space to get a blank for Spouse age but both generate multiple red error messages. What to do if single? TIA It wil...
by BigFoot48
Fri Dec 28, 2018 8:58 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Just wondering if you have any thoughts on the best way to model some of the less common tax events... in my case specifically, looking at how to model the impact of the American Opportunity Tax Credit, which provides a credit of up to $2500 if you have appropriate college expenses of $4000 or more...
by BigFoot48
Tue Dec 25, 2018 8:16 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model - Negative Balances

Hi folks, newbie here. This tool is awesome but I am having one issue and can't seem to find the answer on the board. I know that the tool does not correct for negative account balances, and that must be done manually. (That is, once the taxable account runs out, I want to change it to stop going n...
by BigFoot48
Mon Dec 24, 2018 1:32 pm
Forum: Personal Consumer Issues
Topic: Win 10 image backup software?
Replies: 12
Views: 1036

Re: Win 10 image backup software?

I use the free AOMEI Backupper. It creates a bootable OS on a thumb-drive or DVD which can then be used to restore the drive via an image. I used it successful to restore my MIL's Win 10 computer which I had bricked by deleting the hard drive driver as suggested by Microsoft to solve some problem it...
by BigFoot48
Thu Dec 20, 2018 9:55 am
Forum: Investing - Help with Personal Investments
Topic: Time to move on?
Replies: 10
Views: 1462

Re: Time to move on?

RickBoglehead wrote:
I'd move this ASAP to Vanguard Total Stock Market Index.
I agree. The investment is worth x today and should be replaced with a better investment costing x today.
by BigFoot48
Sun Dec 16, 2018 11:46 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

I don't have time to look thru the many replies here to see if this has already been noted, but the state AGI income calculation appears to be incorrect. On line 367 Pension 1 is subtracted from the Federal AGI. On line 370 Pension 1, adjusted by the percentage that's supposed to be an exclusion is...
by BigFoot48
Sat Dec 15, 2018 8:31 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

BigFoot48, Thank you for this spreadsheet. As a single woman with fewer assets than you (and greater need for planning!) and using Google Sheets (no "clear" macro), I have a lot of work to do to get started, finding and removing data in blue cells or setting to "n" (every spouse entry, annuity, inh...
by BigFoot48
Sat Dec 15, 2018 8:13 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

BTW you might want to add to Excel Online in your list of alternatives - comments/help (upper right triangles) don't seem to work. Thank you. Yes, the cell comments can't be viewed, macros don't work, question marks get moved from the end of a cell label to the front, and the model must be used in ...
by BigFoot48
Fri Dec 14, 2018 4:42 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Question to BIGFOOT: I vaguely seem to remember you saying you were going to issue an update around the beginning of 2019. Is this true? The reason I ask is I will be updating my data inputs at the beginning of the year, and if a new version will be out, I want to use it. Thanks! Set for release Ja...
by BigFoot48
Fri Dec 14, 2018 4:31 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

kolea, I'm glad you like the model and thanks for the questions. COLA: There are various factors, such as pensions, SS, expenses and income taxes that have different assigned escalation rates. This was done to allow flexibility and use the historic escalation rates that each of them may have. The mo...
by BigFoot48
Fri Dec 14, 2018 8:59 am
Forum: Personal Finance (Not Investing)
Topic: Critique my SS/RMD Tax Plan
Replies: 18
Views: 1417

Re: Critique my SS/RMD Tax Plan

jacksonm wrote:
Fri Dec 14, 2018 8:44 am

Thanks. Good to know others are doing it with no IRS problems.
There was a long discussion of the strategy last year (one of many times): viewtopic.php?t=228565
by BigFoot48
Thu Dec 13, 2018 11:06 pm
Forum: Personal Finance (Not Investing)
Topic: Critique my SS/RMD Tax Plan
Replies: 18
Views: 1417

Re: Critique my SS/RMD Tax Plan

.. and then take my RMD in one lump sum in December with enough tax withheld to cover the tax bill. That's exactly how I've been doing RMD with tax withholding for my mother-in-law the past 8 years, and exactly how I plan to do it for myself next year. It's a widely known and accepted Bogleheads st...
by BigFoot48
Wed Nov 28, 2018 4:59 pm
Forum: Investing - Help with Personal Investments
Topic: Roth Conversion
Replies: 50
Views: 3251

Re: Roth Conversion

Thanks everyone for the replies. What I am hearing here is that most replies think I should not abandon a Roth conversion. I realize the devil is in the details but as I was creating a spread sheet to model it, it started getting pretty complex and I thought, why bother if everyone thinks it is a b...
by BigFoot48
Wed Nov 21, 2018 8:58 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Thanks, that seems have worked. One other question. When I look at the graph for "annual income' in the setup tab, or "sources of earnings" in the results tab, it looks like I'm not taking enough from IRA to cover expenses. It seems like something is being left out in the generation of this graph. ...
by BigFoot48
Tue Nov 20, 2018 5:35 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

I just started looking at this. Looks like it could be a useful planning tool. Downloaded and using 18.2 .. Am I doing something wrong, or can't the spreadsheet model this? Thanks The error message is showing a false-positive for your benefits and should be ignored. I will fix it in the next releas...
by BigFoot48
Sun Nov 18, 2018 8:40 am
Forum: Personal Consumer Issues
Topic: [What TV Show Have You Recently Watched?]
Replies: 1026
Views: 109946

Re: [What TV Show Have You Recently Watched?]

The Legend of Buster Scruggs on Netflix, a 6-episode western anthology by the Coen brothers, is very good, although a bit dark. We were going to watch an episode or two and ended up watching the whole 2.5 hours. I thought Ep1 was really funny, the others much more serious.
by BigFoot48
Sat Nov 17, 2018 6:39 pm
Forum: Personal Consumer Issues
Topic: When is Too Long to Return a Hair Dryer to Costco?
Replies: 73
Views: 4998

Re: When is Too Long to Return a Hair Dryer to Costco?

I once saw a couple in the return line with a queen/king-sized mattress that was dirty and well-used, probably 10 years old. A $500-$1000 bite out of the days profits.
by BigFoot48
Tue Oct 30, 2018 8:50 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Hi, Bigfoot, great work. I have been playing around with 18.2. Should i revert to an early version? I have not really taught myself enough to and have only modified the sheets given inputs. Tried to clear it and start with none was too much for me at this time. Dreaming The earlier versions are not...
by BigFoot48
Fri Oct 26, 2018 8:25 am
Forum: Personal Consumer Issues
Topic: [What TV Show Have You Recently Watched?]
Replies: 1026
Views: 109946

Re: [What TV Show Have You Recently Watched?]

Bodyguard on Netflix is starting out very good with intense action scenes, although the lead's Scottish accent is a bit hard to understand occasionally.
by BigFoot48
Wed Oct 17, 2018 3:06 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

A revised version of 18.2 is now available. A correction to the calculation of Federal AGI used in determining Social Security taxable income and state taxable income has been made, thanks to BH mkedst. This correction added to each of these amounts the taxable account adjustment used to estimate th...
by BigFoot48
Wed Oct 17, 2018 2:12 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

Yes, I'm aware of the Taxable Account Adjustment and in my question I did show that I tried both 70% and 97% to include/remove QD/LTCG from taxes. As I mentioned in my question, if I use 97% to remove QD/LTCG from taxes, AGI is incorrect (too low by $23k!) and that gets used for state taxes, social...
by BigFoot48
Wed Oct 17, 2018 12:39 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

That means AGI $25,000, taxable income $13,000, and this will show fed tax $0 in the Simple Tax Calculator (since it has the QD/LTCG data). But, to get fed tax $0 in RPM, taxable income needs to be $0. It seems like RPM could use a QD/LTCG input to subtract from the income going into the tax tables...
by BigFoot48
Wed Oct 17, 2018 7:46 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 513
Views: 179634

Re: Retiree Portfolio Model

I'm having some trouble modeling qualified dividends and long-term capital gains. Maybe it's because QD and LTCG dominate my income. If I set the taxable account adjustment to include QD/LTCG in the taxable account (70%), then my federal taxes will be off - something like $1500, when I'm expecting ...
by BigFoot48
Fri Oct 05, 2018 5:04 pm
Forum: Investing - Theory, News & General
Topic: 2018 Bogleheads Conference Notes
Replies: 36
Views: 5539

Re: 2018 Bogleheads Conference Notes

The Wall Street Journal had a nice article on the conference today: Jack Bogle’s Bogleheads Keep Investing Simple. You Should Too. Inside a gathering when investors pay homage to the father of the index fund. Https://www.wsj.com/articles/jack-bogles-bogleheads-keep-investing-simple-you-should-too-15...
by BigFoot48
Fri Sep 28, 2018 6:59 pm
Forum: Investing - Help with Personal Investments
Topic: Tax Efficient Schwab Bond Fund
Replies: 14
Views: 1399

Re: Tax Efficient Schwab Bond Fund

The proper comparison is the SEC yield, not the annual returns; the annual returns are subject to changes in the market for different types of bonds. The current yields on Admiral shares are 3.23% for Total Bond Market, 2.69% for Intermediate-Term Tax-Exempt, which gives the muni fund a higher yiel...
by BigFoot48
Fri Sep 28, 2018 4:44 pm
Forum: Investing - Help with Personal Investments
Topic: Tax Efficient Schwab Bond Fund
Replies: 14
Views: 1399

Re: Tax Efficient Schwab Bond Fund

The Vanguard Tax-Exempt Bond ETF (VTEB) or iShares National Muni Bond ETF (MUB) would cost only $5 in commission at Schwab. Both have an attractive ER and an intermediate average duration. That's indeed a good way to avoid the high fee on Vanguard funds. I converted my three Vanguard funds in Schwa...