Describes accounting metrics and the formulas produced by the financial and marketing metrics endpoints
This feature provides a set of pre-calculated ratios and metrics used to assess a company's performance. It leverages the Categories feature, which standardizes bespoke data across SMEs. After the data is standardized, meaningful insights and measurements are produced for financial performance.
Currently, to measure company performance, clients need to map each of their customer’s bespoke financial statements to a single standardized chart of accounts - this is what our Categories feature does. After financials are fully standardized, clients need to perform complex calculations in order to produce financial ratios and metrics - this is what our Financial Metrics feature does. It saves the client considerable time and effort.
With this feature, you will decrease the time to onboard customers, underwrite customers faster, easily monitor the ongoing health of your customers, and provide improved financial reporting, planning and analysis. You will have more confidence in your decisions knowing they are based on the latest, most accurate data available.
What ratios and metrics are available?
The following table lists which ratios and metrics are calculated, their formulas and how they translate to Codat data points:
Financial metrics formulas
|Ratio / Metric||Formula||How that's translated to Codat data points|
|Gross profit margin||gross profit / net sales|
|EBITDA||net operating income + interest + tax + depreciation + amortization|
|Debt service coverage ratio||net operating income/total debt service |
Where, total debt service = Loan interest + principal
|Current ratio||current assets / current liabilities|
|Quick ratio||(current assets - inventory – prepaid expenses) / current liabilities|
|Free cash flow||Net Income + Depreciation and amortization (non cash expense) - Working Capital Variation - Purchases of PP&E (CAPEX)|
c. PreviousPeriod's SUM(Asset.Current)
d. PreviousPeriod's SUM(Liability.Current)
|Working capital||current assets – current liabilities|
|Fixed-charge coverage ratio||(EBIT + Fixed charge before tax) / (Fixed charge before tax + Interest)|
Marketing metrics formulas
|Percentage||Formula||How that's translated to Codat data points|
|Marketing to revenue||(revenue) / (sum of marketing operating expense)|
|Marketing to expense||(sum of marketing operating expense) / (expense)|