Where can I find… Company financial ratios?
07/02/2022
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 MIRC.
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…
Systematic Literature Review – Identifying your search terms and constructing your search strings
Our previous posts on the systematic review have looked at getting started and selecting your sources. In this post we will look at the next fundamental stage: Identifying your search terms and constructing your search ...
Navigating the World of Robotics: My Journey at Cranfield University
Hey there, I'm Manideep, and I'm thrilled to share my experience pursuing an MSc in Robotics at Cranfield University. Let me take you through my journey and how Cranfield became the ...
Exploring safer and smarter airports with the Applied Artificial Intelligence MSc group design project
Artificial intelligence (AI) technologies have experienced rapid development in recent years, spanning from large language models (LLMs) to generative artificial intelligence (GAI). These cutting-edge advancements have significantly impacted various aspects of ...
My aerospace manufacturing journey at Cranfield University
Hey there, I'm Abhishek and I wanted to share my journey into aerospace manufacturing, guided by my experiences at Cranfield University. Let's dive into how this remarkable institution shaped my career ...
Changes to Library Services over Easter, 29 March – 1 April
Libraries on the Cranfield site Both Kings Norton Library and the School of Management Library (Building 111, first floor) will be open 24/7 over the Easter weekend. You will be able to use the study ...
How to present well as a group
You will have put a lot of work into your research or project and want to show everyone what you have achieved or discovered, so you need to impart this knowledge as clearly as possible. ...