I am attaching an excel file with most of the information to acquire the ratios and also I am including PDF's of the ratios required.

"'1 Program the spreadsheet to compute the nancial ratios (based on formula sheets from Chapters 4 8r. 5). However, you are NOT required to compute the basic BPS, diluted BPS, Altman's Z-score, and the returns on common stock based on Capital Asset Pricing Model (CAPM). Perform the quantitative analysis of protability and risk ratios. Compare two companies in the same industry based on the nancial ratios you calculate above. Interpret your main ndings for the analysis of the nancial ratios. a) Do a time-series analysis for each rm rst. Explain those nancial ratios that have changed signicantly over time. It's helpful to read the Management Discussion and Analysis section of the annual report to shareholders or the Form 10-K to nd explanations for the time-series changes. b) Do cross-section comparisons across two rms over time. Explain those nancial ratios differ signicantly across rms. Identify the nancial problems that may have impact on the sustainability of prots. Make investment recommendation based on your analysis and comparisons