Where can I find… Company financial ratios?
15/12/2024
Financial ratios are often used to measure the performance of a company. These can be found ‘ready-made’ in several of our finance resources.
Company ratios can be categorised into different types:
- Profitability ratios – e.g. profit margin or return on capital employed. These analyse profitability.
- Liquidity ratios – e.g. cash ratio. These indicate how quickly a company’s assets can be converted into cash in order to pay creditors.
- Solvency (or debt) ratios – e.g. debt equity ratio. These show how well a company can deal with its long term financial obligations.
- Valuation ratios – e.g. price earnings ratio. These are used to measure the attractiveness of an investment in a company.
Analysis of financial ratios can be used to show how well a company is doing relative to its competitors. In this post, we are highlighting resources where the ratios come pre-calculated. Bear in mind however that ratios are calculated using standard formulae from data in the company’s financial statements – and if you are doing some in-depth analysis, you will be expected to do such calculations yourself.
If you need quick ratios, the best resources to look at are:
- Capital IQ
- Fame
- Bloomberg.
On Capital IQ, ratios can be found with the Financials menu. Simply type a company name into the search box, load up the company profile and look to the left hand menu. You will find the Ratios option under the Financials/Valuations heading. Both current and historical rations are available.
Use the menu situated directly above the data table to download to Excel.
On Fame, ten years of financial ratios are available. To view the ratios section, use the dots icon on the left-hand side to open up the table of contents. From here, select ‘Financials’ > ‘Ratios’.
To export, click on the Excel or PDF icon at the top.
On Bloomberg, a summary can be found in the Company Description <DES> or a more detailed list on the Ratios tab within a company’s Financial Analysis <FA>. To export, first ensure your Office Add-ins are enabled then select ‘Output’ > ‘Excel’> ‘Current Template’ from the red menu bar.
If you have any questions about where to find particular ratios or any other financial data you require, please do not hesitate to contact the Library.
Feature image from Pixabay. Available at: https://pixabay.com/photos/savings-budget-investment-money-2789112/
Categories & Tags:
Leave a comment on this post:
You might also like…
Preparing for assignments and exams?
Sorry! We know it seems a bit mean to mention the exams in January rather than looking forward to the break before it! However, we know many of you will be thinking about your forthcoming ...
Screening for FTSE 100 companies on Bloomberg
So you’re researching an index and need some data on its constituent companies? Bloomberg’s Equity Screening tool makes light work of this, not just for the FTSE, but for indices, exchanges and sectors worldwide. Type EQS ...
Accelerating my future: How Cranfield put me on the fast track to automotive safety innovation
Hello! I’m Michaela Kaiser, and I’m thrilled to share my journey studying abroad. I’m from Calgary, Canada, and I recently graduated from Cranfield’s MSc Automotive Engineering course. My path to Cranfield ...
From Myanmar to Cranfield: My path to Renewable Energy
As someone who is passionate about sustainability, my career goal is to build a path in the renewable energy sector. My aspirations comes from the benefits of developing sustainable energy sources and ensuring energy ...
From lifelong dream to circular economy leader: Q&A with Himesha Randeni on the Environmental Management for Business MSc
What does it take to turn a lifelong passion for the planet into a fulfilling and impactful career? For Himesha Randeni, the answer was the Environmental Management for Business MSc at ...
Library services over the Christmas period
Kings Norton Library will be open 24/7 throughout the holiday period as a study space. Library staff will work until 6pm on Friday 19 December and will resume their normal working hours from 9am on ...