Streaming Platform (Netflix, HBO, Disney +, Hulu, Twitch) – Financial Model

Description
Streaming Platform (Netflix) – Financial Model
More and more firms decide to launch their streaming platform that is offering access to content for a subscription. Some of the most famous ones are Netflix, Hulu, Amazon Video, Disney+, HBO Max. Those models are pretty complicated as you have to model a lot of variables.

A few information about the model
1. Customers. In sheet Customers, we model the number of customers based on churn rate and number of customers acquired
2. Sales & Margin. In the sheet Sales & Margin, we model revenues, gross margin, cost of acquisition, retention, logistics costs.
3. Capex. Capex is calculated in sheet Capex, based on the number of customers we have to service. We assume spending money on production facilities, warehouses, and others. There will be also Maintenance Capex. In this sheet, we also calculate in a simplified way the Depreciation.
4. Head Office costs. These costs are calculated in the sheet HQ.
5. Profit and Loss statement. Based on data from previous sheets in the sheet P&L we generate the Profit and Loss statement.
6. Working Capital. Working Capital is calculated in the sheet Work Cap, based on sales and conversion periods assumed for inventory, receivables, and payables.
7. Debt. We assume that the growth will be partially financed by Debt. In this sheet, we calculate the Debt at the end of the year based on assumed loans that we take and repayment of the loans. We also calculate here the financial costs and profits.
8. Cash Flow. Finally, in the sheet CF, we calculate the cash flow based on data from previous sheets