Financial Analysis Worksheet by cht36722

VIEWS: 6 PAGES: 2

									                                                                     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

								
To top