Question

In: Finance

A sports team has a stadium that holds a maximum of 36,000 fans. The league has suggested that the owners of the team consider expanding its seating to 40,000.

A sports team has a stadium that holds a maximum of 36,000 fans. The league has suggested that the owners of the team consider expanding its seating to 40,000. The cost of permits, project management, and construction is expected to be $40,000 per seat. Work can be accomplished over two years, at which time the club will have 4,000 additional seats to sell. Assume the investment would occur equally over years 0 and 1.

Each seat will generate an additional $3,500 of revenue per year for the first three years after completion, $4,000 per year for the next four years, and $5,000 per year for the next four years, at which time a replacement or major renovation of the park will be necessary.

a. If the cost of capital is 15%, will this project be economically feasible, given the information provided? What is the NPV? IRR?

b. The team has approached city officials to seek a subsidy from the city to guarantee a 10% return on the project. How much would the city have to advance at the beginning to accomplish this?

c. What steps might management consider to make the project more economically attractive? Show your analysis.

Solutions

Expert Solution

Given:

Existing capacity  =  36,000 seats

Proposed capacity  =  40,000 seats

Increased capacity  =  40,000 - 36,000  =  4,000 seats

Cost of the project  =  4,000*$40,000  =  $ 160,000,000

The cost has been distributed over the two years (50% in year 0, 50% in year 1)

 

a.

We construct the cash flow table as:

(In this calculation we have not considered about the depreciation and tax, and salvage value had been considered as  =  zero)

  A B C  =  B-A
Year Project cost Expected revenue (Price per seat* number of additional seat) Net cash flow
0 $ 80,000,000   -$ 80,000,000
1 $ 80,000,000   -$ 80,000,000
2   $ 14,000,000 $ 14,000,000
3   $ 14,000,000 $ 14,000,000
4   $ 14,000,000 $ 14,000,000
5   $ 16,000,000 $ 16,000,000
6   $ 16,000,000 $ 16,000,000
7   $ 16,000,000 $ 16,000,000
8   $ 16,000,000 $ 16,000,000
9   $ 20,000,000 $ 20,000,000
10   $ 20,000,000 $ 20,000,000
11   $ 20,000,000 $ 20,000,000
12   $ 20,000,000 $ 20,000,000
13   $ 20,000,000 $ 20,000,000

 

Calculation of NPV:

NPV(15%) = - $80,000,000 - $80,000,000/(1 + 15%) + $14,000,000/(1 + 15%)2 + $14,000,000/(1 + 15%)3 + $14,000,000/(1 + 15%)4 + $16,000,000/(1 + 15%)5 + $16,000,000/(1 + 15%)6 + $16,000,000/(1 + 15%)7 + $16,000,000/(1 + 15%)8 + $20,000,000/(1 + 15%)9 + $20,000,000/(1 + 15%)10 + $20,000,000/(1 + 15%)11 + $20,000,000/(1 + 15%)12 + $20,000,000/(1 + 15%)13NPV(15%)

                  =  - $80,000,000 - $80,000,000/(1 + 15%) + $14,000,000/(1 + 15%)2 + $14,000,000/(1 + 15%)3 + $14,000,000/(1 + 15%)4 + $16,000,000/(1 + 15%)5 + $16,000,000/(1 + 15%)6 + $16,000,000/(1 + 15%)7 + $16,000,000/(1 + 15%)8 + $20,000,000/(1 + 15%)9 + $20,000,000/(1 + 15%)10 + $20,000,000/(1 + 15%)11 + $20,000,000/(1 + 15%)12 + $20,000,000/(1 + 15%)13

                  = - $73,735,434

 

Calculation of IRR:

We calculate the IRR as the discount rate (R) that makes NPV as zero.

So,

NPV = 0 =  - $80,000,000 - $80,000,000/(1 + R) + $14,000,000/(1 + R)2 + $14,000,000/(1 + R)3 + $14,000,000/(1 + R)4 + $16,000,000/(1 + R)5 + $16,000,000/(1 + R)6 + $16,000,000/(1 + R)7 + $16,000,000/(1 + R)8 + $20,000,000/(1 + R)9 + $20,000,000/(1 + R)10 + $20,000,000/91 + R)11 + $20,000,000/(1 + R)12 + $20,000,000/(1 + R)13.......................(1)

 

