million upfront and take a year to make. Afterthat, it is expected to make $ 4.7million in the first year it is released(end of year2) and $ 2.1$2.1
million for the following four years(end of years 3 through6) . What is the payback period of thisinvestment? If you require a payback period of twoyears, will you make themovie? What is the NPV of the movie if the cost of capital is 10.5 %10.5%?
According to the NPVrule, should you make this movie? Please show me each step using excel. This is a sample problem and I need to learn how this is done step by step so that I can do the homework problem.