Question

A football club is considering buying a player on 1 January for USD 20 million. The player's wages will be USD 15,000 per month higher than the man he will replace. The manager expects the purchase to generate a level increase in attendance which will yield an extra income in the first year of USD 90,000 from home matches. The manager also expects the new player to increase the club's chance of reaching the Cup Final in any one year from 6% to 25% . The extra amount generated for club funds by an appearance in a cup final on 30 April is USD 1 million.

The club plays a home on the second of each month throughout the year, but all cup matches are played away from home. Wages are paid at the end of each month . Wages, ticket prices and the reward for reaching a Cup final rise at 4% pa, the increment taking place on 1January.

If the player is purchased , the cost will be borrowed from a bank, which will charge interest at 2% per month and will accept repayment at any time. The owner of the club insists that any purchase should show a profit if the managers expectation are borne out in practice.

(a) If the manager expects that he will keep the player for 9.5 years until he retires. Calculate the NPV of the cash flow , in order to assess whether or not the purchase should go ahead

(b) The purchase goes ahead. Attendances rise as expected, but the club does not reach the Cup final and 12 months after been bought the player is sold again. The club owner calculates that he has made a profit of USD 979,490. Calculate the sale price

Answer 1

Discount Factor	4%								All - Amount - $
Calculation Of Net present Value ( NPV)
	Year 0	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Year 8	Year 9	Year 10
Initial Cash outflow	-2,00,00,000
Incremental Wages($15000 monthly *12* Inflation factor)		-1,80,000	-1,87,200	-1,94,688	-2,02,476	-2,10,575	-2,18,998	-2,27,757	-2,36,868	-2,46,342	-1,28,098
Income from Increased Attendance($90000*12*Inflation rate)		10,80,000	11,23,200	11,68,128	12,14,853	12,63,447	13,13,985	13,66,545	14,21,206	14,78,055	7,68,588
Incremental income from Cup Final($1000000*(25%-6%)*Inflation Rate		1,90,000	1,97,600	2,05,504	2,13,724	2,22,273	2,31,164	2,40,411	2,50,027	2,60,028	1,35,215
Interest Expenses( $20000000*2%*12)		-48,00,000	-48,00,000	-48,00,000	-48,00,000	-48,00,000	-48,00,000	-48,00,000	-48,00,000	-48,00,000	-24,00,000
Total Inflow		-37,10,000	-36,66,400	-36,21,056	-35,73,898	-35,24,854	-34,73,848	-34,20,802	-33,65,634	-33,08,260	-16,24,295
Total Outflow	-2,00,00,000
Net present Value ( Total Inflow - Outflow)	-5,32,89,048
Discount Factor -4%		1.000	1.040	1.082	1.125	1.170	1.217	1.265	1.316	1.369	1.423

So , NPV is showing Negative , No need to club to buy the Player

Calculated Sales price	Amnt($)
Initial Cost	2,00,00,000
Add - Wages	1,80,000
Less Income from Attendance	-10,80,000
Interest Expenses	48,00,000
Add - profit	979490
Total Sale Price	2,48,79,490