Suzan just finished a new movie script. Paramount offers to buy the script, for either (a) $1,000,000 or (b) 4% of the movie's profits. There are three decisions the studio will have to make. The first is to decide if the script is good or bad, and the second is if the movie is good or bad, and the third is advertising. There is only a 30% the script is terrible. If the script is bad, the studio does nothing. If the script is good, the studio will shoot the movie. After the movie is shot, the studio will review it, and a 60% chance the movie is good. If the movie is terrible, it will go directly to the company's streaming service and earn $2.5 million. If the movie is really good, there is a 25% chance the company will advertise heavily and earn a net present value of $200 million. If the movie is good, there is a 75% chance the company will do minimal advertising and earn a net present value of $10 million. Please answer in excel :) Calculate the expected profit of this film. (Enter full value, e.g. 5 million should be 5,000,0000) Answer is not: $32,075,000 Calculate Suzan's payoff if she chooses Option B. (Enter full value, e.g. 5 million should be 5,000,0000) Answer is not: $33,075,000.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Suzan just finished a new movie script. Paramount offers to buy the script, for either (a) $1,000,000 or (b) 4% of the movie's profits. There are three decisions the studio will have to make. The first is to decide if the script is good or bad, and the second is if the movie is good or bad, and the third is advertising. There is only a 30% the script is terrible. If the script is bad, the studio does nothing. If the script is good, the studio will shoot the movie. After the movie is shot, the studio will review it, and a 60% chance the movie is good. If the movie is terrible, it will go directly to the company's streaming service and earn $2.5 million. If the movie is really good, there is a 25% chance the company will advertise heavily and earn a net present value of $200 million. If the movie is good, there is a 75% chance the company will do minimal advertising and earn a net present value of $10 million.

Please answer in excel :)

Calculate the expected profit of this film. (Enter full value, e.g. 5 million should be 5,000,0000) Answer is not: $32,075,000

Calculate Suzan's payoff if she chooses Option B. (Enter full value, e.g. 5 million should be 5,000,0000) Answer is not: $33,075,000. 

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Industry Specific Activities
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education