Please show how to do in excel. I am confused on what it is asking for me to do with the negatives.

Given the information below for HooYaht Corporation, compute the expected share price at the end of 2020 using price ratio analysis Assume that the historical (arithmetic) average growth rates will remain the same for 2020 . (Do not round intermediate calculations. Round your answers to 2 decimal places. Exclude negative annual PE and P/CFPS ratios from the average PE and average P/CFPS ratio calculations. When computing annual growth rates, use a positive sign on the onnual rate of change if the per share value increased in value and use a negative sign on the annual rate of change if the per share volue deceased in value. Given the information below for HooYaht Corporation, compute the expected share price at the end of 2020 using price ratio analysis Assume that the historical (arithmetic) average growth rates will remain the same for 2020 . (Do not round intermediate calculations. Round your answers to 2 decimal places. Exclude negative annual PE and P/CFPS ratios from the average PE and average P/CFPS ratio calculations. When computing annual growth rates, use a positive sign on the onnual rate of change if the per share value increased in value and use a negative sign on the annual rate of change if the per share volue deceased in value