Search found 2697 matches

by BigFoot48
Sun Aug 18, 2019 8:31 am
Forum: Personal Finance (Not Investing)
Topic: Writing Checks on a Schwab IRA
Replies: 25
Views: 2983

Re: Writing Checks on a Schwab IRA

I assume that the only way Schwab knows you wrote a check (QCD or not) is from the presentation for payment to their bank. Therefore, I would try to get all checks issued by Thanksgiving and specify to the charities that you want them to cash the check within a week or so. If the charity misplaces ...
by BigFoot48
Sat Aug 17, 2019 6:26 pm
Forum: Personal Finance (Not Investing)
Topic: Writing Checks on a Schwab IRA
Replies: 25
Views: 2983

Re: Writing Checks on a Schwab IRA

I received Schwab checks on my IRA account today. I activated the service via an online menu on the Schwab website about a week ago. The menu provided a downloadable signature "card" which, when signed and the appropriate IRA account number added, is copied (I took a picture) and uploaded to Schwab....
by BigFoot48
Tue Jul 30, 2019 6:58 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

You can use the "User input income, credit and adjustments", line 191, on the Details page, to enter amounts to increase taxable income from selling those stocks. The amounts entered will become part of AGI so you will need to estimate how much to enter that will result in the calculated bracket tax...
by BigFoot48
Mon Jul 22, 2019 7:31 pm
Forum: Personal Investments
Topic: ORP and RPM recommend large mega Roth's from IRA
Replies: 44
Views: 2646

Re: ORP and RPM recommend large mega Roth's from IRA

Thank the forum for all the discussion. It has helped me find one flaw in my i-ORP and RPM set up. I had set Roth accounts to have 100% stock. And other accounts to have a lower stock / bond ratio. The intent would be to continuously rebalance to stay at my overall target 70/30 stock / bond ration....
by BigFoot48
Mon Jul 22, 2019 12:06 pm
Forum: Investing - Theory, News & General
Topic: Mathematical model of Roth conversion [error] (does not suggest more is better)
Replies: 50
Views: 4740

Re: Mathematical model of Roth conversion suggests more is better.

Thanks. Any idea how the model considers the implied tax liability of the IRA balance at death? It would be instructive if there was an estimated marginal tax rate for beneficiaries and a bequest preference parameter such that the ending account balance would fall at death by such an amount (much a...
by BigFoot48
Wed Jul 17, 2019 11:18 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Adding "head of household" filing status to RPM

I will be filing taxes as "head of household" in early retirement. How difficult would it be to add this option to the spreadsheet? I intend to look at doing it myself if it is feasible no-one has already started. Guessing it may be complicated by the need to use two different tax filing statuses o...
by BigFoot48
Tue Jul 16, 2019 7:40 pm
Forum: Personal Consumer Issues
Topic: Windows 10 - May 2019 Update (1903)
Replies: 44
Views: 4090

Re: Windows 10 - May 2019 Update (1903)

I installed 1903 today and it wiped out my D: partition where I keep all my data. The partition had to be reformatted to be made usable, now I have to reload it from my daily backups. Very disturbed and dismayed by this Window update. A Google search reveals this is a problem dating back to at least...
by BigFoot48
Mon Jun 24, 2019 9:24 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

Duplicate
by BigFoot48
Mon Jun 24, 2019 9:23 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

Nice tool, I'm just learning how to use it, so please bear with me. I noticed that if I change a value on the Setup tab, such as the size of the taxable account, that the Results Summary box on the top of the display update for the Current Results, but not for the three columns to the right of it, ...
by BigFoot48
Thu Jun 13, 2019 4:45 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

Good question. You need to combine the IRAs into IRA 1, which is the only one used for conversions.

The account balances entry titles have cell notes that include:
IRA 1: Note: All Roth conversions come out of this IRA.
IRA 2: Note: No Roth conversions are made from this IRA.
by BigFoot48
Wed Jun 12, 2019 7:25 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

Is it possible to write a script that will look at every cell, and if the cell contains a comment, to copy the comment to a specified sheet, along with the comment cell ID in an adjacent column? So it would create a long listing having 2 columns, which could be printed out or looked at. Possibly. H...
by BigFoot48
Tue Jun 11, 2019 5:05 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

Since this is not state taxable income whatever I enter on Details (181) , I should enter as a negative number on Details #211 ?? This is the cell comment for "user input" in State Income Tax, line 211: Enter yearly amounts to adjust the model's AGI calculation for factors not included in the model...
by BigFoot48
Tue Jun 11, 2019 8:29 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

Thank you for your rapid response and comments. Since I posted, and before I saw your response, I downloaded the latest version and: SUCCESS! The light blue navigation buttons work, at least some of them do, such as "go to top"; and all the graphs show all 30 bars. I can see some comments, such as ...
by BigFoot48
Tue Jun 11, 2019 7:47 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

My first question: is there an organized help file, or an optimal way to troubleshoot problems short of reading all 731 posts? If there is, a link to it in the first post would be helpful (maybe it is there and I just missed it). Now as to what has me perplexed at the moment: 1) none of the buttons...
by BigFoot48
Wed Jun 05, 2019 4:14 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

