Question
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
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 | Cash Flow |
Year 0 | ($10,026,455) initial investment |
Year 1 | $3,445,205 |
Year 2 | $7,425,710 |
Year 3 | $11,398,808 |
Year 4 | $14,629,124 |
(1) 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.
- What is the payback period of the tentpole strategy? Based on this criteria, should Disney invest? Why?
- What is the NPV of the tentpole strategy? Based on this criteria, should Disney invest? Why?
- What is the IRR of the tentpole strategy? Based on this criteria, should Disney invest? Why?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started