Naga Mahanth - E-commerce Financial Model
Are you a e-commerce business founder with dreams of becoming next big thing in
D2C or E-commerce segment?
Are you looking for a kick-ass financial model that will help you in pitching to investors / managing cash flows?
Your wait for a financial model ends here..
Features of Financial Model
Fully integrated model: Changes in one sheet will automatically reflect in other sheet
Logical Flow: All sheets are segmented in a way that they connect logically
KPI Sheets: The summary sheets with important KPIs and Charts are included so that it is easy for reader to understand concepts. This is the key sheet VCs spend more time on.
This is an example of e-commerce financial model for a company in Baby and Mother segment
Sheets in the financial model
To start with, the model has a table of contents linked to each sheet and a summary of business background.
Summary Section
Summary Section contains KPI sheet and Charts sheet.
The KPI sheet comes from a broader understanding of the segment.
It contains 20+ KPIs showing various trends of unit economics, financial, marketing and growth parameters.
The KPIs also includes cash burn by month, cash runway.
Any other metrics that is of interest to Management can also be included.
Charts section contains 3 charts broadly showing trends in revenue, EBITDA, CAC & LTV:CAC ratios, Sales orders etc.,
3 Statements
The usual 3 statements i.e. Profit & Loss Statement (PL), Balance Sheet (BS), Cash Flow Statement (CFS) are presented here.
The 3 statements are presented yearly and PL comes with horizontal and vertical analysis highlighting key ratios.
Profit & Loss statement
Balance sheet
Cash flow statement
Profit & Loss - Month on Month
Month on Month PL is also included for the sake of understanding trends.
Workings
'Workings' segment includes input sheets and various workings sheets viz Revenue, Opex, Payroll, Capex etc.,
The input sheets are bifurcated as:
a. Revenue inputs
b. Expenses, Assets and Liabilities inputs
Revenue - Inputs Sheet
Expenses, Assets & Liabilities - Inputs sheet
Revenue
Revenue workings
Opex sheet
Payroll sheet
Capex sheet
