Скачать с ютуб Build a Financial Model for Your B2C Subscription Startup в хорошем качестве

Build a Financial Model for Your B2C Subscription Startup

Learn how to build a full financial model for an e-commerce startup (subscription-based business) in Excel in this case study-style tutorial. Also included is a downloadable template of the model. 📌 Don't miss the new series: The ULTIMATE Subscription Box Financial Model | Part 1:    • The ULTIMATE Subscription Box Financi...   ✅ Download the Excel template: https://www.ericandrewsstartups.com/o... 🚀 If you want to master the finance skills & frameworks to successfully scale technology startups, secure your spot in my "Finance for Startups" program, today: https://www.ericandrewsstartups.com/f... Communities: 💼 Linkedin:   / eric-andrews-1624b656   ☑️ Twitter/X:   / eric__andrews   🌟 Instagram:   / ericandrews_startups   🔥 Discord: https://bit.ly/discord_eric 💻 Newsletter: https://bit.ly/joinericnewsletter 🎥 Clips:    / @ericandrewsclips7818   Related Startup Videos: 🚩    • 3 Ways to Increase LTV for Subscripti...   🚩    • Why Launch a Rotating Club | Mystery ...   🚩    • How to Calculate Unit Economics & LTV...   🚩    • How Prepaid Subscriptions Are Increas...   🚩 Playlist:    • Finance for eCommerce   ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ In this video, we look at how to build a financial model from scratch for a subscription-based coffee delivery startup in Excel (would also apply to a SaaS company or any subscription business model). This is the type of model that venture capital funds would want to understand before investing in a company. One key point in building startup financial models is that we need to build the simplest and most flexible model we can (so that we can easily update it), while still building a model robust enough to model out the reality of our revenue, expenses, etc. This is difficult but you'll see that if we organize our assumptions well (with good color coding and formula writing), we can create something simple that we can use as a tool to adjust as our forecasts inevitably change. Through building this financial model, we're able to examine the profit margins, breakeven point, burn rate, and the cash runway this eCommerce startup has until it needs to raise more venture funding. This type of model would serve as a good internal budgeting model as well as an external model to sound out to potential investors during fundraising. Sections: 0:30 Discussion around company business model, current fundraising status, and why we need to build the model 1:06 Customer acquisition model (tab) setup & formatting 2:00 Which metric to start the model with and build off of (marketing) 2:55 Customer acquisition costs (CAC) and calculating orders from advertising budget 5:20 How to forecast new and recurring orders for a subscription business 6:28 Churn rates and how we build them into our subscription startup model 8:48 Starting and formatting the full monthly income statement model 9:36 Assumptions for revenue 11:37 Assumptions for the cost of goods sold (COGS) 14:49 Assumptions for a quick & simple payroll model (and general operating expenses) 19:55 Assumptions for other operating expenses 20:19 Why learning to use Excel without the mouse is important & how to improve 23:24 Revenue section & formulas of the income statement model 26:55 COGS & gross profit section of the income statement 27:28 Discussion (excel tip) on locked cell references and how to utilize them to improve formulas 29:19 Operating expenses (including payroll model) section of the income statement 35:43 Operating income and finalizing the income statement 36:44 Adjusting assumptions for the business model 37:40 Creating the overall quarterly rollup summary income statement (tab) 40:36 Discussion of what "runway" is in venture capital and how to use this model to manage cash burn 41:58 Double checking the model 42:55 Case study style discussion of business model, cash positions, and analysis of future prospects My name is Eric and I've worked for seven years in Silicon Valley in finance. This is the type of financial model that I build for eCommerce startups, but would really work for any small businesses. I decided to publish it on Youtube because I believe it is the type of knowledge we should democratize, and that I would have greatly benefitted from as I started my career. ► Subscribe for more finance videos: https://bit.ly/EricAndrewsSubscribe #financialmodel #startups #ecommerce #subscriptionbusiness