Search found 2573 matches

by BigFoot48
Tue Oct 30, 2018 8:50 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

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: 928
Views: 100731

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: 434
Views: 167856

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: 434
Views: 167856

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: 434
Views: 167856

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: 434
Views: 167856

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: 5262

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: 1290

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: 1290

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...
by BigFoot48
Fri Sep 28, 2018 7:46 am
Forum: Investing - Help with Personal Investments
Topic: Tax Efficient Schwab Bond Fund
Replies: 14
Views: 1290

Re: Tax Efficient Schwab Bond Fund

billthecat wrote:
Fri Sep 28, 2018 7:32 am
Aren’t there commissions when buying Vanguard ar Schwab?
Yes there is. In the case of Vanguard Inter-Term Tax Exempt VWITX it's $76 and $0 to sell. This is one of the reason to use Schwab funds wherever possible and do sales as infrequently as possible, such as once-a-year in my MIL's case.
by BigFoot48
Fri Sep 28, 2018 12:39 am
Forum: Investing - Help with Personal Investments
Topic: Tax Efficient Schwab Bond Fund
Replies: 14
Views: 1290

Re: Tax Efficient Schwab Bond Fund

In recent years I've been buying the Vanguard Intermediate Tax Exempt bond fund in my mother-in-laws Schwab taxable account with her RMD proceeds. She also holds Vanguard Total Bond fund there. I look at the returns on each and the impact of her 25% marginal rate on the dividends. In 2017 Tax Exempt...
by BigFoot48
Wed Sep 26, 2018 9:31 am
Forum: Investing - Theory, News & General
Topic: Don't Fear the Reaper (RMDs) - White Coat Investor blog post
Replies: 65
Views: 7641

Re: Don't Fear the Reaper (RMDs) - White Coat Investor blog post

This thread made me look at my forecast in RPM and I see my Federal marginal rate will jump from the 0% I've been purposely achieving the last few years, to 12% in 2019, then, when my wife inherits an IRA a few years later, to 22%.

So it goes - the piper finally gets paid.
by BigFoot48
Wed Sep 19, 2018 9:01 am
Forum: Personal Finance (Not Investing)
Topic: Are Roth conversions a no-brainer for me?
Replies: 22
Views: 2264

Re: Are Roth conversions a no-brainer for me?

You might find the Retiree Portfolio Model very useful in running your numbers.

viewtopic.php?t=97352
by BigFoot48
Tue Sep 18, 2018 12:20 pm
Forum: Personal Finance (Not Investing)
Topic: "Taking" RMDs
Replies: 18
Views: 1755

Re: "Taking" RMDs

When mine starts next year, I will be selling Vanguard Total Bond fund in December and buying Total Bond and/or Vanguard Tax-Exempt Bond fund in the taxable account. Exactly what I have been doing for my 92-YO MIL for many years.
by BigFoot48
Sat Sep 08, 2018 2:20 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

Version 18.2 of the Retiree Portfolio Model model is now available. This update corrects a calculation error in state income taxes for the bracket method as reported by BH ohyeah. At some income and bracket settings the second bracket formula was overstating state taxes (in the Example case by 22%),...
by BigFoot48
Thu Sep 06, 2018 5:54 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

When using the state income tax brackets (my state has 3), I noticed that the middle bracket would include the lower bracket in its calculation. I'm glad you like it and thanks for this report on a possible problem. I took a quick look at the state tax calculation and it appears to be calculating c...
by BigFoot48
Thu Sep 06, 2018 1:01 pm
Forum: Personal Consumer Issues
Topic: Phone Calls from Windows saying computer has Malware
Replies: 40
Views: 2193

Re: Phone Calls from Windows saying computer has Malware

I recommend and use the free Nomorobo service (if your phone company supports it) which significantly cuts down on junk calls. https://www.nomorobo.com/
by BigFoot48
Thu Sep 06, 2018 11:19 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

Great news and thanks for reporting the solution, one that I didn't think of. Using a 32 or 64 bit program should not matter for this model.
by BigFoot48
Wed Sep 05, 2018 6:02 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

So now for your lasted challenge, RPM 18.1 is crashing on me and then reopens with the file name changing from xxx.xlsm to xxx.xlsb. This has happened few times so in troubleshooting I did the following: .... I'm running Windows 10 with current patches always automatically applied. My Excel is part...
by BigFoot48
Thu Aug 30, 2018 12:23 pm
Forum: Personal Finance (Not Investing)
Topic: high RMD withdraw from 401k question
Replies: 31
Views: 3378

