Search found 2654 matches

by BigFoot48
Wed Apr 17, 2019 8:39 am
Forum: Personal Consumer Issues
Topic: Considering an e bike or conversion kit
Replies: 20
Views: 897

Re: Considering an e bike or conversion kit

I bought a $600 Hill Topper conversion kit 4 years ago for the wife's Electra Townie bike to help her keep up with me. It was a 15-minute job to install, replacing the front wheel with one with a motor in the hub and strapping on the battery and on/off switch. It has a 10 mile range but with only te...
by BigFoot48
Tue Apr 16, 2019 10:53 am
Forum: Personal Investments
Topic: How often do you check up on your investments?
Replies: 35
Views: 2086

Re: How often do you check up on your investments?

I look at and record in Microsoft Money all changes in the portfolio from the monthly Schwab statements, but otherwise ignore it. However..... I have my three-fund portfolio set up in Morningstar to allow a quick look at approximate balances and have been looking more often recently because after 20...
by BigFoot48
Sun Apr 14, 2019 8:13 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

Yes. Perhaps this will be helpful. As you can see the other accounts are growing normally while the taxable account goes negative immediately. Sorry the columns don't line up well I'll suspect you don't have enough income or withdrawals from your IRAs to keep the taxable account positive. I'll send...
by BigFoot48
Sun Apr 14, 2019 7:43 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

Have you put your current taxable account and IRA balances and current age in? You might also examine the example data that comes with the model for what data a typical user might input.

Those rates are the Fed tax rates and I don't think not relevant to your problem.
by BigFoot48
Sat Apr 13, 2019 8:14 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

Can someone explain why: RPM is telling me I have "Alert! Portfolio has negative beginning yr balances in one or more accounts for 39 years" messages? In the first section, are you supposed to put the current year, or the year you expect to retire? If the later, you would then have to guess as to f...
by BigFoot48
Thu Apr 11, 2019 8:24 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

Question on how RPM calculates the WITHDRAWAL RATE: The Withdrawal Rate is shown on the Results page. The Taxable Account income is being adjusted by the taxable account adjustment factor set on the Setup page, not the tax rate. So the withdrawal rate calculation is including the portion of the tax...
by BigFoot48
Sat Mar 30, 2019 4:19 pm
Forum: Personal Consumer Issues
Topic: [What TV Show Have You Recently Watched?]
Replies: 1224
Views: 122041

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

Kingdom on Netflix is a Korean vampire series set in ancient times. What sets it apart is that there is not one or two vampires, but villages of them. Entertaining and sub-titled.
by BigFoot48
Tue Mar 19, 2019 9:02 am
Forum: Personal Consumer Issues
Topic: Visiting Tucson, AZ for 3 days - what to see?
Replies: 46
Views: 1665

Re: Visiting Tucson, AZ for 3 days - what to see?

We're planning to visit Tucson, too... I like telescope stuff and have already booked an evening at Kitt Peak. My wife doesn't particularly like telescope stuff and likes ethnography stuff. At the University of Arizona is there an obvious place near the mirror lab that she could visit while I visit...
by BigFoot48
Mon Mar 18, 2019 11:36 pm
Forum: Personal Consumer Issues
Topic: Visiting Tucson, AZ for 3 days - what to see?
Replies: 46
Views: 1665

Re: Visiting Tucson, AZ for 3 days - what to see?

stuyguy wrote:
Mon Mar 18, 2019 8:51 pm
It's indoors, but a tour of the telescope mirror lab on UA campus is fascinating

https://mirrorlab.arizona.edu/content/tours-tickets
Highly recommended. A world-class facility.
by BigFoot48
Mon Mar 18, 2019 1:26 pm
Forum: Personal Consumer Issues
Topic: Visiting Tucson, AZ for 3 days - what to see?
Replies: 46
Views: 1665

Re: Visiting Tucson, AZ for 3 days - what to see?

I live outside Tucson and concur with many of the recommendations, but not visiting Phoenix or Sedona unless you have a week. I've also never had a cracked windshield due to the lousy streets or seen a dust storm in Tucson like they get up in Phoenix. Suggestions: Arizona-Sonora Desert museum Sabino...
by BigFoot48
Fri Mar 08, 2019 10:23 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

sawdust60 wrote:
Fri Mar 08, 2019 10:19 pm

