All Studios P&L

Row Labels Revenue $ mi Budget $ mi p/l $ mi p/l % MaxTarget $

Bollywood $949.49 $213.00 $736.49 345.8% $166.43
Arka Media Works $81.25 $22.50 $58.75 261.1% $42.73
Dharma Productions $28.88 $11.13 $17.75 159.6% $12.17
DVV Entertainment $150.00 $68.75 $81.25 118.2% $54.87
Hombale Films $156.25 $12.50 $143.75 1150.0% $165.78
Mythri Movie Makers $45.00 $25.00 $20.00 80.0% $14.13
Salman Khan Films $184.88 $33.75 $151.13 447.8% $166.43
Vinod Chopra Films $230.50 $30.00 $200.50 668.3% $135.40
Vinod Chopra Productions $5.13 $1.25 $3.88 310.0% $3.46
Yash Raj Films $25.00 $5.00 $20.00 400.0% $22.23
Zee Studios $42.61 $3.13 $39.49 1263.6% $39.80
Hollywood $18,314.80 $3,054.08 $15,260.72 499.7% $6,000.00
20th Century Fox $2,847.00 $237.00 $2,610.00 1101.3% $2,244.60
Castle Rock Entertainment $73.30 $25.00 $48.30 193.2% $47.33
Columbia Pictures $307.10 $55.00 $252.10 458.4% $229.41
Liberty Films $3.30 $3.18 $0.12 3.8% $0.86
Marvel Studios $9,054.60 $1,988.70 $7,065.90 355.3% $6,000.00
Paramount Pictures $2,493.00 $207.20 $2,285.80 1103.2% $2,194.37
Syncopy $1,006.00 $185.00 $821.00 443.8% $640.38
Universal Pictures $1,828.70 $188.00 $1,640.70 872.7% $1,427.41
Warner Bros. Pictures $701.80 $165.00 $536.80 325.3% $467.02
Grand Total $19,264.29 $3,267.08 $15,997.21 489.6% $6,000.00
All Studios P&L

Target & mIllion Actuals - Target $ mi Actuals - Target %

$657.01 $79.48 10.8%
$42.73 $16.02 27.3%
$12.17 $5.58 31.4%
$54.87 $26.38 32.5%
$165.78 -$22.03 -15.3%
$14.13 $5.87 29.4%
$166.43 -$15.31 -10.1%
$135.40 $65.10 32.5%
$3.46 $0.41 10.6%
$22.23 -$2.23 -11.2%
$39.80 -$0.31 -0.8%
$13,251.38 $2,009.34 13.2%
$2,244.60 $365.40 14.0%
$47.33 $0.97 2.0%
$229.41 $22.69 9.0%
$0.86 -$0.74 -616.7%
$6,000.00 $1,065.90 15.1%
$2,194.37 $91.43 4.0%
$640.38 $180.62 22.0%
$1,427.41 $213.29 13.0%
$467.02 $69.78 13.0%
$13,908.38 $2,088.82 13.1%
studio target
20th Century Fox $2,244.60
Arka Media Works $42.73
Castle Rock Entertainment $47.33
Columbia Pictures $229.41
Dharma Productions $12.17
DVV Entertainment $54.87
Government of West Bengal $0.30
Hombale Films $165.78
Liberty Films $0.86
Marvel Studios $6,000.00
Mythri Movie Makers $14.13
Paramount Pictures $2,194.37
Salman Khan Films $166.43
Syncopy $640.38
Universal Pictures $1,427.41
Vinod Chopra Films $135.40
Vinod Chopra Productions $3.46
Warner Bros. Pictures $467.02
Yash Raj Films $22.23
Zee Studios $39.80
 Top Grossing Movies

Row Labels Budget USD mi Revenue USD mi Profit USD mi

