Spreadsheet: 144764d1331130918-changing-table-array-size-in-vlookup-automatically-ef-sample
Sheet: Template

 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 1 | 2
Net Debt | 3.537781 | -0.5 | 4.510893 | 6.388276 | 5.19873 | 6.494436 | 2.634935 | 6.920584 | 9.715 | #N/A
Minority Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Net debt | 3.537781 | -0.5 | 4.510893 | 6.388276 | 5.19873 | 6.494436 | 2.634935 | 6.920584 | 9.715 | #N/A
Total Equity | 10.178624 | 13.982464 | 14.064994 | 18.131359 | 23.046743 | 22.887663 | 24.54125 | 25.351811 | 27.775 | #N/A
Net Operating Assets | 13.716405 | 13.482464 | 18.575887 | 24.519635 | 28.245473 | 29.382099 | 27.176185 | 32.272395 | 37.48999999999999 | #N/A
RNOA |  | 0.2681898179588602 | 0.3400175717138944 | 0.2349133260769728 | 0.1844922193988613 | 0.1631692264455971 | 0.06901608390877723 | 0.07347258344024372 | 0.08895992999589895 | #N/A
Residual Operating Income |  | 2.30695966 | 3.236028269999999 | 2.5061347 | 2.071718379999999 | 1.784244679999999 | -0.9103724900000008 | -0.7209139800000003 | -0.3562895000000008 | #N/A
Shares Out. | #N/A
Equity Value | #N/A
Total Assets | 19.74301 | 22.966719 | 28.193966 | 35.020966 | 42.222393 | 45.424072 | 42.309473 | 49.581018 | 55.222 | #N/A
Total Cash & ST Investments | 1.390641 | 1.88851 | 1.076489 | 3.838172 | 4.987991 | 5.224564 | 6.519065 | 6.601416 | 7.853 | #N/A
Total Current Liabilities | 6.133722 | 6.99884 | 7.540301 | 6.026484 | 8.482312 | 8.826679 | 6.803201 | 9.217559 | 8.705 | #N/A
Short-term Borrowings | 0.141113 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
Curr. Port. of LT Debt | 2.035349 | 0 | 0.01 | 0.008517 | 0 | 0 | 0 | 0 | 0 | #N/A
Curr. Port. of [NAME]. Leases | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Invested Capital | 14.39510900000001 | 14.079369 | 19.587176 | 25.164827 | 28.75209 | 31.372829 | 28.987207 | 33.762043 | 38.664 | #N/A
Operating Income | 2.486364 | 5.490448 | 6.842201 | 6.51302 | 6.751764 | 6.878794 | 3.026623 | 2.980156 | 4.285 | #N/A
Tax-Adjusted EBIT | 1.66586388 | 3.678600159999999 | 4.584274669999999 | 4.3637234 | 4.523681879999999 | 4.608791979999999 | 2.02783741 | 1.99670452 | 2.87095 | #N/A
ROIC |  | 0.2555451410614534 | 0.3256022816079328 | 0.2227847138352154 | 0.1797620893638569 | 0.1602941553118399 | 0.06463674060123809 | 0.06888226658056432 | 0.08503484223392524 | #N/A
0.1
0
Basic EPS | 0.368 | 0.963 | 0.837 | 1.112 | 1.138 | 1.281 | 0.864 | 0.822 | 0.907 | #N/A | #N/A | #N/A
EPS Growth |  | 1.616847826086957 | -0.1308411214953271 | 0.3285543608124255 | 0.02338129496402863 | 0.125659050966608 | -0.3255269320843091 | -0.04861111111111116 | 0.1034063260340634 | #N/A | 0.1 | 0.07
Dividends per Share | NA | 0.06 | 0.11 | 0.12 | 0.16 | 0.18 | 0.2 | 0.22 | NA | #N/A | 0.28 | 0.28
Book Value/Share | 3.12 | 4.1 | 4.04 | 5.16 | 6.49 | 6.85 | 7.77 | 8.26 | 8.89 | #N/A | #N/A | #N/A
Return on Common Equity % | #N/A | 0.3086538461538461 | 0.2041463414634146 | 0.2752475247524753 | 0.2205426356589147 | 0.1973805855161787 | 0.1261313868613139 | 0.1057915057915058 | 0.1098062953995157 | #N/A | #N/A | #N/A
Residual Earnings |  | 0.6509999999999999 | 0.427 | 0.7080000000000001 | 0.6219999999999999 | 0.6319999999999998 | 0.1789999999999999 | 0.04499999999999991 | 0.08099999999999995 | #N/A | #N/A | #N/A
Change in Residual Earnings |  |  | -0.2239999999999999 | 0.2810000000000001 | -0.08600000000000019 | 0.009999999999999898 | -0.4529999999999998 | -0.134 | 0.03600000000000004 | #N/A | #N/A | #N/A
Discounted Residual Earnings |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Book Value | #N/A
Sum of PV of Residual Earnings | #N/A
Terminal Value | #N/A
No Growth Value | #N/A
Current Price | Error
Discount | #N/A
Value with Growth | #N/A
Residuals Growth Rate | 0.05396354241159921
Forecasted EPS | #N/A
Forecasted EPS Growth | #N/A