Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Old 07-20-2021, 10:35 AM   #81
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
REWahoo's Avatar
 
Join Date: Jun 2002
Location: Texas: No Country for Old Men
Posts: 49,012
Quote:
Originally Posted by BlueberryPie View Post
For those who monitor several time a day/week, what do you do with that "information"?
Nothing.
__________________
Numbers is hard

The key to understanding human behavior is realizing half the population is below average.
REWahoo is offline   Reply With Quote
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!

Old 07-20-2021, 10:39 AM   #82
Full time employment: Posting here.
 
Join Date: Mar 2014
Location: Dallas
Posts: 963
Quote:
Originally Posted by Lagniappe View Post
I download all of my transactions from Personal Capital monthly. I download as a csv file, open in Excel, then run a pivot table summing the amount spent by category.Each months worth of transactions becomes a sheet in my master excel spreadsheet, so I can go back and find any transaction I need, or analyze in any way I please. It's super simple, and takes about 3 minutes per month.
I have been doing this with the Bank of America's "My Portfolio" since 2007 so I have the raw transaction data for over 14 years! I have another google sheet where I enter Networth from "My Portfolio" every month. I manually calculated Networth in an excel sheet since 2001. Seeing how the money flows and grows from the early age (20s) has helped me immensely to build up the Networth.
pjigar is offline   Reply With Quote
Old 07-20-2021, 10:46 AM   #83
Full time employment: Posting here.
 
Join Date: Mar 2014
Location: Dallas
Posts: 963
Quote:
Originally Posted by BlueberryPie View Post
For those who monitor several time a day/week, what do you do with that "information"?
The Networth data: Mostly nothing, other than eye ball the log chart of Networth and see if we are on the right trajectory. Graph also kind shows when can we reach the finish line.

The transaction data pivot tables: Helps me keep tabs on spending. If we see a category spending go out of line for a few months then I drill down and see what we have been spending on. We don't necessarily have a budget but this kind of analysis feedback has helped us keep the personal inflation down compared to income "inflation" over the longer term. Which IMHO is the key of rapid build up of our Networth. YMMV.
pjigar is offline   Reply With Quote
Old 07-20-2021, 11:03 AM   #84
Recycles dryer sheets
 
Join Date: Jun 2013
Posts: 253
Quote:
Originally Posted by BlueberryPie View Post
For those who monitor several time a day/week, what do you do with that "information"?
My NW swings by thousands every day, I was done $35K from my monthly high yesterday, made up $12K today, who knows tomorrow...
Tracking closely means that I won't be shocked or surprised at the end of the quarter. All yesterday's action did for my model was shave off a chunk of the current overage between where I am and where my long-term model says I should be and still be on track. My year-end projection didn't change at all, and I didn't need to rebalance at all, but I would have if I'd needed to. I do expect to pay less attention to it when I am in withdrawal.
HenryD is offline   Reply With Quote
Old 07-20-2021, 01:54 PM   #85
Thinks s/he gets paid by the post
 
Join Date: Jun 2021
Posts: 1,048
Quote:
Originally Posted by BlueberryPie View Post
For those who monitor several time a day/week, what do you do with that "information"?
My NW swings by thousands every day, I was done $35K from my monthly high yesterday, made up $12K today, who knows tomorrow...

I'd be worried that by looking too often I would worry about normal swing, or even the advent of a bear market and let emotions/fear take over, even you don't sell or change anything, will you sleep better or worse?
Nothing. It is just something that I do each day, or at least try to do each day. When the market goes significantly down, it confirms why we diversify, with some of our money in deferred income annuities. Technically, we can get by just with our SS and annuities. We do have about 35% of our budget as discretionary spending, and RMD funds that. We don't manage our own money which separates investment decisions from emotions or knee jerk reactions to the market. Having a money manager is definitely right for us.
RetiredHappy is offline   Reply With Quote
Old 07-20-2021, 02:34 PM   #86
Thinks s/he gets paid by the post
 
Join Date: Dec 2014
Location: St. Charles
Posts: 3,312
Quote:
Originally Posted by REWahoo View Post
Nothing.
Quote:
Originally Posted by RetiredHappy View Post
Nothing.
Another vote for nothing.
__________________
If your not living on the edge, you're taking up too much space.
Never slow down, never grow old!
CardsFan is offline   Reply With Quote
Old 07-20-2021, 02:55 PM   #87
gone traveling
 
