[Company Name] Ratio Analysis Input Worksheet [Date]
Gray cells will be calculated for you. You do not need to enter anything into them.
Line Item Inventory Total assets Owners' equity Number of common shares
Beginning of Year
Line Item Current assets Fixed assets Total assets Average total assets Cash and cash equivalents Inventory Average inventory Current liabilities Total liabilities Owners' equity Number of common shares Average number of common shares Average owners' equity Market price per share Cash flow Cash flow per share Dividends paid Total sales Operating expenses Operating income Advertising expense Marketing expense Earnings before interest and taxes Interest expense Net income
Q1
Q2
Q3
Q4
Annual $0 $0 $0 $0 $0 $0 #DIV/0! $0 $0 $0 0 #DIV/0! #DIV/0! $0.00 $0 #DIV/0! $0 $0 $0 $0 $0 $0 $0 $0 $0
0 0
0 0
0 0
0 0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0
0
0
0
[Company Name] Ratio Analysis
Liquidity Ratios
Definition: Current Ratio = Industry Average Variance Quarterly Growth/Decline Quick Ratio = Industry Average Variance Quarterly Growth/Decline Net Working Capital = Current Assets – Current Liabilities Ratio Total Assets Industry Average Variance Quarterly Growth/Decline Current Liabilities to = Inventory Ratio Industry Average Variance Quarterly Growth/Decline Cash Ratio = Industry Average Variance Quarterly Growth/Decline Operating Ratio = Industry Average Variance Quarterly Growth/Decline Operating Expenses Operating Income Cash and Cash Equivalents Current Liabilities Current Liabilities Inventory Current Assets – Inventory Current Liabilities Current Assets Current Liabilities #DIV/0! 2.00 #DIV/0! #DIV/0! #DIV/0! 7.20 #DIV/0! #DIV/0! #DIV/0! = $0 $0 $0 = $0 $0 $0 = $0 $0 #DIV/0! 2.00 #DIV/0! = $0 $0 Q4 Annual
#DIV/0! 2.00 #DIV/0!
=
$0
$0
$0
#DIV/0!
=
$0
$0
$0
2.00 #DIV/0! #DIV/0! #DIV/0! = $0 $0
2.00 #DIV/0!
#DIV/0!
=
$0 $0
2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! = $0 $0 = $0 $0
2.00 #DIV/0!
#DIV/0! 2.00 #DIV/0!
=
$0 $0
#DIV/0! 2.00 #DIV/0!
=
$0 $0
The following calculations can be used for any expense line item or grouping of expense line items: Advertising Expense = to Sales Ratio Industry Average Variance Quarterly Growth/Decline Marketing Expense = to Sales Ratio Industry Average Variance Quarterly Growth/Decline Marketing Expense Total Sales Advertising Expense Total Sales #DIV/0! = $0 $0 #DIV/0! = $0 $0
2.00 #DIV/0! #DIV/0! #DIV/0! = $0 $0
2.00 #DIV/0!
#DIV/0!
=
$0 $0
2.00 #DIV/0! #DIV/0!
2.00 #DIV/0!
[Company Name] Ratio Analysis
Asset Ratios
Definition: Inventory Turnover Ratio = Total Sales Average Inventory #DIV/0! = $0 #DIV/0! #DIV/0! = $0 #DIV/0! Q4 Annual
Industry Average Variance Quarter Growth/Decline Fixed Assets Turnover = Ratio Industry Average Variance Quarter Growth/Decline Total Assets Ratio = Industry Average Variance Quarter Growth/Decline Asset to Equity Ratio = Industry Average Variance Quarter Growth/Decline Total Assets Owners' Equity Total Sales Total Assets Total Sales Fixed Assets
6.00 #DIV/0! #DIV/0! #DIV/0! = $0 $0
2.00 #DIV/0!
#DIV/0!
=
$0 $0
2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! = $0 $0 = $0 $0
2.00 #DIV/0!
#DIV/0! 2.00 #DIV/0!
=
$0 $0
#DIV/0! 2.00 #DIV/0!
=
$0 $0
[Company Name] Ratio Analysis
Profitability Ratios
Definition: Return on Assets Ratio = Industry Average Variance Quarter Growth/Decline Return on Equity Ratio = Industry Average Variance Quarter Growth/Decline Profit Margin Ratio = Industry Average Variance Quarter Growth/Decline Basic Earnings = Power Ratio Industry Average Variance Quarter Growth/Decline Earnings per Share Ratio = Industry Average Variance Quarter Growth/Decline Net Income Average Number of Common Shares Earnings Before Interest and Taxes Total Assets Net Income Total Sales Net Income Average Owners' Equity Net Income Average Total Assets #DIV/0! 2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! #DIV/0! = $0 $0 = $0 $0 = $0 #DIV/0! = $0 $0 #DIV/0! 2.00 #DIV/0! = $0 $0 Q4 Annual
#DIV/0! 2.00 #DIV/0!
=
$0 #DIV/0!
#DIV/0! 2.00 #DIV/0!
=
$0 $0
#DIV/0!
=
$0 $0
2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! = $0 #DIV/0!
2.00 #DIV/0!
#DIV/0! 2.00 #DIV/0!
=
$0 #DIV/0!
[Company Name] Ratio Analysis
Debt Ratios
Definition: Total Debt Ratio = Industry Average Variance Quarter Growth/Decline Interest Coverage Ratio = Earnings Before Interest and Taxes Interest Expense Total Liabilities Total Assets #DIV/0! 2.00 #DIV/0! #DIV/0! #DIV/0! = $0 $0 = $0 $0 #DIV/0! 2.00 #DIV/0! = $0 $0 Q4 Annual
#DIV/0!
=
$0 $0
Industry Average Variance Quarter Growth/Decline Debt/Equity Ratio = Industry Average Variance Quarter Growth/Decline Loan to Value Ratio = Industry Average Variance Quarter Growth/Decline Total Loan Value of Collateral or Property Total Liabilities Owners' Equity
2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! = $0 $0 = $0 $0
2.00 #DIV/0!
#DIV/0! 2.00 #DIV/0!
=
$0 $0
#DIV/0! 2.00 #DIV/0!
=
$0 $0
[Company Name] Ratio Analysis
Market Ratios
Definition: Earnings per Share = (EPS) Ratio Industry Average Variance Quarter Growth/Decline Price to Earnings Ratio = Industry Average Variance Quarter Growth/Decline Price to Cash = Flow Ratio Industry Average Variance Quarter Growth/Decline Payout Ratio = Industry Average Variance Quarter Growth/Decline Dividends Paid Net Income Market Price per Share Cash Flow per Share Market Price per Share Earnings per Share Net Income Average Number of Common Shares #DIV/0! = $0 #DIV/0! #DIV/0! = $0 #DIV/0! #DIV/0! = $0 #DIV/0! #DIV/0! = $0 #DIV/0! #DIV/0! = $0 #DIV/0! Q1 Q2 Q3 Q4 Annual
2.00 #DIV/0!
2.00 #DIV/0! #DIV/0! = $0.00 #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! = $0.00 #DIV/0! #DIV/0! = $0.00 #DIV/0! = $0.00 #DIV/0!
2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! #DIV/0! = $0.00 #DIV/0! = $0.00 #DIV/0!
2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! #DIV/0! = $0.00 #DIV/0! = $0.00 #DIV/0!
2.00 #DIV/0!
#DIV/0! 2.00 #DIV/0!
#DIV/0! 2.00 #DIV/0!
=
$0.00 #DIV/0!
#DIV/0!
#DIV/0!
=
$0.00 #DIV/0!
2.00 #DIV/0!
2.00 #DIV/0! #DIV/0! = $0 $0 #DIV/0! 2.00 #DIV/0! #DIV/0! = $0 $0
2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! = $0 $0
2.00 #DIV/0! #DIV/0! #DIV/0! 2.00 #DIV/0! #DIV/0! = $0 $0
2.00 #DIV/0!
#DIV/0! 2.00 #DIV/0!
#DIV/0! 2.00 #DIV/0!
=
$0 $0