Go Back   iRV2 Forums > RV LIFE STYLES FORUMS > Full-Timers
Click Here to Login
Join iRV2 Today

Mission Statement: Supporting thoughtful exchange of knowledge, values and experience among RV enthusiasts.
Reply
 
Thread Tools Search this Thread Display Modes
 
Old 09-04-2016, 08:55 PM   #1
Senior Member
 
Join Date: Nov 2015
Posts: 506
Retirement planning spreadsheet

We've been planning and preparing for our retirement date (3/31/17) and wondering about a budget and whether our savings and social security will sustain us. Using the attached spreadsheet which I created, I think we will be in good shape

I thought I would share it with you all for a couple reasons. 1) I know I'm not the best and the brightest and I make logic and mathematical mistakes. If you find any, I'd appreciate a heads up. 2) I think others will find it useful for their planning as well.

The file is in .xlsx format so you will need Excel 2007 or later to use it.
The worksheet is protected to prevent inadvertent formula changes. There is no password so you can unlock it if you need to.
The cells with a green background are all editable and intended for you to enter your data.
Retirement date is used in conjunction with SS Benefits @ full Retirement to account for the reduction/increased benefits depending on whether you retire at full retirement age (assumed to be 66) or not. Spousal benefits are assumed to be a percentage of the oldest spouse.

Under the budget item section (A17102), you will need to enter a start and stop date on every item. This will allow for you to accommodate both income items (use a minus sign) and expense items with specific start/stop dates. For example, if you're planning to sell your house and expect to receive $25,000 net on 7/1/2018, there is an example of how to enter that amount included.

If someone finds this useful, that would be great. Have fun with it and I would appreciate any positive feed back or formula corrections you may have.

Roy

P.S. Well, since I can't attach a copy of the spreadsheet, if you're interested in it, PM me with an email address and I'll email you copy.
__________________

__________________
2012 Dodge C3500 DRW 4x4 Long Box, WeatherGuard 90 Gal transfer tank, B&W Companion Hitch
2012 Keystone Montana 3100RL, 520W Solar, 460AH batteries, Morningstar MPPT 45 CC, Bogart 2030RV monitor.
drdarrin is offline   Reply With Quote
Join the #1 RV Forum Today - It's Totally Free!

iRV2.com RV Community - Are you about to start a new improvement on your RV or need some help with some maintenance? Do you need advice on what products to buy? Or maybe you can give others some advice? No matter where you fit in you'll find that iRV2 is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with other RV owners, see fewer ads, upload photographs, create an RV blog, send private messages and so much, much more!

Old 09-04-2016, 09:33 PM   #2
Senior Member
 
Join Date: Nov 2015
Posts: 3,838
Debt free........

That makes all the difference

Retired when I was 50....GF retired 4 yrs later when she was 50
We FTd for 7 yrs traveling weekly seeing/exploring/enjoying the USA via secondary/back roads.

Came off the road 3 yrs ago and bought another S&B
Still debt free......THAT MAKES retirement such a none issue

Debt free also allows one to live on less.

But then I have always lived on what I had instead of living on credit.
And I always paid 'myself' each month just like a bill.
__________________

__________________
Old-Biscuit is offline   Reply With Quote
Old 09-04-2016, 09:36 PM   #3
Senior Member
 
JRPA's Avatar


 
Monaco Owners Club
Join Date: Aug 2008
Location: Las Vegas
Posts: 240
Roy
I sent a PM, looking forward to checking out that spreadsheet and seeing how it might work for us in our situation. Thanks for putting in the effort and sharing.

Bob
__________________

Bob & Pearl
2007 Monaco Camelot 42' PDQ
2013 Lincoln MKX - Roadmaster Falcon 2 - RVi brake - TireSafe Guard TPMS
JRPA is offline   Reply With Quote
Old 09-04-2016, 09:40 PM   #4
Senior Member
 
JRPA's Avatar


 
Monaco Owners Club
Join Date: Aug 2008
Location: Las Vegas
Posts: 240
No doubt that debt free is the way to go, but a budget still comes in handy assuming the check book doesn't has a unlimited balance, at least in my case it comes in right handy.
__________________

Bob & Pearl
2007 Monaco Camelot 42' PDQ
2013 Lincoln MKX - Roadmaster Falcon 2 - RVi brake - TireSafe Guard TPMS
JRPA is offline   Reply With Quote
Old 09-04-2016, 10:30 PM   #5
Senior Member
 
Barbaraok's Avatar
 
Alpine Owners Club
Join Date: Sep 2005
Location: Traveling in North America
Posts: 1,432
Everyone will have different items that they track. For instance, we have a line item in our budget for wine. We're in Sonoma Valley right now - we spend the month of September in CA stocking up our wine for the winter.

