Case 1 – Ratio Analysis
- Go to the end of chapter 1 in text, to “ongoing project”
- Select two companies in the same or similar industries
- Go to SEC Edgar and find their most recent 10K (or the company’s website under “Investor Relations”, SEC Filings and search “annual” filings
- Download an Excel version of the 10K
- Find the financial statements and address the following questions:
- What standards do the companies follow
- Date of the statements and who are the auditors
- Prepare “common sized” income and balance sheets
- What are the trends in each companies’ financial statements
- Compare the common sized financial statements – which company do you believe is performing better and why
- Go to the end of chapter 4 in the text. For the financial statements downloaded in part A:
- Compute the ROE for all three years presented for each company.
- Compute the ROA and RNOA. Compute the profit margin and asset turnover ratio; as well as the net operating profit margin and net operating asset turnover ratio.
- Review the results and compare the two companies.
- Which company is performing better (and why)?
- Which company is trending more favorably?
- Review the balance sheet and calculate the quick ratio, current ratio, debt ratio and debt to equity ratio.
- Discuss the trends in liquidity and solvency for the two companies
- Which company is most liquid?
- Which company is most solvent?
Case 1 – Ratio Analysis