BUS30100 Project: Assignment Ratio Analysis of Publicly Traded Non-Financial and Non-Regulated Companies

Conduct a ratio analysis on two comparable publicly traded companies that are nonfinancial and non-regulated using S&P NetAdvantage. 

1. Select two comparable publicly traded companies that are non-financial and non-regulated. 

a. Non-financial and non-regulated companies are all companies not classified in the industries of 

(1) Finance, Insurance, and Real Estate, 

(2) Public Administration, and 

(3) Electric, Gas and Sanitary Services. 

b. Comparable companies are the ones with the same Primary Industry Classification and a similar size that is measured by the revenue. 

c. The instructions on how to identify appropriate companies can be found in Section C.1 of this file. 

 

2. Download the following ratios for the most recent four filings (2019 to 2022): Category Specific Ratios Financial Ratios Quick ratio; Current ratio Total debt ratio; Cash coverage ratio Inventory turnover; Receivable turnover; Total asset turnover Profit margin; Return on assets; Return on equity Market Value Ratios P/E ratio; Market-to-book ratio a. The instructions on how to download the required ratios are shown in Sections C.2 and C.3 of this file. b. All ratios must be obtained from S&P NetAdvantage. No ratios should be calculated. Missing ratios should be labeled as N/A in the Ratio Analysis worksheet containing the organized data.