Sport Team / Football Club Financial Model in Excel
Originally published: 28/09/2021 15:20
Publication number: ELQ-99751-1
View all versions & Certificate
certified

Sport Team / Football Club Financial Model in Excel

Sports Team / Football Club Financial Model in Excel

Description
Sports Team / Football Club Financial Model in Excel
Sport teams have interesting business models. They can earn from many sources but also they have a lot of cost position. Using the football team we model the financial performance of such a business. This is an annual model. By altering the cells in blue you can adjust the model to your needs.
A few information about the model
1. Payers. In sheet “Players”, we model the number of players we want to have but also from where they will come. Some will come from our Youth Academy, whereas others will be bought from other teams. We also model revenues from transfers. The costs are calculated separately for the First Team (sheet FirstTeam) and Youth Academy (sheet YouthAcademy).
2. Sales & Margin. We start by estimating revenues from different revenues in separate sheets. In the sheet Matches, we calculate the revenues from matches played on grounds, in the sheet “Gadgets” we have revenues from selling gadgets, T-shirts, etc. In separate sheets, we also model Sponsorship revenues and TV ads. In the sheet Sales & Margin, we summarize all 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 have2 main types of Capex for Content: Acquisition Capex and Retention Capex. In a separate sheet (Depreciation) we model the Depreciation by cohorts and Net Value of Assets.
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

This Best Practice includes
1 Excel model

Asen Gyczew offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


5.0 / 5 (1 votes)

please wait...