Please do this in excel and show work.

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 annual 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 value deceased in value.)