One of the things that has made life easier for us was to take quarter/semi-annual/annual costs and literately but aside each month enough so when the item came due, the money was there to pay for it.
__________________
Barbara & David O'Keeffe
Figment II (Alpine 2002 36 MDDS)
On The Road since 2006
Blog
Barbaraok is offline   Reply With Quote
Old 09-05-2016, 05:59 AM   #6
Senior Member


 
Join Date: Feb 2013
Posts: 502
Drdarrin, Sent you a pm too.
Thanks
__________________
bevandtomH is offline   Reply With Quote
Old 09-05-2016, 07:58 AM   #7
Senior Member
 
narampa's Avatar
 
Triple E Owners Club
Ford Super Duty Owner
Join Date: Apr 2013
Posts: 995
Quote:
Originally Posted by Old-Biscuit View Post
Debt free........

That makes all the difference

Retired when I was 50....GF retired 4 yrs later when she was 50
We FTd for 7 yrs traveling weekly seeing/exploring/enjoying the USA via secondary/back roads.

Came off the road 3 yrs ago and bought another S&B
Still debt free......THAT MAKES retirement such a none issue

Debt free also allows one to live on less.

But then I have always lived on what I had instead of living on credit.
And I always paid 'myself' each month just like a bill.
I agree!
Also if you even have to think of the cost of fuel you are not ready.
__________________
narampa is offline   Reply With Quote
Old 09-05-2016, 08:21 AM   #8
Senior Member
 
Join Date: Nov 2015
Posts: 506
Quote:
Originally Posted by Old-Biscuit View Post
Debt free........

That makes all the difference

Retired when I was 50....GF retired 4 yrs later when she was 50
We FTd for 7 yrs traveling weekly seeing/exploring/enjoying the USA via secondary/back roads.

Came off the road 3 yrs ago and bought another S&B
Still debt free......THAT MAKES retirement such a none issue

Debt free also allows one to live on less.

But then I have always lived on what I had instead of living on credit.
And I always paid 'myself' each month just like a bill.
Sadly, not everyone is debt free, myself included. And there is also the opportunity cost to consider. Can I make more on that money that it costs me to finance it? When interest rates are as low as they are right now and have been for the past several years, it would actually cost me more to pay cash for a rig than to finance it. As interest rates begin to ratchet up, that equation changes.

Quote:
Originally Posted by Barbaraok View Post
Everyone will have different items that they track. For instance, we have a line item in our budget for wine. We're in Sonoma Valley right now - we spend the month of September in CA stocking up our wine for the winter.

One of the things that has made life easier for us was to take quarter/semi-annual/annual costs and literately but aside each month enough so when the item came due, the money was there to pay for it.
One of the problems I struggled with was I knew there would be items, such as needing a new tow vehicle, that I'd have to budget for for a specific period of time, not for life. So I added a begin and end date to budget items so that they affect the budget only between those two dates. Every budget item has it's own set of dates.

Oh, and I suggest you try the wines of El Dorado and Amador county as well. We have been enjoying them for the past 18 years.
__________________
2012 Dodge C3500 DRW 4x4 Long Box, WeatherGuard 90 Gal transfer tank, B&W Companion Hitch
2012 Keystone Montana 3100RL, 520W Solar, 460AH batteries, Morningstar MPPT 45 CC, Bogart 2030RV monitor.
drdarrin is offline   Reply With Quote
Old 09-05-2016, 08:36 AM   #9
Senior Member
 
vsheetz's Avatar


 
Fleetwood Owners Club
Ford Super Duty Owner
Join Date: Jun 2012
Location: SoCal
Posts: 11,490
We are just moving from saving into spending. I retired a couple months ago and DW does so at the end of the year. We are fortunate to be debt free - a goal we have worked towards and attained several years ago.

We have done the budget estimations. Plan to set aside money each month towards the quarterly/annual expenses. And have reduced various expenses considerably, and will continue to work to do so the more.

Keeping a appropriate emergency fund readily available has always been a biggie, and continues.

Delaying drawing social security till the most appropriate time is in the plan, balanced with consuming cash on hand until that time.

