Money Investing megathread extravaganza - Page 3

**DaFace** · 06:35 PM

A place to talk about investing stuff.

Amnorix · 06-27-2016, 02:16 PM

I may have posted this before, but I wanted to pass along this tip about one of the better things I have ever done in terms of my overall financial planning and processes.

I track, on a monthly basis, my net worth. I do it the stupidest, old fashioned'est way you can imagine -- by plugging the numbers into a spreadsheet. Now there are apps for that, of course. Early on in life, when you have one or two bank accounts, it's not remotely necessary, but once you're older, and you have a spouse, and you have a 401(k) and the rollover IRA and your wife's rollover IRA and the defined contribution benefit fund and a house with a value offset by a mortgage, blah, blah, blah, it gets a bit more challenging to track it all.

So I have everything in a spreadsheet, and early every month I just update all the figures. For home value I use assessed value (usually a conservative number) and plug in the mortgage balance to offset. All the accounts are updated by month end statement figures, etc.

It has really helped me track everything that we have, and SEE the growth over time, which is very encouraging. Of course, you have to have the stomach to just plug in the numbers and avoid vomiting when years like 2008 come around, but then you can see exactly when you got back to where you were, and be like "hey, for the end of the ****ing world, that didn't take too long to recover from".

Anyway, I've found it useful for managing my financial life. Once you get the hang of it, updating the spreadsheet takes like half an hour a month. Not a big deal at all.

scorpio · 06-27-2016, 03:29 PM

Quote:

Originally Posted by Amnorix

I may have posted this before, but I wanted to pass along this tip about one of the better things I have ever done in terms of my overall financial planning and processes.

I track, on a monthly basis, my net worth. I do it the stupidest, old fashioned'est way you can imagine -- by plugging the numbers into a spreadsheet. Now there are apps for that, of course. Early on in life, when you have one or two bank accounts, it's not remotely necessary, but once you're older, and you have a spouse, and you have a 401(k) and the rollover IRA and your wife's rollover IRA and the defined contribution benefit fund and a house with a value offset by a mortgage, blah, blah, blah, it gets a bit more challenging to track it all.

So I have everything in a spreadsheet, and early every month I just update all the figures. For home value I use assessed value (usually a conservative number) and plug in the mortgage balance to offset. All the accounts are updated by month end statement figures, etc.

It has really helped me track everything that we have, and SEE the growth over time, which is very encouraging. Of course, you have to have the stomach to just plug in the numbers and avoid vomiting when years like 2008 come around, but then you can see exactly when you got back to where you were, and be like "hey, for the end of the ****ing world, that didn't take too long to recover from".

Anyway, I've found it useful for managing my financial life. Once you get the hang of it, updating the spreadsheet takes like half an hour a month. Not a big deal at all.

Just curious, do you count anything toward your net worth other than financial accounts and your house?

**Rain Man** · 06-27-2016, 04:34 PM

At various points in time I've calculated my net worth, but very infrequently so I never had timeline figures. I really wish I'd done what amnorix is doing. I should start now.

eDave · 06-27-2016, 04:35 PM

Quote:

Originally Posted by Rain Man

At various points in time I've calculated my net worth, but very infrequently so I never had timeline figures. I really wish I'd done what amnorix is doing. I should start now.

I'm pretty obsessed with my spreadsheet.

**Rain Man** · 06-27-2016, 04:40 PM

Quote:

Originally Posted by eDave

I'm pretty obsessed with my spreadsheet.

Man, everyone has a spreadsheet but me.

I would only use a spreadsheet for this stuff. I'm too paranoid to use any kind of online tool to summarize everything I've got. I have nightmares of some Moldovan hacker wiping me out.

eDave · 06-27-2016, 04:44 PM

Quote:

Originally Posted by Rain Man

Man, everyone has a spreadsheet but me.

I would only use a spreadsheet for this stuff. I'm too paranoid to use any kind of online tool to summarize everything I've got. I have nightmares of some Moldovan hacker wiping me out.

You can find plenty of templates out there. Some basic, some pretty granular.

