3 Ratio Analysis Input Worksheet #REF! Gray cells will be calculated for you. You do not need to enter anything into them. 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 Not incomo *** Input Liquidity Assets #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Profitability 0 #REF! #DIV/0! #REF! #REF! #REF! #REF! #REF! HDCCI G Debt #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 0 #REF! #DIV/0! #REF! #REF! #REF! #REF! #DCCI Market H #REF! 0 #REF! #REF! 0 #REF! #DIV/0! #REF! #REF! #REF! #REF! HDCCI