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 SOM 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…
Gear up for the future of vehicle design: Introducing the MSc in Virtual Prototyping for Vehicle Structures (VPVS)
The automotive and motorsport industries are in a constant state of evolution. Light weighting, electrification, and ever-stringent safety regulations are driving a revolution in vehicle design. But this innovation requires a ...
Finding industry profiles in Library resources
When researching an industry; its size, value and performance; competitors, brands and trends in the market etc., we recommend having a look at the following services. These can all be accessed via the SOM Library's ...
Setting up a shared group folder in a reference manager
Many of our students are now busy working on their group projects. One easy way to share references amongst a group is to set up group folders in a reference manager like Mendeley or Zotero. ...
Where are they now? From a Women in STEM scholar to a Sustainability Senior Professional
We recently caught up with Karoline, a previous Women in STEM scholar to find out where her scholarship and Cranfield master’s has taken her. How has Cranfield impacted your career? Studying at Cranfield University ...
Alan Harrison Half-Fee Scholarship 2024/2025 Recipient: A transition from working life back to student life, filled with learning, challenges, and rewarding moments
My first term at Cranfield has been filled with learning, new challenges and rewarding moments. Coming in with only a basic understanding of procurement and supply chain management, I knew the first term would ...
Moving with the times: The ‘new-look’ Cranfield Management MSc
For more than a decade, the Cranfield Management MSc has been at the forefront of management education worldwide. Ranked best Management MSc in the UK for value for money and international student experience by ...