Solving from equation (1) for R (by trial and error method or by using the IRR formula in Microsoft Excel )we get:

R = 3.54%R = 3.54%

 

So IRR of the project  =  3.54%

 

b.

We calculate the NPV of the project at @10%

From the equation (1) we replace R  =  10% to get the NPV of the project @10% cost of capital as:

NPV(10%) =  - $51,066,857.......................(2)

So get the NPV  =  0 the subsidy will be required  = $ 51,066,857

 

c.

Option (1) : The project can be completed in one year, so that the revenue can be generated from year 1.

In such case the cash flow will be as below:

  A B C  =  B-A
Year Project cost Expected revenue (Price per seat* number of additional seat) Net cash flow
0 $ 160,000,000   -$ 16,00,00,000
1   $ 14,000,000 $ 14,000,000
2   $ 14,000,000 $ 14,000,000
3   $ 14,000,000 $ 14,000,000
4   $ 16,000,000 $ 16,000,000
5   $ 16,000,000 $ 16,000,000
6   $ 16,000,000 $ 16,000,000
7   $ 16,000,000 $ 16,000,000
8   $ 20,000,000 $ 20,000,000
9   $ 20,000,000 $ 20,000,000
10   $ 20,000,000 $ 20,000,000
11   $ 20,000,000 $ 20,000,000
12   $ 20,000,000 $ 20,000,000

In such case the IRR will be increased to 3.81%

 

Option (2): Consideration of the salvage value:

The analysis has been done considering there is no salvage value, but in reality it is not true because the operation will be continue even after 13 years subjected to additional renovation. If we consider the salvage value  =  50% of the project cost, the cash flow will be:

  A B C D  =  B-A  + C
Year Project cost Expected revenue (Price per seat* number of additional seat) Salvage Value Net cash flow
0 $ 80,000,000     -$ 8,00,00,000
1 $ 80,000,000     -$ 8,00,00,000
2   $ 14,000,000   $ 14,000,000
3   $ 14,000,000   $ 14,000,000
4   $ 14,000,000   $ 14,000,000
5   $ 16,000,000   $ 16,000,000
6   $ 16,000,000   $ 16,000,000
7   $ 16,000,000   $ 16,000,000
8   $ 16,000,000   $ 16,000,000
9   $ 20,000,000   $ 20,000,000
10   $ 20,000,000   $ 20,000,000
11   $ 20,000,000   $ 20,000,000
12   $ 20,000,000   $ 20,000,000
13   $ 20,000,000 $ 80,000,000 $ 100,000,000

In such case, the IRR will be increased to 7.16%

 

Option (3): Consideration of the incremental income from other seats:

 We have considered that there will be no incremental revenue from existing seats , however if there is any incremental revenue from the old seating arrangements, the project will also be more attractive.


a. So IRR of the project  =  3.54%

b. NPV  =  0 the subsidy will be required  = $ 51,066,857

Related Solutions

A Major League baseball team wants to reach out to fans in their stadium to offer...
A Major League baseball team wants to reach out to fans in their stadium to offer them seat upgrades. Which technology would you suggest they use? Multiple Choice Facebook Twitter Beacon Network Interconnected If Katy Perry tweets a closeup of her eyelashes, lengthened using her favorite CoverGirl mascara, CoverGirl will have instantly reached all her millions of followers. This is an example of the Multiple Choice network effect. connected effect. information effect. dynamic effect. timeliness effect. What is the third...
A minor league baseball team plays in a stadium that holds 6,000 spectators. With ticket prices...
A minor league baseball team plays in a stadium that holds 6,000 spectators. With ticket prices at $8, the average attendance had been 3,500. When ticket prices were lowered to $6, the average attendance rose to 4,500. a) (8 points) Find the ticket price ? as a function of the attendance ?. You can assume ticket price is linearly related to attendance. b) (4 points) What ticket price will fill the stadium? What ticket price will ensure there are no...
Consider a Little League team that has 15 players on its roster. (a) How many ways...
Consider a Little League team that has 15 players on its roster. (a) How many ways are there to select 9 players for the starting lineup? ways (b) How many ways are there to select 9 players for the starting lineup and a batting order for the 9 starters? ways (c) Suppose 7 of the 15 players are left-handed. How many ways are there to select 3 left-handed outfielders and have all 6 other positions occupied by right-handed players? ways
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT