Search found 2424 matches

by BigFoot48
Tue Jan 17, 2017 7:05 pm
Forum: Investing - Help with Personal Investments
Topic: Vanguard Tax Exempt Bonds
Replies: 8
Views: 1095

Re: Vanguard Tax Exempt Bonds

I manage my widowed 90 year-old mother-in-law's investments. Three years ago I decided to invest her RMD proceeds, along with proceeds from simplifying her account down to a 3-Fund version, in the Vanguard Intermediate Term Tax Exempt fund (VWITX). She is in the 25% marginal bracket. I've just finis...
by BigFoot48
Tue Jan 17, 2017 5:34 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

The reports I find most useful in ORP are the asset balance report, and income by federal tax bracket. The asset balance report could be simplified and aggregated into a net worth report. Versions of these are created within your spreadsheet, but to me seem less intuitive than the ORP reports. Food...
by BigFoot48
Mon Jan 16, 2017 12:12 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

I found one more issue, again not sure if this is my problem... I decided to download the latest version. Did that, but then saved it as an xlsm file in Excel 2010. When I then tried to run the "clear" macro on that, I got an error: Oops, sorry about that! When I fixed the label for the Q...
by BigFoot48
Mon Jan 16, 2017 8:55 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

Am I doing something incorrectly, or is this something that isn't modeled by just the inputs on the setup page? In that case, I presume I could model it manually by changing the results on the full/base case pages explicitly? Thanks! While there's likely some situations the model can't handle, I be...
by BigFoot48
Sun Jan 15, 2017 3:51 pm
Forum: Personal Finance (Not Investing)
Topic: Setting Withdrawals from Converted Roth in Retiree Portfolio Model
Replies: 2
Views: 189

Re: Setting Withdrawals from Converted Roth in Retiree Portfolio Model

Withdrawals are entered in "Section 10. Special: Roth Conversions" in either of two ways: calculated or yearly entered. In the Example data there is in the calculated option a withdrawal amount of $10,000 set for starting at age 75 and ending at 76, with a 50% yearly escalation. In the ent...
by BigFoot48
Sun Jan 15, 2017 9:12 am
Forum: Personal Finance (Not Investing)
Topic: ROTH conversion calculator to minimize RMDs?
Replies: 18
Views: 1553

Re: ROTH conversion calculator to minimize RMDs?

My options: 1. Keep paying $0 in taxes for the next 6 years, keep converting around $20,000/yr to Roth, and then be hit with the RMDs. 2. Start converting to Roth up to the 10% or 15% max tax bracket, hoping this will minimize the RMDs. Will Bigfoot's Retiree Portfolio Manager give me the best answ...
by BigFoot48
Sat Jan 14, 2017 10:32 am
Forum: Personal Finance (Not Investing)
Topic: Turbo Tax 2016 purchase source
Replies: 85
Views: 10143

Re: Turbo Tax 2016 purchase source

rgs92 wrote:I'm not sure why anyone would need software on a CD these days.

That's the only way Costco, for example, sells it. Less a "need" than a "take-it-or-leave-it" thing.
by BigFoot48
Fri Jan 13, 2017 2:18 pm
Forum: Personal Finance (Not Investing)
Topic: ROTH conversion calculator to minimize RMDs?
Replies: 18
Views: 1553

Re: ROTH conversion calculator to minimize RMDs?

Is there a calculator that given the individual's age (less than 70 and 1/2), amount of tax-deferred balance, tax-filing status, current tax rate, and projected growth of tax-deferred balance, will give you a suggested Roth conversion amount per year, up to 70 and 1/2? Thank you. The Retiree Portfo...
by BigFoot48
Fri Jan 13, 2017 10:15 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

I have a question about the exemption amount displayed under the Federal Taxable Income calculations. Despite setting filing status to "married", the line item for exemptions and deductions seems to include an amount based on a single exemption (4050). Thanks! I do see this occur when the...
by BigFoot48
Thu Jan 12, 2017 8:57 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

I just tried the second fix - no issues. Thanks! Great! The 17.0 and 17.0xb models have been updated with fixed macro name. Anyone using Excel 2007 and newer may want to upgrade to avoid this Excel warning message: "The name, QCD1, either conflicts with a valid range reference or is invalid fo...
by BigFoot48
Wed Jan 11, 2017 4:40 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

So working through the first time and finding this a great since I can see what is being done :sharebeer . In testing the 17v "fix", there is still a substitution being done by Excel for QCD1 when saved to enable macros in Excel 2013. A "find" for QCD1, for the whole worksheet s...
by BigFoot48
Wed Jan 11, 2017 8:56 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

jkrm wrote:I am using Excel 2010 and saved the workbook as a .xlsm file, in case that might be the problem.