Re: high RMD withdraw from 401k question

raaizin wrote:
Tue Aug 28, 2018 6:43 pm
Is there any calculators which could help me decide what optimum withdrawl amount would be.
You might try my Excel Retiree Portfolio Model as it includes most of the factors you are dealing with. Retiree Portfolio Model
by BigFoot48
Wed Aug 29, 2018 10:34 am
Forum: Personal Finance (Not Investing)
Topic: How do you 7 figure guys organize multiple accounts?
Replies: 164
Views: 12116

Re: How do you 7 figure guys organize multiple accounts?

Hulk wrote:
Tue Aug 28, 2018 9:01 am
I attempt a 4 fund portfolio across 5 brokerage companies and 3 banks. Would love to simplify but not so easy
I have everything with Schwab. Just take that first step and move everything possible to a single brokerage and enjoy the ease of access.
by BigFoot48
Sat Aug 25, 2018 9:59 am
Forum: Personal Finance (Not Investing)
Topic: Costco business credit card
Replies: 13
Views: 985

Re: Costco business credit card

I've been unable to confirm that there's no Federal law protecting business cards but it may allow a $500 limit as shown here: Generally, consumer credit cards have more protections on them, but even with a business credit card, as long as you contact your credit card company within 48 hours, the mo...
by BigFoot48
Sat Aug 25, 2018 9:19 am
Forum: Personal Finance (Not Investing)
Topic: Costco business credit card
Replies: 13
Views: 985

Re: Costco business credit card

I investigated the liability for unauthorized charges for the Business card online at Citibank and found this statement: "$0 liability for unauthorized charges means you will not be liable for unauthorized charges on your account." This was found on the "Costco Anywhere Visa® Business Card by Citi" ...
by BigFoot48
Thu Jul 26, 2018 4:50 pm
Forum: Personal Consumer Issues
Topic: [What TV Show Have You Recently Watched?]
Replies: 928
Views: 100731

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

Dark Tourist on Netflix is interesting, showing sites and people around the world that are unusual, unique and occasionally a bit grim. The host, from New Zealand, claims to be seeking out the “mad, macabre, and morbid” and generally succeeds. Eight parts.
by BigFoot48
Sat Jul 21, 2018 8:57 am
Forum: Investing - Help with Personal Investments
Topic: I'm about to inherit a single stock with a worth of just over 7 figures....
Replies: 103
Views: 9312

Re: I'm about to inherit a single stock with a worth of just over 7 figures....

As a Mobil retiree I sold my last 100 shares years ago as I transition to a simplified, diversified Bogleheads portfolio. I have a digital copy of a Mobil stock certificate but any sentimentality I have is with my former co-workers and the work experiences. Sell the stock to those who want the risk ...
by BigFoot48
Fri Jul 20, 2018 11:21 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

Question: I am currently receiving RMDs from a traditional IRA inherited from my mom about 16 years ago and wonder how to model it in RPM. Apparently RPM does not model an IRA in the past. Seems like I need to set this up as though it was inherited this year and RMDs start next year. Is that correc...
by BigFoot48
Fri Jul 13, 2018 5:34 pm
Forum: Investing - Help with Personal Investments
Topic: massive Roth conversion
Replies: 40
Views: 3722

Re: massive Roth conversion

Dottie57 wrote:
Fri Jul 13, 2018 2:23 pm

Will this run on Mac which does not have Visual Basic for applications?
Sorry, but I don't know, but the model can be used without the Visual Basic macros which are just used for navigating and clearing entries.
by BigFoot48
Fri Jul 13, 2018 10:22 am
Forum: Investing - Help with Personal Investments
Topic: massive Roth conversion
Replies: 40
Views: 3722

Re: massive Roth conversion

Put your numbers in the Retiree Portfolio Model to get an estimate of what the gutting might be during conversions, or after 70 during RMD years. It now includes an estimate of the impact of high income on Medicare premiums.
by BigFoot48
Sun Jul 08, 2018 9:28 am
Forum: Personal Finance (Not Investing)
Topic: Checkbook balancing software?
Replies: 31
Views: 1958

