Question

In: Finance

The CEO of Garneau Cinemas is considering making a movie and must decide between a comedy...

The CEO of Garneau Cinemas is considering making a movie and must decide between a comedy and a thriller—it ​doesn't have the production space to make both. The comedy is expected to cost $25 million up front​ (at t​ = 0). After​ that, it is expected to make 16 million in the first year​ (at t​ = 1) and $44 million in each of the following two years​ (at t​ = 2 and t​ = 3). In the fourth year​ (at t​ = 5), it is expected that the movie can be sold into syndication for ​$22 million with no further cash flows back to Garneau Cinemas. The thriller is expected to cost ​$40 million up front​ (at t​ = 0). After​ that, it is expected to make $20 million in the first year​ (at t​ = 1) and $44 million in each of the following four years​ (at t​ = 2,​ 3, 4, and​ 5). In the sixth year​ (at t​ = 6), it is expected that the movie can be sold into syndication for $30 million with no further cash flows back to Garneau Cinemas. The cost of capital is 11​%,and Garneau usually requires projects to have a payback within four years. Determine each​ project's payback and​ NPV, and advise the CEO what she should do.

a) The payback for the comedy is _____ ​years, and the NPV of the comedy is $_____?

b) The payback for the thriller is _____ ​years, and the NPV of the thriller is $_____?

Solutions

Expert Solution

Note: There seems to be some error in the question as the cash flows for comedy movie are written for fourth year but given at t=5.

Assuming correction that it is for t=4 only, the solution will be as given below:

Solution:

Formulas used:

Thus,

a) The payback of comedy is 1.20 years and the NPV is $71.79 million

b) The payback of thriller is 1.45 years and the NPV is $117.04 million

As the payback of both the options is well within the 4 years requirement of the company, the NPV is the deciding factor. Since Thriller has higher NPV than the comedy, thus the CEO should choose to make Thriller rather than the comedy in this case.


Related Solutions

The CEO of Garneau Cinemas is considering making a movie and must decide between a comedy...
The CEO of Garneau Cinemas is considering making a movie and must decide between a comedy and a thrillerlong dashit ​doesn't have the production space to make both. The comedy is expected to cost ​$20 million up front​ (at t​ = 0). After​ that, it is expected to make ​$13 million in the first year​ (at t​ = 1) and ​$4 million in each of the following two years​ (at t​ = 2 and t​ = 3). In the fourth...
You are considering making a movie. The movie is expected to cost $ 10.5million upfront and...
You are considering making a movie. The movie is expected to cost $ 10.5million upfront and take a year to produce. After​ that, it is expected to make $ 4.5 million in the year it is released and $ 1.9 million for the following four years. What is the payback period of this​ investment? If you require a payback period of two​ years, will you make the​ movie? Does the movie have positive NPV if the cost of capital is...
You are considering making a movie. The movie is expected to cost $ 10.4 million up...
You are considering making a movie. The movie is expected to cost $ 10.4 million up front and take a year to produce. After​ that, it is expected to make $ 4.6 million in the year it is released and $ 1.6 million for the following four years. What is the payback period of this​ investment? If you require a payback period of two​ years, will you make the​ movie? Does the movie have positive NPV if the cost of...
You are considering making a movie. The movie is expected to cost $100 million upfront and...
You are considering making a movie. The movie is expected to cost $100 million upfront and takes a year to make. After that, it is expected to make $83 million in the first year it is released and $8 million for the following 20 years. Your cost of capital is 10%. a.) What is the payback period of this investment? (Hint: consider that you look upfront at this, that is from year=0. For solving this task it is necessary to...
You are considering making a movie. The movie is expected to cost $100 million upfront and...
You are considering making a movie. The movie is expected to cost $100 million upfront and takes a year to make. After that, it is expected to make $81 million in the first year it is released and $6 million for the following 20 years. Your cost of capital is 10%. a.) What is the payback period of this investment? (Hint: consider that you look upfront at this, that is from year=0. For solving this task it is necessary to...
You are considering making a movie. The movie is expected to cost $ 10.3 million up...
You are considering making a movie. The movie is expected to cost $ 10.3 million up front and take a year to produce. After​ that, it is expected to make $ 4.1 million in the year it is released and $ 1.9 million for the following four years. What is the payback period of this​ investment? If you require a payback period of two​ years, will you make the​ movie? Does the movie have positive NPV if the cost of...
You are considering making a movie. The movie is expected to cost $ 10.8 million up...
You are considering making a movie. The movie is expected to cost $ 10.8 million up front and take a year to produce. After​ that, it is expected to make $ 4.7 million in the year it is released and $ 1.7 million for the following four years. What is the payback period of this​ investment? If you require a payback period of two​ years, will you make the​ movie? Does the movie have positive NPV if the cost of...
You are considering making a movie. The movie is expected to cost $10.1million up front and...
You are considering making a movie. The movie is expected to cost $10.1million up front and take a year to produce. After​ that, it is expected to make $4.1 million in the year it is released and $1.9 million for the following four years. What is the payback period of this​ investment? If you require a payback period of two​ years, will you make the​ movie? Does the movie have positive NPV if the cost of capital is 10.4%​?
You are considering making a movie. The movie is expected to cost $ 10.7 million up...
You are considering making a movie. The movie is expected to cost $ 10.7 million up front and take a year to produce. After​ that, it is expected to make $ 4.6 million in the year it is released and $ 2.1 million for the following four years. What is the payback period of this​ investment? If you require a payback period of two​ years, will you make the​ movie? Does the movie have positive NPV if the cost of...
You are considering making a movie. The movie is expected to cost $10.7 million upfront and...
You are considering making a movie. The movie is expected to cost $10.7 million upfront and take a year to make. After​ that, it is expected to make $4.5 million in the first year it is released​ (end of year​ 2) and $1.7 million for the following four years​ (end of years 3 through​ 6) . What is the payback period of this​ investment? If you require a payback period of two​ years, will you make the​ movie? What is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT