Business Finance - Management BUS30100 Project Assignment Ratio Analysis of Publicly Traded Non-Financial and Non-Regulated Companies

profilePremiumquest19
BUS30100_Project_RatioAnalysisTemplate_2023S1.xlsx
Home>Business & Finance homework help>Management homework help>Business Finance - Management BUS30100 Project Assignment Ratio Analysis of Publicly Traded Non-Financial and Non-Regulated Companies

Ratio Analysis Template

Ratio Analysis of Publicly Traded Companies
From Y2019 to Y2022
Panel A: Company-Level & Industry-Level Data
Company Ratios Industry Benchmarks
Company 1 Name Company 2 Name Primary Industry Classification
SIC Code # SIC Code
Y2019 Y2020 Y2021 Y2022 Y2019 Y2020 Y2021 Y2022 Y2019 Y2020 Y2021 Y2022
Liquidity Ratios
Quick ratio
Current ratio
Solvency Ratios
Total debt ratio
Cash coverage ratio
Asset Management Ratios
Inventory turnover
Receivable turnover
Total asset turnover
Profitability Measures
Profit Margin
Return on assets
Return on equity
Market Value Ratios
P/E ratio
Market-to-book ratio
Panel B: Evaluation of Company Performance*
Company 1 Name Company 2 Name
SIC Code # SIC Code #
Y2019 Y2020 Y2021 Y2022 Y2019 Y2020 Y2021 Y2022
Liquidity Ratios
Quick ratio
Current ratio
Solvency Ratios
Total debt ratio
Cash coverage ratio
Asset Management Ratios
Inventory turnover
Receivable turnover
Total asset turnover
Profitability Measures
Profit Margin
Return on assets
Return on equity
Market Value Ratios
P/E ratio
Market-to-book ratio
*A favorable comparison between a company ratio and its industry benchmark should be labeled as "Good" while an unfavorable comparison be labeled as "Bad".