 Drip drip drip What's up money geeks mr. V here welcome to another video guys so in today's video I want to show you guys how I'm tracking The dividend income from my individual stocks because I've actually gotten a lot of questions from some of you guys asking me how to track How do you track your dividend income? So I do have a spreadsheet that I'm using for that and I'm gonna walk you guys through it and if you are interested in Downloading the spreadsheet again. I'm gonna put it in the description below I'll put a link there so you can download it. It's gonna take you to my blog and you can also on my blog You can actually see all the different individual stocks that I'm actually holding That do pay dividends and they can download the sheet and use it as very straightforward Again, if you're new to the channel, we'll talk about how to earn money how to save money how to invest and build wealth So if that's something that really interests you go ahead and hit that subscribe button and the notification bell So you don't miss out on new content. So let's jump right on to the computer and take a look at The sheet I'm talking about this is gonna be a very quick video I just wanted to make sure that people that are asking these questions do have an answer and just Not just tell you where to go get it, but show you how he actually works. So here we go So once you once you get this sheet once you download this sheet from from the website You get it on your computer. You just have to enter information in three major places So column a we say it's the ticket symbol. That's the first Part of you gonna enter so whichever stock that you own That's a dividend paying stack. You enter the ticket symbol right there And that's gonna that's gonna take you now to column B Which is it's asking you for the amount of shares of that particular Stock that you own you input that and then what is the average cost per share that you paid? So and then once you input those three It's gonna populate the entire thing for you. You don't have to do anything what's gonna do It's gonna go online Because this whole sheet is automated. It's just gonna go online and pull the current price From Google finance. It's gonna go pull it out and insert it into this sheet for you And then it's gonna do the math and multiply and tell you your equity It's gonna show you your market value currently and then obviously Walk your way through showing you your capital gains And I mean ideally I want everything in column G and H to be green But we know that covert 19 has actually really hurt the market so bad And so I'm seeing a ton of red, but I'm very hopeful because it's a long-term position. So Maybe in one or two years. This is all gonna be green and then it's showing you your annual dividends in column I And then show me your dividend yield in column J. And then obviously What I'm really interested is is the annual income so column N is what you anticipate getting from that particular stock Annually and then so in my case where I'm currently sitting right now. So if you just slide this to the right You would see more detailed information. So where I'm currently sitting right now is that my anticipated annual dividend income in column C is 1200 a little bit over $1200 a year so that amounts to about over a little bit over a hundred dollars a month Which is not bad again when I talk about dividend income in this case It's you sitting there doing nothing and getting paid a hundred dollars a month, which is awesome You own the stock you're getting two things out of the stock the price goes up You're getting growth and the pain new dividends. It's awesome and for starters if you are reinvesting that dividends That's why I said drip drip drip. So that's dividend reinvestment So if you can get a portfolio that has drip You're reinvesting your dividends and letting it grow. So if I took this $1200 and use it and then I'm losing out So if I if I take it and reinvest it next time that they pay me dividends You're not just going to pay me dividends for what I have now the payment dividends for what I have plus the $1200 Which is gonna pay me more dividends So the goal is to compound it over and over in the next 10 15 20 25 30 years Before I start thinking about retirement so that when you retire you have enough money in these portfolios so that you can start Taking that dividends every month and not worry about it And then the good thing about a portfolio like this is which your retirement portfolio The government can tell you when you can start pulling money out Or they take when you have to pull money out or they like it or now you have to start pulling money out of your retirement account But an account like this you don't have to but this comes with a risk The risk there is if the market were to crash like it just did last month and even currently now You are gonna see companies start paying that dividends Which means that income is gonna know be gone your income is gonna be gone and then your stock value would even go down Which you can't even sell and take your money out if you didn't anticipate it something like this happening So even though it's good, but it comes at a risk So I do have another portfolio or other portfolios that covers that so I have a 401k I have a rough area account. I have a traditional area account. I have an HSE account So those are other accounts that are keeping me a buffer So overall, I just want a very solid situation where I cannot be punched in one direction So if you only have a 401k And then the government will tell you when you need to start pulling money out of that account If you only have a let's say a drip account and then what if the economy crashes? So you find yourself in trouble. So that is something that I really wanted to bring out Basically, this is a sheet a kind of a breakdown of your holdings and percent by percentage and then your dividend income by percentage as well So just basic math. So again, this is it. This is a sheet that I use and I've been using in the track my dividends Now for two or three years. So if you're interested again guys I'm gonna put a link in the description below where you can actually go and download this particular sheet Just input your information and there you go. You're up and running and tracking your dividend income I hope this was helpful. Again, if you're new to the channel, we'll talk about how to earn money How to save money how to invest and build wealth So if that's something that really interests you go ahead and hit that subscribe button and the notification bell So you don't miss out on new content and as always guys question of the day What do you think about the sheet? Do you have a better one? Let me know in the comment section and I want to see it if you want to share with me I mean, I'm more than happy to take a look. I'm not emotionally attached to this particular sheet So if I see something that's better, I'm always good for improvement So let me know in the comment section if you have something that's better that helps you track your dividends Stay safe. Stay motivated