Share count is fully diluted (includes outstanding shares, warrants, preferred shares, options, etc.). Annualized revenue is factored by taking the most recent quarterly revenue and multiplying it by four. Company names link to their investor relations page and tickers link to their investor presentations. You can support my work on Patreon here (comes with benefits!)
Looks good
How ya gonna real time Update ??
That’s the goal!
This is exactly what I have been looking for. Any. Chance we can get AYRWF earnings from Q1 and Q2 added to this?
Done! Forgot to update that one – what a busy earnings week that was!
MJ – First, I’d like to thank you for this website and all of your research. It is a site that I check daily for news, research, etc. One comment and potential small opportunity to improve – On top of this page (the investor portal), there is a heading with a date of Jan. 23, 2021 – that may be the date the page / spreadsheet was created?. It does appear the pricing is current, so that date is just confusing. May want to update the spreadsheet to show the current date. Just a suggestion
Thanks for the feedback. Yes, that was the day I started that spreadsheet. The pricing is automatic (20-minute delay) which then updates the market cap and P/S ratios.
Wow – well I’ll become a small patreon then. You have put together a lot of research.
Thanks!
Any idea if Cresco or Trulieve can accelerate to call back their warrants like Ayr did now? This worries me now as I bought the cresco warrants at high of bull market in March.
No, there is no acceleration clause for Truleive or Cresco warrants.
Hey thank you for all this info sir, you’re a legend. May your accounts grow fat and your losses small.
This is too good to be true, excellent data and makes a very clear picture of a heavily fragmented Industry.
Thanks for the feedback!
Thanks for taking the time to complete this. Really appreciate it !! Cheers
You’re welcome!
Thank you very much for your hard work, will be very useful!
You’re welcome!
Hey MJ,
Vext has 2 dispensaries in AZ and not CA ✌
Nice catch – updated!
Solid amount of work. Thsnks for sharing. Bookmarked.
You’re welcome!
ianthus?
Wow this is awesome. Stuff like this can be super helpful for investors and really shed a light on names that are overlooked.
If I may suggest one more piece to add, it would be square footage of cultivation space. By state would be ideal- similar to your dispensary sheet. In the mid to long term I think it will be critical to identify the vertically integrated players, vs the more wholesale and retail-centric. Often easy forget this is a commodity.
Thanks for sharing this site. Really valuable resource for investors in the space.
I did some quick visualizations based on these charts (just for fun). I’d be happy to help you build out some more charts/dashboards that you could host here if you’re interested. I could plug data studio into your spreadsheets and get a much cooler dashboard worked up depending on what data is available. Let me know!
https://datastudio.google.com/s/kL8_YCqYpkU
Nice! I’ll send you an email.
Amazing spreadsheet. Thank you for all of hard work!!!
Hi,
Thanks for all your work synthesizing an enormous amount of data. It would be great to see Body and Mind, who operate in California, Nevada, Ohio and Arkansas added to your list
Looking now!
Very nice, thanks for the hardwork. I’ve compared many of your companies with the SEC/SEDAR filings and although there are some errors, I find this to be mostly accurate. So hard with all this anyways given the multible sources out there. I only read form the horses mouth – filings & disclosure.
I was wondering if you can privide insite into how you’ve calculated your P/S ratios?
Many thanks, R
I calculate P/S by:
1. Multiply the most recent Q revenue by 4 to get an annualized revenue. I prefer that over TTM.
2. Divide market cap by that annualized number to get a P/S ratio.
Hello again MJ,
Just wanted to suggest you put a disclaimer for “Shares” as it is unclear how you are listing that info. As you know, there are many types of shares and even amongst ‘Shares Outstanding’ there can be a couple different types of that. So as to be consistent, I suggest a disclaimer in how/what you are listing that colume as. For example, Body & Minds latest filing(Feb 2, 2021) lists ‘shares outstanding’ as 108, 307,278, while you post 130 mil?
Some investor decks are not updated for long periods of time, but the filings are the latest.
Again, LOVE your work and this has been an invaluable tool for comparison purposes for investing!
Many thanks, R
Is this supposed to update? The date says Jan 23.
That’s just the date I started it.
What an amazing list, thanks for the DD. Found via Yahoo Boards.
Thank you! Incredible!
Thank you for putting this together! Great service. I see only one error: Tilt Holdings has 366 million outstanding shares according to their most recent Sedar filings, not 470 million. Small nit on an excellent project!
I use total dilutive shares which include warrants. If you look at their last investor presentation you’ll see 470 million.
PREMO! An excellent one-glance, comprehensive resource. Thanks for all you do! Now you need a 3rd shift editor…
Thank you. Very nice to see which companies are in which states!
You’ve provided a tremendously helpful resource for serious investors in cannabis. Thank you very much … you are certainly appreciated. Be Well.
Thank you for your site.
It would be awesome if we had a sort column function for the various headings?
This is awesome. Thanks for all the hard work that went into putting it together. One question – where are you getting your revenue estimates? Many of the companies haven’t given guidance for full year 2021 or 2022. I think FactSet does have estimates for the Tier 1 and Tier 2 US operators, but it doesn’t look like you’re using those. Thanks again.
Mostly from investor decks, conference calls and eTrade.
Great site! I don’t see a link to contact you directly, but just wanted to say 4Front Ventures now has 2 stores in IL (the chart says 1).
Thanks – just confirmed and will update.
What is this sorted on to rank them? Great work btw!!
Sorted by market cap each Saturday. My Patreon supporters will get emailed a sortable Exel sheet.
This is a great resource. Thank you for sharing this.
Question: what is the unit of measurement for the “Total Grow” column?
I added up their total cultivation by square footage.
did the “total grow” column go away? Thanks!
I have it as a Patreon feature. A lot of work to maintain both.
the go-to
super dope job on this
Harvest 2021 Rev is $380MM boom! 🙂
Any way to make this sortable by column?
I do provide a downloadable and sortable version for my MJ Insiders on Patreon – it’s one of the many ways I reward them for supporting my work. I just published my newsletter and made it available here: https://www.patreon.com/posts/51026636
Ah I see. I’m a small time investor (still a college student) so I can’t afford $300/year but thank you for putting together this information!
Fair to report gaap vs ifrs? Might be worth calling it out. Thanks for the work.
Thanks for putting this together. Just a heads up SHWZ fully diluted share count is 120 million per the recent investor presentation. 2021 estimated revenue of 125m and 2022 estimated revenue of 250m.
Thanks again!
Thanks for putting this together, lots of great info! Had a couple more questions for you, any chance you can send me an email offline?
AUXLY – CBWTF?
Can we get an update on the warrants, please?
Which ones?
Great site. Just became a $25 per month member. Great value proposition.
Thanks!
Great Site
However have noticed a couple of issues
Tilray now reports in usd $$$ and did so with their most recent Q1, 2022 earnings report
NEW YORK & LEAMINGTON, Ontario–(BUSINESS WIRE)–Oct. 7, 2021– Tilray, Inc. (“Tilray” or the “Company”) (Nasdaq: TLRY; TSX: TLRY), a leading global cannabis-lifestyle and consumer packaged goods company, today reported financial results for the first fiscal quarter ended August 31, 2021. All financial information in this press release is reported in U.S. dollars, unless otherwise indicated, and presented in accordance with accounting principles generally accepted in the U.S. (“GAAP”).
Also Verano reports PreMarket on November 16th not After the close
https://investors.verano.com/news/news-details/2021/VERANO-TO-REPORT-THIRD-QUARTER-2021-FINANCIAL-RESULTS-ON-NOVEMBER-16-2021/default.aspx
Just thought you would like to know
Cheers
Thanks!
well organized…but what happened to the current and forward EV,EBITDA columns ?
FYI, there is a twitter account that also puts up a regular data table as a second check.
I made those Patreon only. It’s just too much work to maintain two sheets of so much data.
I have followed you on Twitter for a few months and really enjoy your commentary and work. Appreciate the good work.
Really loving this data and analysis. Question: can you freeze the column headings and the company names in the main stock spreadsheet here: https://mjstocktrader.com/cannabis-investors-portal-mj-insiders/?
I know Google Sheets has that functionality, but don’t know if it still works when embedded like this. Would make it a lot easier to browse the data down in the deep cuts below the Tier 2s and out into the weeds past EBITDA and such. Either way, great info, really glad to Patreonize!
Can you update HSTRF (Hollister Biosciences) as it is now rebranded to YOURF (Your Way Cannabis Brands) in the spreadsheets?
Thanks
Thanks for the reminder – updated!
Good morning, and thank you for compiling all this data – it is great!
I just had a few questions about your recent updates. Can you please explain to me how you calculated your 2022 peg ratios?
For example. TCNNF 2022 PEG = 0.07 (Which we are both aware is an amazing number given 1 typically indicates fair value.)
Peg ratio = (P/E) / annual % EPS Growth
Scenario #1:
TCNNF current P/E = 35.82
TCNNF current EPS = $0.89
TCNNF % EPS Growth today $0.89 to 2022 estimate $1.97 = 121%
TCNNF PEG 2022 (based on today’s P/E and EPS = 35.82/121 = 0.29
Alternatively you can use your estimated 2021 P/E and EPS for our calculations given we have 2021 behind us and are waiting on year end results. Hopefully the numbers come in close to estimates and this will provide a proper annualized comparison.
Scenario #2:
estimated 2021 P/E of 19.16
estimated 2021 EPS of $1.32
% EPS Growth estimated 2021 EPS $1.32 to 2022 estimates $1.97 = 49%
Peg 2022 (based on your 2021 estimated P/E and EPS) = 19.16/49 = 0.39
Even if you go back to 2020 numbers which I don’t believe would be appropriate I get a 2022 peg ratio of 0.16
Either way I don’t get close to your 0.07.
I am a retail investor trying to continually learn so it is very possible I am completely overlooking or miscalculating something.
I appreciate what you do and thank you in advance for clarifying how you came to these 2022 peg ratios.
Thank you,
Does Ianthus have NJ
Thought they had something in Feb.