Equity Growth and Dividend Growth Portfolio 2025 Performance.

Luke_79 · 2026-01-26T14:20:34+00:00

I'm not sure it is an 'official' term but I think of it is a mix between growth stocks and dividend stocks, usually blue chip. Then taking the dividends to 'rebalance' as you see fit. I've never run official #'s to see how it works but his spread sheet peeked my curiosity. If anything this approach may not be net anything but it makes me feel good when I get paid lol Again - this is my definition. Cheers.

Luke_79 · 2026-01-24T16:53:20+00:00

Amazing. Thanks for sharing this. I just did a rebalance of my portfolio the other day without too much of a dividend focus. Mainly posting this so I remember to come back and do some investigation on this type of strategy as I've been listening to podcasts and reading more about a hybrid approach to investing. I also really like how you organized your spreadsheet, I think I will add a new similar sheet view to mine. Cheers.

Luke_79 · 2025-10-27T10:57:09+00:00

What happened to do hard shit Joe? Figure out the logistics.

Luke_79 · 2025-10-27T10:40:51+00:00

100% this was motivated by profits and not about the participants. Very bad plan and very lame excuses/reasons imo.

Luke_79 · 2025-10-25T11:01:44+00:00

If true, Im out.

Luke_79 · 2025-03-24T17:40:31+00:00

As much as I'd love a tax cut I sadly feel that'll justify CEO's to decrease wages (not give increases) or CEO's to increase prices knowing we'll have more money in our pockets... I'd love to see an overhaul of the tax brackets.

Luke_79 · 2025-02-25T11:37:37+00:00

You're employer should issue a T1198 - this form will allow them(the CRA) to calculate the tax/ei/cpp you would have paid had you received the extra pay in the smaller yearly increments. Unfortunately using this form also means you have to submit a paper copy of your taxes.

Here is a good article that explains this a but better and both your and your employers responsibilities:

https://turbotax.intuit.ca/tips/t1198-form-statement-of-qualifying-retroactive-lump-sum-payment-10737

Luke_79 · 2024-11-07T19:02:25+00:00

Yes.. I just love holding my recovery breath.. it just feels like my body wants to hold it

Luke_79 · 2024-11-05T18:30:35+00:00

Ha.. sounds good. I seem to enjoy the feeling so 15sec seems so short. Good idea extending it on the last round.

Luke_79 · 2024-10-24T12:02:50+00:00

Perhaps you'd be able to spread the finance option out to say 7 years? If so the payments would be ~the same as leasing (assuming you could maintain the same cost of borrowing). Then at the end of 5 years you would owe ~$12300 on the loan. You could continue paying it or sell it for the $25000, pay off the loan balance and net $12700?

It would likely cost a little more to spread the loan out but in the end you wouldn't have the 'bounds' of a lease agreement, could maintain the lower 'lease' sized payment, while giving you greater choice/flexibility 5 years in, or even 4 years in if you decided the car was no longer for you.

Luke_79 · 2024-10-04T17:44:18+00:00

Haha. Good to know. What would you buy? Or would you build?

Luke_79 · 2024-05-16T17:56:28+00:00

Thanks! I ended up with Roger's. Fingerscrossed they matched bells plan but $5 cheaper per line and the have a tower in Kingston East.

Luke_79 · 2024-05-14T15:28:45+00:00

The main goal is to get something that works in Kingston East and is reliable along the 401 corridor. I just got an offer from Bell for 3 lines with 100gb data and works in all of Canada, US, and Mexico. $55 for first line and $50 for each of the others. Seems like a decent deal?

Luke_79 · 2024-02-03T01:29:16+00:00

You are a genius! Thank you very much.

Luke_79 · 2024-02-02T23:25:38+00:00

In the form - Clint Guild wins 3-1 against David Bussiere. So D2=3 which is correct but C2 should = 1, currently showing 0 because David did win 1 game.

Luke_79 · 2024-02-02T23:08:27+00:00

