Link to SS here
https://drive.google.com/file/d/1wnTUrswQy_b_o-PBPAX_VT-yX00zvHAM/view?usp=sharing
If anyone is interested in any of this nonsense the Price of Football book is available at Amazon (go via NSC obvs) for just £9.99 and 100% of the royalties go to the foodback charity Trussell Trust
Will see what I can do, will take a bit of time as the table is collated from individual worksheets on clubs. If I get a chance might upload my full spreadsheet onto Google Docs so people can pick up individual numbers and point out that my Excel skills are frankly shit.
This is the formula used, it's broadly based on the PhD paper of Doctor Tom Markham, who is the guy in charge as SI Games, creators of the marvelous waste of time that is Football Manager.
It's not perfect, but was 99.9% accurate in the Arsenal buyout by Kroenke when to acquired Usmanov's...
Intuitively I'm with you 100%.
The model is based on the business model of the club. Burnley's is to make a profit every year and they deliver on that. The Albion's model is to keep losses to a reasonable level until the investment in the academy and training facilities starts to pay dividends...
Hi LLJ
There's two player costs in the profit and loss account.
Registration cost (paid to the previous employer) which is as you correctly point out, spread over the contract period as an amortisation cost. The club can of course sell the player registration at a profit at a future date so...
Burnley are in my opinion (others are of course available) the best run club financially in the Premier League and the valuation reflects that. Gut reaction is that they should be lower in the table but they make money each year, keep wages low and have a strong balance sheet...and they do it...
It's more to do with Burnley's ability to generate profits every year, relatively high season finishes (which generates extra prize money) compared to their wage bill and having little debt on the balance sheet.
If anyone is interested I've put out a report on club values, Albion came in 18th at £187 million using the MMM formula.
The short version
The long version
http://priceoffootball.com/2728-2/
Two clubs, Newcastle United (owned by a FCW) and Crystal Palace (small club) have been valued on...