Hollywood
Titanic $200.00 $2,202.00 $2,002.00
The Shawshank Redemption $25.00 $73.30 $48.30
Avatar $237.00 $2,847.00 $2,610.00
Avengers: Endgame $400.00 $2,798.00 $2,398.00
Avengers: Infinity War $400.00 $2,048.00 $1,648.00
Captain America: The First Avenger $216.70 $370.60 $153.90
Captain America: The Winter Soldier $177.00 $714.40 $537.40
Doctor Strange in the Multiverse of Madness $200.00 $954.80 $754.80
Gladiator $103.00 $460.50 $357.50
Inception
Interstellar $165.00 $701.80 $536.80
It's a Wonderful Life $3.18 $3.30 $0.12
Jurassic Park $63.00 $1,046.00 $983.00
Parasite $15.50 $263.10 $247.60
Schindler's List $22.00 $322.20 $300.20
The Dark Knight $185.00 $1,006.00 $821.00
The Godfather $7.20 $291.00 $283.80
The Pursuit of Happyness $55.00 $307.10 $252.10
Thor: Love and Thunder $250.00 $670.00 $420.00
Thor: Ragnarok $180.00 $854.00 $674.00
Thor: The Dark World $165.00 $644.80 $479.80
Bollywood
3 Idiots $6.88 $50.00 $43.13
Baahubali: The Beginning $22.50 $81.25 $58.75
Bajirao Mastani $17.50 $43.75 $26.25
Bajrangi Bhaijaan $11.25 $146.13 $134.88
Dilwale Dulhania Le Jayenge $5.00 $25.00 $20.00
K.G.F: Chapter 2 $12.50 $156.25 $143.75
Kabhi Khushi Kabhie Gham $4.88 $17.00 $12.13
Munna Bhai M.B.B.S. $1.25 $5.13 $3.88
Pather Panchali $0.88 $1.25 $0.38
PK $10.63 $106.75 $96.13
Pushpa: The Rise - Part 1 $25.00 $45.00 $20.00
Race 3 $22.50 $38.75 $16.25
RRR $68.75 $150.00 $81.25
Sanju $12.50 $73.75 $61.25
Shershaah $6.25 $11.88 $5.63
Sholay
Taare Zameen Par $1.50 $16.88 $15.38
The Kashmir Files $3.13 $42.61 $39.49
imdb rating

7.90
9.30
7.80
8.40
8.40
6.90
7.80
7.00
8.50
8.80
8.60
8.60
8.20
8.50
9.00
9.00
9.20
8.00
6.80
7.90
6.80

8.40
8.00
7.20
8.10
8.00
8.40
7.40
8.10
8.30
8.10
7.60
1.90
8.00

8.40
8.10
8.30
8.30
movie_id_title industry release_year imdb_rating
101:K.G.F: Chapter 2 Bollywood 2022 8.4
102:Doctor Strange in the Multiverse of Madness Hollywood 2022 7
103:Thor: The Dark World Hollywood 2013 6.8
104:Thor: Ragnarok Hollywood 2017 7.9
105:Thor: Love and Thunder Hollywood 2022 6.8
106:Sholay Bollywood 1975 8.1
107:Dilwale Dulhania Le Jayenge Bollywood 1995 8
108: 3 Idiots Bollywood 2009 8.4
109:Kabhi Khushi Kabhie Gham Bollywood 2001 7.4
110:Bajirao Mastani Bollywood 2015 7.2
111: The Shawshank Redemption Hollywood 1994 9.3
112:Inception Hollywood 2010 8.8
113:Interstellar Hollywood 2014 8.6
115:The Pursuit of Happyness Hollywood 2006 8
116:Gladiator Hollywood 2000 8.5
117:Titanic Hollywood 1997 7.9
118:It's a Wonderful Life Hollywood 1946 8.6
119:Avatar Hollywood 2009 7.8
120:The Godfather Hollywood 1972 9.2
121:The Dark Knight Hollywood 2008 9
122:Schindler's List Hollywood 1993 9
123:Jurassic Park Hollywood 1993 8.2
124:Parasite Hollywood 2019 8.5
125:Avengers: Endgame Hollywood 2019 8.4
126:Avengers: Infinity War Hollywood 2018 8.4
128:Taare Zameen Par Bollywood 2007 8.3
129:Munna Bhai M.B.B.S. Bollywood 2003 8.1
124:Parasite Hollywood 2019 8.5
105:Thor: Love and Thunder Hollywood 2022 6.8
130:PK Bollywood 2014 8.1
131:Sanju Bollywood 2018 NULL
132:Pushpa: The Rise - Part 1 Bollywood 2021 7.6
133:RRR Bollywood 2022 8
134:Baahubali: The Beginning Bollywood 2015 8
135:The Kashmir Files Bollywood 2022 8.3
136:Bajrangi Bhaijaan Bollywood 2015 8.1
137:Captain America: The First Avenger Hollywood 2011 6.9
138:Captain America: The Winter Soldier Hollywood 2014 7.8
139:Race 3 Bollywood 2018 1.9
140:Shershaah Bollywood 2021 8.4
studio language_id
Hombale Films 3
Marvel Studios 5
Marvel Studios 5
Marvel Studios 5
Marvel Studios 5
United Producers 1
Yash Raj Films 1
Vinod Chopra Films 1
Dharma Productions 1
1
Castle Rock Entertainment 5
Warner Bros. Pictures 5
Warner Bros. Pictures 5
Columbia Pictures 5
Universal Pictures 5
Paramount Pictures 5
Liberty Films 5
20th Century Fox 5
Paramount Pictures 5
Syncopy 5
Universal Pictures 5
Universal Pictures 5
5
Marvel Studios 5
Marvel Studios 5
1
Vinod Chopra Productions 1
5
Marvel Studios 5
Vinod Chopra Films 1
Vinod Chopra Films 1
Mythri Movie Makers 2
DVV Entertainment 2
Arka Media Works 2
Zee Studios 1
Salman Khan Films 1
Marvel Studios 5
Marvel Studios 5
Salman Khan Films 1
Dharma Productions 1
movie_id budget revenue unit currency
101 1 12.5 Billions INR
102 200 954.8 Millions USD
103 165 644.8 Millions USD
104 180 854 Millions USD
105 250 670 Millions USD
107 400 2000 Millions INR
108 550 4000 Millions INR
109 390 1360 Millions INR
110 1.4 3.5 Billions INR
111 25 73.3 Millions USD
113 165 701.8 Millions USD
114 205 365.3 Millions USD
115 55 307.1 Millions USD
116 103 460.5 Millions USD
117 200 2202 Millions USD
118 3.18 3.3 Millions USD
119 237 2847 Millions USD
120 7.2 291 Millions USD
121 185 1006 Millions USD
122 22 322.2 Millions USD
123 63 1046 Millions USD
124 15.5 263.1 Millions USD
125 400 2798 Millions USD
126 400 2048 Millions USD
127 70 100 Millions INR
128 120 1350 Millions INR
129 100 410 Millions INR
130 850 8540 Millions INR
131 1 5.9 Billions INR
132 2 3.6 Billions INR
133 5.5 12 Billions INR
134 1.8 6.5 Billions INR
135 250 3409 Millions INR
136 900 11690 Millions INR
137 216.7 370.6 Millions USD
138 177 714.4 Millions USD
139 1.8 3.1 Billions INR
140 500 950 Millions INR
406 30 350 Millions INR
412 160 836.8 Millions USD
actor_id name birth_year
50 Yash 1986
51 Sanjay Dutt 1959
52 Benedict Cumberbatch 1976
53 Elizabeth Olsen 1989
54 Chris Hemsworth 1983
55 Natalie Portman 1981
56 Tom Hiddleston 1981
57 Amitabh Bachchan 1942
58 Jaya Bachchan 1948
59 Shah Rukh Khan 1965
60 Kajol 1974
61 Aamir Khan 1965
62 R. Madhavan 1970
63 Sharman Joshi 1979
64 Hrithik Roshan 1974
65 Ranveer Singh 1985
66 Deepika Padukone 1986
67 Tim Robbins 1958
68 Morgan Freeman 1937
69 Leonardo DiCaprio 1974
70 Ken Watanabe 1959
71 Matthew McConaughey 1969
72 Anne Hathaway 1982
73 John David Washington 1984
74 Robert Pattinson 1986
75 Will Smith 1968
76 Thandiwe Newton 1972
77 Russell Crowe 1964
78 Joaquin Phoenix 1974
79 Kate Winslet 1975
80 James Stewart 1908
81 Donna Reed 1921
82 Sam Worthington 1976
83 Zoe Saldana 1978
84 Marlon Brando 1924
85 Al Pacino 1940
86 Christian Bale 1974
87 Heath Ledger 1979
88 Liam Neeson 1952
89 Ben Kingsley 1943
90 Sam Neill 1947
91 Laura Dern 1967
92 Song Kang-ho 1967
93 Lee Sun-kyun 1975
 94 Robert Downey Jr. 1965
