retired_TigressTrista

Thanks for the suggestion. I have edited my spreadsheet into notebook so let's see how this looks. I have omitted the league position as this is a study on money.

Season 20007/2008 1st September

ClubBank (m)Actual WageBudgeted Wage Difference
Arsenal£72£707,605£829,901£122,296
Aston Villa£47£428,394£496,690£68,296
Birmingham£4£298,309£302,446£4,137
Blackburn£2£410,936£458,333£47,397
Bolton£6£428,253£417,732-£10,521
Chelsea£92£1,488,061£1,699,358£211,297
Derby£1£229,538£218,119-£11,419
Everton£15£580,709£606,760£26,051
Fulham-£1£410,130£409,895-£235
Liverpool£28£1,142,323£1,287,551£145,228
Man City£38£547,697£622,057£74,360
Man Utd£12£1,085,055£1,202,817£117,762
Middlesbrough£7£490,949£538,303£47,354
Newcastle£40£840,401£915,775£75,374
Portsmouth£50£550,331£612,795£62,464
Reading£11£341,656£400,114£58,458
Sunderland£9£222,071£223,370£1,299
Tottenham£5£621,974£709,842£87,868
West Ham£11£721,802£842,962£121,160
Wigan£12£257,161£287,421£30,260

retired_TigressTrista

Didn't work so the next best thing is a picture of my spreadsheet Overview

I'll put one of these in each of my quick summaries. The second update will be up this afternoon.

retired_rn321

Arsenal is CRAZY rich!!!! thats mad man!

retired_rn321

Oh and KUTGW :thup:

retired_TigressTrista

Season 2007/2008 1st February 2008

All wages are based on a weekly basis. Bank balance figures stated are rounded to the nearest million as they can be seen via screenshots.

Quick Summary: A real split in how teams are going about their business. Teams like Sunderland are showing great control and seen impressive financial results because of it. Newcastle in contrast are really pushing the boat out to achieve their targets. Man Utd look in trouble now going into a negative balance. Aston Villa, Bolton and Derby are all over their wage budgets. Overview

Arsenal Have seen their bank balance drop to £55m. Wages have increased to £764,054 but is still well under the new budget of £887,004.

Aston Villa Their bank balance has decreased to £30m. Wages have increased by a massive £140,000 to £563,863 putting it over the new budget of £551,462.

Birmingham Their bank balance has doubled to £8m. Wages have slightly increased to £299,795 just under the budget of £302,418.

Blackburn Have massively increased their bank balance to £11m. Wages have increased to £422,001 well under the increased budget of £472,527.

Bolton Their bank balance has increased to £9m. Wages are getting out of control however now spending £473,617 well over the budget of £417,704.

Chelsea Their bank balance has fallen to £82m. Wages have increased slightly to £1,495,162 still well under the budget of £1,776,811.

Derby Are showing good signs of improvement increasing their bank balance to £6m. Wages however are still increasing to £244,531 over the budget of £218,035.

Everton Their bank balance has increased to £21m. Wages have decreased to £536,605 well under the increased budget of £645,126.

Fulham Have seen their bank balance go from a negative to a positive £2m. Wages have decreased to £400,604, which means they are now under their budget of £409,867.

Liverpool Their bank balance has dipped to £20m. Wages have decreased slightly to £1,141,393 well under the increased budget of £1,351,284.

Man City Have seen their bank balance more than halve to £16m. Wages have increased a lot to £661,646 but are still under the new budget of £734,270.

Man Utd Have worryingly seen the bank balance drop to -£7m. Wages have increased despite this to £1,104,573 under the budget of £1,202,789.

Middlesbrough Have seen their balance increase to £8m. Wages have increased slightly to £491,052 under the budget of £538,163

Newcastle Have seen their bank balance drop massively to £11m. Wages have also had a huge increase to £988,305 still under the increased budget of £1,057,585.

Portsmouth Have seen their bank balance drop to £34m. Wages have had a large increase to £640,250 well under the new budget of £713,145.

Reading Have had a good increase in their bank balance of £15m. Wages have increased to £381,279 still nicely under the new budget of 429,023.

Sunderland Have managed to double their bank balance to £18m. Wages are similar to before with actual been £222,554 just under the budget of £224,714.

Tottenham Have seen their bank balance increase to £8m. Wages have decreased to £611,363 well under the budget of £709,842.

West Ham Have seen their bank balance decrease to £4m. Wages have increased to £795,294 eating into their budget of £842,962.

Wigan Have seen their bank balance increase to £13m. Wages have increased to £304,514 under the new budget of £324,921.

retired_charytine

Interesting so far. :thup:

I could put that into code if you like? or are you fine with the screenies of excel, I'm not fussed.

retired_TigressTrista

It's probably easier for me just to do screenies of excel.

Thank you for the offer though.

retired_charytine

Okay, kutgw anyways. :thup:

