# Ratio Analysis Worksheet

VIEWS: 910 PAGES: 3

• pg 1
```									This is a worksheet used by companies to conduct a quantitative analysis of information
in financial statements. Ratios are calculated from the current year’s numbers and are
then compared to previous years or to competitors to gauge the performance of the
company. Ratio analysis is predominately used by proponents of fundamental analysis.
There are many ratios that can be calculated from the financial statements pertaining to
a company's performance. Some common ratios include the price-earnings ratio, debt-
equity ratio, earnings per share, asset turnover and working capital. This worksheet can
be used by small businesses or other entities that want to conduct a thorough
examination of company earnings.
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