Re: Checkbook balancing software?

I'm still using Microsoft Money Plus Deluxe after many years. It's free to download but no longer updated which isn't an issue in doing check reconciliation. That feature works very well and makes it easy to do in about 1 minute (many entries are entered automatically via the Bills feature.) My 92-Y...
by BigFoot48
Wed Jul 04, 2018 10:28 am
Forum: Personal Consumer Issues
Topic: [What TV Show Have You Recently Watched?]
Replies: 928
Views: 100731

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

"A Very English Scandal", a 3-part BBC true story starring Hugh Grant, was very good. Amazon Prime

3-part, not 4 per correction
by BigFoot48
Sun Jun 24, 2018 9:21 am
Forum: Personal Consumer Issues
Topic: Fixing drip irrigation line
Replies: 13
Views: 1056

Re: Fixing drip irrigation line

I have drip irrigation all over the yard, most inherited and some I installed. It's all buried 4"-12". The older tubing lines randomly starts leaking a few times a year, requiring cutting out the leaking area and installing a coupling or a larger segment of tubing and using two couplings. The most w...
by BigFoot48
Sat Jun 23, 2018 8:49 am
Forum: Investing - Theory, News & General
Topic: I-bonds look pretty bad right now
Replies: 92
Views: 11746

Re: I-bonds look pretty bad right now

I cashed-in my modest holding of i-bonds a few years ago when I finally evolved to having a 3-fund portfolio. (Thank you Taylor!) I also realized that i-bonds would never be more than a few percent of my portfolio because of the annual limit on purchases, and holding an investment that is less than ...
by BigFoot48
Thu Jun 14, 2018 7:34 am
Forum: Personal Consumer Issues
Topic: 2010 Toyota Highlander Heater and AC
Replies: 3
Views: 470

Re: 2010 Toyota Highlander Heater and AC

You might want to post your question at Toyota Nation. Lots of knowledgeable Highlander people there. http://www.toyotanation.com/forum/122-h ... 2008-2013/
by BigFoot48
Sun Jun 10, 2018 2:00 pm
Forum: Investing - Help with Personal Investments
Topic: Investing Help for my Mom - She's 86
Replies: 10
Views: 1026

Re: Investing Help for my Mom - She's 86

I manage my age 90 mother-in-law's portfolio and have her in 20% Total Stock Market and 80% Total Bond and Tax-Exempt Bond (return of 7.3% in 2017), but think retiredjg's suggestion of Vanguard's LifeStrategy Income fund is an excellent idea to keep it simple. If you or her want to keep managing the...
by BigFoot48
Sat Jun 02, 2018 4:27 pm
Forum: Personal Consumer Issues
Topic: [What TV Show Have You Recently Watched?]
Replies: 928
Views: 100731

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

Just finished the Netflix import "Stranger", which is a South Korean crime drama with sub-titles. 18 long episodes so its a big of a ordeal but a very good show on murder and corruption, with excellent acting. Also offers an interesting glimpse into S Korea for those of us who haven't been there.
by BigFoot48
Thu May 31, 2018 6:08 pm
Forum: Personal Finance (Not Investing)
Topic: Writing Checks on a Schwab IRA
Replies: 22
Views: 1635

Re: Writing Checks on a Schwab IRA

Looks like the QCD feature is fairly new, and is limited to 5 checks a month: To make it easier for your clients to make charitable donations from their IRA accounts, Schwab will roll out a new IRA Checkwriting feature on November 15, 2017, that will allow clients to write checks from their IRA acco...
by BigFoot48
Thu May 31, 2018 10:54 am
Forum: Personal Finance (Not Investing)
Topic: Writing Checks on a Schwab IRA
Replies: 22
Views: 1635

Re: Writing Checks on a Schwab IRA

Here's an thread from 2016 on Fidelity's check writing feature: viewtopic.php?t=202913 and 2017 on Vanguard's/etc.: viewtopic.php?t=224379
by BigFoot48
Thu May 31, 2018 10:21 am
Forum: Personal Finance (Not Investing)
Topic: Writing Checks on a Schwab IRA
Replies: 22
Views: 1635

Writing Checks on a Schwab IRA

I just got an email from Schwab concerning a new IRA check writing feature they have created. The most interesting thing is apparently the ability to write checks for qualified charitable distributions without having to have Schwab do it. This would make giving numerous smaller contributions much ea...
by BigFoot48
Thu May 31, 2018 9:01 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