Join Date: Apr 2021
Posts: 74
Quote:
Originally Posted by CardsFan View Post
Another vote for nothing.
Same here, nothing.

I take my blood pressure a lot too but I don't necessarily do something as a result of seeing the readings.
beernutzbob is offline   Reply With Quote
Old 07-20-2021, 03:16 PM   #88
Thinks s/he gets paid by the post
 
Join Date: Dec 2014
Location: St. Charles
Posts: 3,312
Quote:
Originally Posted by beernutzbob View Post
Same here, nothing.

I take my blood pressure a lot too but I don't necessarily do something as a result of seeing the readings.
Well, that one I might pay attention to, if it keeps going up.
__________________
If your not living on the edge, you're taking up too much space.
Never slow down, never grow old!
CardsFan is offline   Reply With Quote
Old 07-20-2021, 03:43 PM   #89
Thinks s/he gets paid by the post
 
Join Date: Jun 2021
Posts: 1,048
Quote:
Originally Posted by CardsFan View Post
Well, that one I might pay attention to, if it keeps going up.
RetiredHappy is offline   Reply With Quote
Old 07-20-2021, 06:17 PM   #90
Recycles dryer sheets
 
Join Date: Feb 2021
Posts: 150
Exactly nothing. So why do you look exactly?
BlueberryPie is offline   Reply With Quote
Old 07-20-2021, 06:23 PM   #91
Thinks s/he gets paid by the post
 
Join Date: Dec 2014
Location: St. Charles
Posts: 3,312
Quote:
Originally Posted by BlueberryPie View Post
Exactly nothing. So why do you look exactly?
Entertainment?

Seriously it is to keep me aware of the ups and downs, so that I DON'T take action. I don't record anything daily, I just compare one day to the next, realizing that on a big day we could lose, or gain, more than a year's spending, BUT:

It Just Doesn't matter:

__________________
If your not living on the edge, you're taking up too much space.
Never slow down, never grow old!
CardsFan is offline   Reply With Quote
Old 07-23-2021, 09:58 PM   #92
Full time employment: Posting here.
teetee's Avatar
 
Join Date: Jul 2019
Posts: 635
Quote:
Originally Posted by BlueberryPie View Post
For those who monitor several time a day/week, what do you do with that "information"?
My NW swings by thousands every day, I was done $35K from my monthly high yesterday, made up $12K today, who knows tomorrow...

I'd be worried that by looking too often I would worry about normal swing, or even the advent of a bear market and let emotions/fear take over, even you don't sell or change anything, will you sleep better or worse?

I like to track my budget/spending throughout the month, but avoid looking too closely at NW.
My monthly NW gain figures go into building a nw gain vs month curve chart with linear regression line to indicate how good this year's forecast is based on exiting months performance.

It is probably a waste of time but I feel calm whenever I see the end-of-year nw projection.

Imagine when the daily NW change is in the range of millions. It takes time to practice on not caring about the market fluctuation.
teetee is offline   Reply With Quote
Old 08-01-2021, 05:16 AM   #93
Dryer sheet wannabe
 
Join Date: Dec 2016
Posts: 11
I have been tracking my NW on Quicken since 1987. I find it interesting and motivating. In 2015 I started using Personal Capital too. I look at it monthly but there are times that I donít look for many months. My dad got me started when I graduated college in 1986, he was an engineer and did everything on spread sheets.
Floridaman10 is offline   Reply With Quote
Old 08-01-2021, 12:29 PM   #94
Recycles dryer sheets
 
Join Date: Mar 2019
Location: Gloucester
Posts: 50
Quote:
Originally Posted by BlueberryPie View Post
Exactly nothing. So why do you look exactly?
Being an accountant, I guess it's in the DNA. Been doing it for years. The charts created from the data were good for tracking the ups and downs of the market swings. Seeing the declines from the Great Recession and following the recovery, validates that if you don't panic and sell, you will reap the rewards of staying the course. Same with last year's temporary meltdown.

I keep two NW numbers one with, one without house value based on assessed value. No real reason, just do.

Like others, I like being able to find any purchase at a moments notice using Quicken. How much did we actually spend on that gym project anyway? Oh, here it is...$XX. Works for us and will keep it up until it doesn't anymore.
Retire2023 is offline   Reply With Quote
Tracking Net Worth and Compound Interest Calculating
Old 08-03-2021, 06:39 PM   #95
Recycles dryer sheets
 
