Financial Ratios

Use the Financial Ratios screen to view a location's financial ratios. To access the screen, navigate to Management Central > Financial > Financial Ratios.

See also Financial Ratios Overview.

Search fields on the Financial Ratios screen are:

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 location grouping from the drop down list. Location groupings are set up on the Profit Centers.

Fields on the Financial Ratios screen are:

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 The Number of Employees value is recorded in the Legacy System's DIVTAB configuration table.
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 the Show amounts used for calculations link to view the actual amounts and the formula identification numbers used for these financial ratio calculations.