February 18, 20242 yr Popular Post Sample dividend calculator I created for some stocks ... Check CalculatorMonthlyDiv5yr Sheet. Inputs - Check Stock Ticker Dividend Reinvest - Shows how your investment looks like if your dividend is reinvested else not. Yearly Investment - IF selected it buys stocks with 12k at beginning of year. Else it spreads $1000k every month evenly and buys 1st of every month. Output Shows in blue how your investment varies based on inputs selected. Shows results for 5 yrs. https://docs.google.com/spreadsheets/d/1HrzsUK5TTQPt6B5XjuLm1wO4J9Pvo_zJwKFQzBcpuA8/edit#gid=1702614343 Any feedback?
February 18, 20242 yr Author The results are underwhelming as most of these stocks are at their 52 week lows ... I need to pick some that have seen price appreciation as well.
February 18, 20242 yr in your dividend experience is it working better for your selected stocks compared to SCHD
February 18, 20242 yr Author 4 minutes ago, rmJU72 said: in your dividend experience is it working better for your selected stocks compared to SCHD It depends on the period selected. I see a clear difference in pattern in Growth Stocks + Consistent div Payers - Like PG, CL Consistent Div stocks that are lagging behind now - Like PFE, T, VZ, MO which are at their 52 yr lows. Using 5 yr calculator it shows how PFE, T, VZ and MO could grow money. Still I think overall these div stocks make sense beyond 5 yrs. I am underwhelmed by the value with in 5 yrs. Somehow yahoo finance is not giving price beyond 5 yrs. Otherwise I was planning to do this for 10 yrs.
February 18, 20242 yr Author 12 minutes ago, rmJU72 said: in your dividend experience is it working better for your selected stocks compared to SCHD In last 5 yrs, SCHD seems to have beat these stocks by a decent margin. I am glad I did this analysis.
February 18, 20242 yr 7 hours ago, Konebhar6 said: so far added PDI, PFE, O, BMY, SBUX, MO, GILD, VZ. Will add more OKE
February 18, 20242 yr By how much % do you think ur future dividend portfolio will beat SCHD? IMO if only looking for dividend income the extra amount you might gain may not be worth the time you put in for research. Also individual picks are riskier.
February 18, 20242 yr Author 3 hours ago, rmJU72 said: By how much % do you think ur future dividend portfolio will beat SCHD? IMO if only looking for dividend income the extra amount you might gain may not be worth the time you put in for research. Also individual picks are riskier. I have PDI, BST, BSTZ, JEPI, JEPQ and bought few dividend stocks when they are at 52 Week lows (PFE, MO). PDI is pure dividend play. A hefty 16-17% div + 15-20% price appreciation so far in 1.5 yrs. Share price will appreciate when Interest rates go down. Until then dividends are good. BST, BSTX, JEPQ have all Given 25+% price appreciation so far in 1.5 yrs. Plus 10-12% dividend. I will have to compare analysis with SCHD in last 1.5 yr. But I am impressed with SCHD. I think blindly we can buy it SIP every week or month for $ cost average.
February 18, 20242 yr Author I added another sheet "DivStockPerformance". IT shows how these stocks performed over years and what your investment looks like in 5 yrs. Select Investment Horizon as input.
February 18, 20242 yr Author 4 hours ago, rmJU72 said: By how much % do you think ur future dividend portfolio will beat SCHD? IMO if only looking for dividend income the extra amount you might gain may not be worth the time you put in for research. Also individual picks are riskier. I am obsessed with numbers. Its just timepass for me. I do not recommend anyone to buy stocks based on these sheets. Its just information I am sharing ..
February 18, 20242 yr 3 hours ago, Konebhar6 said: PDI, PFE, what sources do you use to research about these stocks - any paid services ?
February 18, 20242 yr Author 48 minutes ago, enigmatic said: what sources do you use to research about these stocks - any paid services ? I dont use any paid services. I always start with Yahoo Finance. Plenty of information can be found in the Conversations section for a stock. And then a general Google search.
February 18, 20242 yr Author Can someone confirm if you are able to select the stock in SIPCalculatorMonthlyDiv5Yr Sheet? I am not sure if these selections work if I shared the sheet as a viewer.
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.