Financial Ratios
The Financial Ratios screen can be accessed from the Management Central Quick Links screen by clicking on the Financial Ratio link on the Financial list
The Financial Ratios screen allows you to view a branch locations financial ratios.
See also Financial Ratios Overview.
The following is a description of the fields that appear on the Financial Ratios screen:
| Field | Description |
|---|---|
| Select Period End Date | Search for financial ratios by selecting a period end date from the drop down list. |
| Select Location |
Search for financial ratios by selecting a branch location grouping from the drop down list. Note:
|
The following is a description of the fields that appear on the Financial Ratios screen:
| Field | Description |
|---|---|
| Your Indicator | The current amount calculated for this financial ratio. |
| Your Budget | The amount budgeted for this financial ratio. |
The Financial Ratios formulas used are as follows:
|
Financial Ratios |
|
|---|---|
| Sales Mix | |
| New Equipment | N / (N + U + R + M + V) |
| Used Equipment | U / (N + U + R + M + V) |
| Rentals | R / (N + U + R + M + V) |
| Parts | M / (N + U + R + M + V) |
| Service | V / (N + U + R + M + V) |
| Profitability | |
| Gross Margins | |
| New Equipment | (N - Z) / N |
| Used Equipment | (U - X) / U |
| Rentals | (R - Q) / R |
| Parts | (M - P) / M |
| Service | (V - Y) / V |
| Total | (N + U + R + M + V) - (Z + X + Q + P + Y) / (N + U + R + M + V) |
| Operating Expense % | E / S |
| Pre Tax Income % | (S - D - E - F) / S |
| Revenue Per Employee |
S / Number of Employees Note:
|
| Absorption Rate | ((M - P) + (V - Y)) / (E + 1) |
| Sales to Equity | S / G |
| Return on Assets | (S - D - E - F) / A |
| Return on Equity | (S - D - E - F) / G |
| EBIT | (S - D - E - F + 1 + 3) / S |
| EBITDA | (S - D - E - F + 1 + 2 + 3) / S |
| Return (after taxes) on Working Capital | (S - D - E - F) / ( C - L) |
| Return (before taxes) on Gross Margin | (S - D - E - F - 3) / ((N + U + R + M + V) - (Z + X + Q + P + Y)) |
| Return (after taxes) on Gross Margin | (S - D - E - F) / ((N + U + R + M + V) - (Z + X + Q + P + Y)) |
| Activity | |
| Days Sales Outstanding | (Avg. Begin B and End B) / (N + U + R + M + V) * 365 |
| Inventory Turns | |
| New Equipment | Z / (Avg. Begin W and End W) |
| Used Equipment | X / (Avg. Begin K and End K) |
| Rental | Q / (Avg. Begin H and End H) |
| Parts | P / (Avg. Begin O and End O) |
| Liquidity | |
| Current Ratio | C / L |
| Quick Ratio | (I + J) / L |
| Coverage | |
| Leverage Ratio | T / G |
| Current Debt to Inventory | L / (H + K + O + W) |
| Net Sales to Working Capital | S / G |
| Net Sales to Total Assets | S / A |
| Additional Ratio | |
| Contribution Margin % | (S - D - E - F) / S |
| Return on Service Labor | (V - 4) / 5 |
| Debt Service Ratio | (S - D - E - F + 1 + 3) / 1 |
Click on the Show amounts used for calculations link to view the actual amounts and the formula identification numbers used for these financial ratio calculations.