Docstoc

Ratio Analysis Worksheet FREE & HIGH QUALITY

Document Sample
Ratio Analysis Worksheet  FREE & HIGH QUALITY Powered By Docstoc
					106. Ratio Analysis Worksheet
For the Month Ending ______________________
Current Ratio = Current Assets ÷      Current Liabilities
Current Ratio = ________________ ÷ _______________ = This Year
Current Ratio = ________________ ÷ _______________ = Last Year


Inventory Turnover = Cost of Goods Sold ÷ Inventory
Inventory Turnover = ________________ ÷ _______________ = This Year
Inventory Turnover = ________________ ÷ _______________ = Last Year


Total Asset Turnover = Net Sales ÷ Total Assets
Total Asset Turnover = ________________ ÷ _______________ = This Year
Total Asset Turnover = ________________ ÷ _______________ = Last Year


Average Collection Period = Accounts Receivable ÷ Average Credit Sales/Day
Average Collection Period = ________________ ÷ _______________ = This Year
Average Collection Period = ________________ ÷ _______________ = Last Year


Long-Term Debt to Equity = Long-Term Debt ÷ Stockholders' Equity
Long-Term Debt to Equity = ________________ ÷ _______________ = This Year
Long-Term Debt to Equity = ________________ ÷ _______________ = Last Year


Total Debt to Total Assets = Total Liabilities ÷ Total Assets
Total Debt to Total Assets = ________________ ÷ _______________ = This Year
Total Debt to Total Assets = ________________ ÷ _______________ = Last Year


Earnings per Share = Earnings after Tax less Dividends ÷ Number of Common Shares
Outstanding
Earnings per Share = ________________ ÷ _______________ = This Year
Earnings per Share = ________________ ÷ _______________ = Last Year

				
DOCUMENT INFO
Shared By:
Stats:
views:24
posted:7/14/2010
language:English
pages:1
Description: Ratio Analysis Worksheet FREE & HIGH QUALITY