Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 is

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Modeling Using Excel And VBA

Authors: Chandan Sengupta

1st Edition

0471267686, 978-0471267683

More Books

Students also viewed these Finance questions