In December 2015, The Walt Disney Studios celebrated the world premiere of Star Wars: The Force Awakens. Based on its success, Disney analyzed whether it should invest in making more big budget movies each year from its Pixar, Marvel Studios, and Lucasfilm labels. It refers to this strategy as making 'tentpole' movies, which are movies that can carry its brand and characters through Disney's other business units such as Disney Parks, Experiences and Consumer Products, the Disney Music Group, etc., sort of like a tentpole holding up an entire tent (for example, concurrent with the Black Panther movie they released a Black Panther album, along with Black Panther toys and even Black Panther meet and greets in their Parks). Disney requires a four year payback. Based on its cost of capital (topic to be discussed in the next learning module) and the amount of risk this type of venture has, Disney determines that its required rate of return (appropriate discount rate) is 15%. Disney projects out the following cash flows for its tentpole strategy: Period Year o Year 1 Year 2 Year 3 Year 4 Cash Flow ($10,026,455) initial investment $3,445,205 $7,425,710 $11,398,808 $14,629,124 (1) By Saturday: Create a new thread in this forum, and post your answer to the following questions. Show how you arrived at your answer using Excel and the Excel NPV and IRR functions (attach your Excel spreadsheet to your post. 1. What is the payback period of the tentpole strategy? Based on this criteria, should Disney invest? Why? 2. What is the NPV of the tentpole strategy? Based on this criteria, should Disney invest? Why? 3. What is the IRR of the tentpole strategy? Based on this criteria, should Disney invest? Why