I am finding planning for the nearer term 'go-go' years less challenging than the later years, as the further out in time the crystal ball become less clear. (-:
__________________
Vince and Susan
2011 Tiffin Phaeton 40QTH (Cummins ISC/Freightliner)
Flat towing a modified 2005 Jeep (Rubicon Wrangler)
Previously a 2002 Fleetwood Pace Arrow 37A and a 1995 Safari Trek 2830.
vsheetz is offline   Reply With Quote
Old 09-05-2016, 09:11 AM   #10
Senior Member
 
Barbaraok's Avatar
 
Alpine Owners Club
Join Date: Sep 2005
Location: Traveling in North America
Posts: 1,432
Quote:
Originally Posted by vsheetz View Post

Delaying drawing social security till the most appropriate time is in the plan, balanced with consuming cash on hand until that time.

I am finding planning for the nearer term 'go-go' years less challenging than the later years, as the further out in time the crystal ball become less clear. (-:
We thought about doing that, but that would have meant withdrawing money from IRAs/401Ks. You can't leave your SS to your kids, but you can leave your IRAs to them. So we took the SS and the tax deferred accts are working away - - we've now reached the point of having to take money out (RMDs), so just deposit it into a tax acct with same managers (Vanguard). Don't forget long term care insurance.
__________________
Barbara & David O'Keeffe
Figment II (Alpine 2002 36 MDDS)
On The Road since 2006
Blog
Barbaraok is offline   Reply With Quote
Old 09-05-2016, 09:25 AM   #11
Senior Member
 
RVThere's Avatar
 
Freightliner Owners Club
Join Date: Aug 2008
Location: Florida Keys
Posts: 2,160
One aspect of retirement planning you should keep in mind is a 'sensitivity' analysis.

Pick a few 'what if' scenarios and see if you can still 'stay retired' under those situations. Suppose you miscalculated your expenses and they're really 2x what you put down in this spreadsheet? What if your retirement benefits are cut due to a loss of spouse? What if those lifetime health benefits are cut and you have to supplement with your own insurance?

I retired when I was 52 so, as my investment adviser keeps reminding me, 'your money has to last 40 years'. It's always good to get an opinion from a professional retirement adviser who has far more sophisticated tools at his disposal and can show you various tax and debt strategies that will help you succeed in your retirement. That way they can watch your money and investments while you enjoy your retirement.

As a previous poster said, 'debt free' may not be the best situation for all with low interest rates. Many times its better to have the cash on hand and use "OPM" or "Other People's Money"!
__________________
Tom and Katharine
'07 Winnebago Tour 40TD, 400hp Cummins
'17 Winnebago View 24V, '02 R-Vision B+
RVing for 19 years & 150,000+ miles
RVThere is offline   Reply With Quote
Old 09-05-2016, 09:46 AM   #12
Senior Member
 
vsheetz's Avatar


 
Fleetwood Owners Club
Ford Super Duty Owner
Join Date: Jun 2012
Location: SoCal
Posts: 11,490
Quote:
Originally Posted by Barbaraok View Post
We thought about doing that, but that would have meant withdrawing money from IRAs/401Ks. You can't leave your SS to your kids, but you can leave your IRAs to them. So we took the SS and the tax deferred accts are working away - - we've now reached the point of having to take money out (RMDs), so just deposit it into a tax acct with same managers (Vanguard). Don't forget long term care insurance.
Good points. We won't use tax deferred accounts to bridge to SS. For us doing the financial and life expectancy numbers seems delaying SS is best plan at this point. Agree, long term care insurance needs to be considered. It's expensive and the earlier one starts can be a good thing.
__________________
Vince and Susan
2011 Tiffin Phaeton 40QTH (Cummins ISC/Freightliner)
Flat towing a modified 2005 Jeep (Rubicon Wrangler)
Previously a 2002 Fleetwood Pace Arrow 37A and a 1995 Safari Trek 2830.
vsheetz is offline   Reply With Quote
Old 09-06-2016, 04:49 PM   #13
Senior Member
 
Join Date: Jul 2015
Posts: 165
First off I want to say thanks to drdarrin for the time you took to put together a planning tool and then share with everyone.


Second I want to thank everyone for the conversation on retirement planning. It makes the rest of us who have not retired to relook at our plan to see if it needs adjustments.
__________________
Dave & Brenda
2007 Chevy 2500 Duramax
2012 Sabre 31 RETS 5'er
h20ski is offline   Reply With Quote
Old 09-06-2016, 04:54 PM   #14
Senior Member
 
Join Date: Nov 2015
Posts: 506
You're welcome for the sheet.

I've gotten some what if ideas from the discussion as well.
__________________

__________________
2012 Dodge C3500 DRW 4x4 Long Box, WeatherGuard 90 Gal transfer tank, B&W Companion Hitch
2012 Keystone Montana 3100RL, 520W Solar, 460AH batteries, Morningstar MPPT 45 CC, Bogart 2030RV monitor.
drdarrin is offline   Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintenance Schedule spreadsheet tnrzryd Spartan Motorhome Chassis Forum 24 09-07-2014 05:18 PM
Cost Comparison Spreadsheet jmab Full-Timers 11 08-17-2014 03:20 PM
Weight Distribution Spreadsheet Calculator davidgeminde Trailer Towing and Tow Vehicles Discussion 1 05-31-2014 08:37 AM
Helpful spreadsheet for solar system sizing Pianotuna Going Green 4 02-26-2013 02:42 PM
Need an ISL Maintenance Spreadsheet Lukeaa Monaco Owner's Forum 14 07-24-2008 11:50 AM

» Virginia Campgrounds

Reviews provided by


Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -6. The time now is 08:29 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.