Subscription Meal Kit Financial &DCF Valuation Model

Description
Subscription Business Trends
A subscription box business model is marked by the charging of recurring payments for customers in exchange for a regularly delivered box of services.


This could be daily, weekly, monthly, quarterly, or even yearly. As long as there is an automatic recurring charge, you have a subscription business model. It’s similar to how Software as a Service (SaaS) products work, only with boxes of products in place of software services.


The subscription box business has gained popularity starting in the 2010s to reshape the customer value chain, giving consumers more options and less friction.


Among them, subscription-based meal kit is one of the fastest-growing food delivery businesses in the US. The business delivers perfectly portioned, pre-packaged ingredients and recipe cards to home cooks in need of handholding.


Use of the Model
- This is a real case based, well-structured and fully- developed financial & valuation analysis model that can well help users to understand and analyze subscription business model particularly for meal kit segmentation.


- Moreover it would be an useful analysis tool for bidders on the potential opportunity on this type of business and facilitate a better decision.


- Finally, this ready-to-use template can be used in business plan as the financial forecast by simply customizing the assumptions according to your real case.


Model’s Features
- Highly developed
In order to better demonstrate how the business works, we have established detailed operation assumptions including initial investment, operations, users, churn rate, pricing, debt schedule, depreciations. And the calculation from the assumptions to outputs also has been well broken down.
The model has been performed on quarterly basis in order to fit the seasonality feature of the sector.
The results has then been rolled up to yearly for valuation analysis.


- Highly dynamic
User can easily tailor the model by simply modifying the inputs of the assumption to suit their real purpose.


- Application of financial modeling best practice
The model is ready-to-use and is well structured based on the Best Practice of Financial Modeling and utilized One-Page Model style that facilitates users to easily follow the logic of the model and understand the formula of the calculation without need of switching from sheet to sheet.


- Simplicity
The template is greatly user-friendly either for professional analysts or for users with little experience of financial modeling since its simply design pattern and easy to follow logic.
To guarantee the users satisfaction, the model does not place any complicated formulas or VBA code. The structure and content have been created following the Best Dashboard Principles and considering the high level of flexibility and user-friendly in priority.


Support
Please feel no hesitate to contact us if you experience any problem when using the models provided.
In addition, if you need a customized model for your specific business, please just let us know and we would be happy to help you with this.


Model’s Structure
• TOC – Table of Content
• Illustration— Visualization of Subscription Meal Kit business
• Model –
 Assumptions
 Forecast of the Number of the Subscriptions & Orders
 Forecast of the Revenue
 Other Calculations
 Depreciation & Amortization
 Debt Schedule
 Pro-forma of Profit & Loss - Monthly
 Pro-forma of Cash Flow - Monthly
 Pro-forma of Profit & Loss - Yearly
 Pro-forma of Cash Flow - Yearly
 Pro-forma of Balance Sheet - Yearly
 Valuation
 Sensitivity Analysis
 KPI
• Dashboard—Graphics