VIEWS: 6 PAGES: 2 CATEGORY: Legal POSTED ON: 6/15/2010 Public Domain
Financial Analysis Worksheet Prof. Charles Mulford DuPree School of Management Record financial statement data here: (In thousands of dollars except per share) Enter all amounts as positive unless (brackets) called for. Co. One Co. Two Co. Three Income statement data: Current Yr Prior Yr Current Yr Prior Yr Current Yr Prior Yr Revenue Cost of goods sold Research and development Selling, general & admin. Nonrecurring operating income Nonrecurring operating expense Operating income Other nonrecurring income Other nonrecurring expense Pretax income contin. opers. Provision for income taxes Net income Earnings per share Balance sheet data: Cash and equivalents Short-term investments Accts and notes receivable, net Inventory Total current assets Total assets Accounts payable Total current liabilities Preferred shareholders' equity Total shareholders' equity Common shares outstanding Year-end market price per share Cash flow statement data: Depreciation and amort. expense Cash provided (used) in operating activities Additions to PP&E Page 1 Financial Analysis Worksheet Prof. Charles Mulford DuPree School of Management Financial Ratios Summary: Group Mean Group Mean Co. One Co. Two Co. Three Current Yr Prior Yr Current Yr Prior Yr Current Yr Prior Yr Current Yr Prior Yr Profitability ratios: Gross margin ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Sustainable operating income 0 0 0 0 0 0 0 0 Operating income ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! R&D expense percent #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! SGA expense percent #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Sustainable net income #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Net margin ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Effective tax rate #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Return on total assets #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Return on equity #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! DuPont Analysis: Net margin ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total asset turnover #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total assets to equity #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Liquidity ratios: Current ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Quick ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Leverage ratios: Total assets to equity #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Book value per share #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Activity ratios: Receivables turnover #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Days receivables #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Inventory turnover #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Days inventory #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Payables turnover #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Days payables #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Cash cycle #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total assets turnover #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Days total assets #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Cash Flow ratios: Net cash margin #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Capital expenditures to Deprec.#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Valuation ratios: Earnings per share (EPS) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Price / earnings ratio (PE) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Price / book value #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Page 2