Please download this fixed version and see if you still get that error. Thanks. See below.
by BigFoot48
Wed Jan 11, 2017 8:36 am
Forum: Personal Consumer Issues
Topic: Are $50 drugstore and supermarket "drones" any fun?
Replies: 18
Views: 2098

Re: Are $50 drugstore and supermarket "drones" any fun?

I saw a sign on a neighborhood group-mailbox the other day asking if anyone had seen the drone the person had gotten for Christmas. I think one with an auto-return feature might be a good idea.
by BigFoot48
Tue Jan 10, 2017 11:17 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

I just downloaded and started to use version 17. Excel keeps popping up a box with this message: "The name, QCD1, either conflicts with a valid range reference or is invalid for Excel. The name has been replaced with _QCD1." There is a second sentence about updating manually any reference...
by BigFoot48
Sat Jan 07, 2017 5:35 pm
Forum: Personal Finance (Not Investing)
Topic: Turbo Tax 2016 purchase source
Replies: 85
Views: 10143

Re: Turbo Tax 2016 purchase source

HueyLD wrote:Bigfoot,

Did you purchase it in store or online?

I just learned that Costco.com charges 0.5% less in sales tax. :)

At the store, so add 8.1% to that $54.86!
by BigFoot48
Sat Jan 07, 2017 5:03 pm
Forum: Personal Finance (Not Investing)
Topic: Turbo Tax 2016 purchase source
Replies: 85
Views: 10143

Re: Turbo Tax 2016 purchase source

Just bought TurboTax Premier at Costco for $54.86. Having used TaxAct and H&R in the past few years I've decided to stick with TT and buy it at the first discount and not worry about what I'm paying.
by BigFoot48
Sun Jan 01, 2017 12:06 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

A new version of the Retiree Portfolio Model model is available which includes 2017 tax data and numerous minor updates. I recommend all users download it. Version 17.0 can be downloaded from Dropbox via this link: https://www.dropbox.com/s/xzawrbf773a9r02/Retiree%20Portfolio%20Model%20v17.0.xls?dl=...
by BigFoot48
Tue Dec 27, 2016 5:05 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

Is RPM still compatible with Google sheets? If so, how would I go about downloading it? I don't have Apple so I can't test it, but you should be able to download the file to your computer, then open Sheets online and use the file-import-upload menu to load it into Sheets. It will run there, a bit s...
by BigFoot48
Tue Dec 20, 2016 11:21 am
Forum: Personal Consumer Issues
Topic: Honda Pilot vs Toyota Highlander?
Replies: 61
Views: 5636

Re: Honda Pilot vs Toyota Highlander?

I bought a new Toyota Highlander last year. (Downsized from a Toyota Sequoia.) I really like the car. The only negative I have to say is the "infotainment" system in it. Toyota needs to rip their version of GPS and infotainment out by the roots and start over again. I use my phone for any...
by BigFoot48
Fri Dec 09, 2016 11:38 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

