Answered step by step
Verified Expert Solution
Question
1 Approved Answer
FINANCIAL ANALYSIS EXERCISE (1%)use Bloomberg to conduct key analysis of a public company of your choice. Use any company. For the most recent 3 years
FINANCIAL ANALYSIS EXERCISE (1%)use Bloomberg to conduct key analysis of a public company of your choice. Use any company. For the most recent 3 years (e.g. show 3 series of numbers) provide the companys key:
1) Activity ratios: 1) - Asset turnover Valuation ratios: - Forward P/E - Trailing P/E - Forward Price/BV - Dividend Yield - Fixed asset turnover - Inventory turnover - Days sales outstanding - Days payables outstanding 2) Liquidity ratios: - Current ratio - Quick ratio Cash ratio 2) 3) Profitability ratios: - Gross margin - Operating profit margin - Net profit margin - ROE Solvency ratios: - Debt-to-capital - Interest coverage 4) Provide 3 insights/take-aways from your analysis Be sure to show your work, indicate the appropriate unit (e.g. % or x or days) and present it in a format that is 1) Activity ratios: 1) - Asset turnover Valuation ratios: - Forward P/E - Trailing P/E - Forward Price/BV - Dividend Yield - Fixed asset turnover - Inventory turnover - Days sales outstanding - Days payables outstanding 2) Liquidity ratios: - Current ratio - Quick ratio Cash ratio 2) 3) Profitability ratios: - Gross margin - Operating profit margin - Net profit margin - ROE Solvency ratios: - Debt-to-capital - Interest coverage 4) Provide 3 insights/take-aways from your analysis Be sure to show your work, indicate the appropriate unit (e.g. % or x or days) and present it in a format that isStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started