Search found 13 matches

by Zephavest
Sat Jun 24, 2017 9:00 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

Re: Retiree Portfolio Model

Hi BigFoot, Thank you so much for the fast reply as usual. I pulled the trigger in April and retired. I'm just now having time to get back to some serious planning for my retirement cash flow in detail. Yours is the only tool I've found to give me the insight of the details to instill confidence in ...
by Zephavest
Sat Jun 24, 2017 8:13 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

Re: Retiree Portfolio Model

Hello Big Foot, I just downloaded both versions this morning, I got this error in the 17b version, 17 was fine. This happened when selecting the "Clear" sheet function. Microsoft Run-Time error '1004' The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the ...
by Zephavest
Thu Apr 20, 2017 6:20 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

Re: Retiree Portfolio Model

Speaking of which, a very smart Boglehead has been working on a macro that transfers all the setup entries from an older version to a new version, eliminating this tedious effort. It works like a charm and it will be included in the next release, whenever that happens. This is great to hear, THANK ...
by Zephavest
Fri Jan 06, 2017 9:13 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

Re: Retiree Portfolio Model

Why is all this work more useful than Firecalc? Do state and property taxes really make that much of a difference? I've not tried Firecalc but to answer your question about state and property taxes, I'll give you two examples: California Personal Income Tax Rate (my current state): m Take 10% as th...
by Zephavest
Sun Jan 01, 2017 7:12 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

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. A happy and prosperous new year to all! HI Bigfoot, Happy New year to you as well, thank you so much for all your continued hard work on RPM. I...
by Zephavest
Fri Dec 09, 2016 11:49 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

Re: Retiree Portfolio Model

I suggest using the existing Asset Sales and Expenditures section to model this by assuming a net home purchase and eventual sale, recording the result, then changing to a different set of entries and comparing that result. Keep in mind that each of the four events provided for here can be either c...
by Zephavest
Fri Dec 09, 2016 10:49 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

Re: Retiree Portfolio Model

Hi Bigfoot, I figured out how to avoid any state tax issues, we are moving to Texas when I retire next year, where there is 0% income taxes, but they still get you on your property tax, oh well. Here is an idea for your next January release. Would it be possible to add an item to Section 7. Special ...
by Zephavest
Mon Nov 14, 2016 7:26 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

Re: Retiree Portfolio Model

Great, thank you for the workaround and the fast fix.
by Zephavest
Mon Nov 14, 2016 6:33 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

Re: Retiree Portfolio Model

Hi BigFoot, I found another feature for you, on the Full Case, Base Case and Comparison tabs, when using the Detail Rows (Show/Hide) function. I'm getting the same Pop-up box: Microsoft Visual Basic "Run-time error '1004':" "Unable to set the Hidden property of the Range class" M...
by Zephavest
Wed Nov 02, 2016 11:14 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

Re: Retiree Portfolio Model

Wow, that was fast, thank you so much, working fine now.
by Zephavest
Wed Nov 02, 2016 9:49 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

Re: Retiree Portfolio Model

Hi BigFoot, Thank you for the great new features and improvements in v16.3. I wanted to let you know of an anomaly I found. I downloaded and went to setup v16.3 Oct 16, 2016. I'm using Excel 2010. I used the macros to hide the ORP tab and Clear Entries, they both worked fine. I then tried the hide B...
by Zephavest
Wed Aug 03, 2016 9:11 am
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

Re: Retiree Portfolio Model

I just hope you used both your own models and many other sources in making your early-retirement decision, as we must always remember this wisdom: "the data is not a future reality, just a mathematical construct". Best of luck! Hi Bigfoot, Excellent advice, thank you, I completely underst...
by Zephavest
Tue Aug 02, 2016 2:37 pm
Forum: Personal Finance (Not Investing)
Topic: Retiree Portfolio Model
Replies: 338
Views: 130511

Re: Retiree Portfolio Model

Hello Bigfoot, I would like to join the chorus in thanking you for an absolutely amazing piece of work in Excel!!! I'm a long time Excel user myself and find the things you have been able to do in Excel take it to a whole new level. After using multiple tools, including my own Excel spreadsheet, it ...