Frequently Asked Questions
Can I combine ratios on one graph?
It depends on the ratio. Some ratios it makes sense to analyze together (current and quick ratios). Some ratios show the same information in different ways (debt and equity ratios). For these ratios, you can combine them on the same graph. Be careful that the axis are the same for both graphs. For instance, the A/R Turnover ratio and the Days Sales Uncollected are closely related but are not measured in the same units – one is a ratio and one is in days. They could be combined but you would need a left and right axis.
Can I combine my analysis of ratios?
Where it makes sense, yes. Debt and equity ratios are inverses of each other and can be discussed at the same time. The idea is to be clear and detailed but not repetitive. If you find yourself repeating the same points, you could combine the analyses.
How long should it be?
As many pages as needed but no more so. Quality not quantity! Use the exemplars as a guide.
Do I have to do all the ratios?
You must do all that apply to your company. If you are a service company you don’t have inventory and so you don’t have an inventory turnover ratio or a day’s sales in inventory.
I can’t find….
Current Assets Above Inventory… This is simply the total of all assets listed above inventory on the balance sheet. If you don’t have inventory, ask me in class what assets to look at.
Average Inventory… take the current inventory, the previous year’s inventory and average the two.
Net Sales on Credit… Use total sales or total revenue
Cost of Goods Sold… Find the closest expense (it may be total operating expenses) and make a note in your analysis that you couldn’t find the COGS number and explain what that means for your analysis.
I lost my ratio guide!
Here is another copy.
Below are examples of a ratio analysis at each level of performance.
May 29, 2011 at 3:02 pm
Just to be 100% clear, if we are doing a service company we do not have to calculate:
-Inventory Turnover
-Inventory Turnover Period
-Operating Cycle
-Gross Profit Margin
Is this list correst
May 29, 2011 at 8:00 pm
Correct – however, for Air Canada you could do a quick analysis of one of the other metrics used for looking at profitability and/or efficiency of an airline like operating revenues and expenses per available seat miles (ASM). The figures are calculated for you and presented in the first few pages of your annual report.