PIF and RB Sports & Media

[Jackie Broon]

I need to get a life I know but I decided to put together a spreadsheet estimating our current squad amortisation costs if it's of interest to anyone but me:

 

 

 

 

 

Edited 6 hours ago by Jackie Broon

[Whitley mag]

4 hours ago, Jackie Broon said:

I need to get a life I know but I decided to put together a spreadsheet estimating our current squad amortisation costs if it's of interest to anyone but me:

 

 

 

That yearly cost for Barnes to sit on the bench ffs get shot.

[TheBrownBottle]

15 hours ago, Jackie Broon said:

 

That leaves out a few important factors, that other players included in our amortisation have become fully amortised in that time (Almiron, Joelinton in particular), that when new contracts are signed the amortisation is spread over the length of the new contract (up to 5 years) so, when contracts are extended it will usually significantly reduce amortisation cost for that player, and that when players are sold or released any profit/loss on their remaining amortisation goes straight into the accounts in full.

 

So in 21/22 our main amortisation costs were actually Trippier, Burn, Bruno, Joelinton, ASM, Wilson, Lewis, Willock, Gayle, Ritchie, Murphy and Dubravka all of which bar Trippier, Burn, Bruno are now effectively off the books and Bruno's yearly amortisation cost would have been roughly halved when he signed his new contract (although obviously his increased wags, signing on fees etc. will probably make up for that).

 

 

They're not all off the books, though they will have been reduced significantly.  Willock will be about 5m per season, Joelinton will be around 2m per season, and BDB just shy of 3m.  Hardly breaks the bank, but it never gets to zero until the player leaves.

 

edit: sorry JB, just saw your list after I posted.  Joelinton will still have around 2m to be added, though.  Amortisation for NUFC is running at close to 100m last I checked.

 

 

Edited 11 hours ago by TheBrownBottle

[Skjaere9]

5 hours ago, Jackie Broon said:

I need to get a life I know but I decided to put together a spreadsheet estimating our current squad amortisation costs if it's of interest to anyone but me:

 

 

 

So earlier Benitez-era transfers (Schar, Dubravka, Murphy, Lascelles) have already amortized down to zero, is that right? Or do they still have some tiny amount left to amortize due to various contract extensions over the years?

 

[TheBrownBottle]

1 minute ago, Skjaere9 said:

So earlier Benitez-era transfers (Schar, Dubravka, Murphy, Lascelles) have already amortized down to zero, is that right? Or do they still have some tiny amount left to amortize due to various contract extensions over the years?

 

No, it never reaches zero - even Lascelles will still have a small amount of amortised book value.  It will be so small as to basically be worthless, but it will still have a value.

[Nucasol]

7 hours ago, Jackie Broon said:

I need to get a life I know but I decided to put together a spreadsheet estimating our current squad amortisation costs if it's of interest to anyone but me:

 

 

 

So theoretically £5.8m of the annual amortisation cost will roll off with the contract expirations of Lewis and Wilson and Miggy’s exit. I see us keeping Krafu for another year so that would stay but reduce a touch. Lascelles and Dubs are missing but they will be absolutely trivial given fee and length of time they’ve been here.

 

Targett, Willock and Barnes are £14.8m in that and if we can get decent-ish money back for the latter two we could book some profit and clear space for incomings. However, we’ll have to be careful to balance this with a potential European campaign and the need for bodies - all depends on whether we’ve got some youngsters who can start to step up.

[Pixelphish]

7 hours ago, Jackie Broon said:

I need to get a life I know but I decided to put together a spreadsheet estimating our current squad amortisation costs if it's of interest to anyone but me:

 

 

 

 

Love a spreadsheet me, Jackie. Thanks.

[loki679]

2 hours ago, Pixelphish said:

 

Love a spreadsheet me, Jackie. Thanks.

 

Dude needs to learn to sort his data.  3/7 WNA.

[Shearergol]

5 hours ago, Whitley mag said:

That yearly cost for Barnes to sit on the bench ffs get shot.

 

Let's not bother with subs. Just have a squad of 11 players and hope for the best.

[christ]

30 minutes ago, Shearergol said:

 

Let's not bother with subs. Just have a squad of 11 players and hope for the best.

They’ll be the first people to complain about squad depth if someone gets injured.

[1964]

I wish I understood stuff

[Jackie Broon]

4 hours ago, TheBrownBottle said:

They're not all off the books, though they will have been reduced significantly.  Willock will be about 5m per season, Joelinton will be around 2m per season, and BDB just shy of 3m.  Hardly breaks the bank, but it never gets to zero until the player leaves.

 

edit: sorry JB, just saw your list after I posted.  Joelinton will still have around 2m to be added, though.  Amortisation for NUFC is running at close to 100m last I checked.

 

 

 

 

Missed Joelinton, I've added him in now.

 

Our latest published accounts from 2023 have it at £89m. The accounts have a breakdown of the costs per year:

 

 

 

Since then we've signed:

Tonali - £12m (amortisation per year)

Barnes - £7.6m

Livramento - £6.2m

Vlachodimos - £4m

Hall - £5.6m

Osula - £3m

 

Total 38.4m

 

Contract renewals that have reduced yearly amortisation:

Bruno - 7.8 to 4.4 = -3.4m

Burn - 5.2 to 2.2 = -3m

Gordon 12.9 to 4.7 = -8.2m

 

Total  -£14.6m

 

So that works out at £95.2m for 2024/25 so my estimate is not far off.

 

 

[Choppy Chop Chop]

1 minute ago, Jackie Broon said:

 

Missed Joelinton, I've added him in now.

 

Our latest published accounts from 2023 have it at £89m. The accounts have a breakdown of the costs per year:

 

 

 

Since then we've signed:

Tonali - £12m (amortisation per year)

Barnes - £7.6m

Livramento - £6.2m

Vlachodimos - £4m

Hall - £5.6m

Osula - £3m

 

Total 38.4m

 

Contract renewals that have reduced yearly amortisation:

Bruno - 7.8 to 4.4 = -3.4m

Burn - 5.2 to 2.2 = -3m

Gordon 12.9 to 4.7 = -8.2m

 

Total  -£14.6m

 

So that works out at £95.2m for 2024/25 so my estimate is not far off.

 

 

Thank you for helping us mere mortals to understand 

[Whitley mag]

1 hour ago, Shearergol said:

 

Let's not bother with subs. Just have a squad of 11 players and hope for the best.

Don’t be silly you clearly need subs, but in this PSR world where not in a position to have a sub who barely plays as the 3rd valued highest yearly player.

 

Where at the limit of PSR and Mitchell is clearly on board that we need cheaper younger players.

[kingxlnc]

This PSR stuff is so boring - adding way too much complexity to a simple game

[PauloGeordio]

PIF Invested in Better! 

[Paully]

15 hours ago, Jackie Broon said:

I need to get a life I know but I decided to put together a spreadsheet estimating our current squad amortisation costs if it's of interest to anyone but me:

 

 

 

 

 

 

 

Great stuff this mate - appreciate it!