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.
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
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.
Step by step
Solved in 3 steps with 2 images