stvyreb wrote:
Wed Jun 05, 2019 4:12 pm
Did you mean Section 7 E176 'age when event occurs' not section 8 ?
Yes, 7 Special Events.
by BigFoot48
Wed Jun 05, 2019 3:40 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

so if one is carrying over capital losses, say $3000/year do they just subtract that from E205 "net growth" and how do I account for Inherited IRA RMDs in Section 8. or should I be ? Capital Losses are not provided for in the model. Inherited IRAs are in Section 7. so the Inherited IRA RMD income I...
by BigFoot48
Wed Jun 05, 2019 2:25 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

stvyreb wrote:
Wed Jun 05, 2019 1:38 pm
so if one is carrying over capital losses, say $3000/year do they just subtract that from E205 "net growth"

and how do I account for Inherited IRA RMDs in Section 8. or should I be ?
Capital Losses are not provided for in the model. Inherited IRAs are in Section 7.
by BigFoot48
Tue Jun 04, 2019 8:17 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

I started with 19.1 and truly love your spreadsheet. It is useful and elegant. My question is how do you handle the migration to a new version? I have invested a lot of time in data input and I was wondering what happens in the future when you create a new version? The original way was to load both...
by BigFoot48
Tue Jun 04, 2019 6:46 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

The Taxable Account Earnings Adjustment is in "8. Income Taxes" and explained there, assuming you can read the popups. It is a user-supplied adjustment to taxable account earnings. You might also try the Show All Comments setting in Review and see if that helps. thanks but may I ask where I "suppli...
by BigFoot48
Tue Jun 04, 2019 6:36 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

The Taxable Account Earnings Adjustment is in "8. Income Taxes" and explained there, assuming you can read the popups. It is a user-supplied adjustment to taxable account earnings.

You might also try the Show All Comments setting in Review and see if that helps.
by BigFoot48
Tue Jun 04, 2019 5:49 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

*is there any way to just get a word document with the LONGER popups , even if the cell isn't referenced ?? Not at this time but I will consider it for 2020. or some way to cut&paste them myself I prefer to not be forced to use a popup to digest the instructions if possible. The Zoom setting in the...
by BigFoot48
Sun Jun 02, 2019 9:27 am
Forum: Personal Consumer Issues
Topic: Windows 10 - May 2019 Update (1903)
Replies: 44
Views: 4090

Re: Windows 10 - May 2019 Update (1903)

