Easy Mac
08-07-2005, 10:34 PM
Why is Hollywood constantly complaining about losing money on film? Well, I though i'd look at the various box office reports and come up with a general figure on movies that cost at least 30 million to make and see if they probably turned a profit or not this summer (basing it on the generally accepted value that studios receive about 55% of a movie's total gross). So basically by adding the domestic and worldwide gross, dividing by 55%, then subtracting the budget, we'll see how much money hollywood is actually losing. (Note, I haven't done this yet, so the results you see, I see). G = Rotten Tomato Grade.
So here's the stats:
<table x:str="" style="border-collapse: collapse; width: 663pt;" border="0" cellpadding="0" cellspacing="0" width="882"> <col style="width: 147pt;" width="196"> <col span="2" style="width: 79pt;" width="105"> <col style="width: 86pt;" width="114"> <col style="width: 89pt;" width="119"> <col style="width: 74pt;" width="98"> <col style="width: 64pt;" width="85"> <col style="width: 20pt;" width="27"> <col style="width: 25pt;" width="33"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 147pt;" height="17" width="196">Movie Title</td> <td class="xl25" style="width: 79pt;" width="105">Domestic</td> <td class="xl25" style="width: 79pt;" width="105">Foreign</td> <td class="xl25" style="width: 86pt;" width="114">Total</td> <td class="xl25" style="width: 89pt;" width="119">Received</td> <td class="xl25" style="width: 74pt;" width="98">Budget</td> <td class="xl25" style="width: 64pt;" width="85">Profit/Loss</td> <td class="xl24" style="width: 20pt;" width="27">Wk</td> <td class="xl27" style="width: 25pt;" width="33">G</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Revenge of the Sith</td> <td class="xl26" x:num="377901000" align="right">$377,901,000</td> <td class="xl26" x:num="434147209" align="right">$434,147,209</td> <td class="xl26" x:num="812048209" x:fmla="=$B2+$C2" align="right">$812,048,209</td> <td class="xl26" x:num="446626514.95000005" x:fmla="=$D2*0.55" align="right">$446,626,515</td> <td class="xl26" x:num="113000000" align="right">$113,000,000</td> <td class="xl26" x:num="333626514.95000005" x:fmla="=$E2-$F2" align="right">$333,626,515</td> <td x:num="" align="right">12</td> <td class="xl28" x:num="0.82" align="right">82%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">War of the Worlds</td> <td class="xl26" x:num="224627000" align="right">$224,627,000</td> <td class="xl26" x:num="312744000" align="right">$312,744,000</td> <td class="xl26" x:num="537371000" x:fmla="=$B3+$C3" align="right">$537,371,000</td> <td class="xl26" x:num="295554050" x:fmla="=$D3*0.55" align="right">$295,554,050</td> <td class="xl26" x:num="132000000" align="right">$132,000,000</td> <td class="xl26" x:num="163554050" x:fmla="=$E3-$F3" align="right">$163,554,050</td> <td x:num="" align="right">6</td> <td class="xl28" x:num="0.72" align="right">72%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Madagascar</td> <td class="xl26" x:num="188707954" align="right">$188,707,954</td> <td class="xl26" x:num="220000000" align="right">$220,000,000</td> <td class="xl26" x:num="408707954" x:fmla="=$B4+$C4" align="right">$408,707,954</td> <td class="xl26" x:num="224789374.70000002" x:fmla="=$D4*0.55" align="right">$224,789,375</td> <td class="xl26" x:num="75000000" align="right">$75,000,000</td> <td class="xl26" x:num="149789374.70000002" x:fmla="=$E4-$F4" align="right">$149,789,375</td> <td x:num="" align="right">10</td> <td class="xl28" x:num="0.54" align="right">54%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Mr. and Mrs. Smith</td> <td class="xl26" x:num="180880000" align="right">$180,880,000</td> <td class="xl26" x:num="176568792" align="right">$176,568,792</td> <td class="xl26" x:num="357448792" x:fmla="=$B5+$C5" align="right">$357,448,792</td> <td class="xl26" x:num="196596835.60000002" x:fmla="=$D5*0.55" align="right">$196,596,836</td> <td class="xl26" x:num="110000000" align="right">$110,000,000</td> <td class="xl26" x:num="86596835.600000024" x:fmla="=$E5-$F5" align="right">$86,596,836</td> <td x:num="" align="right">9</td> <td class="xl28" x:num="0.61" align="right">61%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Robots</td> <td class="xl26" x:num="128134870" align="right">$128,134,870</td> <td class="xl26" x:num="118536037" align="right">$118,536,037</td> <td class="xl26" x:num="246670907" x:fmla="=$B6+$C6" align="right">$246,670,907</td> <td class="xl26" x:num="135668998.85000002" x:fmla="=$D6*0.55" align="right">$135,668,999</td> <td class="xl26" x:num="75000000" align="right">$75,000,000</td> <td class="xl26" x:num="60668998.850000024" x:fmla="=$E6-$F6" align="right">$60,668,999</td> <td x:num="" align="right">21</td> <td class="xl28" x:num="0.63" align="right">63%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Wedding Crashers</td> <td class="xl26" x:num="144099000" align="right">$144,099,000</td> <td class="xl26" x:num="18577435" align="right">$18,577,435</td> <td class="xl26" x:num="162676435" x:fmla="=$B7+$C7" align="right">$162,676,435</td> <td class="xl26" x:num="89472039.25" x:fmla="=$D7*0.55" align="right">$89,472,039</td> <td class="xl26" x:num="40000000" align="right">$40,000,000</td> <td class="xl26" x:num="49472039.25" x:fmla="=$E7-$F7" align="right">$49,472,039</td> <td x:num="" align="right">4</td> <td class="xl28" x:num="0.75" align="right">75%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Batman Begins</td> <td class="xl26" x:num="199126000" align="right">$199,126,000</td> <td class="xl26" x:num="156191000" align="right">$156,191,000</td> <td class="xl26" x:num="355317000" x:fmla="=$B8+$C8" align="right">$355,317,000</td> <td class="xl26" x:num="195424350.00000003" x:fmla="=$D8*0.55" align="right">$195,424,350</td> <td class="xl26" x:num="150000000" align="right">$150,000,000</td> <td class="xl26" x:num="45424350.00000003" x:fmla="=$E8-$F8" align="right">$45,424,350</td> <td x:num="" align="right">8</td> <td class="xl28" x:num="0.83" align="right">83%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Fantastic Four</td> <td class="xl26" x:num="143774000" align="right">$143,774,000</td> <td class="xl26" x:num="109499621" align="right">$109,499,621</td> <td class="xl26" x:num="253273621" x:fmla="=$B9+$C9" align="right">$253,273,621</td> <td class="xl26" x:num="139300491.55000001" x:fmla="=$D9*0.55" align="right">$139,300,492</td> <td class="xl26" x:num="100000000" align="right">$100,000,000</td> <td class="xl26" x:num="39300491.550000012" x:fmla="=$E9-$F9" align="right">$39,300,492</td> <td x:num="" align="right">5</td> <td class="xl28" x:num="0.26" align="right">26%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sin City</td> <td class="xl26" x:num="74093153" align="right">$74,093,153</td> <td class="xl26" x:num="48600000" align="right">$48,600,000</td> <td class="xl26" x:num="122693153" x:fmla="=$B10+$C10" align="right">$122,693,153</td> <td class="xl26" x:num="67481234.150000006" x:fmla="=$D10*0.55" align="right">$67,481,234</td> <td class="xl26" x:num="40000000" align="right">$40,000,000</td> <td class="xl26" x:num="27481234.150000006" x:fmla="=$E10-$F10" align="right">$27,481,234</td> <td x:num="" align="right">18</td> <td class="xl28" x:num="0.78" align="right">78%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Monster-In-Law</td> <td class="xl26" x:num="82531000" align="right">$82,531,000</td> <td class="xl26" x:num="39943063" align="right">$39,943,063</td> <td class="xl26" x:num="122474063" x:fmla="=$B11+$C11" align="right">$122,474,063</td> <td class="xl26" x:num="67360734.650000006" x:fmla="=$D11*0.55" align="right">$67,360,735</td> <td class="xl26" x:num="43000000" align="right">$43,000,000</td> <td class="xl26" x:num="24360734.650000006" x:fmla="=$E11-$F11" align="right">$24,360,735</td> <td x:num="" align="right">13</td> <td class="xl28" x:num="0.17" align="right">17%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">The Longest Yard</td> <td class="xl26" x:num="155936427" align="right">$155,936,427</td> <td class="xl26" x:num="14033122" align="right">$14,033,122</td> <td class="xl26" x:num="169969549" x:fmla="=$B12+$C12" align="right">$169,969,549</td> <td class="xl26" x:num="93483251.950000003" x:fmla="=$D12*0.55" align="right">$93,483,252</td> <td class="xl26" x:num="82000000" align="right">$82,000,000</td> <td class="xl26" x:num="11483251.950000003" x:fmla="=$E12-$F12" align="right">$11,483,252</td> <td x:num="" align="right">10</td> <td class="xl28" x:num="0.3" align="right">30%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Herbie: Fully Loaded</td> <td class="xl26" x:num="63510000" align="right">$63,510,000</td> <td class="xl26" x:num="19977000" align="right">$19,977,000</td> <td class="xl26" x:num="83487000" x:fmla="=$B13+$C13" align="right">$83,487,000</td> <td class="xl26" x:num="45917850" x:fmla="=$D13*0.55" align="right">$45,917,850</td> <td class="xl26" x:num="50000000" align="right">$50,000,000</td> <td class="xl26" x:num="-4082150" x:fmla="=$E13-$F13" align="right">-$4,082,150</td> <td x:num="" align="right">7</td> <td class="xl28" x:num="0.41" align="right">41%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Fever Pitch</td> <td class="xl26" x:num="42069531" align="right">$42,069,531</td> <td class="xl26" x:num="300000" align="right">$300,000</td> <td class="xl26" x:num="42369531" x:fmla="=$B14+$C14" align="right">$42,369,531</td> <td class="xl26" x:num="23303242.050000001" x:fmla="=$D14*0.55" align="right">$23,303,242</td> <td class="xl26" x:num="30000000" align="right">$30,000,000</td> <td class="xl26" x:num="-6696757.9499999993" x:fmla="=$E14-$F14" align="right">-$6,696,758</td> <td x:num="" align="right">17</td> <td class="xl28" x:num="0.62" align="right">62%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sky High</td> <td class="xl26" x:num="32050000" align="right">$32,050,000</td> <td class="xl26" x:num="0" align="right">$0</td> <td class="xl26" x:num="32050000" x:fmla="=$B15+$C15" align="right">$32,050,000</td> <td class="xl26" x:num="17627500" x:fmla="=$D15*0.55" align="right">$17,627,500</td> <td class="xl26" x:num="30000000" align="right">$30,000,000</td> <td class="xl26" x:num="-12372500" x:fmla="=$E15-$F15" align="right">-$12,372,500</td> <td x:num="" align="right">2</td> <td class="xl28" x:num="0.66" align="right">66%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Kingdom of Heaven</td> <td class="xl26" x:num="47351043" align="right">$47,351,043</td> <td class="xl26" x:num="162866403" align="right">$162,866,403</td> <td class="xl26" x:num="210217446" x:fmla="=$B16+$C16" align="right">$210,217,446</td> <td class="xl26" x:num="115619595.30000001" x:fmla="=$D16*0.55" align="right">$115,619,595</td> <td class="xl26" x:num="130000000" align="right">$130,000,000</td> <td class="xl26" x:num="-14380404.699999988" x:fmla="=$E16-$F16" align="right">-$14,380,405</td> <td x:num="" align="right">13</td> <td class="xl28" x:num="0.39" align="right">39%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Kicking and Screaming</td> <td class="xl26" x:num="52664450" align="right">$52,664,450</td> <td class="xl26" x:num="1113042" align="right">$1,113,042</td> <td class="xl26" x:num="53777492" x:fmla="=$B17+$C17" align="right">$53,777,492</td> <td class="xl26" x:num="29577620.600000001" x:fmla="=$D17*0.55" align="right">$29,577,621</td> <td class="xl26" x:num="45000000" align="right">$45,000,000</td> <td class="xl26" x:num="-15422379.399999999" x:fmla="=$E17-$F17" align="right">-$15,422,379</td> <td x:num="" align="right">12</td> <td class="xl28" x:num="0.41" align="right">41%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Must Love Dogs</td> <td class="xl26" x:num="26278000" align="right">$26,278,000</td> <td class="xl26" x:num="0" align="right">$0</td> <td class="xl26" x:num="26278000" x:fmla="=$B18+$C18" align="right">$26,278,000</td> <td class="xl26" x:num="14452900.000000002" x:fmla="=$D18*0.55" align="right">$14,452,900</td> <td class="xl26" x:num="30000000" align="right">$30,000,000</td> <td class="xl26" x:num="-15547099.999999998" x:fmla="=$E18-$F18" align="right">-$15,547,100</td> <td x:num="" align="right">2</td> <td class="xl28" x:num="0.39" align="right">39%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Bad News Bears</td> <td class="xl26" x:num="28664000" align="right">$28,664,000</td> <td class="xl26" x:num="0" align="right">$0</td> <td class="xl26" x:num="28664000" x:fmla="=$B19+$C19" align="right">$28,664,000</td> <td class="xl26" x:num="15765200.000000002" x:fmla="=$D19*0.55" align="right">$15,765,200</td> <td class="xl26" x:num="35000000" align="right">$35,000,000</td> <td class="xl26" x:num="-19234800" x:fmla="=$E19-$F19" align="right">-$19,234,800</td> <td x:num="" align="right">3</td> <td class="xl28" x:num="0.45" align="right">45%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">The Dukes of Hazzard</td> <td class="xl26" x:num="30575000" align="right">$30,575,000</td> <td class="xl26" x:num="0" align="right">$0</td> <td class="xl26" x:num="30575000" x:fmla="=$B20+$C20" align="right">$30,575,000</td> <td class="xl26" x:num="16816250" x:fmla="=$D20*0.55" align="right">$16,816,250</td> <td class="xl26" x:num="50000000" align="right">$50,000,000</td> <td class="xl26" x:num="-33183750" x:fmla="=$E20-$F20" align="right">-$33,183,750</td> <td x:num="" align="right">1</td> <td class="xl28" x:num="0.18" align="right">18%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Charlie & the Chocolate Factory</td> <td class="xl26" x:num="169023000" align="right">$169,023,000</td> <td class="xl26" x:num="37264000" align="right">$37,264,000</td> <td class="xl26" x:num="206287000" x:fmla="=$B21+$C21" align="right">$206,287,000</td> <td class="xl26" x:num="113457850.00000001" x:fmla="=$D21*0.55" align="right">$113,457,850</td> <td class="xl26" x:num="150000000" align="right">$150,000,000</td> <td class="xl26" x:num="-36542149.999999985" x:fmla="=$E21-$F21" align="right">-$36,542,150</td> <td x:num="" align="right">4</td> <td class="xl28" x:num="0.81" align="right">81%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Bewitched</td> <td class="xl26" x:num="60717928" align="right">$60,717,928</td> <td class="xl26" x:num="6771975" align="right">$6,771,975</td> <td class="xl26" x:num="67489903" x:fmla="=$B22+$C22" align="right">$67,489,903</td> <td class="xl26" x:num="37119446.650000006" x:fmla="=$D22*0.55" align="right">$37,119,447</td> <td class="xl26" x:num="85000000" align="right">$85,000,000</td> <td class="xl26" x:num="-47880553.349999994" x:fmla="=$E22-$F22" align="right">-$47,880,553</td> <td x:num="" align="right">6</td> <td class="xl28" x:num="0.26" align="right">26%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Cinderella Man</td> <td class="xl26" x:num="60424655" align="right">$60,424,655</td> <td class="xl26" x:num="0" align="right">$0</td> <td class="xl26" x:num="60424655" x:fmla="=$B23+$C23" align="right">$60,424,655</td> <td class="xl26" x:num="33233560.250000004" x:fmla="=$D23*0.55" align="right">$33,233,560</td> <td class="xl26" x:num="88000000" align="right">$88,000,000</td> <td class="xl26" x:num="-54766439.75" x:fmla="=$E23-$F23" align="right">-$54,766,440</td> <td x:num="" align="right">9</td> <td class="xl28" x:num="0.84" align="right">84%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sahara</td> <td class="xl26" x:num="68671925" align="right">$68,671,925</td> <td class="xl26" x:num="51100000" align="right">$51,100,000</td> <td class="xl26" x:num="119771925" x:fmla="=$B24+$C24" align="right">$119,771,925</td> <td class="xl26" x:num="65874558.750000007" x:fmla="=$D24*0.55" align="right">$65,874,559</td> <td class="xl26" x:num="130000000" align="right">$130,000,000</td> <td class="xl26" x:num="-64125441.249999993" x:fmla="=$E24-$F24" align="right">-$64,125,441</td> <td x:num="" align="right">17</td> <td class="xl28" x:num="0.39" align="right">39%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Stealth</td> <td class="xl26" x:num="24458000" align="right">$24,458,000</td> <td class="xl26" x:num="4468040" align="right">$4,468,040</td> <td class="xl26" x:num="28926040" x:fmla="=$B25+$C25" align="right">$28,926,040</td> <td class="xl26" x:num="15909322.000000002" x:fmla="=$D25*0.55" align="right">$15,909,322</td> <td class="xl26" x:num="100000000" align="right">$100,000,000</td> <td class="xl26" x:num="-84090678" x:fmla="=$E25-$F25" align="right">-$84,090,678</td> <td x:num="" align="right">2</td> <td class="xl28" x:num="0.12" align="right">12%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">The Island</td> <td class="xl26" x:num="30942000" align="right">$30,942,000</td> <td class="xl26" x:num="24045000" align="right">$24,045,000</td> <td class="xl26" x:num="54987000" x:fmla="=$B26+$C26" align="right">$54,987,000</td> <td class="xl26" x:num="30242850.000000004" x:fmla="=$D26*0.55" align="right">$30,242,850</td> <td class="xl26" x:num="122000000" align="right">$122,000,000</td> <td class="xl26" x:num="-91757150" x:fmla="=$E26-$F26" align="right">-$91,757,150</td> <td x:num="" align="right">3</td> <td class="xl28" x:num="0.4" align="right">40%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Totals</td> <td class="xl25" x:num="2637209936" x:fmla="=SUM(B2:B26)" align="right">$2,637,209,936</td> <td class="xl25" x:num="1956745739" x:fmla="=SUM(C2:C26)" align="right">$1,956,745,739</td> <td class="xl25" x:num="4593955675" x:fmla="=$B27+$C27" align="right">$4,593,955,675</td> <td class="xl25" x:num="2526675621.25" x:fmla="=$D27*0.55" align="right">$2,526,675,621</td> <td class="xl25" x:num="2035000000" x:fmla="=SUM(F2:F26)" align="right">$2,035,000,000</td> <td class="xl25" x:num="491675621.25" x:fmla="=$E27-$F27" align="right">$491,675,621</td> <td class="xl24"></td> <td class="xl27"></td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Averages</td> <td class="xl25" x:num="105488397.44" x:fmla="=AVERAGE(B2:B26)" align="right">$105,488,397</td> <td class="xl25" x:num="78269829.560000002" x:fmla="=AVERAGE(C2:C26)" align="right">$78,269,830</td> <td class="xl25" x:num="183758227" x:fmla="=$B28+$C28" align="right">$183,758,227</td> <td class="xl25" x:num="101067024.85000001" x:fmla="=$D28*0.55" align="right">$101,067,025</td> <td class="xl25" x:num="81400000" x:fmla="=AVERAGE(F2:F26)" align="right">$81,400,000</td> <td class="xl25" x:num="19667024.850000009" x:fmla="=$E28-$F28" align="right">$19,667,025</td> <td class="xl24"></td> <td class="xl27" x:num="0.50960000000000005" x:fmla="=AVERAGE(I2:I26)" align="right">51%</td> </tr></tbody> </table>
So what does any of this mean? Yes there have been some busts, but they are The Island, Stealth and Sahara, 3 films that never should have been made. I mean, greenlighting a $130 million dollar Matthew McConaughey desert epic? 11 of 14 movies have turned a profit, with Sky High, Must Love Dogs, Charlie and maybe Dukes probably getting close. Strangely, 2 of the top 4 rated films listed have not turned a profit, with 3 of the lowest 5 rated turning a profit. It seems that its more budget control than anything that is hurting Hollywood. 88 million for Cinderella man? But I guess they're thanking their lucky stars for Star Wars, because without that monster, studios averaged about 13 million less in profits per movie. And no, this does not include smaller films like Hustle and Flow, Penguins or Crash. It just goes to show you the type of profits you can turn on good movies.
So here's the stats:
<table x:str="" style="border-collapse: collapse; width: 663pt;" border="0" cellpadding="0" cellspacing="0" width="882"> <col style="width: 147pt;" width="196"> <col span="2" style="width: 79pt;" width="105"> <col style="width: 86pt;" width="114"> <col style="width: 89pt;" width="119"> <col style="width: 74pt;" width="98"> <col style="width: 64pt;" width="85"> <col style="width: 20pt;" width="27"> <col style="width: 25pt;" width="33"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 147pt;" height="17" width="196">Movie Title</td> <td class="xl25" style="width: 79pt;" width="105">Domestic</td> <td class="xl25" style="width: 79pt;" width="105">Foreign</td> <td class="xl25" style="width: 86pt;" width="114">Total</td> <td class="xl25" style="width: 89pt;" width="119">Received</td> <td class="xl25" style="width: 74pt;" width="98">Budget</td> <td class="xl25" style="width: 64pt;" width="85">Profit/Loss</td> <td class="xl24" style="width: 20pt;" width="27">Wk</td> <td class="xl27" style="width: 25pt;" width="33">G</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Revenge of the Sith</td> <td class="xl26" x:num="377901000" align="right">$377,901,000</td> <td class="xl26" x:num="434147209" align="right">$434,147,209</td> <td class="xl26" x:num="812048209" x:fmla="=$B2+$C2" align="right">$812,048,209</td> <td class="xl26" x:num="446626514.95000005" x:fmla="=$D2*0.55" align="right">$446,626,515</td> <td class="xl26" x:num="113000000" align="right">$113,000,000</td> <td class="xl26" x:num="333626514.95000005" x:fmla="=$E2-$F2" align="right">$333,626,515</td> <td x:num="" align="right">12</td> <td class="xl28" x:num="0.82" align="right">82%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">War of the Worlds</td> <td class="xl26" x:num="224627000" align="right">$224,627,000</td> <td class="xl26" x:num="312744000" align="right">$312,744,000</td> <td class="xl26" x:num="537371000" x:fmla="=$B3+$C3" align="right">$537,371,000</td> <td class="xl26" x:num="295554050" x:fmla="=$D3*0.55" align="right">$295,554,050</td> <td class="xl26" x:num="132000000" align="right">$132,000,000</td> <td class="xl26" x:num="163554050" x:fmla="=$E3-$F3" align="right">$163,554,050</td> <td x:num="" align="right">6</td> <td class="xl28" x:num="0.72" align="right">72%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Madagascar</td> <td class="xl26" x:num="188707954" align="right">$188,707,954</td> <td class="xl26" x:num="220000000" align="right">$220,000,000</td> <td class="xl26" x:num="408707954" x:fmla="=$B4+$C4" align="right">$408,707,954</td> <td class="xl26" x:num="224789374.70000002" x:fmla="=$D4*0.55" align="right">$224,789,375</td> <td class="xl26" x:num="75000000" align="right">$75,000,000</td> <td class="xl26" x:num="149789374.70000002" x:fmla="=$E4-$F4" align="right">$149,789,375</td> <td x:num="" align="right">10</td> <td class="xl28" x:num="0.54" align="right">54%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Mr. and Mrs. Smith</td> <td class="xl26" x:num="180880000" align="right">$180,880,000</td> <td class="xl26" x:num="176568792" align="right">$176,568,792</td> <td class="xl26" x:num="357448792" x:fmla="=$B5+$C5" align="right">$357,448,792</td> <td class="xl26" x:num="196596835.60000002" x:fmla="=$D5*0.55" align="right">$196,596,836</td> <td class="xl26" x:num="110000000" align="right">$110,000,000</td> <td class="xl26" x:num="86596835.600000024" x:fmla="=$E5-$F5" align="right">$86,596,836</td> <td x:num="" align="right">9</td> <td class="xl28" x:num="0.61" align="right">61%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Robots</td> <td class="xl26" x:num="128134870" align="right">$128,134,870</td> <td class="xl26" x:num="118536037" align="right">$118,536,037</td> <td class="xl26" x:num="246670907" x:fmla="=$B6+$C6" align="right">$246,670,907</td> <td class="xl26" x:num="135668998.85000002" x:fmla="=$D6*0.55" align="right">$135,668,999</td> <td class="xl26" x:num="75000000" align="right">$75,000,000</td> <td class="xl26" x:num="60668998.850000024" x:fmla="=$E6-$F6" align="right">$60,668,999</td> <td x:num="" align="right">21</td> <td class="xl28" x:num="0.63" align="right">63%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Wedding Crashers</td> <td class="xl26" x:num="144099000" align="right">$144,099,000</td> <td class="xl26" x:num="18577435" align="right">$18,577,435</td> <td class="xl26" x:num="162676435" x:fmla="=$B7+$C7" align="right">$162,676,435</td> <td class="xl26" x:num="89472039.25" x:fmla="=$D7*0.55" align="right">$89,472,039</td> <td class="xl26" x:num="40000000" align="right">$40,000,000</td> <td class="xl26" x:num="49472039.25" x:fmla="=$E7-$F7" align="right">$49,472,039</td> <td x:num="" align="right">4</td> <td class="xl28" x:num="0.75" align="right">75%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Batman Begins</td> <td class="xl26" x:num="199126000" align="right">$199,126,000</td> <td class="xl26" x:num="156191000" align="right">$156,191,000</td> <td class="xl26" x:num="355317000" x:fmla="=$B8+$C8" align="right">$355,317,000</td> <td class="xl26" x:num="195424350.00000003" x:fmla="=$D8*0.55" align="right">$195,424,350</td> <td class="xl26" x:num="150000000" align="right">$150,000,000</td> <td class="xl26" x:num="45424350.00000003" x:fmla="=$E8-$F8" align="right">$45,424,350</td> <td x:num="" align="right">8</td> <td class="xl28" x:num="0.83" align="right">83%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Fantastic Four</td> <td class="xl26" x:num="143774000" align="right">$143,774,000</td> <td class="xl26" x:num="109499621" align="right">$109,499,621</td> <td class="xl26" x:num="253273621" x:fmla="=$B9+$C9" align="right">$253,273,621</td> <td class="xl26" x:num="139300491.55000001" x:fmla="=$D9*0.55" align="right">$139,300,492</td> <td class="xl26" x:num="100000000" align="right">$100,000,000</td> <td class="xl26" x:num="39300491.550000012" x:fmla="=$E9-$F9" align="right">$39,300,492</td> <td x:num="" align="right">5</td> <td class="xl28" x:num="0.26" align="right">26%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sin City</td> <td class="xl26" x:num="74093153" align="right">$74,093,153</td> <td class="xl26" x:num="48600000" align="right">$48,600,000</td> <td class="xl26" x:num="122693153" x:fmla="=$B10+$C10" align="right">$122,693,153</td> <td class="xl26" x:num="67481234.150000006" x:fmla="=$D10*0.55" align="right">$67,481,234</td> <td class="xl26" x:num="40000000" align="right">$40,000,000</td> <td class="xl26" x:num="27481234.150000006" x:fmla="=$E10-$F10" align="right">$27,481,234</td> <td x:num="" align="right">18</td> <td class="xl28" x:num="0.78" align="right">78%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Monster-In-Law</td> <td class="xl26" x:num="82531000" align="right">$82,531,000</td> <td class="xl26" x:num="39943063" align="right">$39,943,063</td> <td class="xl26" x:num="122474063" x:fmla="=$B11+$C11" align="right">$122,474,063</td> <td class="xl26" x:num="67360734.650000006" x:fmla="=$D11*0.55" align="right">$67,360,735</td> <td class="xl26" x:num="43000000" align="right">$43,000,000</td> <td class="xl26" x:num="24360734.650000006" x:fmla="=$E11-$F11" align="right">$24,360,735</td> <td x:num="" align="right">13</td> <td class="xl28" x:num="0.17" align="right">17%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">The Longest Yard</td> <td class="xl26" x:num="155936427" align="right">$155,936,427</td> <td class="xl26" x:num="14033122" align="right">$14,033,122</td> <td class="xl26" x:num="169969549" x:fmla="=$B12+$C12" align="right">$169,969,549</td> <td class="xl26" x:num="93483251.950000003" x:fmla="=$D12*0.55" align="right">$93,483,252</td> <td class="xl26" x:num="82000000" align="right">$82,000,000</td> <td class="xl26" x:num="11483251.950000003" x:fmla="=$E12-$F12" align="right">$11,483,252</td> <td x:num="" align="right">10</td> <td class="xl28" x:num="0.3" align="right">30%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Herbie: Fully Loaded</td> <td class="xl26" x:num="63510000" align="right">$63,510,000</td> <td class="xl26" x:num="19977000" align="right">$19,977,000</td> <td class="xl26" x:num="83487000" x:fmla="=$B13+$C13" align="right">$83,487,000</td> <td class="xl26" x:num="45917850" x:fmla="=$D13*0.55" align="right">$45,917,850</td> <td class="xl26" x:num="50000000" align="right">$50,000,000</td> <td class="xl26" x:num="-4082150" x:fmla="=$E13-$F13" align="right">-$4,082,150</td> <td x:num="" align="right">7</td> <td class="xl28" x:num="0.41" align="right">41%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Fever Pitch</td> <td class="xl26" x:num="42069531" align="right">$42,069,531</td> <td class="xl26" x:num="300000" align="right">$300,000</td> <td class="xl26" x:num="42369531" x:fmla="=$B14+$C14" align="right">$42,369,531</td> <td class="xl26" x:num="23303242.050000001" x:fmla="=$D14*0.55" align="right">$23,303,242</td> <td class="xl26" x:num="30000000" align="right">$30,000,000</td> <td class="xl26" x:num="-6696757.9499999993" x:fmla="=$E14-$F14" align="right">-$6,696,758</td> <td x:num="" align="right">17</td> <td class="xl28" x:num="0.62" align="right">62%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sky High</td> <td class="xl26" x:num="32050000" align="right">$32,050,000</td> <td class="xl26" x:num="0" align="right">$0</td> <td class="xl26" x:num="32050000" x:fmla="=$B15+$C15" align="right">$32,050,000</td> <td class="xl26" x:num="17627500" x:fmla="=$D15*0.55" align="right">$17,627,500</td> <td class="xl26" x:num="30000000" align="right">$30,000,000</td> <td class="xl26" x:num="-12372500" x:fmla="=$E15-$F15" align="right">-$12,372,500</td> <td x:num="" align="right">2</td> <td class="xl28" x:num="0.66" align="right">66%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Kingdom of Heaven</td> <td class="xl26" x:num="47351043" align="right">$47,351,043</td> <td class="xl26" x:num="162866403" align="right">$162,866,403</td> <td class="xl26" x:num="210217446" x:fmla="=$B16+$C16" align="right">$210,217,446</td> <td class="xl26" x:num="115619595.30000001" x:fmla="=$D16*0.55" align="right">$115,619,595</td> <td class="xl26" x:num="130000000" align="right">$130,000,000</td> <td class="xl26" x:num="-14380404.699999988" x:fmla="=$E16-$F16" align="right">-$14,380,405</td> <td x:num="" align="right">13</td> <td class="xl28" x:num="0.39" align="right">39%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Kicking and Screaming</td> <td class="xl26" x:num="52664450" align="right">$52,664,450</td> <td class="xl26" x:num="1113042" align="right">$1,113,042</td> <td class="xl26" x:num="53777492" x:fmla="=$B17+$C17" align="right">$53,777,492</td> <td class="xl26" x:num="29577620.600000001" x:fmla="=$D17*0.55" align="right">$29,577,621</td> <td class="xl26" x:num="45000000" align="right">$45,000,000</td> <td class="xl26" x:num="-15422379.399999999" x:fmla="=$E17-$F17" align="right">-$15,422,379</td> <td x:num="" align="right">12</td> <td class="xl28" x:num="0.41" align="right">41%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Must Love Dogs</td> <td class="xl26" x:num="26278000" align="right">$26,278,000</td> <td class="xl26" x:num="0" align="right">$0</td> <td class="xl26" x:num="26278000" x:fmla="=$B18+$C18" align="right">$26,278,000</td> <td class="xl26" x:num="14452900.000000002" x:fmla="=$D18*0.55" align="right">$14,452,900</td> <td class="xl26" x:num="30000000" align="right">$30,000,000</td> <td class="xl26" x:num="-15547099.999999998" x:fmla="=$E18-$F18" align="right">-$15,547,100</td> <td x:num="" align="right">2</td> <td class="xl28" x:num="0.39" align="right">39%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Bad News Bears</td> <td class="xl26" x:num="28664000" align="right">$28,664,000</td> <td class="xl26" x:num="0" align="right">$0</td> <td class="xl26" x:num="28664000" x:fmla="=$B19+$C19" align="right">$28,664,000</td> <td class="xl26" x:num="15765200.000000002" x:fmla="=$D19*0.55" align="right">$15,765,200</td> <td class="xl26" x:num="35000000" align="right">$35,000,000</td> <td class="xl26" x:num="-19234800" x:fmla="=$E19-$F19" align="right">-$19,234,800</td> <td x:num="" align="right">3</td> <td class="xl28" x:num="0.45" align="right">45%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">The Dukes of Hazzard</td> <td class="xl26" x:num="30575000" align="right">$30,575,000</td> <td class="xl26" x:num="0" align="right">$0</td> <td class="xl26" x:num="30575000" x:fmla="=$B20+$C20" align="right">$30,575,000</td> <td class="xl26" x:num="16816250" x:fmla="=$D20*0.55" align="right">$16,816,250</td> <td class="xl26" x:num="50000000" align="right">$50,000,000</td> <td class="xl26" x:num="-33183750" x:fmla="=$E20-$F20" align="right">-$33,183,750</td> <td x:num="" align="right">1</td> <td class="xl28" x:num="0.18" align="right">18%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Charlie & the Chocolate Factory</td> <td class="xl26" x:num="169023000" align="right">$169,023,000</td> <td class="xl26" x:num="37264000" align="right">$37,264,000</td> <td class="xl26" x:num="206287000" x:fmla="=$B21+$C21" align="right">$206,287,000</td> <td class="xl26" x:num="113457850.00000001" x:fmla="=$D21*0.55" align="right">$113,457,850</td> <td class="xl26" x:num="150000000" align="right">$150,000,000</td> <td class="xl26" x:num="-36542149.999999985" x:fmla="=$E21-$F21" align="right">-$36,542,150</td> <td x:num="" align="right">4</td> <td class="xl28" x:num="0.81" align="right">81%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Bewitched</td> <td class="xl26" x:num="60717928" align="right">$60,717,928</td> <td class="xl26" x:num="6771975" align="right">$6,771,975</td> <td class="xl26" x:num="67489903" x:fmla="=$B22+$C22" align="right">$67,489,903</td> <td class="xl26" x:num="37119446.650000006" x:fmla="=$D22*0.55" align="right">$37,119,447</td> <td class="xl26" x:num="85000000" align="right">$85,000,000</td> <td class="xl26" x:num="-47880553.349999994" x:fmla="=$E22-$F22" align="right">-$47,880,553</td> <td x:num="" align="right">6</td> <td class="xl28" x:num="0.26" align="right">26%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Cinderella Man</td> <td class="xl26" x:num="60424655" align="right">$60,424,655</td> <td class="xl26" x:num="0" align="right">$0</td> <td class="xl26" x:num="60424655" x:fmla="=$B23+$C23" align="right">$60,424,655</td> <td class="xl26" x:num="33233560.250000004" x:fmla="=$D23*0.55" align="right">$33,233,560</td> <td class="xl26" x:num="88000000" align="right">$88,000,000</td> <td class="xl26" x:num="-54766439.75" x:fmla="=$E23-$F23" align="right">-$54,766,440</td> <td x:num="" align="right">9</td> <td class="xl28" x:num="0.84" align="right">84%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Sahara</td> <td class="xl26" x:num="68671925" align="right">$68,671,925</td> <td class="xl26" x:num="51100000" align="right">$51,100,000</td> <td class="xl26" x:num="119771925" x:fmla="=$B24+$C24" align="right">$119,771,925</td> <td class="xl26" x:num="65874558.750000007" x:fmla="=$D24*0.55" align="right">$65,874,559</td> <td class="xl26" x:num="130000000" align="right">$130,000,000</td> <td class="xl26" x:num="-64125441.249999993" x:fmla="=$E24-$F24" align="right">-$64,125,441</td> <td x:num="" align="right">17</td> <td class="xl28" x:num="0.39" align="right">39%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">Stealth</td> <td class="xl26" x:num="24458000" align="right">$24,458,000</td> <td class="xl26" x:num="4468040" align="right">$4,468,040</td> <td class="xl26" x:num="28926040" x:fmla="=$B25+$C25" align="right">$28,926,040</td> <td class="xl26" x:num="15909322.000000002" x:fmla="=$D25*0.55" align="right">$15,909,322</td> <td class="xl26" x:num="100000000" align="right">$100,000,000</td> <td class="xl26" x:num="-84090678" x:fmla="=$E25-$F25" align="right">-$84,090,678</td> <td x:num="" align="right">2</td> <td class="xl28" x:num="0.12" align="right">12%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">The Island</td> <td class="xl26" x:num="30942000" align="right">$30,942,000</td> <td class="xl26" x:num="24045000" align="right">$24,045,000</td> <td class="xl26" x:num="54987000" x:fmla="=$B26+$C26" align="right">$54,987,000</td> <td class="xl26" x:num="30242850.000000004" x:fmla="=$D26*0.55" align="right">$30,242,850</td> <td class="xl26" x:num="122000000" align="right">$122,000,000</td> <td class="xl26" x:num="-91757150" x:fmla="=$E26-$F26" align="right">-$91,757,150</td> <td x:num="" align="right">3</td> <td class="xl28" x:num="0.4" align="right">40%</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Totals</td> <td class="xl25" x:num="2637209936" x:fmla="=SUM(B2:B26)" align="right">$2,637,209,936</td> <td class="xl25" x:num="1956745739" x:fmla="=SUM(C2:C26)" align="right">$1,956,745,739</td> <td class="xl25" x:num="4593955675" x:fmla="=$B27+$C27" align="right">$4,593,955,675</td> <td class="xl25" x:num="2526675621.25" x:fmla="=$D27*0.55" align="right">$2,526,675,621</td> <td class="xl25" x:num="2035000000" x:fmla="=SUM(F2:F26)" align="right">$2,035,000,000</td> <td class="xl25" x:num="491675621.25" x:fmla="=$E27-$F27" align="right">$491,675,621</td> <td class="xl24"></td> <td class="xl27"></td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Averages</td> <td class="xl25" x:num="105488397.44" x:fmla="=AVERAGE(B2:B26)" align="right">$105,488,397</td> <td class="xl25" x:num="78269829.560000002" x:fmla="=AVERAGE(C2:C26)" align="right">$78,269,830</td> <td class="xl25" x:num="183758227" x:fmla="=$B28+$C28" align="right">$183,758,227</td> <td class="xl25" x:num="101067024.85000001" x:fmla="=$D28*0.55" align="right">$101,067,025</td> <td class="xl25" x:num="81400000" x:fmla="=AVERAGE(F2:F26)" align="right">$81,400,000</td> <td class="xl25" x:num="19667024.850000009" x:fmla="=$E28-$F28" align="right">$19,667,025</td> <td class="xl24"></td> <td class="xl27" x:num="0.50960000000000005" x:fmla="=AVERAGE(I2:I26)" align="right">51%</td> </tr></tbody> </table>
So what does any of this mean? Yes there have been some busts, but they are The Island, Stealth and Sahara, 3 films that never should have been made. I mean, greenlighting a $130 million dollar Matthew McConaughey desert epic? 11 of 14 movies have turned a profit, with Sky High, Must Love Dogs, Charlie and maybe Dukes probably getting close. Strangely, 2 of the top 4 rated films listed have not turned a profit, with 3 of the lowest 5 rated turning a profit. It seems that its more budget control than anything that is hurting Hollywood. 88 million for Cinderella man? But I guess they're thanking their lucky stars for Star Wars, because without that monster, studios averaged about 13 million less in profits per movie. And no, this does not include smaller films like Hustle and Flow, Penguins or Crash. It just goes to show you the type of profits you can turn on good movies.