Homepage / 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. Theseindicate 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 measurethe 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 formulaefromdata inthe 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 quickratios, 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 aboutwhere to find particular ratios or any other financial data you require, please do not hesitate to contact MIRC.
Feature image fromPixabay. Available at: https://pixabay.com/photos/savings-budget-investment-money-2789112/
Tracey Nunn
Written By: Tracey Nunn
A Business Librarian since 2006, Tracey leads support for taught MSc courses in the School of Management Library.
Categories & Tags:
Categories: Libraries|Tags: capitaliq, company financials, data, fame, financials, mirc, ratios, SOMLibrary, web-mirc-finance|
Leave a comment on this post:
You might also like…
Adding documents to your Mendeley account
15/12/2023|Tags: barrington, knl, mendeley, referencing, SOMLibrary|
Once you have created your Mendeley account you will want to add documents to it.There are three main waysof doingthis: Drag and Drop - drag filesorfolders from your desktop directly into your Mendeley account. This ...
The 10 areas that must be addressed to deliver Aviation 2050 targets
15/12/2023|Tags: aviation, climate change, SAF, sustainability|
The need for urgent action on sustainable aviation is clear. For industry to meet ICAO and Paris Agreement targets, both the delivery and scaling up of change must happen within this decade. This urgency ...
Archaeologists at Cranfield make a splash in the world of underwater research
15/12/2023|
What do shipwrecks, sunken cities, aircraft, submerged landscapes, and underwater caves have in common? They are all part of our submerged past and are being examined by underwater archaeologists all over the world, including our ...
Research support changes coming early next year
13/12/2023|Tags: barrington, knl, research publishing, research support, rights retention, SOMLibrary|
There are lots of changes ahead for Cranfield in the area of research, so we thought we’d outline them here for you… 1. New CRIS The new CRIS is live from 15 December with Phase ...
Library services over the Christmas period
12/12/2023|Tags: barrington, christmas, closing, knl, opening times, SOMLibrary|
Kings Norton Libraryand our School of Management Library will be open 24/7 throughout the holiday period as a study space. Library staff will work until 6pm on Friday 15 December and will resume their normal ...
Visualising Connections: Using data visualisation tools to expand your literature search
11/12/2023|Tags: barrington, data visualisation, knl, literature search, SOMLibrary|
Using data visualisations can be a great way to reveal connections between datum points and literature searching is no different. If you are interested in uncovering patterns, groups and connections within the literature you are ...
Sign up for more information about studying master’s and research degrees at Cranfield
I'm an expert in financial analysis and library resources, with a particular focus on the intersection of finance and information services. My extensive experience allows me to provide valuable insights into locating company financial ratios and understanding their significance.
In the provided article, the author, Tracey Nunn, a Business Librarian since 2006, discusses the importance of financial ratios in evaluating a company's performance. The article categorizes company ratios into different types, including profitability ratios, liquidity ratios, solvency (or debt) ratios, and valuation ratios. These ratios offer valuable insights into various aspects of a company's financial health.
Here's a breakdown of the concepts mentioned in the article:
-
Profitability Ratios:
- Examples: Profit margin, return on capital employed.
- Purpose: Analyze a company's profitability.
-
Liquidity Ratios:
- Example: Cash ratio.
- Purpose: Indicate how quickly a company's assets can be converted into cash to pay creditors.
-
Solvency (Debt) Ratios:
- Example: Debt equity ratio.
- Purpose: Show how well a company can handle its long-term financial obligations.
-
Valuation Ratios:
- Example: Price earnings ratio.
- Purpose: Measure the attractiveness of an investment in a company.
The article emphasizes that these ratios can be used to compare a company's performance with its competitors. Additionally, it provides information on resources where these ratios come pre-calculated. The mentioned resources are:
- Capital IQ: Ratios can be found with the Financials menu, and both current and historical ratios are available.
- Fame: Offers ten years of financial ratios, accessible through the Financials > Ratios section.
- Bloomberg: Provides a summary in the Company Description
and a detailed list on the Ratios tab within a company's Financial Analysis .
The article concludes by encouraging readers to contact the MIRC (Management Information and Resource Centre) for any questions regarding the location of specific ratios or other financial data.
In summary, this article by Tracey Nunn is a valuable resource for individuals seeking information on financial ratios, where to find them, and how to use them for company analysis. It underscores the importance of understanding a company's financial health through various ratios and directs readers to reputable resources for obtaining pre-calculated ratios.