0% found this document useful (0 votes)
31 views9 pages

Theater Revenue and Profit Analysis

Optimization problem like network

Uploaded by

Muhammad Hayat
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
31 views9 pages

Theater Revenue and Profit Analysis

Optimization problem like network

Uploaded by

Muhammad Hayat
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Description Value

Development Cost 5,000,000


Shows per Week 8
Projected Run Time
100
(weeks)
Theater Operating Cost
1,000
per Show
Ticket Price 50
Concession Profit per
1.5
Ticket
Theater Capacity 800
Expected Occupancy
80%
Rate
Target Return (as a
2
multiple)
Calculating Per Show Revenue and Costs
Description Formula / Value
Expected Attendance
640
per Show
Ticket Revenue per
32000
Show
Concession Revenue per
960
Show
Total Revenue per Show 32960
Theater Operating Cost
1,000
per Show
Profit per Show 31,960
Calculating Weekly Revenue and Costs
Description Formula
Total Weekly Revenue 263680
Total Weekly Operating
8000
Cost
Total Weekly Profit 255680
Calculate Required Weeks for 100% Return
Description Formula
Total Profit Target 10000000
Weeks Needed for
40
Target Return rounded to 40 weeks because answer should be in wee
Sensitivity Analysis for Occupancy Rate
Expected
Occupancy Rate Attendance per
Show
80% 640
85% 680
90% 720
Expected Results in the Table:
Ticket Price Weeks Run Weekly Profit Total Profit
$50 100 $255,680 $25,568,000
$55 100 $281,280 $28,128,000
$50 120 $255,680 $30,681,600
$55 120 $281,280 $33,753,600
use answer should be in weeks
Cell Description Value
A2 Unit Selling Price 50
A3 Unit Variable Cost 10
A4 Current Market Size 300,000
Current Market Share
A5 30%
(English Version)
Expected Market Growth
A6 10%
(Years 1-5)
Expected Market Growth
A7 5%
(Years 6-10)
French Version
A8 6,000,000
Development Cost
New Market Share (with
A9 40%
French Version)
A10 Planning Horizon (Years) 10
b
Calculate Annual Market Size
Year 1 330000
Year 2 363000
Year 3 399300
Year 4 439230
Year 5 461191.5
Year 6 484251.075
Year 7 508463.62875
Year 8 533886.8101875
Year 9 560581.150696875
Year 10 588610.208231719

Calculating Units Sold per Year


1 132000
2 145200
3 159720
4 175692
5 184476.6
6 193700.43
7 203385.4515
8 213554.724075
9 224232.46027875
10 235444.083292688

Calculate Revenue and Variable Costs per Year


Revenue Calculation
1 6600000
2 7260000
3 7986000
4 8784600
5 9223830
6 9685021.5
7 10169272.575
8 10677736.20375
9 11211623.0139375
10 11772204.1646344
Variable Cost Calculation
1 1320000
2 1452000
3 1597200
4 1756920
5 1844766
6 1937004.3
7 2033854.515
8 2135547.24075
9 2242324.6027875
10 2354440.83292688
Calculate Operating Profit
1 5280000
2 5808000
3 6388800
4 7027680
5 7379064
6 7748017.2
7 8135418.06
8 8542188.963
9 8969298.41115001
10 9417763.33170751
Calculate Taxes and After-Tax Profit
Tax Calculation
1 2112000
2 2323200
3 2555520
4 2811072
5 2951625.6
6 3099206.88
7 3254167.224
8 3416875.5852
9 3587719.36446
10 3767105.332683
After-Tax Profit Calculation
1 3168000
2 3484800
3 3833280
4 4216608
5 4427438.4
6 4648810.32
7 4881250.836
8 5125313.3778
9 5381579.04669
10 5650657.9990245