Can you tell me how non-taxable SS impacts Medicare premiums?
https://www.everycrsreport.com/reports/ ... f529460434
by BigFoot48
Fri Mar 08, 2019 6:28 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

Hi, I'm trying to use the model to help me understand the trade off between taking LT capital gains in my trading account versus rolling IRA to Roth. I've retired early and am funding that through my taxable trading account until I start receiving a pension at 65 and SS at 70. The model has helped ...
by BigFoot48
Thu Mar 07, 2019 10:50 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

to be a 2-year lag for IRMAA? You might check the formula for Medicare MAGI; I don't think it should include untaxed SS income. I have updated the model v19.1 for both of your suggestions. The non-taxable SS income impacts two Medicare premium calculations, but not the surcharge item as I now know....
by BigFoot48
Wed Mar 06, 2019 4:56 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

sawdust60 wrote:
Wed Mar 06, 2019 4:34 pm
Doesn't the change in filing status also need to be a 2-year lag for IRMAA?

You might check the formula for Medicare MAGI; I don't think it should include untaxed SS income.
Thanks for reporting those items. I will check it out.
by BigFoot48
Mon Mar 04, 2019 10:39 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

Good timing, as someone just emailed bogleheads.org support* stating that version 19 has a 404 message. The person is not a member, but is using version 15.1 and wanted to upgrade. * See: About Us | Bogleheads Investing Advice and Info or Forum Policies (Section 1.). Apologizes to all. I have been ...
by BigFoot48
Fri Mar 01, 2019 8:01 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

BTW, I made the change and saw my Base plan was much better than the Roth Conv plan. Then realized I had to make the change to the Base tab as well as Detail! Can you please explain further? If you change the inputs, don't they change both the base and detail tabs? What did you change that affected...
by BigFoot48
Fri Mar 01, 2019 7:55 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

Version 19.1 of the Retiree Portfolio Model model is available as of March 1, 2019 and can be downloaded from Dropbox via this link: https://www.dropbox.com/s/9tmifm3lznlefg0/Retiree%20Portfolio%20Model%20v19.1.xlsm?dl=0 Current version updates: March 10: Fixed ACA calculation to still include non-t...
by BigFoot48
Thu Feb 28, 2019 11:42 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

I see I was looking at the move age comparison wrong. However, I still think the formula is incorrect. In the example data if you change the State_Move_Age and Pen_Tax_State2 to zero, you'll see it no longer calculates a value for Pension 1 income taxable in state. If I add a move age like 99, then...
by BigFoot48
Thu Feb 28, 2019 7:23 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

