Calculation details for Nani

Step #1 - Historical movie details for Nani

No Movie Year Tamilnadu Collection Domestic Collection Overseas Collection Total Collection
1 Bhale Bhale Magadivoy 2015 30.00 37.54 10.70 48.24
2 Majnu 2016 19.20 22.70 4.38 27.08
3 Gentleman 2016 21.60 25.00 7.33 32.33
4 Krishna Gaadi Veera Prema Gaadha 2016 15.00 16.65 5.95 22.60
5 Nenu Local 2017 43.80 49.95 8.44 58.39
6 Ninnu Kori 2017 40.50 47.20 9.48 56.68

Step #2 - Adjust collections based on inflation rate

We all know that movie ticket prices aren't what they used to be. The cost of consumer goods and services rise each year. So, taking inflation into account is the only way to meaningfully compare the box office collection of movies over time. Ideally we should use India inflation rate for adjusting box office collection in India and inflation rate from respective countries for overseas collection. For simplicity, our calculations assume US inflation rate as the basis for adjusting the box office collection of all overseas countries. We also take into account the currency rate change over a period of time to accurately calculate the present box office collection values of historical movies.

Step #2a - Collect data to calculate inflation (courtesy www.worldbank.org, www.wikipedia.org/)

Year India Inflation Rate India CPI (Consumer Price Index)
2015 5.872426595 147.6569875
2016 4.97 154.99553977
2017 0.8 156.235504088
Year US Inflation Rate US CPI (Consumer Price Index)
2015 0.118627136 108.695722
2016 1.3 110.108766386
2017 2.5 112.86148554565
Year Average US Dollar to Indian Rupees Exchange Rate
2015 64.20012
2016 67.26527
2017 67.69355

Step #2b - Apply inflation

Present box office collection value of historical movies is calculated by using a simple formula:

Collection(y) = ( CPI(y) / CPI(x) ) * Collection(x)

where "x" represents historical CPI and box office collection values and "y" represents current values.

Example domestic calculations for Bhale Bhale Magadivoy
Bhale Bhale Magadivoy release year
2015
2015 CPI value
147.6569875
Current CPI value
156.235504088
India collection in 2015
37.54 Cr
Inflation adjusted collection
(156.235504088 / 147.6569875 ) * 37.54 = 39.72Cr
Example overseas calculations for Bhale Bhale Magadivoy
Bhale Bhale Magadivoy release year
2015
2015 CPI value
108.695722
2015 USD to INR exchange rate
64.20012
Current CPI value
112.86148554565
Current USD to INR exchange rate
67.69355
Overseas collection in 2015
10.70 Cr = 10.70/64.20012 = $1.67MM
Present value of collection USD
(112.86148554565 / 108.695722 ) * 1.6666635514077 = $1.73 MM
Present value of collection INR
$1.73MM * 67.69355 = 11.71 Cr

Total Bhale Bhale Magadivoy collection in 2015 = 37.54 + 10.70 = 48.24 Cr

Present value of Bhale Bhale Magadivoy collection = 39.72 + 11.71 = 51.44 Cr

Step #2c - Calculate present value of collection based on inflation for all movies

No Movie Year Inflation Adjusted Tamilnadu Collection Inflation Adjusted Domestic Collection Inflation Adjusted Overseas Collection Inflation Adjusted Total Collection
1 Bhale Bhale Magadivoy 2015 31.74 39.72 11.71 51.44
2 Majnu 2016 19.35 22.88 4.52 27.40
3 Gentleman 2016 21.77 25.20 7.56 32.76
4 Krishna Gaadi Veera Prema Gaadha 2016 15.12 16.78 6.14 22.92
5 Nenu Local 2017 43.80 49.95 8.44 58.39
6 Ninnu Kori 2017 40.50 47.20 9.48 56.68

Step #3 - Calculate expected collection based on weightage

For calculating expected collection for an actor, we give appropriate weightage to the movies based on several factors. The weighted average is used to calculate the expected collection of an actor.
No Movie Year Inflation Adjusted Total Collection Weightage Collection * Weightage
1 Bhale Bhale Magadivoy 2015 51.44 2.00 102.87
2 Majnu 2016 27.40 1.00 27.40
3 Gentleman 2016 32.76 2.00 65.52
4 Krishna Gaadi Veera Prema Gaadha 2016 22.92 1.00 22.92
5 Nenu Local 2017 58.39 2.00 116.78
6 Ninnu Kori 2017 56.68 2.00 113.36
Total 10 448.85

Total expected collection for Nani = 448.85/10 = 44.89 Cr