Oops, nevermind..... sorry mom Having recently promised Windows 10 users full control over updates with its major 1903 upgrade, Microsoft has now walked that back and it is Windows 10 Home users (who account for the lion’s share of the OSes 800M-strong userbase) who are hit hardest. CNet breaks down...
by BigFoot48
Fri May 31, 2019 6:57 pm
Forum: Personal Consumer Issues
Topic: Windows 10 - May 2019 Update (1903)
Replies: 44
Views: 4090

Re: Windows 10 - May 2019 Update (1903)

Microsoft last month announced a new Windows 10 policy that seems to fix the worst thing about Windows updates in general. The company decided to finally let you choose when or even if you want to install the latest Windows 10 version, So glad to hear they are doing this as my 92YO MIL really doesn...
by BigFoot48
Wed May 29, 2019 10:18 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

I use Format Rounding, not the Round Function because of cumulative nature of projecting out 30yrs. I agree it makes no difference to a ROM estimate. Today the primary purpose of my research is to determine optimum IRA to Roth conversion profile. Thanks again. I hope the model proves useful in your...
by BigFoot48
Tue May 28, 2019 12:50 pm
Forum: Personal Finance (Not Investing)
Topic: Moving to a Continuing Care Retirement Community
Replies: 24
Views: 1877

Re: Moving to a Continuing Care Retirement Community

You may also want to consider a company that does "estate sales" to get rid of all your stuff that you won't be taking. I see a lot of these sales in the Sun City's outside of Phoenix. One day in our neighborhood we saw one and went in to inquire what happened to the couple that lived there. Turned ...
by BigFoot48
Tue May 28, 2019 8:35 am
Forum: Personal Consumer Issues
Topic: [What TV Show Have You Recently Watched?]
Replies: 1374
Views: 143130

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

The Hot Zone, now showing on Nat Geo based based on an actual Ebola event, is very good, and as scary as the book was.

EDIT: Later episodes were boring with lots of family filler stuff. Should have been edited to about 3 hours.
by BigFoot48
Tue May 28, 2019 8:13 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

FutureEyee: 1. Rounding is user select-able. Forecasts 30 years out can show amounts to the dollar if someone thinks that adds to accuracy or understanding. The reality is that after carefully entering all the balances, factors and choices, virtually every calculation and result will be wrong from w...
by BigFoot48
Tue May 21, 2019 8:13 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model - UPDATE RELEASE

Version 19.1a of the Retiree Portfolio Model model is available as of May 21, 2019 and can be downloaded from Dropbox via this link: https://www.dropbox.com/s/9qrmgww1di1xkuj/Retiree%20Portfolio%20Model%20v19.1a.xlsm?dl=0 This update fixes a formula error in Base case Roth IRA 1 automatic withdrawal...
by BigFoot48
Mon May 20, 2019 8:45 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

RangeleyLake, I'm glad you're finding the model useful and even more glad you found a problem AND solved it! Yes, those formulas should be identical in the Full and Base calculations, but in doing a recent modification the Full formulas for that line didn't get copied over. I will fix that and updat...
by BigFoot48
Fri May 10, 2019 11:29 pm
Forum: Personal Finance (Not Investing)
Topic: Cash - Throw it all on the table!!!
Replies: 150
Views: 24922

Re: Cash - Throw it on the table!

I tend to be a bit lazy about properly managing my money market accounts and noticed at the end of last month they represented about 3.8% of my portfolio, or some two years of spending needs (over SS income). I'd like that to be more like one year so one of these days I'm going to get that invested...
by BigFoot48
Thu May 09, 2019 2:08 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

How do I weigh this out to make a decision? Perhaps not convert since Portfolio is better off not converting? But yet with Roth, the Roth balance is worth more than an IRA balance (taxes owed). Sorry if this question was answered before. Those simple comparisons and convert conclusions are just som...
by BigFoot48
Thu May 09, 2019 11:38 am
Forum: Personal Finance (Not Investing)
Topic: If/When Should I make a trust?
Replies: 27
Views: 2648

Re: If/When Should I make a trust?

The "Beyond the Grave" book is available on Amazon for Kindles for $1.99.
by BigFoot48
Mon May 06, 2019 1:06 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

