My company is estimating the feasibility of entering into a contract to build and operate the metro rail network in Vish
Posted: Sat Nov 27, 2021 5:27 pm
My company is estimating the feasibility of entering into a
contract to build and operate the metro rail network in
Vishakapatnam. As part of the financial analysis, I want to
understand the impact of customer traffic on total revenue. It
is determine that the total revenue is dependent on the
advertisement boards put up at metro stations and the revenue from
sale of metro tickets to passengers. Assume that on an average, the
expected ticket price per passenger is 40 Rs and the number of
passengers travelling in the metro per month is 50,000. Further,
the average monthly revenue generated from advertisements and
billboards is Rs. 6,15,000. I want to assess how a variation
in the number of passengers by 5% and advertising revenue by 10%
will affect the overall revenue of the metro project. Using
Microsoft Excel, assist me in finding out the revenues after
consideration of these variations.
contract to build and operate the metro rail network in
Vishakapatnam. As part of the financial analysis, I want to
understand the impact of customer traffic on total revenue. It
is determine that the total revenue is dependent on the
advertisement boards put up at metro stations and the revenue from
sale of metro tickets to passengers. Assume that on an average, the
expected ticket price per passenger is 40 Rs and the number of
passengers travelling in the metro per month is 50,000. Further,
the average monthly revenue generated from advertisements and
billboards is Rs. 6,15,000. I want to assess how a variation
in the number of passengers by 5% and advertising revenue by 10%
will affect the overall revenue of the metro project. Using
Microsoft Excel, assist me in finding out the revenues after
consideration of these variations.