**lewdog** · 06-27-2016, 05:10 PM

I have a monthly budget spreadsheet and investment spreadsheet. Add in the equity from the mortgage and net worth is easy to calculate.

I love my spreadsheets.

**lewdog** · 06-27-2016, 05:19 PM

Investment tip I have recently learned. Please correct me if I have anything wrong. I can't wait to see some tips from some of you. I love talking about investing and savings/life goals.

Roth IRA tip. A Roth IRA is only for those not making Dane money. A Roth IRA investment account can actually be fairly liquid. Much advice that I have currently been reading is talking about funneling as much money (max hopefully $5,500/year) to your Roth IRA account over dumping extra money into a savings account and earning nothing. This is of course after you have built an emergency fund of 3-6 months. The caveat of doing this is that as long as the Roth IRA has been open for 5+ years, you can withdrawn your contributions at any time, tax free and with no penalties. Meaning that if I have contributed $20k to my Roth over 7 years, and it's currently worth $25k, I am allowed to withdraw up to $20k without penalty. Is this ideal, no. But in a sense, it acts as a second emergency fund as well. And an emergency fund with actual chance to grow unlike a savings account. The money would take at most a few weeks to get to you from my understanding. Easily in the window to pay for a major emergency. Withdrawing money from a 401k should be a last resort for most as the penalties caused by this are not worth it unless it's your last option.

**SAUTO** · 06-27-2016, 05:21 PM

I have a safe room l where I take my cash and roll around in it.
Edit: I go in and make it rain on the on the wife every chance I get

**LoneWolf** · 06-27-2016, 05:26 PM

Quote:

Originally Posted by JASONSAUTO

I have a safe room l where I take my cash and roll around in it.
Edit: I go in and make it rain on the on the wife every chance I get

R8RFAN · 06-27-2016, 05:30 PM

I have 150k cash
I have about 250k in my 401k
My house and cars are paid for

I am 100% debt free

That's my portfolio , Not glamorous but I am happy

**LoneWolf** · 06-27-2016, 05:30 PM

I haven't looked at any of our investment accounts since last Thursday. I don't want to see the losses and make a bad decision out of panic. I'll just ride it out. If I was 62 instead of 43, I'd be worried.

I'm a big believer in index funds with a long-term approach. Just keep putting money into them and forget about it.

**LoneWolf** · 06-27-2016, 05:31 PM

Quote:

Originally Posted by R8RFAN

I have 150k cash
I have about 250k in my 401k
My house and cars are paid for

I am 100% debt free

That's my portfolio , Not glamorous but I am happy

Pretty stupid to keep that much cash on hand. Make that money work for you.

R8RFAN · 06-27-2016, 05:33 PM

Quote:

Originally Posted by LoneWolf

Pretty stupid to keep that much cash on hand. Make that money work for you.

Ok ... gimme something safe to drop 10k in tomorrow

**LoneWolf** · 06-27-2016, 05:36 PM

Quote:

Originally Posted by R8RFAN

Ok ... gimme something safe to drop 10k in tomorrow

Something earning 1% interest is better than putting it underneath your mattress.

06-27-2016, 11:23 AM
DaFace Kind of a mod Join Date: Aug 2005 Location: Donkey Land Casino cash: $176899	Investing megathread extravaganza A place to talk about investing stuff. Last edited by DaFace; 02-19-2021 at 06:35 PM..
Posts: 52,495

