how to calculate with financial calculator

excel is fine too

You are considering making a movie. The movie is expected to cost $10.4 millon up front and take a year to produce After that, it is axpected to make $4.7 miltion in the year it is released and $1.8 milion for the following tour years. What is the payback penod of this investment? If you require a payback penod of two years, will you make the movie? Does the movie have positive NeV It the cost of capital is 10.6%