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…
How to build a business that keeps growing
Ask any business owner about their ambitions and "growth" will almost certainly feature near the top of the list. More customers, higher revenues, larger teams and new markets are often seen as signs of ...
Three practical ways SMEs can build resilience in a challenging business environment
Economic uncertainty, shifting customer expectations and rapid technological change have become part of everyday business. While no organisation can predict every challenge, small and medium-sized enterprises (SMEs) can improve their resilience by focusing on ...
Six reasons students fall in love with Cranfield University
If you ask a Cranfield student what makes the University special, you won’t just get the usual “great teaching” answer. You’ll hear stories about industry projects that feel like real jobs, friendships built with ...
Boosting flight safety: Cranfield’s icing wind tunnel in action
The icing wind tunnel (IWT) was established at Cranfield University in 2003. The facility is capable of producing impact ice on models mounted within a range of different test sections. At present, the Cranfield ...
Getting ready to hand in your thesis?
You are nearly there! Many of our students are now starting to think about finishing their theses. If you are one of them, then you might find this post useful as you write up your ...
Frameworks to help you critically evaluate your sources
With so much information available, it can be challenging to identify reliable sources. Not all information is trustworthy, so it is important to critically evaluate what you find. Library Search and our subscription databases can ...
Comments are closed.