Ratio Analysis Worksheet FREE & HIGH QUALITY by WorkSession

VIEWS: 24 PAGES: 1

More Info
									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

								
To top