Many thanks to the Mac RPM users who provided information to BH catalina355 on which Mac products to use to best run the model. I will make sure the Readme page has this formation for future Mac users.
by BigFoot48
Wed Apr 24, 2019 1:36 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

I encourage you to test the numbers in the model and see the results at the top of the Details page Year 1 start: $100,000, end $107,000 Year 2 start: $107,000, end $114,500 Year 3 start: $114,500, end $122,500 Start balance + additions - expenditures = preliminary end balance (Start balance + preli...
by BigFoot48
Wed Apr 24, 2019 10:40 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

Yes, the return rate set for each account type is applied to the average account balance for the year, year after year. So chose a rate appropriate for a long period. Some historic results are provided in the cell comments to help.
by BigFoot48
Mon Apr 22, 2019 3:51 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Program is dipping into my ROTH account Day 1

My issue is I have a large 401k, and two large Roth IRAs along with a small Tax investment. I am married. My problem is the logic seems to be sourcing my income from the 401k (good, what I am doing now) along with my pension and a small amount from my Roth IRA (bad). I checked the option to draw fi...
by BigFoot48
Mon Apr 22, 2019 7:17 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

What is the reason why FRA_You_Alt is hard-coded as 66 and not equal to +FRA_You? I can unprotect and change but was wondering what your rationale was for hard-coding the value. Just to save the user some work. The FRA is the FRA and its already been entered. In my case, I enter 67 for FRA_You. FRA...
by BigFoot48
Mon Apr 22, 2019 1:11 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

808 wrote:
Sun Apr 21, 2019 11:12 pm
What is the reason why FRA_You_Alt is hard-coded as 66 and not equal to +FRA_You?

I can unprotect and change but was wondering what your rationale was for hard-coding the value.
Just to save the user some work. The FRA is the FRA and its already been entered. OOPS: wrong, see below
by BigFoot48
Sun Apr 21, 2019 10:09 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

Bigfoot, can you give me some hints on the best way to enter the data for my situation? I can't seem to quite get there. I'm a widow. My husband died at 55, so his SS (and mine) hadn't started yet. I now have the inherited IRA (which I can access now, albeit as income, but without penalty), my 401k...
by BigFoot48
Sat Apr 20, 2019 9:33 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

this model is incredible, bigfoot. I've looked at it several times in the past, but was always scared off by the complexity. But over the past two weekends, I've been diligently plugging and playing. Wow, just wow. Thanks a bunch. btw: obviously, we all download the spreadsheet and run it locally. ...
by BigFoot48
Sat Apr 20, 2019 7:10 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

Version 19.1 has been updated today for a calculation error on the Summary page, found and reported by an anonymous user. The Portfolio Balance at Year End on the Summary page was not being calculated correctly (expenses were added rather than subtracted due to not being fixed when expenses were cha...
by BigFoot48
Sat Apr 20, 2019 8:21 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

Thanks for that explanation. My question(s) is how to interpret the results in RPM vs a MC simulator like Flexible Retirement Planner which gives future results in current dollars and applies an expected (i.e. projected) inflation rate (with an input for standard deviation). So, the question is how...
by BigFoot48
Sat Apr 20, 2019 8:01 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 756
Views: 226751

Re: Retiree Portfolio Model

Can someone point me to where the expected rates of inflation are entered in RPM for investments ? I see that there is a field to adjust inflation in Section 5. Income . Does that number also apply to the entire model? In other words are the percentages in Sec 3 Return Rates and Allocations real ra...
by BigFoot48
Wed Apr 17, 2019 8:39 am
Forum: Personal Consumer Issues
Topic: Considering an e bike or conversion kit
Replies: 20
Views: 1079

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

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: 756
Views: 226751

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: 756
Views: 226751

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: 756
Views: 226751

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: 756
Views: 226751

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: 1374
Views: 143130

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.