Join Date: Aug 2016
Location: Austin
Posts: 179
Tracking Net Worth and Compound Interest Calculating

Quote:
Let's be clear on the net worth calculation.

Net worth = all assets - all liabilities. Excluding assets (like RE) or liabilities (like mortgage debt) is not a net worth calculation. Net worth and owner's equity are synonymous. Fudging the calculation by picking out this or that is simply fudging.

Agree. Not sure why anyone would not include their home value in the calculation, especially if it's securing a mortgage. Real estate owned, whether lived in or rented out, is an asset--and one that can be reasonably marked to market. It's called an appraisal. Short of that one can also estimate $/SF by looking on Redfin at recent sold houses in the neighborhood.
Austin704 is offline   Reply With Quote
Old 08-04-2021, 01:04 PM   #96
Dryer sheet aficionado
 
Join Date: Jul 2018
Posts: 28
Quote:
Originally Posted by Austin704 View Post
Agree. Not sure why anyone would not include their home value in the calculation, especially if it's securing a mortgage. Real estate owned, whether lived in or rented out, is an asset--and one that can be reasonably marked to market. It's called an appraisal. Short of that one can also estimate $/SF by looking on Redfin at recent sold houses in the neighborhood.
Technically you're correct that net worth is defined as all assets less all liabilities, however, for most folks on this forum I believe the intent is to reflect net assets that can be used towards funding retirement. For most people, a house will not provide funding towards retirement. Of course you'll say there are some that will downsize and use the excess proceeds but I think that is more the exception than the norm. Using your technically defined term, I guess you would also include value of car, laptops, furniture, or anything that you could sell on ebay/craigslist? The other issue (at least for me) in including the value of a house is the volatility of it's value especially in current times. Seems to artificially inflate net worth for me.

I know this is a bit of a hotly debated topic on this forum and it seems like the compromise I've seen is to differentiate between net worth and investable assets. But again, I think most people tend to simply reference net worth, excluding RE, because of the intent of the metric in this forum.
Eastfolk is offline   Reply With Quote
Old 08-04-2021, 01:24 PM   #97
Thinks s/he gets paid by the post
mpeirce's Avatar
 
Join Date: Feb 2012
Location: Northern Ohio
Posts: 2,848
Quote:
Originally Posted by Eastfolk View Post
Technically you're correct…
I simply keep track of both numbers. I have items in my spreadsheet for total net worth and financial net worth. I like to know both.

It’s not really important to me what the words are since the only person I ever discuss this with is my DW. We both know what the terms refer to.
mpeirce is offline   Reply With Quote
Old 08-04-2021, 03:49 PM   #98
Recycles dryer sheets
 
Join Date: Feb 2021
Posts: 150
Stocks are volatile too, so hard to argue that volatility is a criterion on what to count.

But I'm in the camp of tracking investable assets separately from true NW and I would count it as a "windfall" if i sold my house on a profit. I don't use it to gauge retirement readiness, just like i don't count on inheritance or the like. I am fully aware that it's very subjective, i probably take other things for granted (like some amount of social security) than are no better guarantee.

And I do count my emergency fund in investable assets even though I have no plan to invest it further...

It's not like it's an exact science
BlueberryPie is offline   Reply With Quote
Old 08-14-2021, 07:56 PM   #99
Thinks s/he gets paid by the post
 
Join Date: Aug 2013
Posts: 1,550
I use to look at Total Networth frequently. Once I got beyond Seven figures, not much. Since I'm staying in my house for quiet some time, it didn't even feel real that my home value increased by around $130K-$150K in the last few months due to the housing price appreciation.

I shifted to monitoring my liquid investments, which excludes the house, cars, and all material assets. I also shifted to monitoring my mortgage (my only debt) and focus on reducing that debt.
__________________
No to consumerism, Living a simple life, enjoying the experience - not the material stuff
cyber888 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
Is compound interest stronger than the Force? CaliforniaBlues FIRE and Money 17 01-03-2020 02:39 PM
help! compound interest! Illinois guy Young Dreamers 12 06-26-2017 06:04 AM
Compound Interest Calculators that adjust for COL? CompoundInterestFan FIRE and Money 2 07-03-2007 06:28 PM
 Compound Interest Formula!  : ( Tommy_Dolitte Young Dreamers 5 09-13-2004 01:18 PM

» Quick Links

 
All times are GMT -6. The time now is 04:14 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2022, vBulletin Solutions, Inc.