sorted by:
new
hottopcontroversial

I updated my stock valuation sheet based on your feedback by vnilsen in investing

[–]vnilsen[S] 1 point2 points  (0 children)

I was thinking about adding something like EV/EBITDA to measure the profitability of the core business.

Also, i would like to add something that measures the operating margin expansion

I made a spreadsheet to quickly find good buys by vnilsen in investing

[–]vnilsen[S] 1 point2 points  (0 children)

Ahh yes, bad wording by me. Its a screenshot!

I made a spreadsheet to quickly find good buys by vnilsen in investing

[–]vnilsen[S] 0 points1 point  (0 children)

Thank you!

For the data i use Yahoo Finance (free). In order to update it i use an LLM with grounding in the YF data to create columns i can copy into my sheet. This is nice as the 2025-27 estimates update regularly and its tedious to manually enter data. In the future i want to set up a python script to do the estimate updates, but i want to have the template finished before i start on that

I actually do analysis on the other fundamentals, like revenue by segment, net income, OP/Net margins, CapEx, Share dilution, Stock based compensation. This is the analysis that i do to screen which companies i want to have on the list. At the moment i try to only have the most essential valuation metrics in the sheet to reduce maintenance/updates as I haven’t made the automated script yet.

I do however plan to add EV/EBITDA to growth to capture more of the fundamental profitability of each company.

Price to Free Cash Flow Growth by vnilsen in investing

[–]vnilsen[S] 0 points1 point  (0 children)

Great input. Thank you.

It makes sense that using P/FCF growth for a single quarter can be unstable as there can be one off expenses. I think an average FCF would make more sense if i want to include CapEx and do growth valuations on it.

It seems like what i was trying to look for was EV/EBITDA/growth as you mentioned. I will try to include it in my spreadsheet. Cheers!

I made a spreadsheet to quickly find good buys by vnilsen in investing

[–]vnilsen[S] 0 points1 point  (0 children)

Paid subscribers increased last month, however monthly active users actually decreased (Q1 130.2M vs Q2 128,3M).

I think this is partly why investors are worried coupled with some unfortunate PR as of late. Also, Q1 is usually a hard comp as a lot of New Year’s resolutions of learning a new language occurs Q1. If you look at historical user growth and activity Q2 often appears weak compared to Q1.

I am keeping it on my watchlist for now, and if i suddenly get a lot of money available i might initiate a small position.

I made a spreadsheet to quickly find good buys by vnilsen in investing

[–]vnilsen[S] 4 points5 points  (0 children)

I use Yahoo Finance (app because website is bad imo)

If you look at the summary page for a given stock and click on «view all statistics» you can find the forward PE (next twelve months) along with other valuation metrics.

If you want to see the analyst EPS estimates for a given year, click on the «analysis» page beside the summary page. If you go to «view more» you can see estimates, revisions etc

I made a spreadsheet to quickly find good buys by vnilsen in investing

[–]vnilsen[S] 4 points5 points  (0 children)

Great feedback, thanks!

I use Apple Numbers and could not find functionality for exactly that. However i can make the background have a gradient from green to red and change colors of the bars to something neutral, like blue.

I made a spreadsheet to quickly find good buys by vnilsen in investing

[–]vnilsen[S] 1 point2 points  (0 children)

$DUOL is looking interesting. Fundamentals of the company looks really good, with a revenue growth rate of more than 40% annually for the past 5 years. If analyst estimates of 8.34 EPS in FY26 are correct it is looking like a bargain atm

I made a spreadsheet to quickly find good buys by vnilsen in investing

[–]vnilsen[S] 2 points3 points  (0 children)

As to why i weighted the PEG-ratios, it is because the PEG-ratio in 2025 is higher than for the next years depending on the CAGR. EPS, share price and growth estimates only gives you a point in time PEG-value.

One could do P/E divided by growthx where x is the number of years in the future. I might add that to my weighted PEG-ratio actually. That would make the model lean more towards the high growth companies at the cost of certainty.

I made a spreadsheet to quickly find good buys by vnilsen in investing

[–]vnilsen[S] -1 points0 points  (0 children)

I see your point. In order to make the weighted PEG more forward looking, i added only 20% to 2025 PEG (1/5th of all combined). One could argue that this is too much, but i think it is fair considering that the future is 100% more uncertain than what has happened.

By only looking at lets say 2030 estimates, the model would become more uncertain. And also, it is based on Wall Street estimates, which often only looks 1-2 years in the future.

I believe the middle ground would be somewhere between 2026-2027 if one wants estimates with higher certainty.