Round 5 Excel Sheet

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

Info icon This preview shows pages 1–9. 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
Image of page 1

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

View Full Document Right 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
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 Fast 999 1,386 139% 1,344 97% 1,266 94% 1,428 Feat 1,763 2,118 120% 1,992 94% 1,959 98% 2,411 Fist 366 372 102% 565 152% 743 132% 785 Foam 358 506 141% 601 119% 736 122% 798 Fume 314 332 106% 553 167% 792 143% 891 Flamer N/A 0 806 1,076 Product 7 N/A
Image of page 3

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

View Full Document Right Arrow Icon
% Change 2014 % Change 2015 % Change 2016 % Change 2017 % Change 110% 0% 136% 137% 133% 99% 100% 31% 45% 118% 106% 128% 113% 137% 139% 107% 123% 199% 129% 129% 69% 109% 112% 103% 125% 94% 512% 113% 123% 106% 108% 113% 133%
Image of page 4
Product Name Product Name Product Nam Year Most Likely Best Case Worst Case Most Likely Best Case Worst Case Most Likely Best Case 2010 2011 2012 2013 2014 2015 2016 2017 Best Case = Stocking out Most likely = Given all the information, this is the most likely to happen Worst Case = Given unexpected events (new products enter the market, etc.), sales should not be below this valu Sales Forecast (# of Units ) Analysis by Product for yo
Image of page 5

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

View Full Document Right Arrow Icon
me Product Name Product Name Worst Case Most Likely Best Case Worst Case Most Likely Best Case Worst Case ue our Company
Image of page 6
Price Analysis by Segment Traditional Year Able Baker Cake Daze Eat Fast Duck Product 8 Product 9 2010 $25.99 $28.00 $28.50 $28.00 $26.50 $26.99 2011 $26.99 $28.00 $27.50 $27.00 $27.00 $26.75 $24.00 2012 $26.99 $27.70 $27.00 $25.99 $26.75 $26.25 $23.50 2013 $26.99 $27.60 $27.00 $25.99 $26.75 $26.25 $20.49 2014 2015 2016 2017 Low Year Acre Bead Cedar Dell Ebb Feat Flamer Product 8 Product 9 2010 $20.99 $19.00 $23.50 $21.00 $19.75 $19.94 2011 $20.99 $19.00 $22.00 $20.50 $19.75 $19.99 2012 $20.49 $19.00 $21.50 $19.99 $19.75 $19.29 $19.94 2013 $19.50 $21.00 $19.49 $20.25 $18.99 $18.99 2014 2015 2016 2017 High Year Adam Bid Cid Dixie Echo Fist Ebrian Product 8 Product 9 2010 $38.49 $38.00 $38.50 $40.00 $39.25 $39.49 2011 $38.49 $38.00 $38.00 $28.00 $38.75 $38.75 2012 $37.99 $38.00 $38.00 $26.99 $36.00 $38.25 $39.00 2013 $37.69 $38.20 $38.00 $26.49 $36.00 $37.99 $38.50 2014 2015 2016 2017
Image of page 7

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

View Full Document Right Arrow Icon
Performance Year Aft Bold Coat Dot Edge Foam Product 7 Product 8 Product 9 2010 $33.49 $33.00 $34.50 $35.00 $34.00 $33.99 2011 $33.99 $33.25 $34.00 $34.00 $33.50 $33.75 2012 $33.49 $33.25 $33.50 $26.99 $33.25 $33.49 2013 $32.99 $33.00 $33.00 $26.49 $33.25 $32.99 2014 2015 2016 2017 Size Year Agape Buddy Cure Dune Egg Fume Product 7 Product 8 Product 9 2010 $33.99 $33.00 $34.50 $35.00 $34.50 $33.98 2011 $33.99 $33.25 $34.00
Image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern