Ratio Analysis Spreadsheet “TheScorecard”

Ratio Analysis Spreadsheet "TheScorecard"

Year 1 Year 2

Year 3

Industry Composite

BALANCE SHEET RATIOS: Stability (Staying Power)

1.

Current

2.

Quick

3. Debt-to-Worth

Current Assets Current Liabilities

Cash + Accts. Rec. Current Liabilities

Total Liabilities Net Worth

INCOME STATEMENT RATIOS: Profitability (Earning Power)

4. Gross Margin

5.

Net Margin

Gross Profit Sales

Net Profit Before Tax Sales

ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios

6. Sales to Assets

7. Return on Assets

8.

Return on Investment

Sales Total Assets

Net Profit Before Tax Total Assets

Net Profit Before Tax Net Worth

ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios

9. Inventory Turnover

10.

Inventory TurnDays

Accounts

11.

Receivable

Turnover

Accounts

12.

Receivable

Turn-Days

13.

Accounts Payable Turnover

14.

Average Payment Period

Cost of Goods Sold Inventory 360

Inventory Turnover

Sales Accounts Receivable

360 Accts. Rec. Turnover

Cost of Goods Sold Accounts Payable

360 Accts. Payable Turnover

Calculations, Trends, or

Observations.

copyright 2018 Business Resource Services

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download