I think there may be an error in the calculation of state taxable income for pensions. I live in MA and noticed that my pension income in the future was not being included in state taxable income. Here is the formula for cell j207: =ROUND(IF(AND(State_Move_Age>J$4,State_Move_Age<>0),Pen_Tax_State*J...
by BigFoot48
Sun Feb 24, 2019 10:03 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

I have a question about how to enter a tIRA balance that has a 16% after-tax basis. Section 2 asks for the current tIRA balance. Is there a way to adjust this balance entry to account for the after-tax basis in the tIRA? One thought I had was to just reduce the tIRA amount entered into Section 2 by...
by BigFoot48
Sun Feb 24, 2019 3:05 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

Where does RPM allow one to list ongoing Roth contributions akin to the lines for IRA contributions? My apologies if this has already been answered, I couldn't find answer by searching. There's no provision for additional Roth contributions, but I believe you could use the one of the Roth 1 withdra...
by BigFoot48
Fri Feb 22, 2019 7:53 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

Has anyone found an easy way to view cell comments that get obscured by graphs (and other things)? They are not obscured in the Excel version, thus the positioning of the graphs and sizing of the comments. I don't see a solution to this and don't have a Mac for testing. I would recommend using an a...
by BigFoot48
Sun Feb 17, 2019 12:45 am
Forum: Personal Consumer Issues
Topic: [What TV Show Have You Recently Watched?]
Replies: 1224
Views: 122041

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

American Vandal on Netflix is very funny and well-done.
by BigFoot48
Tue Feb 12, 2019 9:59 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

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 ...
by BigFoot48
Mon Feb 11, 2019 2:27 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

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 cel...
by BigFoot48
Mon Feb 11, 2019 11:18 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

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 wit...
by BigFoot48
Mon Feb 11, 2019 11:03 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

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 Re...
by BigFoot48
Mon Feb 11, 2019 9:01 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

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...
by BigFoot48
Mon Feb 11, 2019 8:38 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

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 fact...
by BigFoot48
Tue Feb 05, 2019 7:48 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

so, if there isn't enough taxable income generated, to cover the choice of expenses/year, then (even for a 55 year old), the model is going to pull money from the traditional IRA 1st ? ; I can't quite follow, what "negative balances" is being referred to, or what is the goal ? I would think that re...
by BigFoot48
Mon Feb 04, 2019 1:23 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

I've run across a difference between the Details and Base case. In the latter, the formula in cell AS205 has the extra term "-AS169". That doesn't appear to be intentional... Thanks Removed. Thanks. Only impacted the year 40 state income tax calculation. I ran the example data on a 40 year period a...
by BigFoot48
Sun Feb 03, 2019 4:08 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

However, I can't follow the language eg what are the "manual withdrawals entered" ? It seems to be saying that it is going to take extra IRA withdrawals (beyond my RMDs) to cover inadequate taxable Earnings from growth, dividends and interest ? In my case I have only Inherited IRA RMDs and don't pl...
by BigFoot48
Sun Feb 03, 2019 7:55 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

re: 1) the problem is there is a mix of EE & I Bonds, with varying interest rates, and as I understand it, these rates are not fixed , I am about 20 years into their 30 life, so 10 years further, and as I understand it , it would be a wild guess to predict their Final Interest lump sum amount.........
by BigFoot48
Sat Feb 02, 2019 12:29 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

1) If you are taking the savings bond interest as a lump when you redeem the bonds, do this: Enter the principle as Tax Exempt on the SETUP sheet. etc etc Thanks for providing that information to another user, it's accurate and should be a very helpful. All users of RPM should understand that it's ...
by BigFoot48
Tue Jan 29, 2019 5:51 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

Boggedown wrote:
Tue Jan 29, 2019 5:42 pm
A couple issues with the Setup sheet Sec. 10 operation. Neither affects the results.
Thanks very much. I will address all those problems in the next release, coming soon, and see about adding a simple Roth conversion benefit to heirs analysis to the Results page.
by BigFoot48
Sat Jan 26, 2019 12:25 pm
Forum: Personal Finance (Not Investing)
Topic: No Children, what will your legacy be?
Replies: 118
Views: 8838

Re: No Children, what will your legacy be?

No kids. Plan to leave most of the estate to the Nature Conservancy, that does good works preserving land for public use in the US and around the world. We've also been giving to a local wild animal rescue organization and they may get on the list. Then there's one or two kids of our friends that ha...
by BigFoot48
Wed Jan 23, 2019 4:51 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

Sadly, something is seriously dodgy about that WPS software, both in Windows and Linux they don't use https for their downloads, and even if you agree to allow the http download it fails ..... Is there any hope that the RPM might work in LibreOffice someday ....... I'm not really sure how to purcha...
by BigFoot48
Wed Jan 23, 2019 4:44 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

I do have several comments / suggestions on the current release: Thanks for those suggestions and corrections to the alert message in Sec 1 and the cell message on the Tax page. I'll fix all those and implement the title improvements and think I can add a state tax total to the Federal recap area.
by BigFoot48
Tue Jan 22, 2019 1:39 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Retiree Portfolio Model

I checked all the versions of Windows spreadsheet programs and here's the current status, in order of best to worse cell comment etc. viewing. Viewing of these comments is critical to using the program the first time. Excel 2003-2016 - best program. If using 2003 the 2007 format xlsm will open and w...
by BigFoot48
Mon Jan 21, 2019 6:07 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

Re: Question about Special Expenditures

I just wanted to confirm that my following assumption is correct. In the setup page there are only two cells for special expenditures. I want to model a few more. Can I just add them to the RESULTS tab, Line #15: Special Expenditures and Donations? If that is correct do I need to do anything else a...
by BigFoot48
Sat Jan 19, 2019 9:26 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 658
Views: 201176

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

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: 856
Views: 50253

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: 658
Views: 201176

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: 658
Views: 201176

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: 658
Views: 201176

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: 658
Views: 201176

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: 658
Views: 201176

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: 658
Views: 201176

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: 658
Views: 201176

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...