Case study 1 | Marketing homework help

Please see attached case study and answer Questions.

***You will see similar case study in google search but the values are totally different.Please dont copy paste the same answers.

 You can answer these questions one by one, or use Excel to estimate and evaluate the cash flows in a holistic way .

Please provide formulas and calculations 

Notes: attached reference file for answers dont use the same as the values in this case study are different -Just use as reference