06-27-2016, 02:16 PM	#31
Amnorix In BB I trust Join Date: May 2003 Location: Boston, Mass. Casino cash: $10029808	I may have posted this before, but I wanted to pass along this tip about one of the better things I have ever done in terms of my overall financial planning and processes. I track, on a monthly basis, my net worth. I do it the stupidest, old fashioned'est way you can imagine -- by plugging the numbers into a spreadsheet. Now there are apps for that, of course. Early on in life, when you have one or two bank accounts, it's not remotely necessary, but once you're older, and you have a spouse, and you have a 401(k) and the rollover IRA and your wife's rollover IRA and the defined contribution benefit fund and a house with a value offset by a mortgage, blah, blah, blah, it gets a bit more challenging to track it all. So I have everything in a spreadsheet, and early every month I just update all the figures. For home value I use assessed value (usually a conservative number) and plug in the mortgage balance to offset. All the accounts are updated by month end statement figures, etc. It has really helped me track everything that we have, and SEE the growth over time, which is very encouraging. Of course, you have to have the stomach to just plug in the numbers and avoid vomiting when years like 2008 come around, but then you can see exactly when you got back to where you were, and be like "hey, for the end of the ****ing world, that didn't take too long to recover from". Anyway, I've found it useful for managing my financial life. Once you get the hang of it, updating the spreadsheet takes like half an hour a month. Not a big deal at all. __________________ "I love signature blocks on the Internet. I get to put whatever the hell I want in quotes, pick a pretend author, and bang, it's like he really said it." George Washington
Posts: 43,125

06-27-2016, 04:34 PM	#33
Rain Man Seize life. Be an ermine. Join Date: Jul 2001 Location: My house Casino cash: $1468491 VARSITY	At various points in time I've calculated my net worth, but very infrequently so I never had timeline figures. I really wish I'd done what amnorix is doing. I should start now. __________________ Active fan of the greatest team in NFL history.
Posts: 143,119

06-27-2016, 05:10 PM	#37
lewdog Mod Team Join Date: Sep 2011 Location: Valley of the hot as **** Casino cash: $81900	I have a monthly budget spreadsheet and investment spreadsheet. Add in the equity from the mortgage and net worth is easy to calculate. I love my spreadsheets. __________________ 2024 Royals game thread record 3-0
Posts: 46,133

06-27-2016, 05:19 PM	#38
lewdog Mod Team Join Date: Sep 2011 Location: Valley of the hot as **** Casino cash: $81900	Investment tip I have recently learned. Please correct me if I have anything wrong. I can't wait to see some tips from some of you. I love talking about investing and savings/life goals. Roth IRA tip. A Roth IRA is only for those not making Dane money. A Roth IRA investment account can actually be fairly liquid. Much advice that I have currently been reading is talking about funneling as much money (max hopefully $5,500/year) to your Roth IRA account over dumping extra money into a savings account and earning nothing. This is of course after you have built an emergency fund of 3-6 months. The caveat of doing this is that as long as the Roth IRA has been open for 5+ years, you can withdrawn your contributions at any time, tax free and with no penalties. Meaning that if I have contributed $20k to my Roth over 7 years, and it's currently worth $25k, I am allowed to withdraw up to $20k without penalty. Is this ideal, no. But in a sense, it acts as a second emergency fund as well. And an emergency fund with actual chance to grow unlike a savings account. The money would take at most a few weeks to get to you from my understanding. Easily in the window to pay for a major emergency. Withdrawing money from a 401k should be a last resort for most as the penalties caused by this are not worth it unless it's your last option. __________________ 2024 Royals game thread record 3-0
Posts: 46,133

06-27-2016, 05:21 PM	#39
SAUTO Shit Join Date: Jun 2008 Casino cash: $10039067	I have a safe room l where I take my cash and roll around in it. Edit: I go in and make it rain on the on the wife every chance I get
Posts: 55,715

06-27-2016, 05:30 PM	#41
R8RFAN Molôn Labé Join Date: Sep 2001 Location: North Carolina Casino cash: $8556872	I have 150k cash I have about 250k in my 401k My house and cars are paid for I am 100% debt free That's my portfolio , Not glamorous but I am happy
Posts: 23,170	2 0

06-27-2016, 05:30 PM	#42
LoneWolf Constable of Untruths Join Date: Oct 2010 Location: Wichita Casino cash: $1084	I haven't looked at any of our investment accounts since last Thursday. I don't want to see the losses and make a bad decision out of panic. I'll just ride it out. If I was 62 instead of 43, I'd be worried. I'm a big believer in index funds with a long-term approach. Just keep putting money into them and forget about it.
Posts: 15,288