Can you please advise on question 2

1) Rank the projects by using each metric (NPV, IRR, Payback, and Profitability Index).

NPV

Retail Store Expansion in Northeast (26.28)

New Doll Film/DVD (9.37)

Toddler Doll Accessory (7.14)

Match my Doll Clothing Line (6.46)

Warehouse Facility Consolidation (3.13)

IRR

New Doll Film/DVD (238.61)

Retail Store Expansion in Northeast (32.04)

Toddler Doll Accessory (25.06)

Match my Doll Clothing Line (20.69)

Warehouse Facility Consolidation (14.82)

Payback

New Doll Film/DVD (1.43)

Retail Store Expansion in Northeast (5.33)

Warehouse Facility Consolidation (8.23)

Toddler Doll Accessory (8.7)

Match my Doll Clothing Line (9.21)

Profitability Index

New Doll Film/DVD (8.93)

Retail Store Expansion in Northeast (3.89)

Toddler Doll Accessory (3.34)

Match my Doll Clothing Line (1.41)

Warehouse Facility Consolidation (0.42)

2) Student may use the Dashboard to perform a quantitative and qualitative analysis from 2009 to 2014 on the followings:

Adjusted net present value Sales EBIT Operating Cash flow Net investment income Whether Acquisitions, New Stores Openings and New Product Launch had impact on the above matrices.