Investment Valuation Major Project

please find question and excel template attached. please assist in completingthanks