hcs 385 Financial Performance Evaluation

ratio-analysis-spreadsheet.xls

Sheet1

RATIO ANALYSIS SPREADSHEET
BALANCE SHEET RATIOS: Stability (Staying Power)
1	Current
		Current Assets		0
		Current Liabilities
2	Quick
		Cash + Accts. Rec.		0
		Current Liabilities
3	Debt-to-Worth
		Total Liabilities		0
		Net Worth
INCOME STATEMENT RATIOS: Profitability (Earning Power)
4	Gross Margin
		Gross Profit		0
		Sales
5	Net Margin
		Net Profit Before Tax		0
		Sales
ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios
6	Sales-to-Assets
		Sales		0
		Total Assets
7	Return on Assets
		Net Profit Before Tax		0
		Total Assets
8	Return on Investment
		Net Profit Before Tax		0
		Net Worth
ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios
9	Inventory Turnover
		Cost of Goods Sold		0
		Inventory
10	Inventory Turn-Days
		360	360	0
		Inventory Turnover
11	Accounts Receivable Turnover
		Sales		0
		Accounts Receivable
12	Accounts Receivable Turn-Days
		360	360	0
		Accts. Rec. Turnover
13	Accounts Payable Turnover
		Cost of Goods Sold		0
		Accounts Payable
14	Average Payment Period
		360	360	0
		Accts. Pay. Turnover