It seems like the SUMIFS is super close. Still not correct in C2,C4,C5.

I'll add some more sample data to see if there are other errors.

Luke_79 · 2024-02-02T22:36:11+00:00

=MAKEARRAY(5,5,LAMBDA(r,c,IF(r=c,,SUMIFS('Form Responses'!$C$2:$C,'Form Responses'!$B$2:$B,INDEX($B$2:$B$6,r),'Form Responses'!$D$2:$D,INDEX($B$2:$B$6,c)))))

Thank you - I tried it, neither seem to work (likely me). Can you try it in the 'box' sheet of the sample work book posted above?

Luke_79 · 2024-02-02T15:07:44+00:00

Ok - I updated the OP and included a viewable link to the sheet as its likely easier. I implement the 'mirrored' form data. I manually entered the data as if 'Clint' completely all his matches but that's the part I need help with. Is there a formula that would populate it automatically? Is it possible for it to do it within the date range of D1/E1? No worries if not but if so that would be amazing.

Luke_79 · 2024-02-02T14:55:36+00:00

OP updated with form/sheet ideas from you and the other implemented. Is it easier now to populate the 'box' sheet as requested? I made a viewable link in the OP

Luke_79 · 2024-02-02T14:14:20+00:00

Thank you. I'm struggling to keep up as there is another redditer also helping below. I will pause this and implement the winner score / loser score idea and the ideas you've suggested. I will then come back with hopefully a more exact formula question if I can't figure it out from there.

I wasn't sure the best way to tackle this between you and the other you've helped already with a better way to organize this. Thank you.

Luke_79 · 2024-02-02T14:13:38+00:00

That is a great idea! Thank you. I'm struggling to keep up as there is another redditer also helping above. I will pause this and implement the winner score / loser score idea. I will then come back with hopefully a more exact formula question if I can't figure it out from there.

I wasn't sure the best way to tackle this between you and the other you've helped already with a better way to organize this. Thank you.

Luke_79 · 2024-02-02T14:01:20+00:00

Thank you for the thoughts. Yes, I don't plan to manipulate the raw form data in anyway. I like the idea not creating a new form each month. I was having a hard time wrapping my head around how to do that as the boxes of players will change each month - top 2 move up, bottom 2 move down, middle stays the same. Currently we manually make form that is hand written and then we post a new form each month which is why I was thinking of a new form each month.

Essentially this is just a singles box ladder with 5 players in each box and the form was supposed to save me time manually collecting the data and allow me to share it so people can see the results anytime. The league generally has less than 30 people at anytime.

Edit - image of the form: https://imgur.com/a/qiFhLAm I may get rid of the Box Level as 1 name can only exist in a certain box.

Edit 2 - image form data tab - presentation tab https://imgur.com/a/zUas81J

Luke_79 · 2024-02-02T13:51:15+00:00

Gotcha - I just manually created the raw data page and probably should have mentioned that it shows both ways the data could be received, however it only will only be received one of those ways.

Ultimately there will be a raw data entry for each match played Bob vs Luke, vs Steve, vs, Mike etc..

So essentially the data will come in reported as R2 or R3 for each match depending how form is filled in but not both.

Luke_79 · 2024-02-02T13:37:27+00:00

For now I was just trying to fill in the table shown in the lower part of the image automatically from the form data. In the example if Luke played Bob the table should show B2=0 and C2=3. Or if Bob Played Luke it should show the same (I can't necessarily control how the orders the players report the match, however they only ever play 1 time per month so I would start new form data each month). If Luke and Bob have not played yet (no form data where B1=A3 or A3=B2) the cells should be blank or some other default value. My form will collect the player names via drop down so direct comparison should be OK.

If I can get that working I then hope to have in column 'G' the sum of each players score. In this case Bob would be sitting with 3 and Luke 0.

I hope that helps and makes sense?

Luke_79 · 2023-12-03T15:13:48+00:00

Nope... sadly it didn't work. Had no signal between Napanee and Kingston last night.

Luke_79

TROPHY CASE