You are considering making a movie. The movie is expected to cost $100 million upfront and takes a year to make. After that, it is expected to make $81 million in the first year it is released and $8 million for the following 20 years. Your cost of capital is 10%.

a.) What is the payback period of this investment? (Hint: consider that you look upfront at this, that is from year=0. For solving this task it is necessary to consider carefully the timeline of the cash flows in years=0,1,2,3,....,21,22)

b.) .calculate the The NPV

PLEASE STATE THE FORMULAS TO SHOW VALUES AS USED ACCORDINGLY,NOT JUST START WRITTING WITHOUT QUOTING THE FORMULAS ON HOW YOU DERIVE THE VALUES OR FUNCTIONS.IF POSSIBLE SHOW HOW IT CAN BE USED USING EXCEL SO THAT I WILL UNDERSTAND EVERYTHING.THANKS AND GOOD LUCK.