Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2 . A . Build the new stadium table [ [ Project analysis: New Stadlum ] , [ , 0 , 1 , 2

2.A. Build the new stadium
\table[[Project analysis: New Stadlum],[,0,1,2,3,4,5,6,7,8,9,10,11,12,13],[,200,,,201,201,201,201,201,201,201,201,201,201,],[Year,7,2008,2009,0,1,2,3,4,5,6,7,8,9,2020],[Initial investment,,-125,-125,,,,,,,,,,,],[\table[[|ncrementa|],[Revenues:]],,,,,,,,,,,,,,],[Attendance (old,,,,,,10.7,11.6,12.7,13.8,15.1,16.4,17.9,19.5,],[Rev**1.4-Old Rev),,,,9.01,9.82,1,7,2,7,2,8,6,8,20.36],[\table[[Sponsorship (old],[Rev*1.2-Old Rev)]],,,,4.07,4.43,4.83,5.27,5.74,6.26,6.82,7.43,8.10,8.83,9.19],[Totalincremental,,,,13.0,14.2,15.5,16.9,18.4,20.1,21.9,23.9,26.0,28.4,],[Revenues,,,,8,6,4,4,6,2,4,1,6,1,29.55],[\table[[Incremental],[Operating Expenses],[(oldx'1.14-Old)]],,,,2.58,2.68,2.79,2.90,3.02,3.14,3.26,3.40,3.53,3.67,3.82],[EBITDA.,,,,\table[[10.5],[0]],\table[[11.5],[7]],\table[[12.7],[5]],\table[[14.0],[4]],\table[[15.4],[5]],\table[[16.9],[9]],\table[[18.6],[7]],\table[[20.5],[2]],\table[[22.5],[3]],\table[[24.7],[4]],25.73],[depreciation,,,,\table[[25.0],[0]],\table[[25.0],[0]],\table[[25.0],[0]],\table[[25.0],[0]],\table[[25.0],[0]],\table[[25.0],[0]],\table[[25.0],[0]],\table[[25.0],[0]],\table[[25.0],[0]],\table[[25.0],[0]],],[\table[[Free Cash Flow/ Rfter],[tax operating cash],[flow]],,,,\table[[15.5],[7]],\table[[16.2],[7]],\table[[17.0],[4]],\table[[17.8],[7]],\table[[18.7],[9]],\table[[19.7],[9]],\table[[20.8],[9]],\table[[22.0],[8]],\table[[23.4],[0]],\table[[24.8],[3]],16.72],[\table[[terminal],[value/Residual Value]],,,,,,,,,,,,,,\table[[284.6],[5]]],[discounting factor,1,0.91,0.82,0.75,0.68,0.62,0.56,0.51,0.46,0.42,0.38,0.35,0.31,0.29],[discounted Cash flow,,\table[[113.5],[2]],\table[[103.1],[0]],\table[[11.6],[7]],\table[[11.0],[7]],\table[[10.5],[3]],\table[[10.0],[3]],9.58,9.16,8.78,8.43,8.11,7.82,86.17],[NPV,\table[[35.2],[9]],,,,,,,,,,,,,]]
Please add the forumlas that go behind these numbers. Thank you!
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Finance Its Development Mathematical Foundations And Current Scope

Authors: T. Wake Epps

1st Edition

0470431997, 9780470431993

More Books

Students also viewed these Finance questions

Question

How do you generate strategic options? Which techniques might help?

Answered: 1 week ago

Question

Learn about HRM development in Poland in recent years.

Answered: 1 week ago