Adjusting Exchange Rates... (First post updated with Jason's new list)

[Jason]

Added 10 films to the master table:

• Pirates of the Caribbean: At World's End
• Harry Potter and the Deathly Hallows Part 1
• The Hobbit: The Desolation of Smaug
• The Hobbit: The Battle of the Five Armies
• Harry Potter and the Order of the Phoenix
• Harry Potter and the Half-Blood Prince
• Spider-Man 3
• Spectre
• Batman v Superman: Dawn of Justice
• The Hunger Games: Catching Fire

Also updated the exchange rate adjustment to be current as of August 19.

 

Archived table as of August 5 (for reference purposes):

Spoiler

The "Worldwide", "Domestic", and "OS Total" show the original unadjusted gross. The "Tracked" column shows the unadjusted gross in territories that have individual tracking and therefore can be adjusted based on their exchange rates. To adjust the untracked gross, I take a weighted average of the USD exchange rate in the tracked territories, with the weight determined by the proportion of overall gross from those territories. This is just an approximation, but one that I hope is more accurate than no adjustment at all. The "OS Adj" column shows the adjusted OS total combining the tracked and untracked OS gross. The "WW Adj" column combines the adjusted OS total with the original domestic total. All figures are in US$ millions.

 

Title	Year	Worldwide	Domestic	OS Total	Tracked	OS Adj	WW Adj
Avatar	2009^	$2,788.0	$760.5	$2,027.5	$1,949.4	$1,638	$2,398
Star Wars: The Force Awakens	2015	$2,068.2	$936.7	$1,131.6	$1,107.1	$1,145	$2,082
Jurassic World	2015	$1,670.4	$652.3	$1,018.1	$959.5	$965	$1,618
Marvel's The Avengers	2012	$1,519.6	$623.4	$896.2	$842.9	$706	$1,329
Furious 7	2015	$1,516.0	$353.0	$1,163.0	$1,084.8	$1,084	$1,437
Avengers: Age of Ultron	2015	$1,405.4	$459.0	$946.4	$919.7	$877	$1,336
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$381.0	$960.5	$927.9	$728	$1,109
Frozen	2013	$1,276.5	$400.7	$875.7	$843.1	$751	$1,152
Iron Man 3	2013	$1,215.4	$409.0	$806.4	$756.0	$652	$1,061
Minions	2015	$1,159.4	$336.0	$823.4	$763.1	$771	$1,107
Transformers: Dark of the Moon	2011	$1,123.8	$352.4	$771.4	$748.2	$630	$983
Skyfall	2012	$1,108.6	$304.4	$804.2	$761.0	$661	$966
Transformers: Age of Extinction	2014	$1,104.1	$245.4	$858.6	$792.5	$725	$971
The Dark Knight Rises	2012	$1,084.9	$448.1	$636.8	$610.4	$529	$977
Toy Story 3	2010	$1,063.2	$415.0	$648.2	$633.0	$535	$950
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$241.1	$804.6	$778.1	$600	$841
Alice in Wonderland	2010	$1,025.5	$334.2	$691.3	$635.2	$544	$879
Zootopia	2016	$1,023.1	$341.3	$681.9	$671.6	$686	$1,027
The Hobbit: An Unexpected Journey	2012	$1,021.1	$303.0	$718.1	$678.8	$569	$872
The Dark Knight	2008^	$1,004.6	$534.9	$469.7	$440.1	$381	$916
Despicable Me 2	2013	$970.8	$368.1	$602.7	$571.5	$485	$853
Finding Nemo	2003^	$936.7	$380.8	$555.9	$454.8	$511	$891
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$196.6	$690.1	$661.0	$506	$703
Ice Age: Continental Drift	2012	$877.2	$161.3	$715.9	$683.3	$558	$720
Inside Out	2015	$857.4	$356.5	$501.0	$499.8	$468	$824

 

Edited October 24, 2016 by Jason
added table description

[peludo]

18 minutes ago, Jason said:

Added 10 films to the master table:

• Pirates of the Caribbean: At World's End
• Harry Potter and the Deathly Hallows Part 1
• The Hobbit: The Desolation of Smaug
• The Hobbit: The Battle of the Five Armies
• Harry Potter and the Order of the Phoenix
• Harry Potter and the Half-Blood Prince
• Spider-Man 3
• Spectre
• Batman v Superman: Dawn of Justice
• The Hunger Games: Catching Fire

Also updated the exchange rate adjustment to be current as of August 19.

 

Archived table as of August 5 (for reference purposes):

  Reveal hidden contents

Title	Year	Worldwide	Domestic	OS Total	Tracked	OS Adj	WW Adj
Avatar	2009^	$2,788.0	$760.5	$2,027.5	$1,949.4	$1,638	$2,398
Star Wars: The Force Awakens	2015	$2,068.2	$936.7	$1,131.6	$1,107.1	$1,145	$2,082
Jurassic World	2015	$1,670.4	$652.3	$1,018.1	$959.5	$965	$1,618
Marvel's The Avengers	2012	$1,519.6	$623.4	$896.2	$842.9	$706	$1,329
Furious 7	2015	$1,516.0	$353.0	$1,163.0	$1,084.8	$1,084	$1,437
Avengers: Age of Ultron	2015	$1,405.4	$459.0	$946.4	$919.7	$877	$1,336
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$381.0	$960.5	$927.9	$728	$1,109
Frozen	2013	$1,276.5	$400.7	$875.7	$843.1	$751	$1,152
Iron Man 3	2013	$1,215.4	$409.0	$806.4	$756.0	$652	$1,061
Minions	2015	$1,159.4	$336.0	$823.4	$763.1	$771	$1,107
Transformers: Dark of the Moon	2011	$1,123.8	$352.4	$771.4	$748.2	$630	$983
Skyfall	2012	$1,108.6	$304.4	$804.2	$761.0	$661	$966
Transformers: Age of Extinction	2014	$1,104.1	$245.4	$858.6	$792.5	$725	$971
The Dark Knight Rises	2012	$1,084.9	$448.1	$636.8	$610.4	$529	$977
Toy Story 3	2010	$1,063.2	$415.0	$648.2	$633.0	$535	$950
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$241.1	$804.6	$778.1	$600	$841
Alice in Wonderland	2010	$1,025.5	$334.2	$691.3	$635.2	$544	$879
Zootopia	2016	$1,023.1	$341.3	$681.8	$671.6	$672	$1,013
The Hobbit: An Unexpected Journey	2012	$1,021.1	$303.0	$718.1	$678.8	$569	$872
The Dark Knight	2008^	$1,004.6	$534.9	$469.7	$440.1	$381	$916
Despicable Me 2	2013	$970.8	$368.1	$602.7	$571.5	$485	$853
Finding Nemo	2003^	$936.7	$380.8	$555.9	$454.8	$511	$891
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$196.6	$690.1	$661.0	$506	$703
Ice Age: Continental Drift	2012	$877.2	$161.3	$715.9	$683.3	$558	$720
Inside Out	2015	$857.4	$356.5	$501.0	$499.8	$468	$824

 

Great job as always

 

But just a suggestion. Would not be more clear to order the new table by the new WW gross instead with the original? Just saying...

[Jason]

11 minutes ago, peludo said:

Great job as always

 

But just a suggestion. Would not be more clear to order the new table by the new WW gross instead with the original? Just saying...

 

Hmmm. Honestly, I didn't think about that, it's listed by original WW because that's the order I add new films to the table for the most part, and it's pretty trivial for me to sort using a different column in the Excel file when I want to.

 

I just added a table sorting by new WW gross instead of original, in a spoiler tag (for now, anyway) so that the post isn't too large.

[peludo]

34 minutes ago, Jason said:

 

Hmmm. Honestly, I didn't think about that, it's listed by original WW because that's the order I add new films to the table for the most part, and it's pretty trivial for me to sort using a different column in the Excel file when I want to.

 

I just added a table sorting by new WW gross instead of original, in a spoiler tag (for now, anyway) so that the post isn't too large.

I just suggested it to know what would be the real order of the WW list with the ER adjusting. But please, do it as you want. I do not pretend to change anything 

[Jason]

Added The Lord of the Rings: The Return of the King to the master table. Also updated the exchange rate adjustment to be current as of September 9.

 

Archived tables as of August 19 (for reference purposes): 

Spoiler

Sorted by original WW:

Quote

Title	Year	Worldwide	Domestic	OS Total	Tracked	OS Adj	WW Adj
Avatar	2009^	$2,788.0	$760.5	$2,027.5	$1,949.4	$1,658	$2,418
Star Wars: The Force Awakens	2015	$2,068.2	$936.7	$1,131.6	$1,107.1	$1,158	$2,095
Jurassic World	2015	$1,670.4	$652.3	$1,018.1	$959.5	$973	$1,626
Marvel's The Avengers	2012	$1,519.6	$623.4	$896.2	$842.9	$712	$1,335
Furious 7	2015	$1,516.0	$353.0	$1,163.0	$1,084.8	$1,092	$1,445
Avengers: Age of Ultron	2015	$1,405.4	$459.0	$946.4	$919.7	$883	$1,342
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$381.0	$960.5	$927.9	$737	$1,118
Frozen	2013	$1,276.5	$400.7	$875.7	$843.1	$761	$1,162
Iron Man 3	2013	$1,215.4	$409.0	$806.4	$756.0	$657	$1,066
Minions	2015	$1,159.4	$336.0	$823.4	$763.1	$780	$1,116
Transformers: Dark of the Moon	2011	$1,123.8	$352.4	$771.4	$748.2	$634	$987
Skyfall	2012	$1,108.6	$304.4	$804.2	$761.0	$669	$973
Transformers: Age of Extinction	2014	$1,104.1	$245.4	$858.6	$792.5	$730	$975
The Dark Knight Rises	2012	$1,084.9	$448.1	$636.8	$610.4	$534	$982
Toy Story 3	2010	$1,067.0	$415.0	$652.0	$633.0	$541	$956
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$241.1	$804.6	$778.1	$608	$849
Alice in Wonderland	2010	$1,025.5	$334.2	$691.3	$635.2	$552	$886
Zootopia	2016	$1,023.2	$341.3	$681.9	$671.9	$692	$1,034
The Hobbit: An Unexpected Journey	2012	$1,021.1	$303.0	$718.1	$678.8	$577	$880
The Dark Knight	2008^	$1,004.6	$534.9	$469.7	$440.1	$385	$919
Despicable Me 2	2013	$970.8	$368.1	$602.7	$571.5	$490	$859
Pirates of the Caribbean: At World's End	2007	$963.4	$309.4	$654.0	$644.7	$551	$860
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$296.0	$664.3	$669.8	$529	$825
The Hobbit: The Desolation of Smaug	2013	$958.4	$258.4	$700.0	$653.0	$565	$823
The Hobbit: The Battle of the Five Armies	2014	$956.0	$255.1	$700.9	$560.4	$646	$901
Finding Nemo	2003^	$940.3	$380.8	$559.5	$454.8	$519	$900
Harry Potter and the Order of the Phoenix	2007	$939.9	$292.0	$647.9	$646.9	$544	$836
Harry Potter and the Half-Blood Prince	2009	$934.4	$302.0	$632.5	$609.0	$514	$816
Spider-Man 3	2007	$890.9	$336.5	$554.3	$549.6	$447	$783
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$196.6	$690.1	$661.0	$514	$711
Spectre	2015	$880.7	$200.1	$680.6	$646.1	$670	$870
Ice Age: Continental Drift	2012	$877.2	$161.3	$715.9	$683.3	$566	$727
Batman v Superman: Dawn of Justice	2016	$872.7	$330.4	$542.3	$509.7	$547	$877
The Hunger Games: Catching Fire	2013	$865.0	$424.7	$440.3	$411.3	$353	$777
Inside Out	2015	$857.6	$356.5	$501.1	$499.8	$474	$830

Sorted by adjusted WW:

Quote

Title	Year	Worldwide	Domestic	OS Total	Tracked	OS Adj	WW Adj
Avatar	2009^	$2,788.0	$760.5	$2,027.5	$1,949.4	$1,658	$2,418
Star Wars: The Force Awakens	2015	$2,068.2	$936.7	$1,131.6	$1,107.1	$1,158	$2,095
Jurassic World	2015	$1,670.4	$652.3	$1,018.1	$959.5	$973	$1,626
Furious 7	2015	$1,516.0	$353.0	$1,163.0	$1,084.8	$1,092	$1,445
Avengers: Age of Ultron	2015	$1,405.4	$459.0	$946.4	$919.7	$883	$1,342
Marvel's The Avengers	2012	$1,519.6	$623.4	$896.2	$842.9	$712	$1,335
Frozen	2013	$1,276.5	$400.7	$875.7	$843.1	$761	$1,162
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$381.0	$960.5	$927.9	$737	$1,118
Minions	2015	$1,159.4	$336.0	$823.4	$763.1	$780	$1,116
Iron Man 3	2013	$1,215.4	$409.0	$806.4	$756.0	$657	$1,066
Zootopia	2016	$1,023.2	$341.3	$681.9	$671.9	$692	$1,034
Transformers: Dark of the Moon	2011	$1,123.8	$352.4	$771.4	$748.2	$634	$987
The Dark Knight Rises	2012	$1,084.9	$448.1	$636.8	$610.4	$534	$982
Transformers: Age of Extinction	2014	$1,104.1	$245.4	$858.6	$792.5	$730	$975
Skyfall	2012	$1,108.6	$304.4	$804.2	$761.0	$669	$973
Toy Story 3	2010	$1,067.0	$415.0	$652.0	$633.0	$541	$956
The Dark Knight	2008^	$1,004.6	$534.9	$469.7	$440.1	$385	$919
The Hobbit: The Battle of the Five Armies	2014	$956.0	$255.1	$700.9	$560.4	$646	$901
Finding Nemo	2003^	$940.3	$380.8	$559.5	$454.8	$519	$900
Alice in Wonderland	2010	$1,025.5	$334.2	$691.3	$635.2	$552	$886
The Hobbit: An Unexpected Journey	2012	$1,021.1	$303.0	$718.1	$678.8	$577	$880
Batman v Superman: Dawn of Justice	2016	$872.7	$330.4	$542.3	$509.7	$547	$877
Spectre	2015	$880.7	$200.1	$680.6	$646.1	$670	$870
Pirates of the Caribbean: At World's End	2007	$963.4	$309.4	$654.0	$644.7	$551	$860
Despicable Me 2	2013	$970.8	$368.1	$602.7	$571.5	$490	$859
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$241.1	$804.6	$778.1	$608	$849
Harry Potter and the Order of the Phoenix	2007	$939.9	$292.0	$647.9	$646.9	$544	$836
Inside Out	2015	$857.6	$356.5	$501.1	$499.8	$474	$830
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$296.0	$664.3	$669.8	$529	$825
The Hobbit: The Desolation of Smaug	2013	$958.4	$258.4	$700.0	$653.0	$565	$823
Harry Potter and the Half-Blood Prince	2009	$934.4	$302.0	$632.5	$609.0	$514	$816
Spider-Man 3	2007	$890.9	$336.5	$554.3	$549.6	$447	$783
The Hunger Games: Catching Fire	2013	$865.0	$424.7	$440.3	$411.3	$353	$777
Ice Age: Continental Drift	2012	$877.2	$161.3	$715.9	$683.3	$566	$727
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$196.6	$690.1	$661.0	$514	$711

 

 

Edited September 12, 2016 by Jason
made corrections for Zootopia in Aug 19 archive

[peludo]

I have adjusted by exchange rates Marvel Cinematic Universe films (New OS / New WW):

 

1. Age of Ultron: 880.7 / 1.339b

2. The Avengers: 708.4 / 1.331b

3. Civil War: 734.5 / 1.142b

4. Iron Man 3: 657.4 / 1.066b

5. Guardians of the Galaxy: 365.1 / 698.3

6. The Winter Soldier: 384.6 / 644.4

7. Iron Man 2: 259.2 / 571.7

8. The Dark World: 352.8 / 559.1

9. Iron Man: 199.1 / 517.5

10. Ant-Man: 323.9 / 504.1

11. Thor: 201.4 / 382.5

12. Captain America: 142.8 / 319.5

13. The Incredible Hulk: 93.1 / 227.9

[sensui]

On ‎9‎/‎14‎/‎2016 at 9:46 AM, peludo said:

I have adjusted by exchange rates Marvel Cinematic Universe films (New OS / New WW):

 

1. Age of Ultron: 880.7 / 1.339b

2. The Avengers: 708.4 / 1.331b

3. Civil War: 734.5 / 1.142b

4. Iron Man 3: 657.4 / 1.066b

5. Guardians of the Galaxy: 365.1 / 698.3

6. The Winter Soldier: 384.6 / 644.4

7. Iron Man 2: 259.2 / 571.7

8. The Dark World: 352.8 / 559.1

9. Iron Man: 199.1 / 517.5

10. Ant-Man: 323.9 / 504.1

11. Thor: 201.4 / 382.5

12. Captain America: 142.8 / 319.5

13. The Incredible Hulk: 93.1 / 227.9

Awesome list as always. I know you're busy but could you do the same list and add inflation to it? I'm waiting with baited breath for the inflation adjusted list on page 6 to be updated with this years titles plus the original Jungle Book and the other movies you wanted to include.  Not to mention updating the WW list adjusted by inflation without China figures and adding a 10% of 3D for 2D films list as well. But thanks a lot Peludo and now Jason for adding actual analysis to the boxoffice forums and not just constant sports team bickering about my movie is better than yours, because of its gross, nonsense.

 

 

[BadAtGender]

I love this project, but I've had a thought about the requirement of constant bookkeeping. Because the exchange rates are always in flux, the numbers constantly need to be updated. That's useful if we're comparing to brand new films, but it feels like a lot of excess work.

 

What if instead we just picked a baseline exchange rate time? Peludo did some work of that by comparing films that, say, had Avatar's exchange rate instead of more current ones. And, actually, since it is the biggest WW film, using Avatar might not be so bad. It establishes a clear baseline and there's a historical reason for doing it.

 

I think if this were done, by converting all the films to what their gross would be in the exchange rates of December 2009/January 2010 (say, January 1, 2010?), it would  mean that once a film's release is finished, it's data can be static in the table, and then the only work that would need to be done would be for new films as they are released or for older films as information about their grosses is found, and then it's just converting by rolling back the exchange rates to that point (and, again, it might even be easier since we can just save a historical archive of the exchange rates of that point in time.)

 

Or am I not understanding the process that Peludo and Jason are doing for their calculations? It's possible I'm entirely off base in this. It wouldn't necessarily answer the "how big would x film be if it was released right now?" question, but we could see things in the Avatar Exchange Rate Index, so to speak, which ultimately would be just as useful if we're primarily looking at the "what film was bigger" question.

[Jason]

57 minutes ago, DamienRoc said:

I love this project, but I've had a thought about the requirement of constant bookkeeping. Because the exchange rates are always in flux, the numbers constantly need to be updated. That's useful if we're comparing to brand new films, but it feels like a lot of excess work.

 

I can't speak towards Peludo's methods, but it's actually extremely trivial for me to update the current exchange rate. I have one master column of current exchange rates that when updated instantly updates every single other film in the spreadsheet. I can pretty much do any date that someone is interested in, as long as it's after 2002-ish. Further back than that it gets more challenging to produce accurate numbers, because of spotty availability of currency data, as well as the changeover to the Euro.

 

I actually could update the master list more often, but day-to-day fluctuations aren't very meaningful. I've decided on every two weeks-ish only because if I did it less often than that there's a risk I'd forget about it completely.

[peludo]

4 hours ago, DamienRoc said:

I love this project, but I've had a thought about the requirement of constant bookkeeping. Because the exchange rates are always in flux, the numbers constantly need to be updated. That's useful if we're comparing to brand new films, but it feels like a lot of excess work.

 

What if instead we just picked a baseline exchange rate time? Peludo did some work of that by comparing films that, say, had Avatar's exchange rate instead of more current ones. And, actually, since it is the biggest WW film, using Avatar might not be so bad. It establishes a clear baseline and there's a historical reason for doing it.

 

I think if this were done, by converting all the films to what their gross would be in the exchange rates of December 2009/January 2010 (say, January 1, 2010?), it would  mean that once a film's release is finished, it's data can be static in the table, and then the only work that would need to be done would be for new films as they are released or for older films as information about their grosses is found, and then it's just converting by rolling back the exchange rates to that point (and, again, it might even be easier since we can just save a historical archive of the exchange rates of that point in time.)

 

Or am I not understanding the process that Peludo and Jason are doing for their calculations? It's possible I'm entirely off base in this. It wouldn't necessarily answer the "how big would x film be if it was released right now?" question, but we could see things in the Avatar Exchange Rate Index, so to speak, which ultimately would be just as useful if we're primarily looking at the "what film was bigger" question.

As @Jason has said, it is easy for me to change the ER. I have just to collect the current ER (or whenever ER) and change one single column. That is maybe 5 minutes. I do not have to recalculate everything again

 

To adjust with current ER is precisely to give a better view of the magnitude of each film with the current context (if we do not take into account inflation, of course). And people tend to forget very quickly and just live present. We live in a YA society. For that reason I think it is more useful to know that with today ER Civil War would had beaten IM3 than if we say that if Civil War had had 2013's ER it would had made about 1.3b. Although that is just my opinion. I can give lists using certain ER and if some of you prefer it, I can fix a historical moment (as Avatar release being the biggest film ever). We can do it as people prefer.

[peludo]

7 hours ago, sensui said:

Awesome list as always. I know you're busy but could you do the same list and add inflation to it? I'm waiting with baited breath for the inflation adjusted list on page 6 to be updated with this years titles plus the original Jungle Book and the other movies you wanted to include.  Not to mention updating the WW list adjusted by inflation without China figures and adding a 10% of 3D for 2D films list as well. But thanks a lot Peludo and now Jason for adding actual analysis to the boxoffice forums and not just constant sports team bickering about my movie is better than yours, because of its gross, nonsense.

 

 

That is a lot of pressure for me 

 

 

MCU adjusting DOM and OS by DOM inflation (DOM / OS / WW):

1. The Avengers: 678.2 / 770.7 / 1.449b

2. Age of Ultron: 471.5 / 904.7 / 1.376b

3. Civil War: 408 / 734.5 / 1.142b

4. Iron Man 3: 435.7 / 700.3 / 1.136b

5. Guardians of the Galaxy: 353.2 / 387.0 / 740.2

6. The Winter Soldier: 275.3 / 407.7 / 683.0

7. Iron Man 2: 342.9 / 284.5 / 627.5

8. Iron Man: 384.0 / 240.1 / 624.2

9. The Dark World: 219.8 / 375.8 / 595.6

10. Ant-Man: 185.1 / 332.8 / 517.9

11. Thor: 197.7 / 220.0 / 417.7

12. Captain America: 192.9 / 156.0 / 348.9

13. The Incredible Hulk: 162.6 / 112.3 / 274.9

 

DCU adjusting DOM and OS by DOM inflation (DOM / OS / WW):

1. Batman v Superman: 330.4 / 542.0 / 872.4

2. Suicide Squad: 313.8 / 406.0 / 719.8 (not adjusted by ER. Inflation 1)

3. Man of Steel: 310.0 / 338.3 / 648.3

 

And finally, MCU+DCU adjusted by ER, not by inflation, and without China:

1. The Avengers: 1.245b

2. Age of Ultron: 1.100b

3. Civil War: 952m

4. Iron Man 3: 945m

5. Batman v Superman: 777m

6. Suicide Squad: 719m

7. Guardians of the Galaxy: 601m

8. Iron Man 2: 546m

9. Man of Steel: 545m

10. The Winter Soldier: 529m

11. The Dark World: 504m

12. Iron Man: 502m

13. Ant-Man: 399m

14. Thor: 382m

15. Captain America: 319m

16. The Incredible Hulk: 219m

[Jason]

Added eight films to the master table:

• Transformers: Revenge of the Fallen
• The Twilight Saga: Breaking Dawn Part 2
• Inception
• Shrek the Third
• Fast & Furious 6
• Indiana Jones and the Kingdom of the Crystal Skull
• Deadpool
• Guardians of the Galaxy

Also updated the exchange rate adjustment to be current as of September 23.

 

Archived tables from September 9, for reference purposes:

Spoiler

Sorted by original WW:

Quote

Title	Year	Worldwide	Domestic	OS Total	Tracked	OS Adj	WW Adj
Avatar	2009^	$2,788.0	$760.5	$2,027.5	$1,949.4	$1,645	$2,405
Star Wars: The Force Awakens	2015	$2,068.2	$936.7	$1,131.6	$1,107.1	$1,149	$2,086
Jurassic World	2015	$1,670.4	$652.3	$1,018.1	$959.5	$966	$1,618
Marvel's The Avengers	2012	$1,519.6	$623.4	$896.2	$842.9	$706	$1,330
Furious 7	2015	$1,516.0	$353.0	$1,163.0	$1,084.8	$1,083	$1,436
Avengers: Age of Ultron	2015	$1,405.4	$459.0	$946.4	$919.7	$877	$1,336
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$381.0	$960.5	$927.9	$731	$1,112
Frozen	2013	$1,276.5	$400.7	$875.7	$843.1	$752	$1,152
Iron Man 3	2013	$1,215.4	$409.0	$806.4	$756.0	$652	$1,061
Minions	2015	$1,159.4	$336.0	$823.4	$763.1	$773	$1,109
Transformers: Dark of the Moon	2011	$1,123.8	$352.4	$771.4	$748.2	$630	$982
The Lord of the Rings: The Return of the King	2003^	$1,119.9	$377.8	$742.1	$736.5	$669	$1,046
Skyfall	2012	$1,108.6	$304.4	$804.2	$761.0	$666	$970
Transformers: Age of Extinction	2014	$1,104.1	$245.4	$858.6	$792.5	$724	$969
The Dark Knight Rises	2012	$1,084.9	$448.1	$636.8	$610.4	$531	$979
Toy Story 3	2010	$1,067.0	$415.0	$652.0	$633.0	$536	$951
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$241.1	$804.6	$778.1	$602	$843
Alice in Wonderland	2010	$1,025.5	$334.2	$691.3	$635.2	$546	$880
Zootopia	2016	$1,023.2	$341.3	$681.9	$671.9	$686	$1,027
The Hobbit: An Unexpected Journey	2012	$1,021.1	$303.0	$718.1	$678.8	$573	$876
The Dark Knight	2008^	$1,004.6	$534.9	$469.7	$440.1	$383	$918
Despicable Me 2	2013	$970.8	$368.1	$602.7	$571.5	$486	$854
Pirates of the Caribbean: At World's End	2007	$963.4	$309.4	$654.0	$644.7	$545	$854
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$296.0	$664.3	$669.8	$525	$821
The Hobbit: The Desolation of Smaug	2013	$958.4	$258.4	$700.0	$653.0	$561	$819
The Hobbit: The Battle of the Five Armies	2014	$956.0	$255.1	$700.9	$560.4	$642	$897
Finding Nemo	2003^	$940.3	$380.8	$559.5	$454.8	$513	$894
Harry Potter and the Order of the Phoenix	2007	$939.9	$292.0	$647.9	$646.9	$539	$831
Harry Potter and the Half-Blood Prince	2009	$934.4	$302.0	$632.5	$609.0	$510	$812
Spider-Man 3	2007	$890.9	$336.5	$554.3	$549.6	$445	$781
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$196.6	$690.1	$661.0	$510	$706
Spectre	2015	$880.7	$200.1	$680.6	$646.1	$666	$866
Ice Age: Continental Drift	2012	$877.2	$161.3	$715.9	$683.3	$561	$722
Batman v Superman: Dawn of Justice	2016	$872.7	$330.4	$542.3	$509.7	$542	$872
The Hunger Games: Catching Fire	2013	$865.0	$424.7	$440.3	$411.3	$350	$775
Inside Out	2015	$857.6	$356.5	$501.1	$499.8	$470	$826

Sorted by adjusted WW:

Quote

Title	Year	Worldwide	Domestic	OS Total	Tracked	OS Adj	WW Adj
Avatar	2009^	$2,788.0	$760.5	$2,027.5	$1,949.4	$1,645	$2,405
Star Wars: The Force Awakens	2015	$2,068.2	$936.7	$1,131.6	$1,107.1	$1,149	$2,086
Jurassic World	2015	$1,670.4	$652.3	$1,018.1	$959.5	$966	$1,618
Furious 7	2015	$1,516.0	$353.0	$1,163.0	$1,084.8	$1,083	$1,436
Avengers: Age of Ultron	2015	$1,405.4	$459.0	$946.4	$919.7	$877	$1,336
Marvel's The Avengers	2012	$1,519.6	$623.4	$896.2	$842.9	$706	$1,330
Frozen	2013	$1,276.5	$400.7	$875.7	$843.1	$752	$1,152
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$381.0	$960.5	$927.9	$731	$1,112
Minions	2015	$1,159.4	$336.0	$823.4	$763.1	$773	$1,109
Iron Man 3	2013	$1,215.4	$409.0	$806.4	$756.0	$652	$1,061
The Lord of the Rings: The Return of the King	2003^	$1,119.9	$377.8	$742.1	$736.5	$669	$1,046
Zootopia	2016	$1,023.2	$341.3	$681.9	$671.9	$686	$1,027
Transformers: Dark of the Moon	2011	$1,123.8	$352.4	$771.4	$748.2	$630	$982
The Dark Knight Rises	2012	$1,084.9	$448.1	$636.8	$610.4	$531	$979
Skyfall	2012	$1,108.6	$304.4	$804.2	$761.0	$666	$970
Transformers: Age of Extinction	2014	$1,104.1	$245.4	$858.6	$792.5	$724	$969
Toy Story 3	2010	$1,067.0	$415.0	$652.0	$633.0	$536	$951
The Dark Knight	2008^	$1,004.6	$534.9	$469.7	$440.1	$383	$918
The Hobbit: The Battle of the Five Armies	2014	$956.0	$255.1	$700.9	$560.4	$642	$897
Finding Nemo	2003^	$940.3	$380.8	$559.5	$454.8	$513	$894
Alice in Wonderland	2010	$1,025.5	$334.2	$691.3	$635.2	$546	$880
The Hobbit: An Unexpected Journey	2012	$1,021.1	$303.0	$718.1	$678.8	$573	$876
Batman v Superman: Dawn of Justice	2016	$872.7	$330.4	$542.3	$509.7	$542	$872
Spectre	2015	$880.7	$200.1	$680.6	$646.1	$666	$866
Pirates of the Caribbean: At World's End	2007	$963.4	$309.4	$654.0	$644.7	$545	$854
Despicable Me 2	2013	$970.8	$368.1	$602.7	$571.5	$486	$854
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$241.1	$804.6	$778.1	$602	$843
Harry Potter and the Order of the Phoenix	2007	$939.9	$292.0	$647.9	$646.9	$539	$831
Inside Out	2015	$857.6	$356.5	$501.1	$499.8	$470	$826
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$296.0	$664.3	$669.8	$525	$821
The Hobbit: The Desolation of Smaug	2013	$958.4	$258.4	$700.0	$653.0	$561	$819
Harry Potter and the Half-Blood Prince	2009	$934.4	$302.0	$632.5	$609.0	$510	$812
Spider-Man 3	2007	$890.9	$336.5	$554.3	$549.6	$445	$781
The Hunger Games: Catching Fire	2013	$865.0	$424.7	$440.3	$411.3	$350	$775
Ice Age: Continental Drift	2012	$877.2	$161.3	$715.9	$683.3	$561	$722
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$196.6	$690.1	$661.0	$510	$706

 

 

[Jason]

Added eleven films to the master table:

• The Jungle Book (2016)
• 2012
• Maleficent
• The Amazing Spider-Man
• The Hunger Games: Mockingjay - Part 1
• Shrek Forever After
• Madagascar 3: Europe's Most Wanted
• Monsters University
• Up
• Gravity
• Captain America: The Winter Soldier

Also updated the exchange rate to be current as of October 10.

 

Archived tables from September 23, for reference purposes:

Spoiler

Sorted by original WW:

Quote

Title	Year	Worldwide	Domestic	OS Total	Tracked	OS Adj	WW Adj
Avatar	2009^	$2,788.0	$760.5	$2,027.5	$1,949.4	$1,648	$2,408
Star Wars: The Force Awakens	2015	$2,068.2	$936.7	$1,131.6	$1,107.1	$1,149	$2,086
Jurassic World	2015	$1,670.4	$652.3	$1,018.1	$959.5	$967	$1,619
Marvel's The Avengers	2012	$1,519.6	$623.4	$896.2	$842.9	$706	$1,329
Furious 7	2015	$1,516.0	$353.0	$1,163.0	$1,084.8	$1,085	$1,438
Avengers: Age of Ultron	2015	$1,405.4	$459.0	$946.4	$919.7	$877	$1,336
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$381.0	$960.5	$927.9	$731	$1,112
Frozen	2013	$1,276.5	$400.7	$875.7	$843.1	$756	$1,156
Iron Man 3	2013	$1,215.4	$409.0	$806.4	$756.0	$652	$1,061
Minions	2015	$1,159.4	$336.0	$823.4	$763.1	$773	$1,109
Transformers: Dark of the Moon	2011	$1,123.8	$352.4	$771.4	$748.2	$631	$983
The Lord of the Rings: The Return of the King	2003^	$1,119.9	$377.8	$742.1	$736.5	$669	$1,047
Skyfall	2012	$1,108.6	$304.4	$804.2	$761.0	$664	$969
Transformers: Age of Extinction	2014	$1,104.1	$245.4	$858.6	$792.5	$725	$971
The Dark Knight Rises	2012	$1,084.9	$448.1	$636.8	$610.4	$530	$978
Toy Story 3	2010	$1,067.0	$415.0	$652.0	$633.0	$535	$950
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$241.1	$804.6	$778.1	$603	$844
Alice in Wonderland	2010	$1,025.5	$334.2	$691.3	$635.2	$547	$881
Zootopia	2016	$1,023.6	$341.3	$682.3	$672.0	$689	$1,030
The Hobbit: An Unexpected Journey	2012	$1,021.1	$303.0	$718.1	$678.8	$572	$875
The Dark Knight	2008^	$1,004.6	$534.9	$469.7	$440.1	$381	$916
Despicable Me 2	2013	$970.8	$368.1	$602.7	$571.5	$485	$853
Pirates of the Caribbean: At World's End	2007	$963.4	$309.4	$654.0	$644.7	$546	$856
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$296.0	$664.3	$669.8	$525	$821
The Hobbit: The Desolation of Smaug	2013	$958.4	$258.4	$700.0	$653.0	$561	$819
The Hobbit: The Battle of the Five Armies	2014	$956.0	$255.1	$700.9	$560.4	$643	$898
Finding Nemo	2003^	$940.3	$380.8	$559.5	$454.8	$514	$895
Harry Potter and the Order of the Phoenix	2007	$939.9	$292.0	$647.9	$646.9	$539	$831
Harry Potter and the Half-Blood Prince	2009	$934.4	$302.0	$632.5	$609.0	$510	$812
Spider-Man 3	2007	$890.9	$336.5	$554.3	$549.6	$443	$780
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$196.6	$690.1	$661.0	$509	$706
Spectre	2015	$880.7	$200.1	$680.6	$646.1	$665	$865
Ice Age: Continental Drift	2012	$877.2	$161.3	$715.9	$683.3	$560	$721
Batman v Superman: Dawn of Justice	2016	$873.3	$330.4	$542.9	$509.7	$541	$872
The Hunger Games: Catching Fire	2013	$865.0	$424.7	$440.3	$411.3	$349	$774
Inside Out	2015	$857.6	$356.5	$501.1	$499.8	$469	$826
Transformers: Revenge of the Fallen	2009	$836.3	$402.1	$434.2	$426.3	$381	$783
The Twilight Saga: Breaking Dawn Part 2	2012	$829.7	$292.3	$537.4	$526.3	$414	$706
Inception	2010	$825.5	$292.6	$533.0	$531.0	$453	$746
Shrek the Third	2007	$799.0	$322.7	$476.2	$467.6	$365	$687
Fast & Furious 6	2013	$788.7	$238.7	$550.0	$501.0	$439	$678
Indiana Jones and the Kingdom of the Crystal Skull	2008	$786.6	$317.1	$469.5	$466.7	$345	$662
Deadpool	2016	$782.6	$363.1	$419.5	$401.6	$436	$799
Guardians of the Galaxy	2014	$773.3	$333.2	$440.1	$416.8	$358	$691

Sorted by adjusted WW:

Quote

Title	Year	Worldwide	Domestic	OS Total	Tracked	OS Adj	WW Adj
Avatar	2009^	$2,788.0	$760.5	$2,027.5	$1,949.4	$1,648	$2,408
Star Wars: The Force Awakens	2015	$2,068.2	$936.7	$1,131.6	$1,107.1	$1,149	$2,086
Jurassic World	2015	$1,670.4	$652.3	$1,018.1	$959.5	$967	$1,619
Furious 7	2015	$1,516.0	$353.0	$1,163.0	$1,084.8	$1,085	$1,438
Avengers: Age of Ultron	2015	$1,405.4	$459.0	$946.4	$919.7	$877	$1,336
Marvel's The Avengers	2012	$1,519.6	$623.4	$896.2	$842.9	$706	$1,329
Frozen	2013	$1,276.5	$400.7	$875.7	$843.1	$756	$1,156
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$381.0	$960.5	$927.9	$731	$1,112
Minions	2015	$1,159.4	$336.0	$823.4	$763.1	$773	$1,109
Iron Man 3	2013	$1,215.4	$409.0	$806.4	$756.0	$652	$1,061
The Lord of the Rings: The Return of the King	2003^	$1,119.9	$377.8	$742.1	$736.5	$669	$1,047
Zootopia	2016	$1,023.6	$341.3	$682.3	$672.0	$689	$1,030
Transformers: Dark of the Moon	2011	$1,123.8	$352.4	$771.4	$748.2	$631	$983
The Dark Knight Rises	2012	$1,084.9	$448.1	$636.8	$610.4	$530	$978
Transformers: Age of Extinction	2014	$1,104.1	$245.4	$858.6	$792.5	$725	$971
Skyfall	2012	$1,108.6	$304.4	$804.2	$761.0	$664	$969
Toy Story 3	2010	$1,067.0	$415.0	$652.0	$633.0	$535	$950
The Dark Knight	2008^	$1,004.6	$534.9	$469.7	$440.1	$381	$916
The Hobbit: The Battle of the Five Armies	2014	$956.0	$255.1	$700.9	$560.4	$643	$898
Finding Nemo	2003^	$940.3	$380.8	$559.5	$454.8	$514	$895
Alice in Wonderland	2010	$1,025.5	$334.2	$691.3	$635.2	$547	$881
The Hobbit: An Unexpected Journey	2012	$1,021.1	$303.0	$718.1	$678.8	$572	$875
Batman v Superman: Dawn of Justice	2016	$873.3	$330.4	$542.9	$509.7	$541	$872
Spectre	2015	$880.7	$200.1	$680.6	$646.1	$665	$865
Pirates of the Caribbean: At World's End	2007	$963.4	$309.4	$654.0	$644.7	$546	$856
Despicable Me 2	2013	$970.8	$368.1	$602.7	$571.5	$485	$853
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$241.1	$804.6	$778.1	$603	$844
Harry Potter and the Order of the Phoenix	2007	$939.9	$292.0	$647.9	$646.9	$539	$831
Inside Out	2015	$857.6	$356.5	$501.1	$499.8	$469	$826
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$296.0	$664.3	$669.8	$525	$821
The Hobbit: The Desolation of Smaug	2013	$958.4	$258.4	$700.0	$653.0	$561	$819
Harry Potter and the Half-Blood Prince	2009	$934.4	$302.0	$632.5	$609.0	$510	$812
Deadpool	2016	$782.6	$363.1	$419.5	$401.6	$436	$799
Transformers: Revenge of the Fallen	2009	$836.3	$402.1	$434.2	$426.3	$381	$783
Spider-Man 3	2007	$890.9	$336.5	$554.3	$549.6	$443	$780
The Hunger Games: Catching Fire	2013	$865.0	$424.7	$440.3	$411.3	$349	$774
Inception	2010	$825.5	$292.6	$533.0	$531.0	$453	$746
Ice Age: Continental Drift	2012	$877.2	$161.3	$715.9	$683.3	$560	$721
The Twilight Saga: Breaking Dawn Part 2	2012	$829.7	$292.3	$537.4	$526.3	$414	$706
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$196.6	$690.1	$661.0	$509	$706
Guardians of the Galaxy	2014	$773.3	$333.2	$440.1	$416.8	$358	$691
Shrek the Third	2007	$799.0	$322.7	$476.2	$467.6	$365	$687
Fast & Furious 6	2013	$788.7	$238.7	$550.0	$501.0	$439	$678
Indiana Jones and the Kingdom of the Crystal Skull	2008	$786.6	$317.1	$469.5	$466.7	$345	$662

 

 

[Jason]

I've managed to find ticket price data for a total of 57 countries (excluding US + Canada) that account for about 96% of overseas box office gross. The data I have mostly goes as far back as 2005, there are a handful of markets that go back further than that, but not enough to be useful for the purposes of box office adjustment. Data has been compiled from multiple sources, for many countries I have calculated the average ticket price by dividing the total box office gross by the total number of admissions.

 

Average ticket prices are shown below in US$, but in some cases I have converted from local currency using the average exchange rate for that year. For countries where I have both US$ and local currency figures available, conversion using the average rate for the year gives figures that agree to within 1%.

 

 

I have data from 1998-2004 for a limited set of countries, this data is shown below in local currency (I have no need to convert it for reasons explained in the following post).

Quote

Country	1998	1999	2000	2001	2002	2003	2004
Australia	$7.87	$8.00	$8.41	$8.88	$9.13	$9.62	$9.91
China	¥13.32	¥13.50	¥14.00	¥5.33	¥8.27	¥8.55	¥11.19
France	€ 5.38	€ 5.36	€ 5.39	€ 5.45	€ 5.59	€ 5.74	€ 5.82
Germany	€ 5.46	€ 5.42	€ 5.41	€ 5.55	€ 5.86	€ 5.70	€ 5.70
Italy	€ 4.96	€ 5.15	€ 5.24	€ 5.30	€ 5.58	€ 5.56	€ 5.68
Japan	¥1,264	¥1,263	¥1,262	¥1,226	¥1,224	¥1,252	¥1,240
South Korea	₩5,149	₩5,230	₩5,609	₩5,861	₩6,018	₩6,003	₩6,287
Spain	€ 3.58	€ 3.78	€ 3.96	€ 4.20	€ 4.45	€ 4.65	€ 4.81
United Kingdom	£3.70	£4.00	£4.02	£4.14	£4.29	£4.44	£4.49

 

This is the data I am using to adjust films in my master table by ticket price inflation. If you know of a source for data for countries not on these list (at least admissions and gross box office) let me know! For many countries I have data from 2005 to 2013 but not 2014 and 2015, so even a source with only recent data could help.

 

Sources:

• Data from 1998-2004 from Focus 2006
• Data from 2005-2013 generally from UNESCO: Admissions & gross box office (GBO)
• Data for 2014 and 2015 filled in with the sources listed here
• Where necessary, average annual exchange rates from OANDA

Edited July 6, 2017 by Jason
added 2016 ticket prices

[Jason]

Alright, so I've added a new table with OS and WW grosses adjusted for ticket price inflation as well as exchange rates. For now I have ticket price adjusted grosses for the films in the $1B club, but I hope to complete the rest in the next couple weeks.

 

My method for adjusting the OS gross combines exchange rate adjustment with the ratio of the local currency ticket price at release (calculated where necessary from US$ ticket price) and the extrapolated local ticket price for 2016 (using the local rate of inflation in the past two years). My reason for combining exchange rate adjustment with local currency ticket prices rather than a simpler direct comparison between the US$ ticket prices is that exchange rates can occasionally change much faster than the rate of inflation. For example, from July to December 2014 the US dollar strengthened about 13% against a basket of currencies, which is faster than the local rate of inflation in almost all the countries I have data for. I'm using a local ticket price extrapolated to 2016 rather than 2015 prices since I think we're most interested in comparing historical grosses to films currently in release. The error introduced by extrapolation will be less than the difference between 2016 and 2015 prices. I will replace the estimated ticket prices with actual 2016 prices once data comes in early next year.

 

For films with spring or summer release dates, the local ticket price is simply the average ticket price for that year. For films with fall or winter releases I've used the average of the ticket prices from the preceding/following years. I think this will result in a more accurate adjustment based on patterns I've observed from closer examination of the adjusted domestic list at BOM. (If you reverse-calculate the original average ticket prices for films, releases such as Avatar have an average ticket price in between that of the preceding/following years. Spring/summer releases have an average ticket price generally reflective of the average ticket price for that year.)

 

The adjustment for the OS gross that is not from tracked territories or where no ticket price data is available is extrapolated from the territories where data is available. This should be more accurate than no adjustment at all, given the broad agreement with overall exchange rate and ticket price trends for films in a given year.

 

For films released from 1998-2004, the TP adjusted grosses are adjusted by an additional "fudge factor" that takes into account that the limited territories where data is available have a generally lower rate of inflation than those from where data is missing. This fudge factor is empirically determined by comparing adjustments using 2005 ticket prices with the limited territories from 1998-2004 and with the full data set. It is highest for films released in 2004 and lower in earlier films, due to the larger grosses from emerging markets.

 

Also, four films added to the table (as of October 24):

• Titanic
• Captain America: Civil War
• Pirates of the Caribbean: Dead Man's Chest
• Star Wars: Episode I - The Phantom Menace

 

Archived tables from October 10 (ER adjustment only), for reference purposes:

Spoiler

Sorted by original WW:

Quote

Title	Year	Worldwide	Domestic	OS Total	Tracked	OS Adj	WW Adj
Avatar	2009^	$2,788.0	$760.5	$2,027.5	$1,949.4	$1,635	$2,396
Star Wars: The Force Awakens	2015	$2,068.2	$936.7	$1,131.6	$1,107.1	$1,137	$2,074
Jurassic World	2015	$1,670.4	$652.3	$1,018.1	$959.5	$959	$1,612
Marvel's The Avengers	2012	$1,519.6	$623.4	$896.2	$842.9	$702	$1,325
Furious 7	2015	$1,516.0	$353.0	$1,163.0	$1,084.8	$1,080	$1,433
Avengers: Age of Ultron	2015	$1,405.4	$459.0	$946.4	$919.7	$873	$1,332
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$381.0	$960.5	$927.9	$724	$1,105
Frozen	2013	$1,276.5	$400.7	$875.7	$843.1	$746	$1,147
Iron Man 3	2013	$1,215.4	$409.0	$806.4	$756.0	$649	$1,058
Minions	2015	$1,159.4	$336.0	$823.4	$763.1	$768	$1,104
Transformers: Dark of the Moon	2011	$1,123.8	$352.4	$771.4	$748.2	$628	$980
The Lord of the Rings: The Return of the King	2003^	$1,119.9	$377.8	$742.1	$736.5	$662	$1,039
Skyfall	2012	$1,108.6	$304.4	$804.2	$761.0	$656	$960
Transformers: Age of Extinction	2014	$1,104.1	$245.4	$858.6	$792.5	$722	$967
The Dark Knight Rises	2012	$1,084.9	$448.1	$636.8	$610.4	$525	$973
Toy Story 3	2010	$1,067.0	$415.0	$652.0	$633.0	$528	$943
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$241.1	$804.6	$778.1	$599	$840
Alice in Wonderland	2010	$1,025.5	$334.2	$691.3	$635.2	$541	$875
Zootopia	2016	$1,023.6	$341.3	$682.3	$672.0	$684	$1,026
The Hobbit: An Unexpected Journey	2012	$1,021.1	$303.0	$718.1	$678.8	$568	$871
The Dark Knight	2008^	$1,004.6	$534.9	$469.7	$440.1	$377	$912
Despicable Me 2	2013	$970.8	$368.1	$602.7	$571.5	$482	$850
The Jungle Book	2016	$966.2	$364.0	$602.2	$561.6	$587	$951
Pirates of the Caribbean: At World's End	2007	$963.4	$309.4	$654.0	$644.7	$540	$850
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$296.0	$664.3	$669.8	$519	$815
The Hobbit: The Desolation of Smaug	2013	$958.4	$258.4	$700.0	$653.0	$557	$815
The Hobbit: The Battle of the Five Armies	2014	$956.0	$255.1	$700.9	$560.4	$638	$893
Finding Nemo	2003^	$940.3	$380.8	$559.5	$454.8	$507	$888
Harry Potter and the Order of the Phoenix	2007	$939.9	$292.0	$647.9	$646.9	$533	$825
Harry Potter and the Half-Blood Prince	2009	$934.4	$302.0	$632.5	$609.0	$504	$806
Spider-Man 3	2007	$890.9	$336.5	$554.3	$549.6	$440	$777
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$196.6	$690.1	$661.0	$507	$703
Spectre	2015	$880.7	$200.1	$680.6	$646.1	$657	$857
Ice Age: Continental Drift	2012	$877.2	$161.3	$715.9	$683.3	$558	$720
Batman v Superman: Dawn of Justice	2016	$873.3	$330.4	$542.9	$509.7	$539	$869
The Hunger Games: Catching Fire	2013	$865.0	$424.7	$440.3	$411.3	$347	$772
Inside Out	2015	$857.6	$356.5	$501.1	$499.8	$466	$823
Transformers: Revenge of the Fallen	2009	$836.3	$402.1	$434.2	$426.3	$379	$781
The Twilight Saga: Breaking Dawn Part 2	2012	$829.7	$292.3	$537.4	$526.3	$412	$704
Inception	2010	$825.5	$292.6	$533.0	$531.0	$449	$742
Shrek the Third	2007	$799.0	$322.7	$476.2	$467.6	$362	$684
Fast & Furious 6	2013	$788.7	$238.7	$550.0	$501.0	$437	$676
Indiana Jones and the Kingdom of the Crystal Skull	2008	$786.6	$317.1	$469.5	$466.7	$340	$658
Deadpool	2016	$782.6	$363.1	$419.5	$401.6	$433	$797
Guardians of the Galaxy	2014	$773.3	$333.2	$440.1	$416.8	$356	$689
2012	2009	$769.7	$166.1	$603.6	$563.2	$472	$638
Maleficent	2014	$758.5	$241.4	$517.1	$489.0	$414	$656
The Amazing Spider-Man	2012	$757.9	$262.0	$495.9	$483.6	$400	$662
The Hunger Games: Mockingjay - Part 1	2014	$755.4	$337.1	$418.2	$399.2	$359	$696
Shrek Forever After	2010	$752.6	$238.7	$513.9	$511.6	$399	$637
Madagascar 3: Europe's Most Wanted	2012	$746.9	$216.4	$530.5	$488.6	$410	$626
Monsters University	2013	$744.2	$268.5	$475.7	$449.6	$383	$651
Up	2009	$735.1	$293.0	$442.1	$410.0	$347	$640
Gravity	2013	$723.2	$274.1	$449.1	$333.0	$357	$631
Captain America: The Winter Soldier	2014	$714.4	$259.8	$454.7	$417.9	$378	$638

Sorted by adjusted WW:

Quote

Title	Year	Worldwide	Domestic	OS Total	Tracked	OS Adj	WW Adj
Avatar	2009^	$2,788.0	$760.5	$2,027.5	$1,949.4	$1,635	$2,396
Star Wars: The Force Awakens	2015	$2,068.2	$936.7	$1,131.6	$1,107.1	$1,137	$2,074
Jurassic World	2015	$1,670.4	$652.3	$1,018.1	$960.1	$959	$1,612
Furious 7	2015	$1,516.0	$353.0	$1,163.0	$1,084.8	$1,080	$1,433
Avengers: Age of Ultron	2015	$1,405.4	$459.0	$946.4	$919.7	$873	$1,332
Marvel's The Avengers	2012	$1,519.6	$623.4	$896.2	$842.9	$702	$1,325
Frozen	2013	$1,276.5	$400.7	$875.7	$843.1	$746	$1,147
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$381.0	$960.5	$927.9	$724	$1,105
Minions	2015	$1,159.4	$336.0	$823.4	$763.1	$768	$1,104
Iron Man 3	2013	$1,215.4	$409.0	$806.4	$756.0	$649	$1,058
The Lord of the Rings: The Return of the King	2003^	$1,119.9	$377.8	$742.1	$736.5	$662	$1,039
Zootopia	2016	$1,023.6	$341.3	$682.4	$672.0	$684	$1,026
Transformers: Dark of the Moon	2011	$1,123.8	$352.4	$771.4	$748.2	$628	$980
The Dark Knight Rises	2012	$1,084.9	$448.1	$636.8	$610.4	$525	$973
Transformers: Age of Extinction	2014	$1,104.1	$245.4	$858.6	$792.5	$722	$967
Skyfall	2012	$1,108.6	$304.4	$804.2	$761.0	$656	$960
The Jungle Book	2016	$966.3	$364.0	$602.3	$561.6	$587	$951
Toy Story 3	2010	$1,067.0	$415.0	$652.0	$633.0	$528	$943
The Dark Knight	2008^	$1,004.6	$534.9	$469.7	$440.1	$377	$912
The Hobbit: The Battle of the Five Armies	2014	$956.0	$255.1	$700.9	$560.4	$638	$893
Finding Nemo	2003^	$940.3	$380.8	$559.5	$454.8	$507	$888
Alice in Wonderland	2010	$1,025.5	$334.2	$691.3	$635.2	$541	$875
The Hobbit: An Unexpected Journey	2012	$1,021.1	$303.0	$718.1	$678.8	$568	$871
Batman v Superman: Dawn of Justice	2016	$873.3	$330.4	$542.9	$509.7	$539	$869
Spectre	2015	$880.7	$200.1	$680.6	$646.1	$657	$857
Despicable Me 2	2013	$970.8	$368.1	$602.7	$571.5	$482	$850
Pirates of the Caribbean: At World's End	2007	$963.4	$309.4	$654.0	$644.7	$540	$850
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$241.1	$804.6	$778.1	$599	$840
Harry Potter and the Order of the Phoenix	2007	$939.9	$292.0	$647.9	$646.9	$533	$825
Inside Out	2015	$857.6	$356.5	$501.1	$499.8	$466	$823
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$296.0	$664.3	$669.8	$519	$815
The Hobbit: The Desolation of Smaug	2013	$958.4	$258.4	$700.0	$653.0	$557	$815
Harry Potter and the Half-Blood Prince	2009	$934.4	$302.0	$632.5	$609.0	$504	$806
Deadpool	2016	$782.6	$363.1	$419.5	$401.6	$433	$797
Transformers: Revenge of the Fallen	2009	$836.3	$402.1	$434.2	$426.3	$379	$781
Spider-Man 3	2007	$890.9	$336.5	$554.3	$549.6	$440	$777
The Hunger Games: Catching Fire	2013	$865.0	$424.7	$440.3	$411.3	$347	$772
Inception	2010	$825.5	$292.6	$533.0	$531.0	$449	$742
Ice Age: Continental Drift	2012	$877.2	$161.3	$715.9	$683.3	$558	$720
The Twilight Saga: Breaking Dawn Part 2	2012	$829.7	$292.3	$537.4	$526.3	$412	$704
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$196.6	$690.1	$661.0	$507	$703
The Hunger Games: Mockingjay - Part 1	2014	$755.4	$337.1	$418.2	$399.2	$359	$696
Guardians of the Galaxy	2014	$773.3	$333.2	$440.1	$416.8	$356	$689
Shrek the Third	2007	$799.0	$322.7	$476.2	$467.6	$362	$684
Fast & Furious 6	2013	$788.7	$238.7	$550.0	$501.0	$437	$676
The Amazing Spider-Man	2012	$757.9	$262.0	$495.9	$483.6	$400	$662
Indiana Jones and the Kingdom of the Crystal Skull	2008	$786.6	$317.1	$469.5	$466.7	$340	$658
Maleficent	2014	$758.5	$241.4	$517.1	$489.0	$414	$656
Monsters University	2013	$744.2	$268.5	$475.7	$449.6	$383	$651
Up	2009	$735.1	$293.0	$442.1	$410.0	$347	$640
Captain America: The Winter Soldier	2014	$714.4	$259.8	$454.7	$417.9	$378	$638
2012	2009	$769.7	$166.1	$603.6	$563.2	$472	$638
Shrek Forever After	2010	$752.6	$238.7	$513.9	$511.6	$399	$637
Gravity	2013	$723.2	$274.1	$449.1	$333.0	$357	$631
Madagascar 3: Europe's Most Wanted	2012	$746.9	$216.4	$530.5	$488.6	$410	$626

 

 

Edited November 6, 2016 by Jason
added methodology details

[Jason]

I've finished adjusting all the films in the master table for ticket price inflation as well as exchange rates.

 

Also added the following 12 films:

• Harry Potter and the Sorcerer's Stone
• The Lord of the Rings: The Two Towers
• Shrek 2
• Harry Potter and the Goblet of Fire
• Harry Potter and the Chamber of Secrets
• The Lord of the Rings: The Fellowship of the Ring
• Star Wars: Episode III - Revenge of the Sith
• Spider-Man
• Harry Potter and the Prisoner of Azkaban
• Spider-Man 2
• The Da Vinci Code
• X-Men: Days of Future Past

Also updated the exchange rate adjustment to be current as of November 18.

 

Tables using exchange rates as of October 24, for comparison purposes:

Spoiler

Sorted by original WW:

Quote

Title	Year	WW	WW ER	WW TP	Dom	Adj D	OS	OS ER	OS TP	%Tr	%Tic
Avatar	2009^	$2,788.0	$2,373	$2,685	$760.5	$837	$2,027.5	$1,613	$1,848	96.1%	88.7%
Titanic	1997^	$2,186.8	$2,126	$3,300	$658.7	$1,166	$1,528.1	$1,468	$2,134	71.7%	51.5%
Star Wars: The Force Awakens	2015	$2,068.2	$2,060	$2,063	$936.7	$931	$1,131.6	$1,123	$1,132	97.8%	89.7%
Jurassic World	2015	$1,670.4	$1,602	$1,642	$652.3	$681	$1,018.1	$950	$961	94.3%	81.3%
Marvel's The Avengers	2012	$1,518.8	$1,320	$1,406	$623.4	$662	$895.5	$696	$744	94.1%	77.9%
Furious 7	2015	$1,516.0	$1,424	$1,434	$353.0	$353	$1,163.0	$1,071	$1,081	93.3%	80.1%
Avengers: Age of Ultron	2015	$1,405.4	$1,324	$1,339	$459.0	$461	$946.4	$865	$878	97.2%	82.2%
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$1,096	$1,195	$381.0	$413	$960.5	$715	$781	96.6%	86.9%
Frozen	2013	$1,276.5	$1,139	$1,204	$400.7	$422	$875.7	$738	$781	96.3%	90.4%
Iron Man 3	2013	$1,214.8	$1,053	$1,094	$409.0	$420	$805.8	$644	$673	93.8%	78.3%
Minions	2015	$1,159.4	$1,097	$1,138	$336.0	$351	$823.4	$761	$787	92.7%	79.3%
Captain America: Civil War	2016	$1,153.3	$1,130	$1,128	$408.1	$408	$745.2	$722	$720	92.8%	79.5%
Transformers: Dark of the Moon	2011	$1,123.8	$974	$1,032	$352.4	$381	$771.4	$621	$651	97.0%	80.9%
The Lord of the Rings: The Return of the King	2003^	$1,119.9	$1,030	$1,489	$377.8	$531	$742.1	$652	$959	99.3%	65.8%
Skyfall	2012	$1,108.6	$951	$1,013	$304.4	$326	$804.2	$646	$687	94.6%	87.7%
Transformers: Age of Extinction	2014	$1,104.1	$961	$969	$245.4	$259	$858.6	$716	$710	92.3%	81.7%
The Dark Knight Rises	2012	$1,084.9	$967	$1,058	$448.1	$496	$636.8	$519	$563	95.9%	84.5%
Toy Story 3	2010	$1,067.0	$938	$1,041	$415.0	$449	$652.0	$523	$592	97.1%	88.1%
Pirates of the Caribbean: Dead Man's Chest	2006	$1,066.2	$963	$1,261	$423.3	$556	$642.9	$539	$704	93.5%	86.4%
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$833	$909	$241.1	$262	$804.6	$591	$647	96.7%	88.5%
Star Wars: Episode I - The Phantom Menace	1999^	$1,027.0	$1,034	$1,587	$474.5	$778	$552.5	$560	$809	82.5%	65.8%
Alice in Wonderland	2010	$1,025.5	$869	$960	$334.2	$362	$691.3	$535	$598	91.9%	85.3%
Zootopia	2016	$1,023.8	$1,018	$1,017	$341.3	$341	$682.5	$677	$676	98.5%	91.3%
The Hobbit: An Unexpected Journey	2012	$1,021.1	$862	$924	$303.0	$326	$718.1	$559	$599	94.5%	86.8%
The Dark Knight	2008^	$1,004.6	$908	$1,117	$534.9	$641	$469.7	$373	$476	93.7%	82.7%
Harry Potter and the Sorcerer's Stone	2001	$974.8	$1,063	$1,494	$317.6	$481	$657.2	$745	$1,013	81.5%	65.1%
Despicable Me 2	2013	$970.8	$846	$913	$368.1	$404	$602.7	$478	$510	94.8%	85.2%
The Jungle Book	2016	$966.5	$945	$944	$364.0	$364	$602.5	$581	$580	93.2%	84.5%
Pirates of the Caribbean: At World's End	2007	$963.4	$843	$1,069	$309.4	$387	$654.0	$533	$682	98.6%	90.4%
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$809	$892	$296.0	$323	$664.3	$513	$569	100.0%	92.0%
The Hobbit: The Desolation of Smaug	2013	$958.4	$807	$847	$258.4	$274	$700.0	$549	$574	93.3%	86.2%
The Hobbit: The Battle of the Five Armies	2014	$956.0	$883	$903	$255.1	$269	$700.9	$628	$635	79.9%	73.8%
Finding Nemo	2003^	$940.3	$877	$1,192	$380.8	$530	$559.5	$496	$662	81.3%	66.5%
Harry Potter and the Order of the Phoenix	2007	$939.9	$811	$1,025	$292.0	$365	$647.9	$519	$659	99.8%	90.6%
Harry Potter and the Half-Blood Prince	2009	$934.4	$800	$935	$302.0	$348	$632.5	$498	$586	96.3%	88.5%
The Lord of the Rings: The Two Towers	2002^	$926.0	$938	$1,362	$342.6	$497	$583.5	$595	$865	97.2%	66.5%
Shrek 2	2004	$919.8	$852	$1,199	$441.2	$612	$478.6	$410	$588	96.8%	65.7%
Harry Potter and the Goblet of Fire	2005	$896.9	$845	$1,137	$290.0	$389	$606.9	$555	$748	93.0%	85.8%
Spider-Man 3	2007	$890.9	$772	$994	$336.5	$421	$554.3	$435	$573	99.2%	85.9%
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$696	$837	$196.6	$226	$690.1	$500	$611	95.8%	87.5%
Spectre	2015	$880.7	$848	$854	$200.1	$204	$680.6	$648	$650	94.9%	84.7%
Harry Potter and the Chamber of Secrets	2002	$879.0	$911	$1,280	$262.0	$387	$617.0	$649	$893	90.1%	72.9%
Ice Age: Continental Drift	2012	$877.2	$714	$787	$161.3	$174	$715.9	$552	$612	95.4%	85.1%
Batman v Superman: Dawn of Justice	2016	$873.3	$866	$865	$330.4	$330	$542.9	$535	$535	93.9%	78.6%
The Lord of the Rings: The Fellowship of the Ring	2001^	$871.5	$938	$1,415	$315.5	$472	$556.0	$622	$943	97.2%	66.9%
The Hunger Games: Catching Fire	2013	$865.0	$768	$801	$424.7	$440	$440.3	$343	$360	93.4%	83.5%
Inside Out	2015	$857.6	$817	$851	$356.5	$372	$501.1	$461	$479	99.7%	83.7%
Star Wars: Episode III - Revenge of the Sith	2005^	$848.8	$857	$1,146	$380.3	$511	$468.5	$476	$635	91.5%	83.4%
Transformers: Revenge of the Fallen	2009	$836.3	$776	$927	$402.1	$464	$434.2	$374	$463	98.2%	83.2%
The Twilight Saga: Breaking Dawn Part 2	2012	$829.7	$700	$758	$292.3	$316	$537.4	$407	$442	97.9%	85.4%
Inception	2010	$825.5	$735	$806	$292.6	$319	$533.0	$443	$487	99.6%	92.1%
Spider-Man	2002	$821.7	$845	$1,257	$403.7	$598	$418.0	$441	$659	93.4%	59.6%
Shrek the Third	2007	$799.0	$679	$861	$322.7	$404	$476.2	$356	$457	98.2%	90.6%
Harry Potter and the Prisoner of Azkaban	2004	$796.7	$744	$1,019	$249.5	$346	$547.1	$495	$673	90.9%	68.8%
Fast & Furious 6	2013	$788.7	$672	$708	$238.7	$253	$550.0	$433	$455	91.1%	78.6%
Indiana Jones and the Kingdom of the Crystal Skull	2008	$786.6	$653	$792	$317.1	$380	$469.5	$336	$412	99.4%	91.9%
Spider-Man 2	2004	$783.8	$739	$1,041	$373.6	$518	$410.2	$365	$523	94.9%	61.9%
Deadpool	2016	$782.6	$793	$793	$363.1	$363	$419.5	$429	$430	95.7%	79.5%
Guardians of the Galaxy	2014	$773.3	$685	$713	$333.2	$355	$440.2	$352	$358	94.7%	83.8%
2012	2009	$769.7	$632	$725	$166.1	$191	$603.6	$466	$534	93.3%	80.3%
Maleficent	2014	$758.5	$653	$681	$241.4	$254	$517.1	$412	$427	94.6%	79.5%
The Da Vinci Code	2006	$758.2	$676	$897	$217.5	$286	$540.7	$458	$611	99.8%	88.4%
The Amazing Spider-Man	2012	$757.9	$659	$708	$262.0	$283	$495.9	$397	$424	97.5%	79.6%
The Hunger Games: Mockingjay - Part 1	2014	$755.4	$692	$714	$337.1	$351	$418.2	$355	$364	95.5%	81.2%
Shrek Forever After	2010	$752.6	$632	$719	$238.7	$260	$513.9	$394	$459	99.6%	90.6%
X-Men: Days of Future Past	2014	$747.9	$651	$669	$233.9	$246	$513.9	$417	$423	93.2%	81.2%
Madagascar 3: Europe's Most Wanted	2012	$746.9	$621	$675	$216.4	$234	$530.5	$405	$441	92.1%	83.3%
Monsters University	2013	$744.2	$649	$695	$268.5	$284	$475.7	$380	$411	94.5%	83.8%
Up	2009	$735.1	$636	$737	$293.0	$338	$442.1	$343	$398	92.7%	84.8%
Gravity	2013	$723.2	$626	$661	$274.1	$290	$449.1	$352	$371	74.2%	83.4%
Captain America: The Winter Soldier	2014	$714.3	$635	$653	$259.8	$274	$454.5	$375	$379	92.0%	78.4%

Sorted by ER adjusted WW:

Quote

Title	Year	WW	WW ER	WW TP	Dom	Adj D	OS	OS ER	OS TP	%Tr	%Tic
Avatar	2009^	$2,788.0	$2,373	$2,685	$760.5	$837	$2,027.5	$1,613	$1,848	96.1%	88.7%
Titanic	1997^	$2,186.8	$2,126	$3,300	$658.7	$1,166	$1,528.1	$1,468	$2,134	71.7%	51.5%
Star Wars: The Force Awakens	2015	$2,068.2	$2,060	$2,063	$936.7	$931	$1,131.6	$1,123	$1,132	97.8%	89.7%
Jurassic World	2015	$1,670.4	$1,602	$1,642	$652.3	$681	$1,018.1	$950	$961	94.3%	81.3%
Furious 7	2015	$1,516.0	$1,424	$1,434	$353.0	$353	$1,163.0	$1,071	$1,081	93.3%	80.1%
Avengers: Age of Ultron	2015	$1,405.4	$1,324	$1,339	$459.0	$461	$946.4	$865	$878	97.2%	82.2%
Marvel's The Avengers	2012	$1,518.8	$1,320	$1,406	$623.4	$662	$895.5	$696	$744	94.1%	77.9%
Frozen	2013	$1,276.5	$1,139	$1,204	$400.7	$422	$875.7	$738	$781	96.3%	90.4%
Captain America: Civil War	2016	$1,153.3	$1,130	$1,128	$408.1	$408	$745.2	$722	$720	92.8%	79.5%
Minions	2015	$1,159.4	$1,097	$1,138	$336.0	$351	$823.4	$761	$787	92.7%	79.3%
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$1,096	$1,195	$381.0	$413	$960.5	$715	$781	96.6%	86.9%
Harry Potter and the Sorcerer's Stone	2001	$974.8	$1,063	$1,494	$317.6	$481	$657.2	$745	$1,013	81.5%	65.1%
Iron Man 3	2013	$1,214.8	$1,053	$1,094	$409.0	$420	$805.8	$644	$673	93.8%	78.3%
Star Wars: Episode I - The Phantom Menace	1999^	$1,027.0	$1,034	$1,587	$474.5	$778	$552.5	$560	$809	82.5%	65.8%
The Lord of the Rings: The Return of the King	2003^	$1,119.9	$1,030	$1,489	$377.8	$531	$742.1	$652	$959	99.3%	65.8%
Zootopia	2016	$1,023.8	$1,018	$1,017	$341.3	$341	$682.5	$677	$676	98.5%	91.3%
Transformers: Dark of the Moon	2011	$1,123.8	$974	$1,032	$352.4	$381	$771.4	$621	$651	97.0%	80.9%
The Dark Knight Rises	2012	$1,084.9	$967	$1,058	$448.1	$496	$636.8	$519	$563	95.9%	84.5%
Pirates of the Caribbean: Dead Man's Chest	2006	$1,066.2	$963	$1,261	$423.3	$556	$642.9	$539	$704	93.5%	86.4%
Transformers: Age of Extinction	2014	$1,104.1	$961	$969	$245.4	$259	$858.6	$716	$710	92.3%	81.7%
Skyfall	2012	$1,108.6	$951	$1,013	$304.4	$326	$804.2	$646	$687	94.6%	87.7%
The Jungle Book	2016	$966.5	$945	$944	$364.0	$364	$602.5	$581	$580	93.2%	84.5%
Toy Story 3	2010	$1,067.0	$938	$1,041	$415.0	$449	$652.0	$523	$592	97.1%	88.1%
The Lord of the Rings: The Two Towers	2002^	$926.0	$938	$1,362	$342.6	$497	$583.5	$595	$865	97.2%	66.5%
The Lord of the Rings: The Fellowship of the Ring	2001^	$871.5	$938	$1,415	$315.5	$472	$556.0	$622	$943	97.2%	66.9%
Harry Potter and the Chamber of Secrets	2002	$879.0	$911	$1,280	$262.0	$387	$617.0	$649	$893	90.1%	72.9%
The Dark Knight	2008^	$1,004.6	$908	$1,117	$534.9	$641	$469.7	$373	$476	93.7%	82.7%
The Hobbit: The Battle of the Five Armies	2014	$956.0	$883	$903	$255.1	$269	$700.9	$628	$635	79.9%	73.8%
Finding Nemo	2003^	$940.3	$877	$1,192	$380.8	$530	$559.5	$496	$662	81.3%	66.5%
Alice in Wonderland	2010	$1,025.5	$869	$960	$334.2	$362	$691.3	$535	$598	91.9%	85.3%
Batman v Superman: Dawn of Justice	2016	$873.3	$866	$865	$330.4	$330	$542.9	$535	$535	93.9%	78.6%
The Hobbit: An Unexpected Journey	2012	$1,021.1	$862	$924	$303.0	$326	$718.1	$559	$599	94.5%	86.8%
Star Wars: Episode III - Revenge of the Sith	2005^	$848.8	$857	$1,146	$380.3	$511	$468.5	$476	$635	91.5%	83.4%
Shrek 2	2004	$919.8	$852	$1,199	$441.2	$612	$478.6	$410	$588	96.8%	65.7%
Spectre	2015	$880.7	$848	$854	$200.1	$204	$680.6	$648	$650	94.9%	84.7%
Despicable Me 2	2013	$970.8	$846	$913	$368.1	$404	$602.7	$478	$510	94.8%	85.2%
Harry Potter and the Goblet of Fire	2005	$896.9	$845	$1,137	$290.0	$389	$606.9	$555	$748	93.0%	85.8%
Spider-Man	2002	$821.7	$845	$1,257	$403.7	$598	$418.0	$441	$659	93.4%	59.6%
Pirates of the Caribbean: At World's End	2007	$963.4	$843	$1,069	$309.4	$387	$654.0	$533	$682	98.6%	90.4%
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$833	$909	$241.1	$262	$804.6	$591	$647	96.7%	88.5%
Inside Out	2015	$857.6	$817	$851	$356.5	$372	$501.1	$461	$479	99.7%	83.7%
Harry Potter and the Order of the Phoenix	2007	$939.9	$811	$1,025	$292.0	$365	$647.9	$519	$659	99.8%	90.6%
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$809	$892	$296.0	$323	$664.3	$513	$569	100.0%	92.0%
The Hobbit: The Desolation of Smaug	2013	$958.4	$807	$847	$258.4	$274	$700.0	$549	$574	93.3%	86.2%
Harry Potter and the Half-Blood Prince	2009	$934.4	$800	$935	$302.0	$348	$632.5	$498	$586	96.3%	88.5%
Deadpool	2016	$782.6	$793	$793	$363.1	$363	$419.5	$429	$430	95.7%	79.5%
Transformers: Revenge of the Fallen	2009	$836.3	$776	$927	$402.1	$464	$434.2	$374	$463	98.2%	83.2%
Spider-Man 3	2007	$890.9	$772	$994	$336.5	$421	$554.3	$435	$573	99.2%	85.9%
The Hunger Games: Catching Fire	2013	$865.0	$768	$801	$424.7	$440	$440.3	$343	$360	93.4%	83.5%
Harry Potter and the Prisoner of Azkaban	2004	$796.7	$744	$1,019	$249.5	$346	$547.1	$495	$673	90.9%	68.8%
Spider-Man 2	2004	$783.8	$739	$1,041	$373.6	$518	$410.2	$365	$523	94.9%	61.9%
Inception	2010	$825.5	$735	$806	$292.6	$319	$533.0	$443	$487	99.6%	92.1%
Ice Age: Continental Drift	2012	$877.2	$714	$787	$161.3	$174	$715.9	$552	$612	95.4%	85.1%
The Twilight Saga: Breaking Dawn Part 2	2012	$829.7	$700	$758	$292.3	$316	$537.4	$407	$442	97.9%	85.4%
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$696	$837	$196.6	$226	$690.1	$500	$611	95.8%	87.5%
The Hunger Games: Mockingjay - Part 1	2014	$755.4	$692	$714	$337.1	$351	$418.2	$355	$364	95.5%	81.2%
Guardians of the Galaxy	2014	$773.3	$685	$713	$333.2	$355	$440.2	$352	$358	94.7%	83.8%
Shrek the Third	2007	$799.0	$679	$861	$322.7	$404	$476.2	$356	$457	98.2%	90.6%
The Da Vinci Code	2006	$758.2	$676	$897	$217.5	$286	$540.7	$458	$611	99.8%	88.4%
Fast & Furious 6	2013	$788.7	$672	$708	$238.7	$253	$550.0	$433	$455	91.1%	78.6%
The Amazing Spider-Man	2012	$757.9	$659	$708	$262.0	$283	$495.9	$397	$424	97.5%	79.6%
Maleficent	2014	$758.5	$653	$681	$241.4	$254	$517.1	$412	$427	94.6%	79.5%
Indiana Jones and the Kingdom of the Crystal Skull	2008	$786.6	$653	$792	$317.1	$380	$469.5	$336	$412	99.4%	91.9%
X-Men: Days of Future Past	2014	$747.9	$651	$669	$233.9	$246	$513.9	$417	$423	93.2%	81.2%
Monsters University	2013	$744.2	$649	$695	$268.5	$284	$475.7	$380	$411	94.5%	83.8%
Up	2009	$735.1	$636	$737	$293.0	$338	$442.1	$343	$398	92.7%	84.8%
Captain America: The Winter Soldier	2014	$714.3	$635	$653	$259.8	$274	$454.5	$375	$379	92.0%	78.4%
Shrek Forever After	2010	$752.6	$632	$719	$238.7	$260	$513.9	$394	$459	99.6%	90.6%
2012	2009	$769.7	$632	$725	$166.1	$191	$603.6	$466	$534	93.3%	80.3%
Gravity	2013	$723.2	$626	$661	$274.1	$290	$449.1	$352	$371	74.2%	83.4%
Madagascar 3: Europe's Most Wanted	2012	$746.9	$621	$675	$216.4	$234	$530.5	$405	$441	92.1%	83.3%

Sorted by TP adjusted WW:

Quote

Title	Year	WW	WW ER	WW TP	Dom	Adj D	OS	OS ER	OS TP	%Tr	%Tic
Titanic	1997^	$2,186.8	$2,126	$3,300	$658.7	$1,166	$1,528.1	$1,468	$2,134	71.7%	51.5%
Avatar	2009^	$2,788.0	$2,373	$2,685	$760.5	$837	$2,027.5	$1,613	$1,848	96.1%	88.7%
Star Wars: The Force Awakens	2015	$2,068.2	$2,060	$2,063	$936.7	$931	$1,131.6	$1,123	$1,132	97.8%	89.7%
Jurassic World	2015	$1,670.4	$1,602	$1,642	$652.3	$681	$1,018.1	$950	$961	94.3%	81.3%
Star Wars: Episode I - The Phantom Menace	1999^	$1,027.0	$1,034	$1,587	$474.5	$778	$552.5	$560	$809	82.5%	65.8%
Harry Potter and the Sorcerer's Stone	2001	$974.8	$1,063	$1,494	$317.6	$481	$657.2	$745	$1,013	81.5%	65.1%
The Lord of the Rings: The Return of the King	2003^	$1,119.9	$1,030	$1,489	$377.8	$531	$742.1	$652	$959	99.3%	65.8%
Furious 7	2015	$1,516.0	$1,424	$1,434	$353.0	$353	$1,163.0	$1,071	$1,081	93.3%	80.1%
The Lord of the Rings: The Fellowship of the Ring	2001^	$871.5	$938	$1,415	$315.5	$472	$556.0	$622	$943	97.2%	66.9%
Marvel's The Avengers	2012	$1,518.8	$1,320	$1,406	$623.4	$662	$895.5	$696	$744	94.1%	77.9%
The Lord of the Rings: The Two Towers	2002^	$926.0	$938	$1,362	$342.6	$497	$583.5	$595	$865	97.2%	66.5%
Avengers: Age of Ultron	2015	$1,405.4	$1,324	$1,339	$459.0	$461	$946.4	$865	$878	97.2%	82.2%
Harry Potter and the Chamber of Secrets	2002	$879.0	$911	$1,280	$262.0	$387	$617.0	$649	$893	90.1%	72.9%
Pirates of the Caribbean: Dead Man's Chest	2006	$1,066.2	$963	$1,261	$423.3	$556	$642.9	$539	$704	93.5%	86.4%
Spider-Man	2002	$821.7	$845	$1,257	$403.7	$598	$418.0	$441	$659	93.4%	59.6%
Frozen	2013	$1,276.5	$1,139	$1,204	$400.7	$422	$875.7	$738	$781	96.3%	90.4%
Shrek 2	2004	$919.8	$852	$1,199	$441.2	$612	$478.6	$410	$588	96.8%	65.7%
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$1,096	$1,195	$381.0	$413	$960.5	$715	$781	96.6%	86.9%
Finding Nemo	2003^	$940.3	$877	$1,192	$380.8	$530	$559.5	$496	$662	81.3%	66.5%
Star Wars: Episode III - Revenge of the Sith	2005^	$848.8	$857	$1,146	$380.3	$511	$468.5	$476	$635	91.5%	83.4%
Minions	2015	$1,159.4	$1,097	$1,138	$336.0	$351	$823.4	$761	$787	92.7%	79.3%
Harry Potter and the Goblet of Fire	2005	$896.9	$845	$1,137	$290.0	$389	$606.9	$555	$748	93.0%	85.8%
Captain America: Civil War	2016	$1,153.3	$1,130	$1,128	$408.1	$408	$745.2	$722	$720	92.8%	79.5%
The Dark Knight	2008^	$1,004.6	$908	$1,117	$534.9	$641	$469.7	$373	$476	93.7%	82.7%
Iron Man 3	2013	$1,214.8	$1,053	$1,094	$409.0	$420	$805.8	$644	$673	93.8%	78.3%
Pirates of the Caribbean: At World's End	2007	$963.4	$843	$1,069	$309.4	$387	$654.0	$533	$682	98.6%	90.4%
The Dark Knight Rises	2012	$1,084.9	$967	$1,058	$448.1	$496	$636.8	$519	$563	95.9%	84.5%
Toy Story 3	2010	$1,067.0	$938	$1,041	$415.0	$449	$652.0	$523	$592	97.1%	88.1%
Spider-Man 2	2004	$783.8	$739	$1,041	$373.6	$518	$410.2	$365	$523	94.9%	61.9%
Transformers: Dark of the Moon	2011	$1,123.8	$974	$1,032	$352.4	$381	$771.4	$621	$651	97.0%	80.9%
Harry Potter and the Order of the Phoenix	2007	$939.9	$811	$1,025	$292.0	$365	$647.9	$519	$659	99.8%	90.6%
Harry Potter and the Prisoner of Azkaban	2004	$796.7	$744	$1,019	$249.5	$346	$547.1	$495	$673	90.9%	68.8%
Zootopia	2016	$1,023.8	$1,018	$1,017	$341.3	$341	$682.5	$677	$676	98.5%	91.3%
Skyfall	2012	$1,108.6	$951	$1,013	$304.4	$326	$804.2	$646	$687	94.6%	87.7%
Spider-Man 3	2007	$890.9	$772	$994	$336.5	$421	$554.3	$435	$573	99.2%	85.9%
Transformers: Age of Extinction	2014	$1,104.1	$961	$969	$245.4	$259	$858.6	$716	$710	92.3%	81.7%
Alice in Wonderland	2010	$1,025.5	$869	$960	$334.2	$362	$691.3	$535	$598	91.9%	85.3%
The Jungle Book	2016	$966.5	$945	$944	$364.0	$364	$602.5	$581	$580	93.2%	84.5%
Harry Potter and the Half-Blood Prince	2009	$934.4	$800	$935	$302.0	$348	$632.5	$498	$586	96.3%	88.5%
Transformers: Revenge of the Fallen	2009	$836.3	$776	$927	$402.1	$464	$434.2	$374	$463	98.2%	83.2%
The Hobbit: An Unexpected Journey	2012	$1,021.1	$862	$924	$303.0	$326	$718.1	$559	$599	94.5%	86.8%
Despicable Me 2	2013	$970.8	$846	$913	$368.1	$404	$602.7	$478	$510	94.8%	85.2%
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$833	$909	$241.1	$262	$804.6	$591	$647	96.7%	88.5%
The Hobbit: The Battle of the Five Armies	2014	$956.0	$883	$903	$255.1	$269	$700.9	$628	$635	79.9%	73.8%
The Da Vinci Code	2006	$758.2	$676	$897	$217.5	$286	$540.7	$458	$611	99.8%	88.4%
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$809	$892	$296.0	$323	$664.3	$513	$569	100.0%	92.0%
Batman v Superman: Dawn of Justice	2016	$873.3	$866	$865	$330.4	$330	$542.9	$535	$535	93.9%	78.6%
Shrek the Third	2007	$799.0	$679	$861	$322.7	$404	$476.2	$356	$457	98.2%	90.6%
Spectre	2015	$880.7	$848	$854	$200.1	$204	$680.6	$648	$650	94.9%	84.7%
Inside Out	2015	$857.6	$817	$851	$356.5	$372	$501.1	$461	$479	99.7%	83.7%
The Hobbit: The Desolation of Smaug	2013	$958.4	$807	$847	$258.4	$274	$700.0	$549	$574	93.3%	86.2%
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$696	$837	$196.6	$226	$690.1	$500	$611	95.8%	87.5%
Inception	2010	$825.5	$735	$806	$292.6	$319	$533.0	$443	$487	99.6%	92.1%
The Hunger Games: Catching Fire	2013	$865.0	$768	$801	$424.7	$440	$440.3	$343	$360	93.4%	83.5%
Deadpool	2016	$782.6	$793	$793	$363.1	$363	$419.5	$429	$430	95.7%	79.5%
Indiana Jones and the Kingdom of the Crystal Skull	2008	$786.6	$653	$792	$317.1	$380	$469.5	$336	$412	99.4%	91.9%
Ice Age: Continental Drift	2012	$877.2	$714	$787	$161.3	$174	$715.9	$552	$612	95.4%	85.1%
The Twilight Saga: Breaking Dawn Part 2	2012	$829.7	$700	$758	$292.3	$316	$537.4	$407	$442	97.9%	85.4%
Up	2009	$735.1	$636	$737	$293.0	$338	$442.1	$343	$398	92.7%	84.8%
2012	2009	$769.7	$632	$725	$166.1	$191	$603.6	$466	$534	93.3%	80.3%
Shrek Forever After	2010	$752.6	$632	$719	$238.7	$260	$513.9	$394	$459	99.6%	90.6%
The Hunger Games: Mockingjay - Part 1	2014	$755.4	$692	$714	$337.1	$351	$418.2	$355	$364	95.5%	81.2%
Guardians of the Galaxy	2014	$773.3	$685	$713	$333.2	$355	$440.2	$352	$358	94.7%	83.8%
Fast & Furious 6	2013	$788.7	$672	$708	$238.7	$253	$550.0	$433	$455	91.1%	78.6%
The Amazing Spider-Man	2012	$757.9	$659	$708	$262.0	$283	$495.9	$397	$424	97.5%	79.6%
Monsters University	2013	$744.2	$649	$695	$268.5	$284	$475.7	$380	$411	94.5%	83.8%
Maleficent	2014	$758.5	$653	$681	$241.4	$254	$517.1	$412	$427	94.6%	79.5%
Madagascar 3: Europe's Most Wanted	2012	$746.9	$621	$675	$216.4	$234	$530.5	$405	$441	92.1%	83.3%
X-Men: Days of Future Past	2014	$747.9	$651	$669	$233.9	$246	$513.9	$417	$423	93.2%	81.2%
Gravity	2013	$723.2	$626	$661	$274.1	$290	$449.1	$352	$371	74.2%	83.4%
Captain America: The Winter Soldier	2014	$714.3	$635	$653	$259.8	$274	$454.5	$375	$379	92.0%	78.4%

 

 

Edited November 20, 2016 by Jason

[Jason]

The post above with ticket price data has been updated to include 13 additional countries:

• Chile
• Egypt
• Hong Kong
• Indonesia
• Malaysia
• Morocco
• New Zealand
• Peru
• Singapore
• Thailand
• United Arab Emirates
• Uruguay
• Venezuela

The 57 territories in my list now account for about 96% of overseas box office gross, up from 87%.

 

I am in the process of updating the existing films in the master table with the additional ticket price data. In the meantime, I'm haven't added any additional films other than Big Hero 6 and Tangled, but the current list with existing ticket price data has been updated to exchange rates as of January 10.

 

Archived table from November 18 (ordered by original WW), for comparison:

Spoiler

Title	Year	WW	WW ER	WW TP	Dom	Adj D	OS	OS ER	OS TP	%Tr	%Tic
Avatar	2009^	$2,788.0	$2,327	$2,629	$760.5	$837	$2,027.5	$1,566	$1,792	96.1%	88.7%
Titanic	1997^	$2,186.8	$2,088	$3,250	$658.7	$1,166	$1,528.1	$1,430	$2,084	71.7%	51.5%
Star Wars: The Force Awakens	2015	$2,068.2	$2,030	$2,032	$936.7	$931	$1,131.6	$1,093	$1,101	97.8%	89.7%
Jurassic World	2015	$1,670.4	$1,576	$1,614	$652.3	$681	$1,018.1	$924	$933	94.3%	81.3%
Marvel's The Avengers	2012	$1,518.8	$1,298	$1,380	$623.4	$662	$895.5	$675	$718	94.1%	77.9%
Furious 7	2015	$1,516.0	$1,393	$1,401	$353.0	$353	$1,163.0	$1,040	$1,048	93.3%	80.1%
Avengers: Age of Ultron	2015	$1,405.4	$1,299	$1,311	$459.0	$461	$946.4	$840	$850	97.2%	82.2%
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$1,075	$1,171	$381.0	$413	$960.5	$694	$758	96.6%	86.9%
Frozen	2013	$1,276.5	$1,111	$1,173	$400.7	$422	$875.7	$710	$750	96.3%	90.4%
Iron Man 3	2013	$1,214.8	$1,034	$1,072	$409.0	$420	$805.8	$625	$652	93.8%	78.3%
Minions	2015	$1,159.4	$1,074	$1,111	$336.0	$351	$823.4	$738	$761	92.7%	79.3%
Captain America: Civil War	2016	$1,153.3	$1,108	$1,104	$408.1	$408	$745.2	$700	$696	92.8%	79.5%
Transformers: Dark of the Moon	2011	$1,123.8	$956	$1,011	$352.4	$381	$771.4	$604	$630	97.0%	80.9%
The Lord of the Rings: The Return of the King	2003^	$1,119.9	$1,012	$1,467	$377.8	$531	$742.1	$634	$936	99.3%	65.8%
Skyfall	2012	$1,108.6	$937	$998	$304.4	$326	$804.2	$633	$672	94.6%	87.7%
Transformers: Age of Extinction	2014	$1,104.1	$942	$948	$245.4	$259	$858.6	$696	$689	92.3%	81.7%
The Dark Knight Rises	2012	$1,084.9	$954	$1,042	$448.1	$496	$636.8	$505	$546	95.9%	84.5%
Toy Story 3	2010	$1,067.0	$922	$1,022	$415.0	$449	$652.0	$507	$572	97.1%	88.1%
Pirates of the Caribbean: Dead Man's Chest	2006	$1,066.2	$947	$1,240	$423.3	$556	$642.9	$523	$684	93.5%	86.4%
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$814	$887	$241.1	$262	$804.6	$573	$625	96.7%	88.5%
Star Wars: Episode I - The Phantom Menace	1999^	$1,027.0	$1,018	$1,566	$474.5	$778	$552.5	$543	$789	82.5%	65.8%
Alice in Wonderland	2010	$1,025.5	$851	$939	$334.2	$362	$691.3	$516	$577	91.9%	85.3%
Zootopia	2016	$1,023.8	$999	$997	$341.3	$341	$682.5	$658	$656	98.5%	91.3%
The Hobbit: An Unexpected Journey	2012	$1,021.1	$848	$908	$303.0	$326	$718.1	$545	$582	94.5%	86.8%
The Dark Knight	2008^	$1,004.6	$899	$1,105	$534.9	$641	$469.7	$364	$464	93.7%	82.7%
Harry Potter and the Sorcerer's Stone	2001	$974.8	$1,039	$1,466	$317.6	$481	$657.2	$721	$985	81.5%	65.1%
Despicable Me 2	2013	$970.8	$831	$897	$368.1	$404	$602.7	$463	$493	94.8%	85.2%
The Jungle Book	2016	$966.5	$931	$929	$364.0	$364	$602.5	$567	$565	93.2%	84.5%
Pirates of the Caribbean: At World's End	2007	$963.4	$826	$1,047	$309.4	$387	$654.0	$516	$660	98.6%	90.4%
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$794	$875	$296.0	$323	$664.3	$498	$552	100.0%	92.0%
The Hobbit: The Desolation of Smaug	2013	$958.4	$793	$831	$258.4	$274	$700.0	$534	$558	93.3%	86.2%
The Hobbit: The Battle of the Five Armies	2014	$956.0	$869	$889	$255.1	$269	$700.9	$613	$620	79.9%	73.8%
Finding Nemo	2003^	$940.3	$862	$1,175	$380.8	$530	$559.5	$481	$645	81.3%	66.5%
Harry Potter and the Order of the Phoenix	2007	$939.9	$796	$1,005	$292.0	$365	$647.9	$504	$639	99.8%	90.6%
Harry Potter and the Half-Blood Prince	2009	$934.4	$785	$916	$302.0	$348	$632.5	$483	$568	96.3%	88.5%
The Lord of the Rings: The Two Towers	2002^	$926.0	$922	$1,342	$342.6	$497	$583.5	$579	$845	97.2%	66.5%
Shrek 2	2004	$919.8	$841	$1,189	$441.2	$612	$478.6	$400	$577	96.8%	65.7%
Harry Potter and the Goblet of Fire	2005	$896.9	$828	$1,114	$290.0	$389	$606.9	$538	$725	93.0%	85.8%
Spider-Man 3	2007	$890.9	$762	$980	$336.5	$421	$554.3	$426	$559	99.2%	85.9%
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$681	$816	$196.6	$226	$690.1	$485	$590	95.8%	87.5%
Spectre	2015	$880.7	$834	$840	$200.1	$204	$680.6	$634	$636	94.9%	84.7%
Harry Potter and the Chamber of Secrets	2002	$879.0	$890	$1,255	$262.0	$387	$617.0	$628	$869	90.1%	72.9%
Ice Age: Continental Drift	2012	$877.2	$696	$766	$161.3	$174	$715.9	$535	$592	95.4%	85.1%
Batman v Superman: Dawn of Justice	2016	$873.3	$848	$846	$330.4	$330	$542.9	$518	$516	93.9%	78.6%
The Lord of the Rings: The Fellowship of the Ring	2001^	$871.5	$921	$1,395	$315.5	$472	$556.0	$605	$923	97.2%	66.9%
The Hunger Games: Catching Fire	2013	$865.0	$758	$790	$424.7	$440	$440.3	$334	$350	93.4%	83.5%
Inside Out	2015	$857.6	$804	$835	$356.5	$372	$501.1	$447	$463	99.7%	83.7%
Star Wars: Episode III - Revenge of the Sith	2005^	$848.8	$844	$1,130	$380.3	$511	$468.5	$463	$619	91.5%	83.4%
Transformers: Revenge of the Fallen	2009	$836.3	$766	$913	$402.1	$464	$434.2	$364	$449	98.2%	83.2%
The Twilight Saga: Breaking Dawn Part 2	2012	$829.7	$686	$742	$292.3	$316	$537.4	$394	$426	97.9%	85.4%
Inception	2010	$825.5	$724	$793	$292.6	$319	$533.0	$431	$473	99.6%	92.1%
Spider-Man	2002	$821.7	$831	$1,241	$403.7	$598	$418.0	$427	$643	93.4%	59.6%
Shrek the Third	2007	$799.0	$669	$848	$322.7	$404	$476.2	$346	$444	98.2%	90.6%
Harry Potter and the Prisoner of Azkaban	2004	$796.7	$729	$1,001	$249.5	$346	$547.1	$479	$655	90.9%	68.8%
Fast & Furious 6	2013	$788.7	$658	$693	$238.7	$253	$550.0	$420	$440	91.1%	78.6%
Indiana Jones and the Kingdom of the Crystal Skull	2008	$786.6	$643	$780	$317.1	$380	$469.5	$326	$400	99.4%	91.9%
Spider-Man 2	2004	$783.8	$727	$1,028	$373.6	$518	$410.2	$353	$510	94.9%	61.9%
Deadpool	2016	$782.6	$779	$778	$363.1	$363	$419.5	$416	$415	95.7%	79.5%
Guardians of the Galaxy	2014	$773.3	$676	$703	$333.2	$355	$440.2	$343	$349	94.7%	83.8%
2012	2009	$769.7	$618	$707	$166.1	$191	$603.6	$452	$516	93.3%	80.3%
Maleficent	2014	$758.5	$638	$664	$241.4	$254	$517.1	$396	$409	94.6%	79.5%
The Da Vinci Code	2006	$758.2	$661	$877	$217.5	$286	$540.7	$444	$591	99.8%	88.4%
The Amazing Spider-Man	2012	$757.9	$646	$693	$262.0	$283	$495.9	$384	$410	97.5%	79.6%
The Hunger Games: Mockingjay - Part 1	2014	$755.4	$683	$703	$337.1	$351	$418.2	$346	$353	95.5%	81.2%
Shrek Forever After	2010	$752.6	$620	$704	$238.7	$260	$513.9	$381	$443	99.6%	90.6%
X-Men: Days of Future Past	2014	$747.9	$640	$657	$233.9	$246	$513.9	$406	$410	93.2%	81.2%
Madagascar 3: Europe's Most Wanted	2012	$746.9	$608	$659	$216.4	$234	$530.5	$392	$425	92.1%	83.3%
Monsters University	2013	$744.2	$635	$680	$268.5	$284	$475.7	$367	$395	94.5%	83.8%
Up	2009	$735.1	$626	$724	$293.0	$338	$442.1	$333	$386	92.7%	84.8%
Gravity	2013	$723.2	$616	$651	$274.1	$290	$449.1	$342	$360	74.2%	83.4%
Captain America: The Winter Soldier	2014	$714.3	$624	$641	$259.8	$274	$454.5	$364	$367	92.0%	78.4%

Adjusted OS grosses are now an average of 0.7% lower compared to November 18.

 

Edited January 12, 2017 by Jason
added a link, made a note of the change since Nov. 18

[peludo]

@Jason Thank you again for your hard work

 

This chart shows how hard is to reach 1 billion OS. Just 4 films would had reached today that mark (Titanic, Avatar, SW7 and F7), even less than the real 5 (JW would lose that privilege). And just another 4 would had made over 900 (JW, HP1, FOTR and ROTK). I guess that among older films just a bunch like Snow White, Gone with the Wind, 101 dalmatians, Jungle Book (1967), Jaws, Star Wars, E.T., Jurassic Park and Lion King would have chances to make it. Maybe I am forgetting some more classics but those are the only possible films that come to my mind right now.

[Jason]

I've finished adjusting the films in the table with the additional ticket price data. I've also added 15 additional films:

• Brave
• Cars
• Cars 2
• Finding Dory
• Interstellar
• Man of Steel
• Ratatouille
• Star Wars: Episode II - Attack of the Clones
• Suicide Squad
• The Hunger Games
• The Hunger Games: Mockingjay - Part 2
• The Secret Life of Pets
• Thor: The Dark World
• WALL-E
• Wreck-It Ralph

The exchange rates have been updated to be current as of February 16.

 

Archived table from January 10 (ordered by original WW), for comparison:

Spoiler

Title	Year	WW	WW ER	WW TP	Dom	Adj D	OS	OS ER	OS TP	%Tr	%Tic
Avatar	2009^	$2,788.0	$2,319	$2,622	$760.5	$837	$2,027.5	$1,558	$1,785	96.1%	88.7%
Titanic	1997^	$2,186.8	$2,074	$3,222	$658.7	$1,166	$1,528.1	$1,415	$2,056	71.7%	51.5%
Star Wars: The Force Awakens	2015	$2,068.2	$2,023	$2,024	$936.7	$931	$1,131.6	$1,086	$1,093	97.8%	89.7%
Jurassic World	2015	$1,670.4	$1,570	$1,607	$652.3	$681	$1,018.1	$918	$926	94.3%	81.3%
Marvel's The Avengers	2012	$1,518.8	$1,295	$1,377	$623.4	$662	$895.5	$672	$715	94.1%	77.9%
Furious 7	2015	$1,516.0	$1,391	$1,400	$353.0	$353	$1,163.0	$1,038	$1,047	93.3%	80.1%
Avengers: Age of Ultron	2015	$1,405.4	$1,297	$1,309	$459.0	$461	$946.4	$838	$848	97.2%	82.2%
Harry Potter and the Deathly Hallows Part 2	2011	$1,341.5	$1,069	$1,165	$381.0	$413	$960.5	$688	$752	96.6%	86.9%
Frozen	2013	$1,276.5	$1,099	$1,160	$400.7	$422	$875.7	$698	$738	96.3%	90.4%
Iron Man 3	2013	$1,214.8	$1,033	$1,071	$409.0	$420	$805.8	$624	$651	93.8%	78.3%
Minions	2015	$1,159.4	$1,071	$1,109	$336.0	$351	$823.4	$735	$759	92.7%	79.3%
Captain America: Civil War	2016	$1,153.3	$1,106	$1,102	$408.1	$408	$745.2	$698	$694	92.8%	79.5%
Transformers: Dark of the Moon	2011	$1,123.8	$952	$1,007	$352.4	$381	$771.4	$600	$626	97.0%	80.9%
The Lord of the Rings: The Return of the King	2003^	$1,119.9	$1,005	$1,454	$377.8	$531	$742.1	$628	$923	99.3%	65.8%
Skyfall	2012	$1,108.6	$933	$994	$304.4	$326	$804.2	$629	$668	94.6%	87.7%
Transformers: Age of Extinction	2014	$1,104.1	$940	$946	$245.4	$259	$858.6	$694	$688	92.3%	81.7%
The Dark Knight Rises	2012	$1,084.9	$950	$1,039	$448.1	$496	$636.8	$502	$543	95.9%	84.5%
Toy Story 3	2010	$1,067.0	$914	$1,013	$415.0	$449	$652.0	$499	$564	97.1%	88.1%
Pirates of the Caribbean: Dead Man's Chest	2006	$1,066.2	$940	$1,234	$423.3	$556	$642.9	$517	$677	93.5%	86.4%
Pirates of the Caribbean: On Stranger Tides	2011	$1,045.7	$810	$883	$241.1	$262	$804.6	$569	$622	96.7%	88.5%
Star Wars: Episode I - The Phantom Menace	1999^	$1,027.0	$1,009	$1,553	$474.5	$778	$552.5	$535	$775	82.5%	65.8%
Alice in Wonderland	2010	$1,025.5	$845	$934	$334.2	$362	$691.3	$511	$572	91.9%	85.3%
Zootopia	2016	$1,023.8	$996	$994	$341.3	$341	$682.5	$655	$653	98.5%	91.3%
The Hobbit: An Unexpected Journey	2012	$1,021.1	$846	$906	$303.0	$326	$718.1	$543	$581	94.5%	86.8%
The Dark Knight	2008^	$1,004.6	$896	$1,102	$534.9	$641	$469.7	$361	$461	93.7%	82.7%
Harry Potter and the Sorcerer's Stone	2001	$974.8	$1,027	$1,448	$317.6	$481	$657.2	$709	$966	81.5%	65.1%
Despicable Me 2	2013	$970.8	$830	$896	$368.1	$404	$602.7	$462	$492	94.8%	85.2%
The Jungle Book	2016	$966.5	$928	$926	$364.0	$364	$602.5	$564	$562	93.2%	84.5%
Pirates of the Caribbean: At World's End	2007	$963.4	$820	$1,041	$309.4	$387	$654.0	$510	$654	98.6%	90.4%
Harry Potter and the Deathly Hallows Part 1	2010	$960.3	$790	$871	$296.0	$323	$664.3	$494	$548	100.0%	92.0%
The Hobbit: The Desolation of Smaug	2013	$958.4	$792	$831	$258.4	$274	$700.0	$533	$557	93.3%	86.2%
The Hobbit: The Battle of the Five Armies	2014	$956.0	$866	$886	$255.1	$269	$700.9	$611	$618	79.9%	73.8%
Finding Nemo	2003^	$940.3	$854	$1,164	$380.8	$530	$559.5	$473	$634	81.3%	66.5%
Harry Potter and the Order of the Phoenix	2007	$939.9	$790	$998	$292.0	$365	$647.9	$498	$632	99.8%	90.6%
Harry Potter and the Half-Blood Prince	2009	$934.4	$780	$911	$302.0	$348	$632.5	$478	$563	96.3%	88.5%
The Lord of the Rings: The Two Towers	2002^	$926.0	$916	$1,331	$342.6	$497	$583.5	$573	$834	97.2%	66.5%
Shrek 2	2004	$919.8	$838	$1,183	$441.2	$612	$478.6	$397	$571	96.8%	65.7%
Harry Potter and the Goblet of Fire	2005	$896.9	$821	$1,106	$290.0	$389	$606.9	$531	$717	93.0%	85.8%
Spider-Man 3	2007	$890.9	$760	$978	$336.5	$421	$554.3	$424	$557	99.2%	85.9%
Ice Age: Dawn of the Dinosaurs	2009	$886.7	$682	$818	$196.6	$226	$690.1	$485	$592	95.8%	87.5%
Spectre	2015	$880.7	$830	$836	$200.1	$204	$680.6	$630	$632	94.9%	84.7%
Harry Potter and the Chamber of Secrets	2002	$879.0	$879	$1,239	$262.0	$387	$617.0	$617	$853	90.1%	72.9%
Ice Age: Continental Drift	2012	$877.2	$697	$767	$161.3	$174	$715.9	$535	$593	95.4%	85.1%
Batman v Superman: Dawn of Justice	2016	$873.3	$847	$846	$330.4	$330	$542.9	$517	$515	93.9%	78.6%
The Lord of the Rings: The Fellowship of the Ring	2001^	$871.5	$915	$1,383	$315.5	$472	$556.0	$599	$911	97.2%	66.9%
The Hunger Games: Catching Fire	2013	$865.0	$758	$790	$424.7	$440	$440.3	$333	$350	93.4%	83.5%
Inside Out	2015	$857.6	$801	$832	$356.5	$372	$501.1	$444	$460	99.7%	83.7%
Star Wars: Episode III - Revenge of the Sith	2005^	$848.8	$837	$1,122	$380.3	$511	$468.5	$457	$611	91.5%	83.4%
Transformers: Revenge of the Fallen	2009	$836.3	$764	$910	$402.1	$464	$434.2	$362	$446	98.2%	83.2%
The Twilight Saga: Breaking Dawn Part 2	2012	$829.7	$688	$744	$292.3	$316	$537.4	$395	$428	97.9%	85.4%
Inception	2010	$825.5	$721	$790	$292.6	$319	$533.0	$428	$470	99.6%	92.1%
Spider-Man	2002	$821.7	$826	$1,231	$403.7	$598	$418.0	$422	$633	93.4%	59.6%
Shrek the Third	2007	$799.0	$668	$847	$322.7	$404	$476.2	$345	$443	98.2%	90.6%
Harry Potter and the Prisoner of Azkaban	2004	$796.7	$721	$988	$249.5	$346	$547.1	$471	$642	90.9%	68.8%
Fast & Furious 6	2013	$788.7	$657	$692	$238.7	$253	$550.0	$418	$439	91.1%	78.6%
Indiana Jones and the Kingdom of the Crystal Skull	2008	$786.6	$640	$777	$317.1	$380	$469.5	$323	$396	99.4%	91.9%
Spider-Man 2	2004	$783.8	$724	$1,020	$373.6	$518	$410.2	$350	$502	94.9%	61.9%
Deadpool	2016	$782.6	$780	$779	$363.1	$363	$419.5	$416	$416	95.7%	79.5%
Guardians of the Galaxy	2014	$773.3	$676	$703	$333.2	$355	$440.2	$343	$349	94.7%	83.8%
2012	2009	$769.7	$616	$705	$166.1	$191	$603.6	$450	$515	93.3%	80.3%
Maleficent	2014	$758.5	$636	$662	$241.4	$254	$517.1	$394	$407	94.6%	79.5%
The Da Vinci Code	2006	$758.2	$657	$872	$217.5	$286	$540.7	$439	$586	99.8%	88.4%
The Amazing Spider-Man	2012	$757.9	$644	$691	$262.0	$283	$495.9	$382	$408	97.5%	79.6%
The Hunger Games: Mockingjay - Part 1	2014	$755.4	$682	$703	$337.1	$351	$418.2	$345	$353	95.5%	81.2%
Shrek Forever After	2010	$752.6	$621	$706	$238.7	$260	$513.9	$382	$445	99.6%	90.6%
X-Men: Days of Future Past	2014	$747.9	$639	$656	$233.9	$246	$513.9	$405	$410	93.2%	81.2%
Madagascar 3: Europe's Most Wanted	2012	$746.9	$609	$660	$216.4	$234	$530.5	$392	$426	92.1%	83.3%
Monsters University	2013	$744.2	$631	$674	$268.5	$284	$475.7	$362	$390	94.5%	83.8%
Up	2009	$735.1	$623	$721	$293.0	$338	$442.1	$330	$383	92.7%	84.8%
Gravity	2013	$723.2	$613	$648	$274.1	$290	$449.1	$339	$358	74.2%	83.4%
Captain America: The Winter Soldier	2014	$714.3	$623	$640	$259.8	$274	$454.5	$363	$366	92.0%	78.4%
Big Hero 6	2014	$657.8	$610	$632	$222.5	$234	$435.3	$388	$397	98.8%	87.8%
Tangled	2010	$591.8	$485	$544	$200.8	$219	$391.0	$284	$325	100.0%	91.0%

 

Adjusted OS grosses are now an average of 2.1% higher compared with January 10 exchange rates.

Edited February 18, 2017 by Jason

[kswiston]

@Jason

 

Do you plan on continuing to update this table, or is this a project that you have taken as far as you are interested in taking?