Financial evaluation of the compnay

hello this is a finacial review for a company 2 PDF files are inculded one says the question and the other is names AEIS company matrials 

The questions are needed to be answered fully using the formulas attached ( if needed ) based on the AEIS company metrials attached ( please only use this as a refrence ) 

please fill the below excel Intrinsic Share Price Value of Advanced Energy for advance 5 years too 

attached is the one for HP you need to use the information and the wacc that u previoulsy cacluted