Docstoc

Ratio Analysis Worksheet

Document Sample
Ratio Analysis Worksheet Powered By Docstoc
					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




© Copyright 2011 Docstoc Inc. registered document proprietary, copy not   2

				
DOCUMENT INFO
Description: 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.