retired_TigressTrista

Season 2007/2008 1st June 2008

All wages are based on a weekly basis. Bank balance and wage increase figures stated are rounded. Results are compared to 1st September.

Quick Summary: Most clubs continue to provide good financial results. Most are keeping within budgets and are making a profit and seeing higher funds into bank accounts. Everton and Sunderland are doing particularly well. Villa, Newcastle and Man City all recorded a loss. Villa, Bolton and Derby are still over their wage budgets. Derby, Fulham and Reading were relegated so will need to keep tight control over their finances. Overview

Arsenal Finished the league in 2nd place. Their bank balance recovered well to £75m in the last sector and finishing with slightly high figure than the start of the year. Wages finish on £865,590 around £160,000 higher than the start of the season. Wages are currently £19,800 under budget and considering their high profit of £33m this year and champions league football next year they seem to be in a sound financial position.

Aston Villa Finished 11th in the league. Their bank balance was £13m lower than the start of the season. Wages finished on £557,279 which is around £130,000 higher than the start of the season. Wages are currently over budget by £5,873 and considering their loss of £8m they will need to perform better on the pitch to continue at current levels of spending.

Birmingham Finished 17th in the league. Their bank balance finished on £16m a great season for them. Wages finished on £289,278 which was £3,000 lower than the start of the season and £13,140 under budget. Impressive profit of £15m, premiership football next year, and under wage budget means a great season for them.

Blackburn Finished 13th in the league. Their bank balance finished on £20m 5 times higher than the start of the season. Wages finished on £411,034 which was roughly the same as the start of the season and currently £61,409 under the wage budget. Impressive results for Blackburn of £22m profit.

Bolton Finished 15th in the league. Their bank balance finished on £17m, 3 times has high on the start of the season. Wages finished £437,094 which was around £9,000 higher than the start of the season and £19,418 over budget. Impressive profit of £25m means the overspend on wages should be fine.

ChelseaFinished 4th in the league. Their bank balance finished £101m, £9m up on the start of the season. Wages finished on £1,513,062 which is around £20,000 higher than the start of the season and £263,693 under budget. £27m profit for the year plus champions league football will mean Chelsea can be pleased.

Derby Finished 20th in the league. Their bank balance finished on £10m impressive considering it only started on £1m. Wages finished on £258,299 £30,000 higher than the start of the season and £40,320 over budget. £15m profit for the year but relegation and current over spending could see Derby in trouble if they do not get a quick return to the prem.

Everton Finished 6th in the league. Their bank balance more than doubled to £34m. Wages finished on £497,035 managing to cut £80,000 from the wage bill putting themselves £147,979 under budget. Profit of £21m, Europe and a lot of money to spare on wages put Everton in a very strong position.

Fulham Finished 19th in the league. Their bank balance rose from a negative to £4m. Wages finished on £402,294 cutting £8,000 and putting themselves £7,433 under budget. Profit of £6m is good but relegation and a high wage bill for the Championship will mean Fulham need to cut costs.

Liverpool Finished as champions. However success came at a small cost seeing their bank balance decline to £25m. Wages finished on £1,246,807 adding £100,000 to the start of the season but still £104,449 under budget. Profit of £5m plus silverware means Liverpool should be very happy.

Man City Finished 12th in the league. Their bank balance however declined to £22m. Wages finished £663,031 adding £110,000 to the cost to the start of the season but still £71,211 under budget. A loss of £9m and a bank balance in decline mean Man City need to watch their spending more.

Man Utd Finished 3rd in the league. Their bank balance showed improvement to £18m, good considering they went into negatives. Wages finished on £1,126,354 around £40,000 higher than the start of the season but £76,379 under budget. Man U recorded impressive profit of £59m and should be fine as long as champions league football continues.

Middlesbrough Finished 13th in the league. Their bank balance increased well to £18m. Wages finished on £491,647 around the same as the start of the season and £46,460 under budget. Profits of £15m and a place in Europe mean Middlesbrough should be looking to improve next season.

Newcastle Finished in 5th. Their bank balance decreased hugely to £13m. Wages finished on £994,091 a massive £150,000 added to it but still £63,438 under budget. A loss of £10m, loss in funds and higher wages show a team that pushed out the boat to get a champions league place but missed it. Must look to get funds back in place or get champions league to continue soundly.

Portsmouth Finished in 6th. Their bank balance decreased slightly to £43m. Wages finished on £646,145 a £95,000 increase but £66,972 under budget. A loss of £14m is worrying but can be cut by better spending in the transfer market. A EURO Vase place.

Reading Finished in 18th.Their bank balance increased to £17m Wages finished on £404,978 increasing around £60,000 but still £24,055 under budget. Profit of £11m but may need to cut wages to be stable in the championship.

Sunderland Finished in 9th. Their bank balance quadrupled to £37m.Wages finished on £235,515 increasing by £13,000 and £14,382 under budget. Profit of £39m and still in the prem means Sunderland can increase spending nicely.

