DTE Energy company

Entergy corporation

Collect annual reports $(5$ latest consecutive years from $2019)$ of the assigned selected companies.calculate all the ratios of companies that covered in Chapter $3.$ Calculate all your ratios in and Excel File. You need to show all your calculations in excel file but use the calculated value in your main report.$-$ From $2019$ to $2023.$ Analyze the total $5$ years' ratios. Your analysis should contain comparison between the two companies and within the company itself.Based on the ratio you need to answer following questions$-$

Q$1$: Should you invest in the mentioned companies based on ratio analysis? Justify your decision with a detailed explanation. Q$2$: Is it advisable to offer raw materials on credit to the specified companies, considering the findings from the ratio analysis? Provide a thorough explanation for your decision.Q$3$: Should you grant a longterm loan as a banker to these companies? Justify your decision.Use graphs, charts in your analysis.