Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

You are considering making a movie

Finance Aug 13, 2020

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 consider carefully the timeline of the cash flows in years=0,1,2,3,....,21,22)

The payback period is ___ years(round to a full year)

b.) If you require a payback period of two years, will you make the movie?

Answer:  (fill in "yes" or "no")

c.) What is the NPV of this project?

The NPV is $ million(round to two decimals)

d.) According to the NPV rule, should you make the movie?

Answer:  (fill in "yes" or "no")

Expert Solution

a] Year Cash Flow [$ million] Cumulative Cash Flow    
  0 $               (100.00) $           (100.00)    
  1 $                    83.00 $             (17.00)    
  2 $                      8.00 $               (9.00)    
  3 $                      8.00 $               (1.00)    
  4 $                      8.00 $                  7.00    
  5 $                      8.00 $               15.00    
  6 $                      8.00 $               23.00    
  Payback period = 3+1/8 = Rounded off to 4 Years    
b] N0        
  As the payback period of this project is more than    
  the maximum permissible payback, the move will    
  not be made.        
c] NPV = -100+83/1.1+8*(1.1^20-1)/(0.1*1.1^20)/1.1 = $               37.37 million
d] Yes        
  The investment should be made as the NPV is positive.
Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment