Page Break Preview Default Zoom 50% Page Layout Normal Show 100 Zoom to 1 Custom Views 1 xfx c D the earliest appearance of the data in your formular, really the Glen Dates for 2. Using the avenge Emultiple in Table 10.1, estimate Nike share price b. Whange of share prices de you entiste based on the highest and lowest Peltiples in Table 10.17 4. Using the evene price to book value multiple in Table 10.1, estimate Nike's share price 4. What mange or share prices do you estimate based on the highest and lowest price-to-book value multiples in Table 10.17 Tahle 10.1 Name Nike, Inc Adidas AG Under Armour Puma AG Skechen U.S.A Wolverine World Wide Steven Madden, Lid Rocky Bands, Inc Market Capitalization (5 million) 134.210 50,885 9,219 9.110 3,452 3.283 2,943 189 Enterprise Value 5 million) 132,775 49,475 8.862 9,538 5.185 3,280 2,068 179 Avenge PE 33.22 28.69 NM 43.42 18.04 17.83 22.84 13.13 23.99 Price Rank 13.65 6.95 4.71 9.24 6.76 21.89 1.45 1.24 7.46 Enterprise Value Sales 3.65 1.97 1.66 426 3.13 3.01 0.44 0.71 Enterprise Vala EBITDA 25.44 14.81 18.82 33.70 26.45 34.53 7.78 19.98 2.17 All Ratios as of April 2019 5 s EPS 2.57 Book value of equity 6.13 .. Using the wente PE multiple in Table 10.1, estimate Nike share price. Nike share price estimate 5. What age of share prices do you estimate based on the highest and lowest Pre multiples in Table 10.17 Highest PE Lowest PE Highest price estimate Lowest price estimate c. Using the wenke price to book value multiple in Table 10.1, estimate Nike's share price Sher price estimule d. What mange of share prices do you estimate based on the highest and lowest price-to-book valve multiples in Table 10.12 Highest price-lo-book Lowest price-to-book Highest price estimate Lowest price estimate Requirements In cell D31, by using cell references, calculate Nike's share price based on the avenge P/E multiple of the indukty