Bigfoot - just a general thank you and to say that your RPM tool has been very valuable to us and many others. Thanks very much! And I want to thank the many Bogleheads who have contributed extremely useful features to it that were beyond my Excel knowledge base, and all the error reports that help...
by BigFoot48
Thu May 31, 2018 8:46 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

jkrm wrote:
Thu May 31, 2018 8:31 am
I just noticed an odd thing. If I enter manual withdrawals (cell E139 of the setup tab), then all withdrawals from IRA1 abruptly stop when I turn 80 (column V, rows 85 - 89 of the Details tab).
I suspect your IRA1 has a zero balance by age 80. What is shown in Setup J139 - Ending Balance?
by BigFoot48
Wed May 30, 2018 4:03 pm
Forum: Investing - Help with Personal Investments
Topic: 15% rate of return in last 15 years can I expect the same in next 16 years
Replies: 39
Views: 4357

Re: 15% rate of return in last 15 years can I expect the same in next 16 years

I see on madsinger's 2017 annual summary of returns that VFINX: Vanguard 500 Index Fund Investor had a 6.07% CAGR since 1999. I use 5% nominal.
by BigFoot48
Tue May 29, 2018 11:33 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

Does anyone know if it is possible for the model to use IRA2 for Roth conversions once IRA1 completely converted or doesn't have enough funds for desired conversion? I'm afraid not. A solution is to add to IRA1 the extra amount desired, reducing IRA2 balance. Or just completely combine them for thi...
by BigFoot48
Sat May 26, 2018 8:15 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

Any chance there will be a versions that includes as an input, the cost basis of taxable account and takes into consideration the capital gains tax paid on withdrawals from such an account, as well as its impact on Roth conversion tax rates. This seems like it would change the Roth Conversion analy...
by BigFoot48
Mon May 14, 2018 5:23 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

Exemptions bug. Thanks for reporting that bug and its been fixed! Personal Federal exemptions are not used beginning in 2018, but the age checking has been fixed to require the starting age to be greater than Your starting age and the ending age less than Your ending age. The extra exemptions are n...
by BigFoot48
Mon May 14, 2018 12:33 pm
Forum: Investing - Theory, News & General
Topic: Total Bond - SEC yield breaks 3%
Replies: 104
Views: 13582

Re: Total Bond - SEC yield breaks 3%

It's not all that bad. If you used the mutual fund instead of the ETF (using total bond market index fund VBTLX) you would be up $13.78 instead :wink: I happen to have 60% of my portfolio in the Vanguard Total Bond ETF, which I moved to from the mutual fund as I'm with Schwab and was annoyed by wha...
by BigFoot48
Sun May 13, 2018 8:16 am
Forum: Personal Consumer Issues
Topic: [What TV Show Have You Recently Watched?]
Replies: 928
Views: 100731

Re: Netflix, Your Current Favorite Show

Just finished the 8-part "Safe" UK series. Well acted, interesting missing person/crime drama.
by BigFoot48
Sun Apr 15, 2018 5:15 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model - SPIA Exclusion Ratio

I could use a little direction regarding the Exclusion Ratio for a SPIA purchase. I have reviewed several annuity offerings and each have a different method for defining the taxable portion. One in particular states the monthly payment is $2376 and the taxable portion is $323 per month. Based on th...
by BigFoot48
Sun Apr 15, 2018 5:03 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

When I tried to use the "clear entry macro" I get an error (1004) "the cell or chart is on a protected sheet ". The debug shows it to be at: !special events Range("G156:J156").Select Sorry about that! Fixed. I failed to test the clear macro with page protection turned on and it faulted on those cel...
by BigFoot48
Sun Apr 15, 2018 3:09 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

Hello, I assume RPM account balances are nominal (inflated dollars). Is there an easy way to display them in real (non-inflated) dollars? Thank you. 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...
by BigFoot48
Sun Apr 15, 2018 10:59 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 434
Views: 167856

Re: Retiree Portfolio Model

Version 18.1 of the Retiree Portfolio Model model is now available. This update adds new features along with other improvements and updates. Calculated results have not changed from 18.0 so only those who would like to use one of the new features need to download it. Note: the model was updated as ...