Cover | Table of Contents | Worksheet 30 - Ratio Analysis Worksheet

Ratio Analysis Worksheet

Would you like to send the completed form to yourself or someone else by e-mail? If so, please provide the following:

Your name:
Your e-mail address:
Address you wish to send the results to:

Please don't enter commas or dollar signs, just the numbers and the decimals.

		Year 1	Year 2	Year 3	Industry Averages
Solvency Ratios
Current Ratio	Current Assets Current Liabilities
Quick Ratio	Cash & Acct. Rec. Current Liabilities
Safety Ratio
Debt/Equity	Total Liabilities Net Worth
Profitability Ratios
Gross Margin Ratio - %	Gross Profit Sales
Net Profit Margin Ratio - %	Net Profit (B4Tax) Sales
Asset Management Ratios
Sales to Assets	Sales Total Assets
Return on Assets %	Net Profit (B4Tax) Total Assets
Return on Investment %	Net Profit (B4Tax) Net Worth
Inventory Management Ratios (Cost of Goods Sold)
Inventory Turnover	C.O.G.S. Inventory
Inventory Turnover Days	Days in Period Inv. T.O.
Accounts Receivable Management Ratios
Accounts Receivable Turnover	Sales Acct. Rec.
Accounts Receivable Collection Period	Days in Period A/R T.O.
Accounts Payable Period	C.O.G.S. Acct. Pay.
Accounts Payable Days	Days in Period A/P T.O.