9 ай бұрын
Пікірлер
@juwonrichard Күн бұрын
Can this be done On gohighlevel?
@aldoctor_sh 2 күн бұрын
What i have to do if i forgot the password
@christianblake6447 5 күн бұрын
We are now married😭😂 Seriously, thank you.
@wawawiwaa 6 күн бұрын
❤❤❤❤❤❤
@wawawiwaa 6 күн бұрын
tysmmm for thisss!!! this is soooo valuable!! lots of info in a single vid!! 😭🫶🏻🔥
@AandF 6 күн бұрын
Wow, youre a champion - thank you so much Eric! What about a transactional product that only takes about 1-3 weeks to close ? How would you format the sheet?
@stephena.8193 7 күн бұрын
Hi Eric, first of all thanks for the video, great explanation! I wonder though if the profitability you explain around 16:10 is correct? Wouldn't break even occur during month 2 as the profits cummulate vs the one time cac? 33+65+95=193>115
@lilbrusselsprout8261 7 күн бұрын
Hey Eric, very helpful, thanks. Question for you: If my product offers only 6 month and 12 month memberships, I'm assuming looking at one year wouldn't really give you a great picture of retention since each customer doesn't have the opportunity to churn every month. That being said, 1) How many years would you recommend looking back to get a good picture of the company's retention 2) Would you break these tables out separately for 6 month memberships and 12 month memberships? Any other insights on longer term contracts and how to analyze them would be extremely valuable, thank you. Edit: one more question. Since sales commission is technically an expense related to acquiring customers, would you put that expense into CAC and exclude it from gross margin calculations? In other words if I give 10% sales commission on a $100 product, I wouldn't deduct $10 from the $100 to get gross margin but would instead add $10 to my CAC, correct?
@Aira.Padilla 8 күн бұрын
Hi Eric, I am a new ecom biz owner still getting my fit in the industry so I really appreciate these videos you are making. I've been binge-watching your video to learn all this stuff. Thank you so much for giving us all this info!
@supercarlitos2006 11 күн бұрын
This is exactly what I needed. Thank you so much for sharing this.
@angelinamarch2005 12 күн бұрын
I’m having trouble building the first table from the dataset (a step back from what you’ve shown)!! can’t find the right formula!
@DimitriGaldava-yi1rz 13 күн бұрын
Thank you for the video, however I had to pay $5 for it even video says for free, but I dont mind.
@eric_andrews 13 күн бұрын
@DimitriGaldava-yi1rz i had to start charging a small fee for it recently to support my rising software costs. Thank you for understanding and I hope it helps you a lot!
@LakshKaushik-s2r 17 күн бұрын
@is forecasting of this analysis / Net sales also possible further? And what methods will be most suitable?
@nicolem.williams5511 17 күн бұрын
This information is so valuable, and I really appreciate the complete breakdown. Your channel is helping me so much. Thank you!!
@eric_andrews 13 күн бұрын
@@nicolem.williams5511 my pleasure!!! Thanks for the comment
@godislove8831 19 күн бұрын
Hi Eric , My name is Surprise i was searching questions and answers for an administrator finance position and i bumped into your video where you were explaining about finance interview 3years ago, you know how to explain and I was impressed , so i would like you to help me to understand Administrator finance position and duties , what are the questions and answers. I would be very happy if you help me , thanks in advance.
@godislove8831 19 күн бұрын
Hi Eric , i am going to interview for Administrator finance i would like you to help me with questions and duties for this position.
@raulsiqueirayt 22 күн бұрын
Very great video Eric! Thank you so much :)
@adorable_writes 22 күн бұрын
Finally after 4 days I have completed this model I have spearing no efforts to learn Financial Start up Models Thanx a lot to upload such a valuable content lot of love from India
@Ayush-bc2kz 23 күн бұрын
Great Video Eric. I am wondering in a more real world scenario - an ecommerce store has 100's of SKU's how would we proceed in calculating contributional margin for the same?
@soundaryasuresh1845 23 күн бұрын
How to assume future revenue growth based on historical data in income statement
@RicardoRodriguez-y6p 24 күн бұрын
This was awesome to watch and use. I am also looking to benchmark L&D NPS in the healthcare industry. Any sources you can point me to?
@michaelstopperich8528 25 күн бұрын
How can I calculate the churn if a customer is paying a flat fee for my service and, depending on the service, they could be an active customer for 2+ years?
@eric_andrews 25 күн бұрын
@@michaelstopperich8528 so they are locked in to 2 year contracts?
@michaelstopperich8528 25 күн бұрын
@@eric_andrewsThey are locked into a contract yes, but the terms vary. Some pay the full balance of the service when they sign the agreement and others make payments for 3 to 10 months. But once the customer is done paying, its very likely they will remain an active customer for a period of time. Could be months could be multiple years.
@michaelstopperich8528 25 күн бұрын
They are locked into contracts, but terms vary. I sell Immigration Legal Services, so you could sign up for a $10,000 service, pay $2,000/month for 5 months then we send your application to USCIS (the government) to be reviewed and either "Approved" or "Denied". But its realistic we don't receive an answer of approval or denial for 6 to 12 months. This is where i'm getting stuck on how to calculate the churn.
@eric_andrews 24 күн бұрын
@michaelstopperich8528 yes the thing you're getting stuck on is you are trying to use "churn rate" for a business that is not a subscription. I have a video on this here but basically i would just be focused on LTV per customer, churn only really applies to subscription businesses where people are actively canceling the service which is different kzfaq.info/get/bejne/aLeJkpRyud-4f4k.htmlsi=xr67SIQU2H0tSRsX
@michaelstopperich8528 25 күн бұрын
How can I calculate the churn if a customer is paying a flat fee for my service and, depending on the service, they could be an active customer for 2+ years?
@Tiffanyonfire 25 күн бұрын
Hi Eric～great work～can I know where I can download the Excel?
@eric_andrews 25 күн бұрын
@@Tiffanyonfire in the description
@TheWeb3TV 26 күн бұрын
How do we get the framework excel file used in the video ?
@AlternativeInvestor 26 күн бұрын
AI short
@eric_andrews 26 күн бұрын
@@AlternativeInvestor haha, i wish. That would save me a lot of work
@tanupreet.chadha 26 күн бұрын
Unemployed, how do i buy that model. Give it for free!
@eric_andrews 26 күн бұрын
Watch the case study here: kzfaq.info/get/bejne/eNiKjNqcyJi3poE.html
@SyedHassanRazaJafri 26 күн бұрын
They are extremely efficient. I worked in Constellation Software Inc. for 5 years. Amazing model amazing growth!
@saadAlshweaer 27 күн бұрын
Hello Eric, I appreciate the content being provided very much, but may I know how companies or agencies that provide subscription services for online stores and SAAS receive wages from the stores? Do they take a percentage of the sales of their subscriptions or do they receive an amount each month?
@eric_andrews 27 күн бұрын
@saadAlshweaer it depends on the company. A mix of both, but lower-end products usually do a monthly fee, where some of the more enterprise level softwares do a % of sales or they increase pricing based on usage which is similar.
@duncanmahood2878 28 күн бұрын
"The whale only gets harpooned when it surfaces." 💯
@eric_andrews 28 күн бұрын
@@duncanmahood2878 lol yes
@JasonAmir-qo4uo 28 күн бұрын
What do you think of Constellation Software's (CSU) business model?
@RoseBalerus 28 күн бұрын
Is that a new established strategy?
@GibsonJames-gr3on 28 күн бұрын
I like their diversified portfolio of software companies. Their acquisition strategy is impressive, over 100 companies acquired!
@RobertDamanii 28 күн бұрын
How do they manage so many different software brands?
@John-ww2fv 28 күн бұрын
They invest heavily in R&D, driving innovation. Their decentralized approach gives each company autonomy.
@RubenDominguez-ei3fd 28 күн бұрын
That's smart, allowing them to maintain their unique cultures. What about their organic growth strategy?
@syedjawaadali9841 28 күн бұрын
You nailed it bro! All covered in 23 minutes. Kudos!
@juliemcdermott7521 29 күн бұрын
excellent
@Buy_YT_Views_897 29 күн бұрын
🤯
@LennyYT 29 күн бұрын
Interesting. I'd love to know what they bing to the table to turn these companies around.
@eric_andrews 28 күн бұрын
I think they help with some basic benchmarking, budgeting, etc, but my understanding is that they just let the companies run mostly. They don't really need them to do anything different because of the multiples they buy them at.
@LennyYT 28 күн бұрын
@@eric_andrews this is next level. Why Hormozi is not all over this? 😂😂😂
@eric_andrews 28 күн бұрын
@LennyYT haha ya, they keep an amazingly low profile but can't hide forever i think they are like 10th largest company on canadian stock exchange now
@firte3899 29 күн бұрын
Thanks for putting out great videos on software and finance
@eric_andrews 29 күн бұрын
@@firte3899 my pleasure!!
@End_rick997 29 күн бұрын
I'm new to trading, and I've lost a good sum trying out strategies I found in online tutorials. I would sincerely appreciate any recommendations you have.
@eric_andrews 29 күн бұрын
What else do you know about Constellation Software? There is much more to unpack than I covered today, please share below!
@oluseyiolojede5619 Ай бұрын
Financial modelling simplified
@Neeltje_Schoenmaker Ай бұрын
Thanks, ou explain it so to the point, very helpful
@LennyYT Ай бұрын
This is awesome 🎉 can you share more context on how your client converted so high for a generic giveaway prize? What was the follow up and other secondary strategies like? 🙏
@medhatibrahim5447 Ай бұрын
We have a Monthly and Annual Subscriptions the annual is amortized Over 12 Month to have our Monthly Revenue . So in Jan. 2024 to calculate the ratios should i add YTD December + Jan Revenue and start calculating the ratios? . Your Excel Line 66 is accumulated Figures or the Monthly revenue of every Month Only
@nitishdhawan1297 Ай бұрын
This is one of the best videos on the interpretation of customer cohorts.
@Fcku12 Ай бұрын
Bro you killed it... Everyone only talks about easy stuff but the real stuff no one talks about it.. Thank you!
@eric_andrews Ай бұрын
Haha thanks. That is my goal, glad it was helpful