Tottenham Finished in 10th. Their bank balance rose well to £16m. Wages finished on £641,850 increasing by £20,000 and £67,964 under budget. Profit of £21m means Tottenham can spend more to get the results they want.

West Ham Finished in 7th. Their bank balance decreased slightly to £10m. Wages finished on £750,294 increasing by about £30,000 and £92,640 under budget. Profit of £3m means West Ham should be careful about increasing wages much more so they continue to be profitable.

Wigan Finished in 16th. Their bank balance rose to £20m. Wages finished on £318,987 increasing by about £60,000 and £5,876 under budget. Profit of £16m means Wigan look good at the moment.

retired_TigressTrista

Season 2008/2009 1st September 2008
All wages are based on a weekly basis. Bank balance figures stated are rounded to the nearest million as they can be seen via screenshots.

Quick Summary: Most clubs have taken it upon themselves to increase their wages some like Sunderland rather excessively. Only Fulham and Man Utd have cut their wage bill. Derby, Sunderland and Wigan are currently over spending on wages and Wigan are the only side to have a negative balance. In total clubs are now paying wages £2,523,157 per week higher than the same time last season. Most clubs have seen their bank balance decrease but this is to be expected with teams strengthening for the up and coming season. There is now however £1m more money in the clubs balances. Overview

Arsenal Have increased their bank balance to £85m. Wages have increase by about £95,000 to £961,591 they are under the budget of £1,267,129. Predicted to finish 3rd.

Aston Villa Have seen a small decrease in their bank balance to £33m. Wages have increased by about £86,000 to £643,777 they are under the budget of £825,055. Predicted to finish 10th.

Birmingham Have seen a decrease in bank balance to £10m.Wages have increased by about £140,000 to £433,233 they are under the budget of £448,187. Predicted to finish 20th.

Blackburn Have seen a decrease in bank balance to £11m. Wages have increased by about £130,000 to £540,057 they are under the budget of £624,629. Predicted to finish 13th.

Bolton Have seen a decrease in bank balance to £3m. Wages have increased by about £80,000 to £520,703 they are under the budget of £557,128. Predicted to finish 15th.

Chelsea Have seen a decrease in their bank balance to £77m. Wages have increased by about £35,000 to £1,548,488 they are under the budget of £1,935,607. Predicted to finish 4th.

Derby Have seen an increase in their bank balance to £13m. Wages have increased by about £80,000 to £338,607 this takes them over the budget of £336,404. Strange for a side that has been relegated to be adding to the wage bill so much. Predicted to finish 3rd Championship.

Everton Have seen a decrease in their bank balance to £14m. Wages have increased by about £110,000 to £607,953 they are under the budget of £700,238. Predicted to finish 6th.

Fulham Have seen an increase in their bank balance to £7m. Wages have decreased by about £35,000 to £366,083 they are under the budget of £407,591. Predicted to finish 1st Championship.

Liverpool Have seen a decrease in their bank balance to £11m. Wages have increased by about £30,000 to £1,279,104 they are under the budget of £1,527,577. Predicted to finish 1st.

Man City Have seen a decrease in their bank balance to £15m. Wages have increased by about £80,000 to £741,778 they are under the budget of £905,941. Predicted to finish 12th.

Man Utd Have seen a massive increase in their bank balance to £70m. Wages have decreased by about £40,000 to £1,088,074 they are under the budget of £1,360,075. Predicted to finish 2nd.

Middlesbrough Have seen a decrease in their bank balance to £7m. Wages have increased by about £60,000 to £555,808 they are under the budget of £602,401. Predicted to finish 14th.

Newcastle Have seen a decrease in their bank balance to £9m. Wages have increased by about £100,000 to £1,097,200 they are under the budget of £1,209,772. Predicted to finish 5th.

Portsmouth Have seen a decrease in their bank balance to £20m. Wages have increased by about £170,000 to £817,536 they are under the budget of £949,895. Predicted to finish 9th.

Reading Have seen an increase in their bank balance to £32m. Wages have increase by only a few hundred pounds to £405,357 they are under the budget of £509,210. Predicted to finish 2nd championship.

Sunderland Have seen a decrease in their bank balance to £1m. Wages have increased by about £210,000 to £448,086 they are over the budget of £388,645. Predicted to finish 11th.

Tottenham Have seen an increase in their bank balance to £33m. Wages have increased by about £105,000 to £748,517 they are under the budget of £867,178. Predicted to finish 8th.

West Ham Have seen an increase in their bank balance to £16m. Wages have increased by about £17,000 to £767,753 they are under the budget of £878,142. Predicted to finish 7th.

Wigan Have seen a decrease in their bank balance to -£2m. Wages have increased by about £100,000 to £416,807 they are over the budget of £403,764.Predicted to finish 19th.