Depreciation Calculation
1 1200000
2 1200000
3 1200000
4 1200000
5 1200000
6 0
7 0
8 0
9 0
10 0
Free Cash Flow (FCF) Calculation
1 4368000 initial inve -6000000
2 4684800
3 5033280
4 5416608
5 5627438.4
6 4648810.32
7 4881250.836
8 5125313.3778
9 5381579.04669
10 5650657.9990245
NPV Calculation for Different Discount Rates
Discount
NPV Calculation
Rate
5% -Rs6,000,000.00
10% -Rs6,000,000.00
15% -Rs6,000,000.00
20% -Rs6,000,000.00
Cell Description Value
Prototype Development
A2 500,000
Cost
A3 Depreciation Period (Years) 5
A4 Selling Price per Widget 40
A5 Variable Cost per Widget 20
A6 Initial Market Size (Year 1) 100,000
A7 Market Growth Rate 5%
A8 Market Share 30%
A9 Tax Rate 40%
A10 Planning Horizon 5 years

Calculate Annual Market Size


1 100,000
2 105000
3 110250
4 115762.5
5 121550.625

Calculate Units Sold per Year


1 30000
2 31500
3 33075
4 34728.75
5 36465.1875

Calculate Revenue and Variable Costs per Year


Revenue Calculation
1 1200000
2 1260000
3 1323000
4 1389150
5 1458607.5
Variable Cost Calculation
1 600000
2 630000
3 661500
4 694575
5 729303.75
Calculate Depreciation
1 100000
2 100000
3 100000
4 100000
5 100000
Calculate Operating Profit
1 500000 0
2 530000 0
3 561500 0
4 594575 0
5 629303.75 0

Calculate Taxes and After-Tax Profit


Tax Calculation
1 200000
2 212000
3 224600
4 237830
5 251721.5
After-Tax Profit Calculation
1 300000
2 318000
3 336900
4 356745
5 377582.25
Free Cash Flow (FCF) Calculation
1 400000
2 418000
3 436900
4 456745
5 477582.25
2189227.25
an increase in market share changes profit.
Market Share Cumulative FCF (5 Years)
10% 2000000
20% 2180000
30% 2378000
40% 2595800
50% 2835380

increase in market size growth changes profit


market growth rates Total FCF
5% 2189227
7% 2270266
10% 2189227
12% 6857329
15% 2627257

Common questions

Powered by AI

Key variables affecting NPV include discount rates, initial investment costs, projected cash inflows (revenue and profit), and time horizon for evaluation. The NPV remains constant across different discount rates as shown in the calculations provided .

A 10% decrease in occupancy, from 80% to 70%, would lower the expected number of attendees per show, thus reducing ticket revenue and overall weekly revenue proportionally. Since the current occupancy yields $263,680 weekly revenue, the revised figures need to be calculated based on the new expected attendance .

Depreciation is calculated as $1,200,000 annually for the first 5 years, after which it is no longer factored into costs. This reduces taxable income in the initial years, thus affecting the operating profit which increases after depreciation ceases .

The tax rate, applied to operating profit, determines the amount paid as tax, thus impacting the after-tax profit. The remaining profit, adjusted for non-cash items like depreciation, is used in calculating free cash flow, showing cash actually generated .

With a weekly profit of $255,680 at a ticket price of $50, achieving a target profit of $25,568,000 would require 100 weeks, as calculated by dividing the target profit by the weekly profit .

If the ticket price is increased to $55, the expected weekly profit would be $281,280. This assumes that the theater maintains the same number of shows per week and occupancy rate, as indicated in the table showing expected results .

An increase in market share results in higher cumulative free cash flow over 5 years. For example, increasing market share from 10% to 50% raises cumulative FCF from $2,000,000 to $2,835,380 .

By analyzing different combinations of occupancy rates and ticket prices, one can identify which scenarios yield the highest profit margins. For example, varying both variables can uncover the most profitable strategy, guiding pricing and marketing efforts .

At a 5% growth rate, the annual market size after 5 years increases to 121,550.625 units, from an initial size of 100,000 units, as calculated by continuously applying the growth rate over the years .

The theater operating cost per show directly reduces the total weekly profit since it is deducted from the revenue generated per show. Higher operating costs result in lower profit margins, impacting overall profitability .

You might also like