Financial Performance Management

Ratios template

RATIO ANALYSIS - A TEMPLATE
CALCULATIONS:
		company A			company B
Input data for Liquidity Ratios:		year	year		year	year
Current Assets
Current Liabilities
Inventories
Cash
LIQUIDITY RATIOS:		year	year		year	year
Current Ratio		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Current Assets/Current Liabilities
Quick Ratio (or Acid Test Ratio)		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
(Current Assets-Inventories)/Current Liabilities
Cash Ratio		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Cash/Current Liabilities
		company A			company B
Input data for Profitability Ratios:		year	year		year	year
Gross Profit		0	0		0	0
Operating Income		0	0		0	0
Pre Tax Income		0	0		0	0
Net Income		0	0		0	0
Sales		0	0		0	0
Total Equity		0	0		0	0
Total Assets		0	0		0	0
PROFITABILITY RATIOS:		year	year		year	year
Gross Margin		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Gross Profit/Sales
Operating Margin		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Operating Income/Sales
PreTax Margin		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
PreTax Income/Sales
Net Profit Margin		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Net Income/Sales
Return on Equity (ROE)		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Net Income/Tot.Equity
Return on Assets (ROA)		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Net Income/Tot.Assets
LEVERAGE RATIOS Input:		year	year		year	year
Total Debt		0	0		0	0
Total Equity		0	0		0	0
Total Assets		0	0		0	0
EBIT (Operating income)		0	0		0	0
Interest Expense		0	0		0	0
LEVERAGE RATIOS:		year	year		year	year
Debt/Equity Ratio		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Total Debt/Total Equity
Debt/Capital Ratio		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Total Debt/(Tot.Equity+Tot.Debt)
Equity Multiplier		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Total Assets/Total Equity
Interest Coverage Ratio		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
EBIT/Interest Expense
Input data for Working Capital Ratios:		year	year		year	year
Inventories		0	0		0	0
Account Receivables		0	0		0	0
Account Payables		0	0		0	0
Purchases		0	0		0	0
Sales		0	0		0	0
WORKING CAPITAL RATIOS:		year	year		year	year
Inventory Days		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
(Inventories/Purchases) x 360
Account Receivable Days		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
(Account Receivable/Sales) x 360
Account Payable Days		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
(Account Payable Days/Purchases) x 360
Duration Working Capital Cycle		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Stock Period + Credit Period - Payable Period
VALUATION RATIOS Input:		year	year		year	year
Earnings (Net Income)		0	0		0	0
Total Shares Outstanding		0	0		0	0
Current market price		0	0		0	0
Dividends per share		0.00	0.00		0	0
Total Equity		0	0	same as above	0	0
VALUATION RATIOS:		year	year		year	year
Earnings per share		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Earnings/Tot.SharesOutstanding
Price/Earnings Ratio		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Market price/Earnings per share
Book Value per Share		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Tot.Equity/Tot.SharesOutstanding
Dividend Yield		ERROR:#DIV/0!	ERROR:#DIV/0!		ERROR:#DIV/0!	ERROR:#DIV/0!
Tot.Dividends/Market Price