Hi Eric, I am a graduate student who is trying to learn various business and financial models. I came across your channel a few days back and I can't tell you how much of a treasure it is. Thank you for helping me learn what financial modeling looks like in real-time scenarios. This is so useful for students and freshers who aspire to get real-time experience in modelling.More power to you ! Looking forward for many more amazing contents.
Hi Dhivya - it really means a lot to me to hear your story and that these videos have been really valuable for you. I'll keep trying to democratize this knowledge for all people! Thanks for everything.
Thank you Eric from the bottom of my heart! I needed a good format in a short period of time to lay out a financial model. I finally ran across your example and it got me well on my way. I look forward to watching your more detailed model videos soon. Your work is well-planned, concise, and clear. Thank you so much!
Awesome model Eric! Super helpful case study. This is way better than looking at someone's already-built model and trying to figure out how it fits together, or how to start. Thanks!
Hey Kyle - really appreciate that feedback. I'm glad the "starting from an empty sheet" helped you understand the order / mechanics of these types of models. Cheers.
I know this is based on a subscription based model... but what about a standard e-commerce store where we buy the products up front? Also I'd like to factor in a drop-shipping based model too. 1) How do we factor in inventory purchases for a standard retail / e-commerce store environment? - If I pay shipping on importing those inventory purchases, is that an expense or a cost of good? 2) Do you have a formula for inventory management and planning? How much should I purchase to increase sales? 3) Where do we look to increase financing + adding loan liabilities? 4) Why is there no sales tax / VAT? How can we factor this in? Thanks again for the great videos… excellent help.
Hey Saul - will do my best to help. In your situation you could do one of two options - (A) just put your shipping and inventory expenses into your P&L, and then record the revenue later on when you sell it, or (B) build a balance sheet and cash flow statement because the business would be investing up-front cash to buy and hold holding significant assets (inventory) for longer periods of time and then selling them off. For that reason, there would be a big different between your P&L model and your actual cash position, hopefully that makes sense. I would do A if it was just my own small business and was trying to figure out the math, but B would be more so outside people could understand it. 1 - that's all cost of goods sold. anything that touches the product (other than marketing) is cost of goods sold 2 - there is no formula, you just want to make sure that you are forecasting your sales (units sold) out far enough that you have time to manufacture and import your product. So, it might take 6 months to get product into the country, so you will want to see how many units you plan to sell over the next 6 months to make sure you have enough inventory. that's basically the main value of a financial model, to anticipate your needs so you can prepare 3 - that's all on the balance sheet. you probably need to build a 3 statement financial model. usually businesses that build up large amounts of inventory use revolving lines of credit or credit cards. you'll make sure you are forecasting both the value of your inventory and your outstanding debt each month to make sure you are managing your liquidity well. 4 - many businesses have no sales tax or VAT. it depends on the type of product & country. I would include those things in revenue. hope that helps
This was so helpful and a great learning experience. I learned how to formulate a financial forcast as well as a new skill in Microsoft excel👍 if i was able to give more than one like id be spamming
I enjoyed your other video on building a 3 stmt fin model, and purchasing the bundle of classes now. Very useful stuff that can be used everyday, thank you!
I really appreciate you letting me know! I'm working on some more business analysis & modeling style videos right now, and will be releasing them soon. Thanks for the comment 👍😀
Eric your contents are a treasure . It has helped me immensely . Do you mind explaining us how to add 2-3 revenue streams data into one file . For example , in addition to subscription , if the company earns from a marketplace model or add from revenue in their app , how would they add those in their model ?
I'm happy to hear that. In those scenarios, you would just create a separate section & forecast for each type of revenue & COGS. In your consolidated model, you would probably keep each type of revenue & COGS in it's own account, but just consolidate them all into the same model. Here is an example of me doing that in one of my other videos: ua-cam.com/video/UBsK07oq1MI/v-deo.htmlsi=Sk8sk_sPbVBsLzhW
Hi ERIC,I see your model ,it is very much appreciated and I learn more new things through this model and I also see your basic model, appreciated, appreciated,now can you upload something other basic model, Warm regards Pushpendra
Hi Pushpendra, here are some of my other modeling videos you can take a look at! => Building a 3 statement financial model ua-cam.com/video/xlXDZyZ9azk/v-deo.html => E-commerce financial model ua-cam.com/video/bsmyakxOPLY/v-deo.html
Hi ERIC,This is pushpendra here,I have very basic knowledge about Excel,so that if you upload some besic model on 3 financial statement then it will be helpful for me. Thanks and Warm regards Pushpendra
Question: Aren't COGS intended to include all COGS (even for refunded transactions)? Aren't those cost sunk after the transaction occurs? That said this is super helpful. I always pull these up for my team
Yep, totally. Didn't really cover that in this video but the extra COGS would just hit normally and you'd have the revenue reversed out at the top as "refunds", depends on the business model in some cases can be even 5% of revenue+. One thing I recommend is offering buy one get one free (or other bundles) or discounts where you say "no refunds", can help a lot.
Very helpful video Eric. One follow up question: how do you account for organic / word of mouth marketing, especially initially / at launch? If the initial customer acquisition is based on viral spread or word of mouth rather than $ spent, would you maintain that as a separate line item in the customer acquisition tab and use the same churn, spend, etc assumptions as paid acquisition customers?
Ya, it's a good question. Most startups actually drive 40% ish percent of their revenue from organic sales (obviously completely depends on the company / situation), but that's what I've seen across some different companies (could be from social media following, PR, SEO, email, etc). I would build a separate line item for that on your acquisition page, with its own assumptions. You could also just model your CAC going down over time as a BLENDED CAC (rather than Paid CAC), meaning a mix of paid and organic new clients, to show the proportion of organic going up thus driving marketing costs down. Either way would be fine. Great question.
hey eric, please give the exact downloadable teemplate because in the income statement assumptions, there are little variations as compared your tutorial.
Happy to help. Yes, you can either do with with the keyboard, copy the cell with the formula you want (control + C) and highlight the cells you want to paste the formula and then past (control + V). You can also highlight the area and go to the bottom right highlighted cell and when your cursor makes that tiny black cross click and hold down and then drag the formula. Maybe check out some of my Excel videos as well, here's a good starting point: ua-cam.com/video/efX9u5hUUY8/v-deo.html
Hey Peter, I would just take your "new customers" and make a separate revenue line with a one time cost where you just calculate new customers * one time setup cost ($) for each month. That would probably work.
Hi Eric, I really liked the way you explain this financial model. Would I have a chance to use this model for a restaurant business? Or it wouldn't fit?
Hi Fabio - I think you could use this model as a starting point, although you would probably need to change the revenue & cost model for how a restaurant works. Customers probably return to restaurants at a certain return rate each month, so I think you could use these concepts to build a business plan. Thanks for the comment!
EBITDA is just your operating profit + depreciation added back to it. In this video we didn't have any depreciation, so the EBITDA would be the same as your operating income. Valuations depend a lot on the business factors (% of revenue that is recurring, gross profit margins, growth rate, etc), but generally they are based on a multiple of profit (EBITDA or net income). The multiples depend on the business. A lot of businesses are valued in the 10-30X EBITDA range. I dive deeper into the multiples-valuation method in this video: ua-cam.com/video/nDa-hjtXC3M/v-deo.htmlsi=40Gm3bVTVSPwR9hq
This was insanely helpful you have no idea! I so look forward to your new videos. I have a question though, regarding CAC, it's so difficult to estimate this value before launching your business. Since it's kind of the backbone of building this model , can you replace it with something else?
Great! No, I would not advise replacing this metric. If you haven't launched the business yet, I would do the math to try to estimate your customer lifetime value (I have a video => ua-cam.com/video/eHi875QuVcA/v-deo.html). Once you know what that is, you will know what your maximum CAC can be in order to run the business profitably. You can put in some CAC assumptions that are lower than your LTV. Once you know what your maximum CAC is, you know the target your business must hit or do better than. CAC and LTV are the backbone of any business, whether you've launched them or not. Cheers.
@@eric_andrews I actually just finished building the whole thing and woow I'm impressed! Will definitely check the video. Thanks again and best of luck.
This was amazing. No BS nothing fancy. Thank you Eric :) Also, are you planning on helping us with financial models on merger & acquisitions, advanced valuations, Leveraged Buyout LBO Modeling?
Hey Muhammad - I'm so happy to hear that! Yes I plan to release many videos around different subjects of more advanced financial modeling this year, although my real passion is tech / venture rather than PE 🙂. This week I'm going to release a lesson on building a full 3 statement financial model (income statement, balance sheet, and cash flow). Make sure you are subscribed I think it will be helpful!
Eric, amazing stuff. I just subscribed to your channel. I am returning to workforce after 5 years of break. Very nervous to attend interview as i feel outdated. your videos boost confidence. Thank you. Would you have a sample for building finance model for supporting the marketing and sales teams who are responsible for generating the majority of revenue via ads.
It's my pleasure Vinodha. Don't worry, you can do this! Review my video on "customer acquisition cost calcuation", that will help you start understanding how finance can support marketing and also give better forecasts. You can use the market ad spend budget, divide it by CPA (to get units sold), and then use units sold to calculate revenue. That's the best way to calculate revenue !! ua-cam.com/video/8WChmQuTeN0/v-deo.html
Good points Sappy - glad you are thinking about this in a real context. These models are just meant to be frameworks people can use to learn from and adapt, just like you're doing! Hope it was helpful!
Hi Eric ..loved it . Thank u so much for sharing such great work . Just wanted ask one thing .. what about the balance n cash flow statment or is it provided in other video by u .. if yes, please share the link.
Hey Deepti - thanks for the note, happy it was helpful. Yes I have another video on building the balance sheet & cash flow here => ua-cam.com/video/xlXDZyZ9azk/v-deo.html
@@eric_andrews hey thank you so much replying back . Alredy been through this video .. I thought u had sperate continue video for this ecommerce fin model on bal sheet n CF. Thank you .. alwys enjoy ur channel . Subscribed ❤️
@@deeptisharma4272 Hey - great to hear, thank you!!! Yes, the reason I didn't build the the BS & CF for the ecomm model was that most early stage startups have basically no assets and no debt so they just use an income statement with "burn" at the bottom and a cash balance to manage things. Later on when they start to buy more things or have a more complex business the balance sheet and cash flow become more necessary, but most businesses (in my experience) doing under around ~$2MM USD / month in revenue don't need the full 3 statement model, just the simplified version I covered in this video. Hope that helps!
Hey Eric, very informative video. Thanks for sharing this. I have a question, why didn’t you account for CLTV in this sheet? Or is CLTV a function of CAC which you have explained in your other video?
Hey Vinayak - yep, I cover the calculation and the LTV vs CAC relationship in two other specific videos. Here they are: Customer retention & LTV for all business models: ua-cam.com/video/OwCATJh4lNg/v-deo.html LTV for subscription businesses: ua-cam.com/video/eHi875QuVcA/v-deo.html
Thank you Eric, with this video tutorial l really learn from you on how to make complex forecast models simple. I work on program finance and budget for an IP R&D coy in Silicon valley. I need help on how to model long term IP rev recognition. Please l need help in this area. Please can l send you my contact so you can put me through?
Thanks for the really helpful video Eric. I'm building an ecommerce business that has both one time purchase and subscription models, would you then build in an additional set of assumptions in the customer acquisition model with say a lower CAC but higher churn rate and then combine the two in the monthly model?
Hey David, yeah that's exactly what I would do. I would just build them as separate product lines with separate CPAs / marketing budgets and separate revenue streams. One thing to note though is many companies use a one time sample product to try to get people to convert into the subscription, so you might have some sort of conversion from one time -> subscription customers. Again I don't know the specifics of your model but something to think about.
Hay David!! I hope you've had a massive success with your project!! I'd like to ask you a quick doubt: How do you make the revenue recognition with your two different sales types?? I mean, with "suscriptions products" you use the MRR (monthly recurring revenue), but with your "one time sales" products; do you incorporate those sales in your MRR too, or how do you record and track those sales?? Hope you can give some advice 🙌
Maybe as a mature business, but in the venture world we are building brand new companies that lose money in order to scale a hyper-speed, this is easily a $200 million valuation business at the end of year 4! Probably at a 10X revenue multiple which would be reasonable, and maybe even conservative
![[UA] NAVI проти G2 Esports | Blast Premier Fall Final](http://i.ytimg.com/vi/QWlIm4FGESQ/mqdefault.jpg)
![Startup Financial Model for eCommerce [Template Included]](/img/n.gif)
Hi Eric,
I am a graduate student who is trying to learn various business and financial models. I came across your channel a few days back and I can't tell you how much of a treasure it is. Thank you for helping me learn what financial modeling looks like in real-time scenarios. This is so useful for students and freshers who aspire to get real-time experience in modelling.More power to you ! Looking forward for many more amazing contents.
Hi Dhivya - it really means a lot to me to hear your story and that these videos have been really valuable for you. I'll keep trying to democratize this knowledge for all people! Thanks for everything.
Thanks Eric! You uncovered the magic of calculating if business is good or bad to invest!
My pleasure!
You’re the man...simple, concise, and not bland.
I really appreciate that Jay. I think this stuff is interesting and it sounds like you do too! Thanks for checking it out
Great tutorial, really helped me out 🙂
@@innerfreedomhealingschool fantastic!
thank you Eric, I'm a tech guy but can understand your content easily! It's really helpful for me as a non financial person
Awesome to hear it, the more we all understand about what is going on the better we can all build together 😎
This is good Eric. Straight to the point, very well explained.
My pleasure
Thank you Eric from the bottom of my heart! I needed a good format in a short period of time to lay out a financial model. I finally ran across your example and it got me well on my way. I look forward to watching your more detailed model videos soon. Your work is well-planned, concise, and clear. Thank you so much!
Hey really appreciate that feedback so glad my content has been valuable for you. Cheers
Thank u very much brother ERIC
You are very welcome ! 🙌
Thanks Eric for wonderfully explaining the model from scratch. It is very helpful
Very welcome Silky, thanks for checking it out!
Great presentation and easy to understand, been trying to build a professional financial model this has made my life a lot easier.
I'm really glad to hear that, thanks for letting me know. Good luck
Awesome model Eric! Super helpful case study. This is way better than looking at someone's already-built model and trying to figure out how it fits together, or how to start. Thanks!
Hey Kyle - really appreciate that feedback. I'm glad the "starting from an empty sheet" helped you understand the order / mechanics of these types of models. Cheers.
Just love it, very practical, No B.s. Thank you Eric.!Pure value. Subscribed!
That's awesome! Thanks for the subscribe and really glad you found it valuable daniel
Hi Eric ! This video was amazing. One thousand thanks to your excellent work. Well done !
I know this is based on a subscription based model... but what about a standard e-commerce store where we buy the products up front? Also I'd like to factor in a drop-shipping based model too.
1) How do we factor in inventory purchases for a standard retail / e-commerce store environment?
- If I pay shipping on importing those inventory purchases, is that an expense or a cost of good?
2) Do you have a formula for inventory management and planning? How much should I purchase to increase sales?
3) Where do we look to increase financing + adding loan liabilities?
4) Why is there no sales tax / VAT? How can we factor this in?
Thanks again for the great videos… excellent help.
Hey Saul - will do my best to help. In your situation you could do one of two options - (A) just put your shipping and inventory expenses into your P&L, and then record the revenue later on when you sell it, or (B) build a balance sheet and cash flow statement because the business would be investing up-front cash to buy and hold holding significant assets (inventory) for longer periods of time and then selling them off. For that reason, there would be a big different between your P&L model and your actual cash position, hopefully that makes sense. I would do A if it was just my own small business and was trying to figure out the math, but B would be more so outside people could understand it.
1 - that's all cost of goods sold. anything that touches the product (other than marketing) is cost of goods sold
2 - there is no formula, you just want to make sure that you are forecasting your sales (units sold) out far enough that you have time to manufacture and import your product. So, it might take 6 months to get product into the country, so you will want to see how many units you plan to sell over the next 6 months to make sure you have enough inventory. that's basically the main value of a financial model, to anticipate your needs so you can prepare
3 - that's all on the balance sheet. you probably need to build a 3 statement financial model. usually businesses that build up large amounts of inventory use revolving lines of credit or credit cards. you'll make sure you are forecasting both the value of your inventory and your outstanding debt each month to make sure you are managing your liquidity well.
4 - many businesses have no sales tax or VAT. it depends on the type of product & country. I would include those things in revenue.
hope that helps
Thank you so much Mr. Eric.. It is very useful content presented in a very simplified way.
My pleasure. Really glad it helped you Abdul.
Thank you for such a clear and valuable example!
Thanks for the feedback! Really happy you found it valuable Maryna!
Simple and usable. Thank you very much Eric!
My pleasure Olefile! Happy it was valuable for you
Eric you are brilliant! Thank you sharing this and making it easy for other to create simple models !!
Thanks Eric this is really helpful! I've been trying to find this kind of financial modeling info for my side-gig forever. Great explanations 👍🏻
My pleasure! Glad it was useful and let me know if you need anything else.
This was so helpful and a great learning experience. I learned how to formulate a financial forcast as well as a new skill in Microsoft excel👍 if i was able to give more than one like id be spamming
I'm so happy this was valuable for you! Thanks for letting me know!! I really appreciate the like 🙂🙂
I enjoyed your other video on building a 3 stmt fin model, and purchasing the bundle of classes now. Very useful stuff that can be used everyday, thank you!
Sophia ! Thanks so much for your support! So glad you found my content valuable, its my pleasure to help 😀😀
Excellent 👍 this is the stuff I am looking for. Rathe than excel function. Keep it up and looking forward to next one.
I really appreciate you letting me know! I'm working on some more business analysis & modeling style videos right now, and will be releasing them soon. Thanks for the comment 👍😀
Great videos Eric, I've subscribed. Great job and hope to see more content from you!
Thank you!!! Much more to come this year, I appreciate the support and glad it was valuable.
Eric your contents are a treasure . It has helped me immensely . Do you mind explaining us how to add 2-3 revenue streams data into one file . For example , in addition to subscription , if the company earns from a marketplace model or add from revenue in their app , how would they add those in their model ?
I'm happy to hear that. In those scenarios, you would just create a separate section & forecast for each type of revenue & COGS. In your consolidated model, you would probably keep each type of revenue & COGS in it's own account, but just consolidate them all into the same model.
Here is an example of me doing that in one of my other videos: ua-cam.com/video/UBsK07oq1MI/v-deo.htmlsi=Sk8sk_sPbVBsLzhW
Awesome video. I learned a ton that actually will apply well to my small woodworking business
I'm really happy it was helpful and applies to your business as well. Thanks for the note!
Great video, extremely helpful!!
Happy to help Joe
This was really helpfull and important
Pavankumar - really appreciate that. Thanks for the comment.
Very helpful.....indeed
Hi ERIC,I see your model ,it is very much appreciated and I learn more new things through this model and I also see your basic model, appreciated, appreciated,now can you upload something other basic model,
Warm regards
Pushpendra
Hi Pushpendra, here are some of my other modeling videos you can take a look at!
=> Building a 3 statement financial model ua-cam.com/video/xlXDZyZ9azk/v-deo.html
=> E-commerce financial model
ua-cam.com/video/bsmyakxOPLY/v-deo.html
Hi ERIC,This is pushpendra here,I have very basic knowledge about Excel,so that if you upload some besic model on 3 financial statement then it will be helpful for me.
Thanks and Warm regards
Pushpendra
Question: Aren't COGS intended to include all COGS (even for refunded transactions)? Aren't those cost sunk after the transaction occurs?
That said this is super helpful. I always pull these up for my team
Yep, totally. Didn't really cover that in this video but the extra COGS would just hit normally and you'd have the revenue reversed out at the top as "refunds", depends on the business model in some cases can be even 5% of revenue+. One thing I recommend is offering buy one get one free (or other bundles) or discounts where you say "no refunds", can help a lot.
Subscribed
🙏🙏🙏
Very helpful video Eric. One follow up question: how do you account for organic / word of mouth marketing, especially initially / at launch? If the initial customer acquisition is based on viral spread or word of mouth rather than $ spent, would you maintain that as a separate line item in the customer acquisition tab and use the same churn, spend, etc assumptions as paid acquisition customers?
Ya, it's a good question. Most startups actually drive 40% ish percent of their revenue from organic sales (obviously completely depends on the company / situation), but that's what I've seen across some different companies (could be from social media following, PR, SEO, email, etc). I would build a separate line item for that on your acquisition page, with its own assumptions. You could also just model your CAC going down over time as a BLENDED CAC (rather than Paid CAC), meaning a mix of paid and organic new clients, to show the proportion of organic going up thus driving marketing costs down. Either way would be fine. Great question.
hey eric, please give the exact downloadable teemplate because in the income statement assumptions, there are little variations as compared your tutorial.
Make a forecast for software startup with no history sales revenue, but it had Incurred fixed and variable expenses
You haven't looked around my channel yet I can see...you're in for a surprise 😎
how about if I have 2 or 3 price options for Subscription
Hi, great video. Could you provide info on how you dragged the formulas over the several months?--- beginner´s level here :)
Happy to help. Yes, you can either do with with the keyboard, copy the cell with the formula you want (control + C) and highlight the cells you want to paste the formula and then past (control + V).
You can also highlight the area and go to the bottom right highlighted cell and when your cursor makes that tiny black cross click and hold down and then drag the formula.
Maybe check out some of my Excel videos as well, here's a good starting point: ua-cam.com/video/efX9u5hUUY8/v-deo.html
Many thanks Eric for the good job you are doing. In this model, how do we treat Setup (one-off) cost?
Hey Peter, I would just take your "new customers" and make a separate revenue line with a one time cost where you just calculate new customers * one time setup cost ($) for each month. That would probably work.
HI ERIC, plz also share templates with us when you upload a vedio for us for teaching us financial models
Hey Zeenat - you can download templates to all my financial models in the descriptions below the videos!
Hi Eric, I really liked the way you explain this financial model. Would I have a chance to use this model for a restaurant business? Or it wouldn't fit?
Hi Fabio - I think you could use this model as a starting point, although you would probably need to change the revenue & cost model for how a restaurant works. Customers probably return to restaurants at a certain return rate each month, so I think you could use these concepts to build a business plan. Thanks for the comment!
Eric how to calculate the EBITDA and valuations from these details ? Can you help us with the same
EBITDA is just your operating profit + depreciation added back to it. In this video we didn't have any depreciation, so the EBITDA would be the same as your operating income.
Valuations depend a lot on the business factors (% of revenue that is recurring, gross profit margins, growth rate, etc), but generally they are based on a multiple of profit (EBITDA or net income). The multiples depend on the business. A lot of businesses are valued in the 10-30X EBITDA range.
I dive deeper into the multiples-valuation method in this video: ua-cam.com/video/nDa-hjtXC3M/v-deo.htmlsi=40Gm3bVTVSPwR9hq
This was insanely helpful you have no idea! I so look forward to your new videos. I have a question though, regarding CAC, it's so difficult to estimate this value before launching your business. Since it's kind of the backbone of building this model , can you replace it with something else?
Great! No, I would not advise replacing this metric. If you haven't launched the business yet, I would do the math to try to estimate your customer lifetime value (I have a video => ua-cam.com/video/eHi875QuVcA/v-deo.html). Once you know what that is, you will know what your maximum CAC can be in order to run the business profitably. You can put in some CAC assumptions that are lower than your LTV. Once you know what your maximum CAC is, you know the target your business must hit or do better than. CAC and LTV are the backbone of any business, whether you've launched them or not. Cheers.
@@eric_andrews I actually just finished building the whole thing and woow I'm impressed! Will definitely check the video. Thanks again and best of luck.
@@cbfnm awesome!! 👍👍👍👍👍
Hello Eric, the download link for the template doesn´t work anymore.
Thanks!
This was amazing. No BS nothing fancy. Thank you Eric :) Also, are you planning on helping us with financial models on merger & acquisitions, advanced valuations, Leveraged Buyout LBO Modeling?
Hey Muhammad - I'm so happy to hear that! Yes I plan to release many videos around different subjects of more advanced financial modeling this year, although my real passion is tech / venture rather than PE 🙂. This week I'm going to release a lesson on building a full 3 statement financial model (income statement, balance sheet, and cash flow). Make sure you are subscribed I think it will be helpful!
@@eric_andrews looking forward to watching it.
@@GrayWolff Thanks! Published it a few days ago! ua-cam.com/video/xlXDZyZ9azk/v-deo.html
Eric, amazing stuff. I just subscribed to your channel. I am returning to workforce after 5 years of break. Very nervous to attend interview as i feel outdated. your videos boost confidence. Thank you. Would you have a sample for building finance model for supporting the marketing and sales teams who are responsible for generating the majority of revenue via ads.
It's my pleasure Vinodha. Don't worry, you can do this! Review my video on "customer acquisition cost calcuation", that will help you start understanding how finance can support marketing and also give better forecasts. You can use the market ad spend budget, divide it by CPA (to get units sold), and then use units sold to calculate revenue. That's the best way to calculate revenue !! ua-cam.com/video/8WChmQuTeN0/v-deo.html
@@eric_andrews Thank you Eric
@@vinodhakarthik8485 happy to help
Hi eric thank you for this .
But i have to say it , the link to the spreadsheet is labeled as dangerous , i guess it is the ssl of the website
Thanks for letting me know, I will look into that. Hopefully, it still worked for you.
Customer service would go up as you scale - so would fulfillment usually
Good points Sappy - glad you are thinking about this in a real context. These models are just meant to be frameworks people can use to learn from and adapt, just like you're doing! Hope it was helpful!
Hi Eric ..loved it . Thank u so much for sharing such great work .
Just wanted ask one thing .. what about the balance n cash flow statment or is it provided in other video by u .. if yes, please share the link.
Hey Deepti - thanks for the note, happy it was helpful. Yes I have another video on building the balance sheet & cash flow here => ua-cam.com/video/xlXDZyZ9azk/v-deo.html
@@eric_andrews hey thank you so much replying back . Alredy been through this video .. I thought u had sperate continue video for this ecommerce fin model on bal sheet n CF.
Thank you .. alwys enjoy ur channel . Subscribed ❤️
@@deeptisharma4272 Hey - great to hear, thank you!!! Yes, the reason I didn't build the the BS & CF for the ecomm model was that most early stage startups have basically no assets and no debt so they just use an income statement with "burn" at the bottom and a cash balance to manage things. Later on when they start to buy more things or have a more complex business the balance sheet and cash flow become more necessary, but most businesses (in my experience) doing under around ~$2MM USD / month in revenue don't need the full 3 statement model, just the simplified version I covered in this video. Hope that helps!
@@eric_andrews yes thanks alot 😊❤️
Hey Eric, very informative video. Thanks for sharing this. I have a question, why didn’t you account for CLTV in this sheet? Or is CLTV a function of CAC which you have explained in your other video?
Hey Vinayak - yep, I cover the calculation and the LTV vs CAC relationship in two other specific videos. Here they are:
Customer retention & LTV for all business models: ua-cam.com/video/OwCATJh4lNg/v-deo.html
LTV for subscription businesses: ua-cam.com/video/eHi875QuVcA/v-deo.html
What does benefits really mean in the "personal cost" i don't get it. Why 25% and why should we consider it? If someone can help me. Much appreciated.
Healthcare insurance & payroll taxes basically.
Thank you Eric, with this video tutorial l really learn from you on how to make complex forecast models simple. I work on program finance and budget for an IP R&D coy in Silicon valley. I need help on how to model long term IP rev recognition. Please l need help in this area. Please can l send you my contact so you can put me through?
Thanks for the really helpful video Eric. I'm building an ecommerce business that has both one time purchase and subscription models, would you then build in an additional set of assumptions in the customer acquisition model with say a lower CAC but higher churn rate and then combine the two in the monthly model?
Hey David, yeah that's exactly what I would do. I would just build them as separate product lines with separate CPAs / marketing budgets and separate revenue streams. One thing to note though is many companies use a one time sample product to try to get people to convert into the subscription, so you might have some sort of conversion from one time -> subscription customers. Again I don't know the specifics of your model but something to think about.
Hay David!! I hope you've had a massive success with your project!!
I'd like to ask you a quick doubt: How do you make the revenue recognition with your two different sales types?? I mean, with "suscriptions products" you use the MRR (monthly recurring revenue), but with your "one time sales" products; do you incorporate those sales in your MRR too, or how do you record and track those sales??
Hope you can give some advice 🙌
Good spreadsheet, terrible business!
Maybe as a mature business, but in the venture world we are building brand new companies that lose money in order to scale a hyper-speed, this is easily a $200 million valuation business at the end of year 4! Probably at a 10X revenue multiple which would be reasonable, and maybe even conservative