Financial Ratio Analysis
Introduction  
General formulas and descriptions to help you get started
Check with Finance organization for company-specific formulas and definitions
Start by looking at year-over-year trends
To highlight inefficiencies, compare the current year ratio to 'benchmark' (competitor and/or industry average)
PERFORMANCE  
GP/Sales Gross Profits (GP) to Sales ratio = the proportion of sales that finds its way to Gross Profits. Higher the better...
NI/Sales Net Income (NI) to Sales ratio = the proportion of sales that finds its way to net income (net profits). Higher the better...
ROE Net Income / Average equity. Higher the better. Note: the denominator is usually an average over a 2 yr period.
OPERATING (AKA Liquidity): how easily a firm can lay its hands on cash
Current Ratio Current Assets / Current Liability. Higher the better. More potential cash on hand. Similar to Net Working ing capital
which is CA-CL.
EFFICIENCY: how efficiently a firm is using its assets
Sales/Assets: Sales / Average Total Assets. A high ratio could indicate that firm is working close to capacity.
Note: the denominator is an average ...i.e (Yr1+Yr/2).
Inv/Sales Inventory (Inv) to Sales ratio = the proportion of sales that is consumed by inventory. Lower the better...
CGS/Inv The proportion of inventory that is tied up in Cost of Goods Sold (CGS). Lower the better…
CGS/Sales The proportion of sales that is tied up in CGS. Lower the better.
Invent Turns CGS/Avg inventory = rate in which companies turn-over their inventory. Higher the better...
(Days) Note: (Inv/(Net Sales/365 days)) will tell you the number of inventory days-on-hand.
Avg Collect Average Receivables/ (Net Sales/365 days) = how quickly customers pay bills.
Note: Average Receivables is an average over a 2 yr period.
(Days) Note: (Average Receivables/(Net Sales/365 days)) will tell you the number of collection days.