95 Chris Evans 1981
150 Kanu Banerjee 1905
151 Karuna Banerjee 1919
152 Darsheel Safary 1997
153 Sunil Dutt 1929
154 Anushka Sharma 1988
155 Ranbir Kapoor 1982
156 Allu Arjun 1982
157 Fahadh Faasil 1982
158 N. T. Rama Rao Jr. 1983
159 Ram Charan 1985
160 Prabhas 1979
161 Rana Daggubati 1984
162 Mithun Chakraborty 1950
163 Anupam Kher 1955
164 Salman Khan 1965
165 Nawazuddin Siddiqui 1967
166 Tommy Lee Jones 1946
167 Sebastian Stan 1982
168 Anil Kapoor 1956
169 Sidharth Malhotra 1985
170 Kiara Advani 1991
movie_id actor_id
101 50
101 51
102 52
102 53
103 54
103 55
103 56
104 54
104 56
105 54
105 55
106 57
106 58
107 59
107 60
108 61
108 62
108 63
109 59
109 57
109 64
110 65
110 66
111 67
111 68
112 69
112 70
113 71
113 72
114 73
114 74
115 75
115 76
116 77
116 78
117 69
117 79
118 80
118 81
119 82
119 83
120 84
120 85
121 86
121 87
122 88
122 89
123 90
123 91
124 92
124 93
125 94
125 95
125 54
126 94
126 95
126 54
127 150
127 151
128 61
128 152
129 51
129 153
130 61
130 154
131 155
131 154
132 156
132 157
133 158
133 159
134 160
134 161
135 162
135 163
136 164
136 165
137 95
137 166
138 95
138 167
139 164
139 168
140 169
140 170
language_id name
1 Hindi
2 Telugu
3 Kannada
4 Tamil
5 English
6 French
7 Bengali
8 Gujarati