|
|
09-25-2012, 07:26 AM
|
#61
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: May 2005
Location: Lawn chair in Texas
Posts: 14,183
|
Have a google spreadsheet that tracks investments more or less in real time. Also have the rebalance bands entered, so don't do anything until something is outside the band (though I have been known to tweak my allocation based on my bunion/Ouija board/Magic Eight Ball...)
Adjust once a month or so for dividend reinvestment.
__________________
Have Funds, Will Retire
...not doing anything of true substance...
|
|
|
|
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!
Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org 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 our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!
|
09-25-2012, 07:35 AM
|
#62
|
gone traveling
Join Date: Apr 2009
Location: Eastern PA
Posts: 3,851
|
Quote:
Originally Posted by militaryman
So how do I value those when doing a networth estimate?
|
Many have different opinions on this point, but as for me/DW? We don't calculate any income stream of having any value unless it can be "passed on" until we are both gone.
For instance, my VA disability, my DW's two small pension plans, our respective SS are all calculated at $0.
However, our joint life SPIA does have value that will be passed on to our estate if we both die before the age of 78 (our joint life calculation).
BTW, we carry all "personal property" (cars, funiture, odds & ends, etc.) as zero worth as far as considering gross estate net worth.
Just the way we look at it.
|
|
|
09-25-2012, 07:43 AM
|
#63
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jul 2006
Posts: 11,401
|
I use an Excel spreadsheet to calculate net worth and do some graphs, scenario building and sensitivity analysis once a year, on March 31st. When there have been major changes In my personal circumstances I may do it halfway through the fiscal year, but never more often. During 2008 it would have been just too painful!
|
|
|
09-25-2012, 07:46 AM
|
#64
|
Recycles dryer sheets
Join Date: Jun 2007
Location: Oklahoma City
Posts: 338
|
Quote:
Originally Posted by rescueme
Many have different opinions on this point, but as for me/DW? We don't calculate any income stream of having any value unless it can be "passed on" until we are both gone.
For instance, my VA disability, my DW's two small pension plans, our respective SS are all calculated at $0.
However, our joint life SPIA does have value that will be passed on to our estate if we both die before the age of 78 (our joint life calculation).
BTW, we carry all "personal property" (cars, funiture, odds & ends, etc.) as zero worth as far as considering gross estate net worth.
Just the way we look at it.
|
^^^^^ That's what I figured most folks do also ....
Therefore someone who indicates they have a networth of $0 or a negative networth is not necessarily indicative at all of the standard of living they will be able to have in retirement, i guess.
I can lose all my investment $$ right before retirement and , i guess technically have a networth of zero, yet my pensions/annuity/ss should allow the DW and I to gross > $4,000 per month.
__________________
USAF Veteran -- Retired Air National Guard -- OSW -- ONW -- OIF
|
|
|
09-25-2012, 07:47 AM
|
#65
|
Recycles dryer sheets
Join Date: Jan 2008
Posts: 277
|
I was obliged to calculate net worth each time we applied for a mortgage, which was 4 times in the past 30 years.
|
|
|
09-25-2012, 08:14 AM
|
#66
|
Thinks s/he gets paid by the post
Join Date: Jun 2010
Posts: 2,301
|
Quote:
Originally Posted by militaryman
Therefore someone who indicates they have a networth of $0 or a negative networth is not necessarily indicative at all of the standard of living they will be able to have in retirement, i guess.
|
I guess it depends on how you want to use the networth value. For comparing to others, you could compute the present value (using some estimate for inflation) of the pension payments assuming an average lifetime. Or you could take the pension payment and figure out an equivalent "lump sum" using a 4% rate. Obviously all very approximate.
|
|
|
09-25-2012, 08:50 AM
|
#67
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: May 2009
Posts: 9,343
|
Quote:
Originally Posted by photoguy
I guess it depends on how you want to use the networth value. For comparing to others, you could compute the present value (using some estimate for inflation) of the pension payments assuming an average lifetime. Or you could take the pension payment and figure out an equivalent "lump sum" using a 4% rate. Obviously all very approximate.
|
I only tally up assets that have any worth if I drop dead. I guess it's all in ones perspective. To me, in my retirement it is only about cash flow since I have a generous pension, I consider myself "red neck rich". To my daughter if I dropped dead today, she would bemoan the fact of how poor I was.
|
|
|
09-25-2012, 08:50 AM
|
#68
|
Thinks s/he gets paid by the post
Join Date: Dec 2010
Location: USA
Posts: 1,050
|
I have a general idea based on monthly income/expenses.
Some elect not to include real estate, but I include rental real estate (value minus any liability/selling cost). I also am aware of the NW number including personal real estate, but don't factor that in my FI number.
|
|
|
09-25-2012, 08:55 AM
|
#69
|
Thinks s/he gets paid by the post
Join Date: Mar 2007
Posts: 1,860
|
I do mine about once a quarter, and round off to the nearest $10,000. Accuracy is important, but precision is not. Someday I'm hoping I have enough to round to the nearest $100,000.
__________________
"Live every day as if it were your last, and one day you'll be right" - unknown
|
|
|
09-25-2012, 09:59 AM
|
#70
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2007
Posts: 7,746
|
I update my "Quarterly Financial Statements" spreadsheet on a quarterly basis. Which reminds me, this weekend is time for another update that will probably show huge NW increases vs June 30 2012.
I also update a "portfolio analysis" spreadsheet 1-2x a month. This is my rebalancing spreadsheet that calculates which slices of the asset allocation are most out of balance, and that is where I direct new contributions, or if the percentages are way out of balance I'll do some buying and selling to get everything close to the target percentages.
__________________
Retired in 2013 at age 33. Keeping busy reading, blogging, relaxing, gaming, and enjoying the outdoors with my wife and 3 kids (8, 13, and 15).
|
|
|
09-25-2012, 10:05 AM
|
#71
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2007
Posts: 14,328
|
I used to have a guy working for me that did it every morning over coffee, manually, on a spread sheet. Couldn't get any work out of him for the first couple of hours a day.
|
|
|
09-25-2012, 10:12 AM
|
#72
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: May 2006
Location: west coast, hi there!
Posts: 8,809
|
Have been tracking in Excel for many years now. One tab per year. Reasons for tracking weekly are:
1) Rebalancing when equities go above our max percentage. I just sell 1%.
2) Knowing how many months of spending we have left. Sell short bonds if more needed.
3) Seeing our overall strategy on one sheet. This sheet is linked to an allocation sheet.
4) Every quarter recently I have benched marked our portfolio against a simple indexed portfolio and also against a portfolio that includes Vanguard Wellington.
5) Seeing how we are doing versus the inflation adjusted starting retirement liquid (no real estate) net worth.
|
|
|
09-25-2012, 01:27 PM
|
#73
|
Thinks s/he gets paid by the post
Join Date: Jul 2011
Posts: 1,289
|
I'm a Yodlee user too and really like it. Everything I need is tracked on the site daily
|
|
|
09-25-2012, 01:40 PM
|
#74
|
Thinks s/he gets paid by the post
Join Date: Jun 2004
Location: No. California
Posts: 1,858
|
Once a month on the first, using a spreadsheet. I only count cash, bank and investment accounts.
|
|
|
09-26-2012, 05:15 AM
|
#75
|
Recycles dryer sheets
Join Date: Apr 2007
Posts: 410
|
I have a master FI spreadsheet that I have been using to track net worth, expenses and other random financial data since July 2002. I set it up when I was at one of my high points of frustration at my previous job -- my mom was going in for open heart surgery and my boss gave me a hard time about taking time off to be with her and help during her recovery. One of those "who needs this job thing..." kind of moments.
I have been tracking networth figures consistently on a monthly basis since then. I use yodlee to consolidate and track account figures automatically. In September 2008, I added a daily networth sheet, which I update every morning over coffee (5 in the morning here means the markets just closed in NYC). I think I started it the MOnday after Lehman collapsed, mostly just to see what happened. It was indeed scary to watch all those red figures lining up and the balance going down, but eventually things started to go back up again. Now I have a nice little rollercoaster journey to follow. We are currently at a peak, which may turn into another trough. Seeing the historical data helps me stay the course and keep buying things when they are on sale - I have good evidence if the wisdom of that approach. Besides, what else are you going to do with your US$? They are losing value in China anyway, so we might as well keep them invested primarily in the US markets.
|
|
|
09-26-2012, 09:27 AM
|
#76
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jan 2007
Location: New Orleans
Posts: 47,500
|
I just timed myself when manually checking my portfolio balance and bank account this morning, manually entering everything into my spreadsheet, and adding it up. This included Vanguard, TSP, and bank account (net worth as I understand it to be defined by David1961 in the first post of this thread).
It took 3 minutes, and that included figuring out why my bank balance had changed and entering that expenditure into the spreadsheet, as well. Luckily, as a retiree I can afford to spend 3 minutes over coffee doing something that I like to do.
__________________
Already we are boldly launched upon the deep; but soon we shall be lost in its unshored, harbourless immensities. - - H. Melville, 1851.
Happily retired since 2009, at age 61. Best years of my life by far!
|
|
|
09-26-2012, 09:40 AM
|
#77
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Mar 2007
Posts: 14,328
|
Quote:
Originally Posted by W2R
..........It took 3 minutes...........
|
Oh sure, but you don't have as many coins as I do.
|
|
|
09-26-2012, 09:47 AM
|
#78
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jan 2007
Location: New Orleans
Posts: 47,500
|
__________________
Already we are boldly launched upon the deep; but soon we shall be lost in its unshored, harbourless immensities. - - H. Melville, 1851.
Happily retired since 2009, at age 61. Best years of my life by far!
|
|
|
09-26-2012, 10:00 AM
|
#79
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Nov 2010
Location: Sarasota, FL & Vermont
Posts: 36,370
|
Quote:
Originally Posted by W2R
I just timed myself when manually checking my portfolio balance and bank account this morning, manually entering everything into my spreadsheet, and adding it up. This included Vanguard, TSP, and bank account (net worth as I understand it to be defined by David1961 in the first post of this thread).
It took 3 minutes, and that included figuring out why my bank balance had changed and entering that expenditure into the spreadsheet, as well. Luckily, as a retiree I can afford to spend 3 minutes over coffee doing something that I like to do.
|
For me it is just a couple clicks in Quicken to select "One Step Update" and type in my One Step Update password and accept any transactions of the day. EZ
|
|
|
09-26-2012, 10:02 AM
|
#80
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Jan 2007
Location: New Orleans
Posts: 47,500
|
Quote:
Originally Posted by pb4uski
For me it is just a couple clicks in Quicken to select "One Step Update" and type in my One Step Update password. EZ
|
Yeah, and when a person can do it with 2 clicks with Quicken, or probably even faster (and cheaper) manually as I described, I don't really know why they use "no time" as a reason not to compute net worth more frequently. I suspect that they really don't feel any driving curiousity about it, which is OK too.
__________________
Already we are boldly launched upon the deep; but soon we shall be lost in its unshored, harbourless immensities. - - H. Melville, 1851.
Happily retired since 2009, at age 61. Best years of my life by far!
|
|
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|