Round 6 Excel Sheet

Round 6 Excel Sheet - ROS ROA Year Andrews Baldwin Chester...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
ROA Year Andrews Baldwin Chester Digby Erie Ferris Year Andrews 2010 -0.8% -1.0% 3.2% 0.2% 1.7% -2.5% 2010 -0.8% 2011 1.6% 2.6% 4.1% -1.1% 4.2% 1.7% 2011 2.6% 2012 4.8% 3.8% 7.0% 5.5% 5.8% 2.4% 2012 7.1% 2013 9.3% -0.3% 9.9% 9.5% 7.6% 6.4% 2013 14.6% 2014 10.6% 4.0% 10.5% 14.2% 7.4% 11.5% 2014 16.9% 2015 9.6% 18.0% 10.8% 15.3% 8.5% 8.8% 2015 17.1% 2016 2016 2017 2017 Average 5.9% 4.5% 7.6% 7.3% 5.9% 4.7% Average 9.6% ROE Asset Turnover Year Andrews Baldwin Chester Digby Erie Ferris Year Andrews 2010 -1.7% -2.1% 6.3% 0.4% 3.6% -5.3% 2010 1.01 2011 4.2% 5.1% 8.2% 2.5% 9.1% 3.1% 2011 1.61 2012 10.8% 6.8% 12.9% 11.9% 13.2% 4.8% 2012 1.47 2013 17.3% -0.4% 18.1% 19.9% 17.8% 11.0% 2013 1.58 2014 19.2% 5.0% 16.8% 18.8% 16.7% 18.9% 2014 1.60 2015 18.0% 19.2% 16.3% 17.3% 19.1% 12.7% 2015 1.77 2016 2016 2017 2017 Average 11.3% 5.6% 13.1% 11.8% 13.3% 7.5% Average 1.51 Market Share (% in $) Year Andrews Baldwin Chester Digby Erie Ferris 2010 16.0% 15.0% 19.0% 16.0% 16.0% 18.0% 2011 18.0% 16.0% 18.0% 15.0% 16.0% 17.0% 2012 16.0% 14.0% 19.0% 15.0% 17.0% 19.0% 2013 16.0% 10.0% 20.0% 16.0% 19.0% 19.0% 2014 17.1% 8.7% 18.9% 13.3% 19.5% 22.6% 2015 17.1% 8.5% 18.3% 11.5% 21.1% 23.6% 2016 2017 Average 16.7% 12.0% 18.9% 14.5% 18.1% 19.9% ROS
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Baldwin Chester Digby Erie Ferris -1.0% 3.3% 0.2% 1.9% -2.4% 2.9% 4.5% -0.9% 4.9% 1.7% 4.2% 8.1% 5.2% 7.9% 2.9% -0.3% 12.0% 8.5% 11.3% 7.4% 3.6% 12.8% 11.6% 10.6% 15.9% 16.5% 13.3% 12.4% 13.2% 11.0% 4.3% 9.0% 6.2% 8.3% 6.1% Baldwin Chester Digby Erie Ferris 0.96 1.04 0.89 1.10 0.96 1.10 1.09 0.82 1.16 1.03 1.12 1.15 0.94 1.37 1.22 0.94 1.21 0.89 1.48 1.15 0.89 1.22 0.82 1.44 1.38 0.91 1.23 0.81 1.56 1.25 0.99 1.16 0.86 1.35 1.17
Background image of page 2
Total Units Sold (000) 2009 2010 % Change 2011 % Change 2012 % Change 2013 Andrews Able 999 1,401 140% 1,649 118% 1,548 94% 1,704 Acre 1,763 1,398 79% 1,652 118% 1,023 62% 0 Adam 366 526 144% 690 131% 882 128% 1,196 Aft 358 409 114% 550 134% 691 126% 950 Agape 314 397 126% 554 140% 722 130% 959 Product 6 N/A Product 7 N/A Baldwin Baker 999 1,015 102% 1,176 116% 1,083 92% 1,074 Bead 1,763 1,722 98% 1,881 109% 2,079 111% 2,079 Bid 366 492 134% 578 117% 595 103% 182 Bold 358 379 106% 456 120% 478 105% 215 Buddy 314 388 124% 462 119% 431 93% 508 Product 6 N/A Product 7 N/A Chester Cake 999 1,439 144% 1,559 108% 1,423 91% 1,512 Cedar 1,763 1,705 97% 1,748 103% 2,057 118% 2,624 Cid 366 478 131% 632 132% 931 147% 1,053 Coat 358 461 129% 557 121% 697 125% 952 Cure 314 406 129% 498 123% 688 138% 953 Product 6 N/A Product 7 N/A Digby Daze 999 1,235 124% 1,060 1,138 107% 1,213 Dell 1,763 2,036 115% 2,091 103% 2,350 112% 2,900 Dixie 366 274 75% 562 205% 601 107% 1,198 Dot 358 372 104% 335 90% 350 104% 450 Dune 314 318 101% 197 62% 350 178% 450 Duck N/A 0 456 649 142% 450 Product 7 N/A Erie Eat 999 1,271 127% 1,254 99% 1,408 112% 1,532 Ebb 1,763 1,524 86% 1,708 112% 2,124 124% 2,376 Echo 366 500 137% 595 119% 660 111% 680 Edge 358 414 116% 500 121% 692 138% 868 Egg 314 409 130% 505 123% 593 117% 558 Ebrian N/A 0 144 737 Ewayne N/A 0 Ferris
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/08/2011 for the course WCOB 3016 taught by Professor Staff during the Spring '08 term at Arkansas.

Page1 / 67

Round 6 Excel Sheet - ROS ROA Year Andrews Baldwin Chester...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online