for michael smith

profilesozfhf
the_bet-2701-coal.xlsx

Sheet3

Exported Unit Value ($/ton) 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
World 31 31 31 41 57 56 56 84 95 120 103 84 74 62
Exported value (USD)
World 20,778,841 20,491,358 22,000,143 31,820,638 46,197,809 49,747,351 52,949,450 94,755,565 81,089,520 104,514,104 139,471,773 128,612,227 111,951,138 97,480,260 76,364,141
Exported quantity (tons)
World 675,423,655 656,719,840 713,131,863 768,687,327 809,608,724 882,680,021 950,208,506 No Quantity 965,326,946 1,097,957,057 1,163,401,541 1,247,638,520 1,330,630,864 1,309,496,777 1,228,955,549

COAL

HS 2701: World Exported Unit Value %∆P Exported value P*Q %∆(P*Q) Exported quantity %∆Q P %∆P eps Price Elasticity of Supply eps Price Elasticity of Supply
COAL USD/ton % 1000 USD USD % tons % USD/ton % current/current short run current/previous long run
2001 $31.00 20,778,841 $20,778,841,000.00 675,423,655 $30.76
2002 $31.00 0.00% 20,491,358 $20,491,358,000.00 -1.38% 656,719,840 -2.77% $31.20 1.43% -1.9431 perverse
2003 $31.00 0.00% 22,000,143 $22,000,143,000.00 7.36% 713,131,863 8.59% $30.85 -1.13% -7.6025 perverse 6.0275 price elastic
2004 $41.00 32.26% 31,820,638 $31,820,638,000.00 44.64% 768,687,327 7.79% $41.40 34.18% 0.2279 price inelastic -6.8948 perverse
2005 $57.00 39.02% 46,197,809 $46,197,809,000.00 45.18% 809,608,724 5.32% $57.06 37.84% 0.1407 price inelastic 0.1557 price inelastic
2006 $56.00 -1.75% 49,747,351 $49,747,351,000.00 7.68% 882,680,021 9.03% $56.36 -1.23% -7.3316 perverse 0.2385 price inelastic
2007 $56.00 0.00% 52,949,450 $52,949,450,000.00 6.44% 950,208,506 7.65% $55.72 -1.13% -6.7858 perverse -6.2146 perverse
2008 94,755,565 $94,755,565,000.00 78.95%
2009 $84.00 81,089,520 $81,089,520,000.00 -14.42% 965,326,946 $84.00
2010 $95.00 13.10% 104,514,104 $104,514,104,000.00 28.89% 1,097,957,057 13.74% $95.19 13.32% 1.0316 price elastic
2011 $120.00 26.32% 139,471,773 $139,471,773,000.00 33.45% 1,163,401,541 5.96% $119.88 25.94% 0.2298 price inelastic 0.4476 price inelastic
2012 $103.00 -14.17% 128,612,227 $128,612,227,000.00 -7.79% 1,247,638,520 7.24% $103.08 -14.01% -0.5167 perverse 0.2791 price inelastic
2013 $84.00 -18.45% 111,951,138 $111,951,138,000.00 -12.95% 1,330,630,864 6.65% $84.13 -18.38% -0.3618 perverse -0.4747 perverse
2014 $74.00 -11.90% 97,480,260 $97,480,260,000.00 -12.93% 1,309,496,777 -1.59% $74.44 -11.52% 0.1379 price inelastic 0.0864 price inelastic
2015 $62.00 -16.22% 76,364,141 $76,364,141,000.00 -21.66% 1,228,955,549 -6.15% $62.14 -16.53% 0.3721 price inelastic 0.5339 price inelastic
MAX $120.00 39.02% $139,471,773.00 $139,471,773,000.00 78.95% $1,330,630,864.00 13.74% $119.88 37.84%
MIN $31.00 -18.45% $20,491,358.00 $20,491,358,000.00 -21.66% $656,719,840.00 -6.15% $30.76 -18.38%
AVER $66.07 4.02% $71,881,621.20 $71,881,621,200.00 12.96% $985,704,799.29 5.12% $66.16 4.06%

ECO 435 The Bet: 2701 Coal BJ