4. (a) Refer to the table below. Work out the Price Earnings Ratios of the five companies P, Q, R, S and T. Provide a brief interpretation of this ratio. (1.5 marks) Company P Q R S T Po $6.57 $45.46 $4.89 $18.00 $67.85 EPS $1.36 $6.78 $0.53 $1.65 $8.04 PE Ratio (b) Using statistical and/or reference functions (MATCH, INDEX) to display in cells the names of the two companies whose shares represent the best value based solely on their Price Earnings Ratios; i.e. assuming that the companies are otherwise equivalent in potential and risk. Please construct the template based on the picture below: (2.5 marks) Best value solely by PE ratio Second best value solely by PE ratio