(25 Points) Colonial Broadcast Case Question Use Regression Number 4 and the following assumptions to answer this question: Assume the base production cost of a movie is $2,600,000. Assume it costs $200,000 more to make a Fact based movie compared to a Fictional movie. Assume it costs $500,000 to hire an actor whom is considered to be a Star. Assume that a network can collect $380,000 in revenue for each Rating point a movie generates. Assume all the parameter estimates are statistically significant. Show all your work a. Ignoring for a moment the time value of money, what is the total expected rating and profit for each of the following three movies? 1. Fiction Based Movie on ABD 2. Fact Based Movie with Two Stars on BBS 3. Fiction Based Movie with One Star on CBC b. What is the net present value of the profits generated from each movie? Assume that movie 1 will be produced and aired immediately. Movie 2 will be produced and aired two years from today. Movie three will be produced and aired one year from today. Assume for simplicity that all revenues and costs for each movie will be received/paid exactly 0, 1 or 2 years from today. Assume the discount rate is 4%. c. If the decision had to made today on which movie to choose, which one would you choose? Why?