Here is an idea for your next January release. Would it be possible to add an item to Section 7. Special Events? The idea is to compare alternate investment ideas, the scenario would be along the following lines. (I understand the "Expenditures" item helps on this but I'm not sure it show...
by BigFoot48
Sun Dec 04, 2016 3:56 pm
Forum: Personal Finance (Not Investing)
Topic: Do You Consider Dividends As Income?
Replies: 65
Views: 4167

Re: Do You Consider Dividends As Income?

That means that you have made an assessment that a withdrawal rate of 3.4% of the current balance is "very safe." I wouldn't disagree that this is likely true, but I wonder on what basis you have made that assessment. My basis for assessing that statement would be to go to FireCalc, enter...
by BigFoot48
Sun Dec 04, 2016 1:53 pm
Forum: Personal Finance (Not Investing)
Topic: Do You Consider Dividends As Income?
Replies: 65
Views: 4167

Re: Do You Consider Dividends As Income?

When figuring annual income, do you include your dividends? Even when they are re-invested? This is not an income tax query. I'm just wondering if - in your mind - you factor them in. I thinking maybe in this first year of retirement and living on 2 pensions, it would make me feel 'wealthier' to in...
by BigFoot48
Sat Dec 03, 2016 9:23 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

Hi, First off, I am very impressed with the Retiree Portfolio Model. It has taken me several hours to learn to use it. I still do not fully understand it all, but I am working on it. So THANK YOU for the enormous effort you have put into this. Thank you. It has been a bunch of work, but I found all...
by BigFoot48
Wed Nov 30, 2016 6:14 pm
Forum: Personal Consumer Issues
Topic: Should I buy a new car for safety's sake?
Replies: 152
Views: 6568

Re: Should I buy a new car for safety's sake?

I'm just glad I survived driving for 10 years a 1970 VW Bus with a thin piece of sheet metal between me and eternity!
by BigFoot48
Wed Nov 30, 2016 11:53 am
Forum: Personal Consumer Issues
Topic: Should I buy a new car for safety's sake?
Replies: 152
Views: 6568

Re: Should I buy a new car for safety's sake?

I would absolutely buy a new car with as many of the advanced safety features as possible. I bought a 2005 Highlander with some of the new safety features, such as limited (won't go to a full stop) automatic braking, adaptive cruise control and rear cross-traffic alert, and would never have another ...
by BigFoot48
Sat Nov 26, 2016 6:00 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

The current version 16.3 has been updated as a result of the state tax bracket problem reported by gponym. Many thanks to him for assisting me in resolving this. The impact on the ending portfolio value for the Example data was only $2,000, or 0.01%, so I'm just updating the current version. I recom...
by BigFoot48
Sat Nov 26, 2016 8:21 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

I have found a state tax anomaly. Still using early Nov v16.3. I saw it in Full Case in normally hidden State Brackets row 204. I did not play around to see if any other rows show anomalous behavior. That is very odd. I've reviewed the calculations and don't see any problem and the example data doe...
by BigFoot48
Fri Nov 25, 2016 9:01 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

That's nice, thanks for fixing so soon. And glad you could make sense of my post, it wasn't the picture of clarity. Reading between the lines, it sounds like no great harm will come from halving the Roth 1 withdrawal starting amount in the early November v16.3. Assuming that, I'll wait to update. I...
by BigFoot48
Wed Nov 23, 2016 11:07 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

Thanks for making and sharing this great tool, BigFoot. I just got v16.3 on 11/20 from the official site. I noticed something curious while setting up my situation: The Roth 2 withdrawal appears to replicate the Roth 1 withdrawal in the Base Case worksheet. Thank you for this detailed problem repor...
by BigFoot48
Sat Nov 19, 2016 8:54 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

For federal income tax, how do I change the number of exemptions to include dependents (row # 172 on the Full Case/Base Case page)? Also, it seems that this number is always 1 regardless what I choose for Filing status (row # 174 on the Setup page). Glad you like the model! The Filing Status (Marri...
by BigFoot48
Mon Nov 14, 2016 7:01 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

Yes, it was the same protection issue, which I have now fixed on all pages. Sorry about that. If you don't want to download again, just un-protect each sheet to allow those macros to work. Or, un-protect and then re-protect and check the boxes for format cells, columns and rows.
by BigFoot48
Wed Nov 02, 2016 10:30 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

I used the macros to hide the ORP tab and Clear Entries, they both worked fine. I then tried the hide Base case and received the following error (you get the error with the Exclude Base case set to either Y or N): Any recommendations or do you think this is just a bug in Excel 2010? No, a programmi...
by BigFoot48
Mon Oct 24, 2016 6:39 pm
Forum: Personal Finance (Not Investing)
Topic: Early retirement reality check
Replies: 36
Views: 7162

Re: Early retirement reality check

Bigfoot48 , it appears that you have been working on your model and refining it for a few years now - I haven't studied it thoroughly but it's quite impressive , big file and it seems to incorporate many inputs that are relevant to retirees - kudos to you for this undertaking . However , I think it...
by BigFoot48
Sun Oct 16, 2016 4:43 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

A new version of the model, 16.3 - Oct 16, 2016 (updated Nov 26), is now available and can be downloaded from Dropbox via this link: Replaced by 17.0 Changes include: Nov 26: fixed an error in the middle State tax bracket calculation. Impacted Example data ending portfolio balance by $2,000 or 0.01%...
by BigFoot48
Thu Oct 06, 2016 3:53 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

Would it make sense to add a qualified charitable distribution parameter? That would reduce AGI and possibly taxes. Thanks I've been thinking about doing that as I see a lot of discussion about it and it's now more or less a permanent tax feature according to what I've read. I've got an update abou...
by BigFoot48
Thu Oct 06, 2016 1:11 pm
Forum: Personal Finance (Not Investing)
Topic: Early retirement reality check
Replies: 36
Views: 7162

Re: Early retirement reality check

I am assuming that my Social security benefits Will be worth less by the time I am 70, either by higher taxes, lower benefit calculations, etc. So I am not very comfortable using the Social Security benefits in my calculations. Our plan is to shoot for 4% withdrawal rate, With the understanding tha...
by BigFoot48
Wed Sep 28, 2016 7:01 pm
Forum: Personal Consumer Issues
Topic: Please recommend a new tablet
Replies: 26
Views: 2504

Re: Please recommend a new tablet

My wife really likes the look and performance of the Samsung Galaxy Tab S2 9.7" that we bought at Costco. It replaced a Nexus 10 that was having battery problems. It is above your price-point though, at $480.
by BigFoot48
Tue Sep 27, 2016 10:57 am
Forum: Personal Finance (Not Investing)
Topic: Can I make a legal last will/testament by myself?
Replies: 61
Views: 6660

Re: Can I make a legal last will/testament by myself?

I never seen an article or post that a Nolo Willmaker prepared Will was found to be invalid by a court. Anyone seen evidence of that happening?
by BigFoot48
Sun Sep 25, 2016 9:43 am
Forum: Personal Finance (Not Investing)
Topic: Best Frugal Way to Create a Will
Replies: 32
Views: 4310

Re: Best Frugal Way to Create a Will

Recently found that many states now have TRANSFER ON DEATH deeds for real estate too this is very interesting! who does one file or record such RE TOD deed with? thank you! I did such a deed when my father-in-law died and his wife became the home owner with their sole child, my wife, the ultimate b...
by BigFoot48
Thu Sep 22, 2016 4:57 pm
Forum: Personal Finance (Not Investing)
Topic: best software for financial planning
Replies: 60
Views: 8301

Re: best software for financial planning

I noticed a couple of other weird things. It told me we had too much income for aca subsides. Which might be true if we were a two person household since we are a four person family not accurate. It also says to take money out of tax deferred. We are both shy of 59 1/2? You might want to email Jame...
by BigFoot48
Thu Sep 22, 2016 8:32 am
Forum: Personal Finance (Not Investing)
Topic: best software for financial planning
Replies: 60
Views: 8301

Re: best software for financial planning

But is that how it works IRL? If someone works from ages 15 to 50 then stops working and claims SS at 70 the PIA grows for 20 years? The PIA is fixed based on the earnings history at the end of employment but does not include the annual inflation adjustments between the end of employment and starti...
by BigFoot48
Wed Sep 21, 2016 11:07 pm
Forum: Personal Finance (Not Investing)
Topic: best software for financial planning
Replies: 60
Views: 8301

Re: best software for financial planning

I put a PIA at my full retirement(67) of 17k. I would guess my yearly PIA at 70 would be more like 21k. My spouse's was also listed way too high as well The actual amount depends on the number of years between now and your PIA year, as the COLA rate entered will escalate your entered PIA amount for...
by BigFoot48
Mon Sep 19, 2016 7:19 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

LadyGeek, the 2.5% Social Security COLA I've been using in the example data comes from the average over the past 27 years, as you found out. This is also the rate the ORP model has been using but he recently reduced it and the inflation rate to the Federal Reserve target of 2% in his new "simpl...
by BigFoot48
Sun Sep 18, 2016 4:26 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

Thanks LadyGeek for all the corrections and suggestions and I concur on their benefit. I have corrected or modified all of them that you have reported through your last post. As for cell comments being blocked by graphs, I'm unaware of any with that problem but will adjust any that are reported, or ...
by BigFoot48
Sat Sep 17, 2016 3:19 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

All of the link and macro issues reported by LadyGeek and some more have been fixed in the current version 16.2. I'm glad to see that the clickable link issue that forced me to show links rather than make them clickable has gone away. The broken data validation message is likely the false positive t...
by BigFoot48
Sun Sep 11, 2016 11:40 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 288
Views: 101554

Re: Retiree Portfolio Model

Thanks LadyGeek! I will fix those in the next few weeks.
by BigFoot48
Tue Aug 30, 2016 11:52 pm
Forum: Personal Finance (Not Investing)
Topic: best software for financial planning
Replies: 60
Views: 8301

Re: best software for financial planning

In the Retiree Model Portfolio, would converting one of the IRAs (the smallest) to an annuity for modeling purposes be a reasonable work around to the single IRA conversion limitation? I tried that as an experiment, setting the annuity payments to equal the RMDs of the smallest IRA and it seemed to...
by BigFoot48
Tue Aug 30, 2016 3:59 pm
Forum: Personal Finance (Not Investing)
Topic: best software for financial planning
Replies: 60
Views: 8301

Re: best software for financial planning/ look at Retirees Model Portfolio

This must have been where I fell short previewing the Retiree's Model Portfolio... :oops: I wanted to enter different types of accounts (457/403B/) as well as many more of them. Couldn't figure an easy way to do that. Also wanted to delete the 'Inherited IRA' entries, but...? There's is a limit to ...
by BigFoot48
Fri Aug 26, 2016 11:57 am
Forum: Investing - Help with Personal Investments
Topic: Are Bogleheads Buying I-Bonds 2016?
Replies: 87
Views: 15139

Re: Are Bogleheads Buying I-Bonds 2016?

I sold the i-bonds we held in Treasury Direct last year and our Vanguard Inflation-Protected Securities fund earlier this year as I finally adopted the 3-fund portfolio. (Total Bond Fund VBMFX returns the last 5 years have been: 7.56, 4.05, -2.26, 5.76 and 0.30%) The amount of both inflation bond ho...

Go to advanced search