Professional Football Club Finance: Wage-to-Revenue, Player Registration Amortisation, Transfer Instalments, Matchday & Broadcast Income

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Build Redmarsh Athletic's revenue for one season: matchday income from games, attendance and yield per fan, broadcast income from a fixed share plus a merit payment looked up by final position, and commercial income.
• Work out Redmarsh's wage-to-revenue ratio, its squad cost from the counted wage groups and amortisation, the squad cost ratio under a fictional league rule and the headroom or excess in money.
• Amortise eight fictional player registrations over their contracts, work out the season's charge and the book value per player and in total, and reset the schedule after a contract extension.
• Work out the book value at sale and the profit on disposal of four fictional player sales, compare the profit with the cash that actually arrives this season and flag a sale below book value.
• Turn four fictional transfer deals into payables and receivables per year, work out the net transfer cash, the net transfer spend and the present value of the instalments with NPV.
• Compare next season in Tier 1 and Tier 2 of the fictional Lantern League: revenue by level, a wage bill cut by relegation clauses, the operating result, the break-even wage bill and a probability-weighted result.
• Build Redmarsh's quarterly cash flow, separate operating cash from transfer cash, find the low point of the season and work out how much owner funding keeps a minimum cash buffer.
• Build a five-season dashboard for Redmarsh: wage ratio and squad cost ratio per season, a fictional rule check, revenue growth with POWER, the number of seasons above the limit and a line chart of revenue against wages.