📐 Input Data Mapping

To ensure the most accurate results, we base our calculations on standard Czech accounting statements (CAS). Here is an overview of where to find individual items.

Item in FinSightWhere to find it (Income Statement / Balance Sheet)Note
SalesIncome Statement: I. Sales of products and services + II. Sales of goodsTotal company turnover.
EBITIncome Statement: * Operating resultEarnings before interest and taxes.
EBITDAIncome Statement: EBIT + E.1. Value adjustments (Depreciation)Earnings before interest, taxes, depreciation and amortization.
Interest expenseIncome Statement: N. Interest expenseCost of debt capital.
Cost of goods soldIncome Statement: B. Cost of goods soldUsed as approximation for COGS.
Total assetsBalance Sheet: TOTAL ASSETS
EquityBalance Sheet: A. Equity
DebtBalance Sheet: B.+C. DebtTotal debt (long-term and short-term).
CashBalance Sheet: C.IV. Cash and cash equivalentsCash register + bank accounts.

🧮 Main Indicator Formulas

Profitability

We measure the efficiency with which the company generates profit.

ROS (Return on Sales) = Net profit / Sales
ROE (Return on Equity) = Net Profit / Equity
ROA (Return on Assets) = Net Profit / Total Assets

Liquidity

The company's ability to pay its obligations on time.

Current Ratio = Current Assets / Current Liabilities
Quick Ratio = (Current Assets - Inventory) / Current Liabilities
Cash Ratio = Cash / Current Liabilities

Activity

DSO (Days Sales Outstanding) = (Receivables / Sales) × 365
DPO (Days Payable Outstanding) = (Payables / Cost of Goods Sold) × 365
Cash Conversion Cycle = DSO + DIO - DPO

Cash Flow Analysis

FinSight calculates cash flow using the indirect method from financial statements.

Operating cash flow:
Net profit
+ Depreciation (EBITDA - EBIT)
± Change in working capital (ΔCurrent Assets - ΔCurrent Liabilities)
= Operating CF
Investing cash flow:
Change in non-current assets (estimated from balance sheet)
= Investing CF
Financing cash flow:
Change in debt + Change in equity
= Financing CF
Net cash flow:
Operating CF + Investing CF + Financing CF

Note: Investing and financing cash flows are estimated from the balance sheet, as they are not directly available from the income statement. For more accurate analysis, we recommend using the official cash flow statement.

Debt

We measure capital structure and the company's ability to repay debts.

Debt/Equity = Debt / Equity
Debt/Assets = Debt / Total Assets
Equity Ratio = Equity / Total Assets

Break-even analysis

The break-even point shows at what sales the company will cover all costs.

Break-even point = Fixed costs / (1 - Variable costs / Sales)
Safety margin = (Sales - Break-even point) / Sales × 100%

Fixed and variable costs are estimated by industry (see section "Where We Use Estimates").

Forecast (3 scenarios)

FinSight uses Holt's exponential smoothing with trend for predicting future values. The model automatically detects trends in historical data and extrapolates them into the future.

Holt's model:
Level: Lt = α × Yt + (1 - α) × (Lt-1 + Tt-1)
Trend: Tt = β × (Lt - Lt-1) + (1 - β) × Tt-1
Predikce: Ŷt+h = Lt + h × Tt

3 scenarios:

Forecasts are indicative and based only on historical data. Actual development depends on many external factors (market, competition, management, macroeconomics).

🧠 Advanced Models

Altman Z-Score (for private companies)

We use a modified model for private companies (non-manufacturing / private), which is more suitable for Czech private companies (s.r.o.) than the original model for publicly traded companies.

Z' = 0.717*X1 + 0.847*X2 + 3.107*X3 + 0.420*X4 + 0.998*X5

X1 = Working Capital / Assets
X2 = Retained Earnings / Assets
X3 = EBIT / Assets
X4 = Equity / Debt
X5 = Sales / Assets

Beneish M-Score (Earnings Manipulation Detection)

Statistical model that looks for anomalies in accounting (e.g., fictitious sales or cost capitalization). We use the full 8-factor model according to the original research by Prof. Messod Beneish (1999).

Beneish M-Score formula:
M = -4.84 + 0.92×DSRI + 0.528×GMI + 0.404×AQI + 0.892×SGI + 0.115×DEPI - 0.172×SGAI + 4.679×TATA - 0.327×LVGI

Interpretation: If the score is higher than -2.22 (e.g., -1.5), it indicates a probability of earnings manipulation. Values below -2.22 suggest low manipulation risk.

Detailed description of 8 Beneish M-Score components:

Component Calculation Meaning
DSRI
(Days Sales in Receivables Index)
(Receivablest / Salest) / (Receivablest-1 / Salest-1) Growth in receivables-to-sales ratio may indicate fictitious sales. DSRI > 1.2 is a warning signal.
GMI
(Gross Margin Index)
((Salest-1 - COGSt-1) / Salest-1) / ((Salest - COGSt) / Salest) Decline in gross margin may indicate cost manipulation. GMI > 1.1 is a warning signal.
AQI
(Asset Quality Index)
(Non-current Assetst / Assetst) / (Non-current Assetst-1 / Assetst-1) Growth in non-current assets ratio may indicate cost capitalization. AQI > 1.2 is a warning signal.
SGI
(Sales Growth Index)
Salest / Salest-1 Rapid sales growth may be legitimate, but can also mask manipulation. SGI > 1.5 requires attention.
DEPI
(Depreciation Index)
(Depreciationt-1 / (Non-current Assetst-1 + Depreciationt-1)) / (Depreciationt / (Non-current Assetst + Depreciationt)) Decline in depreciation rate may indicate extended asset life to increase profit. DEPI > 1.0 is a warning signal.
SGAI
(SG&A Expense Index)
(OPEXt / Salest) / (OPEXt-1 / Salest-1) Decline in operating expenses-to-sales ratio may indicate hiding expenses. SGAI > 1.1 is a warning signal.
TATA
(Total Accruals to Total Assets)
(Net Profit - Depreciation - ΔWorking Capital) / Assets High accrual items may indicate aggressive accounting. TATA > 0.05 is a warning signal.
LVGI
(Leverage Index)
(Debtt / Assetst) / (Debtt-1 / Assetst-1) Growth in leverage may indicate attempts to hide problems. LVGI > 1.0 is a warning signal.

⚠️ Important warning: Beneish M-Score is a statistical model, not proof of fraud. High scores may have legitimate reasons (rapid growth, acquisitions, changes in accounting policies). Low scores do not guarantee absence of manipulation. Use as a complementary tool for due diligence, not as the sole source of truth.

⚠️ Where We Use Estimates (Heuristics)

Some data is not directly available in basic statements, so we use standardized estimates for indicative analysis purposes. It is important to know about them.

1. Loan repayments (for DSCR)

Since we do not know the company's repayment schedule, we estimate annual principal repayment as 15% of total debt. This corresponds to an average loan of approximately 7 years. For companies with short-term financing, this estimate may be inaccurate.

2. Retained earnings (for Z-Score)

If not provided, we estimate the "Retained Earnings" item as 40% of Equity. For start-ups, this may overestimate the score, for established companies it may underestimate it.

3. Variable vs. Fixed costs (for Break-even)

We estimate the ratio of fixed and variable costs based on the industry you choose. Specific ratios by industry:

Industry Share of variable costs Note
IT/SW20%Minimal variable costs (mainly people = fixed)
Services30%Mainly people (fixed), minimal material
Healthcare40%Medicines and materials vs. personnel
Transport55%Fuel vs. vehicle leasing
Manufacturing65%Materials, energy (variable) vs. machinery (fixed)
Construction70%Materials and subcontracting
Retail75%Purchase of goods is the main cost
General (default)60%Average value for unclassified companies

Reality may differ according to the specific business model. These values are indicative and based on average ratios in the given industries.

4. Operating expenses (OPEX) for Beneish SGAI

We primarily calculate as (Sales - COGS) - EBIT. If COGS is not available, we use a fallback estimate of 15% of sales, which corresponds to an average company with medium cost structure.

5. Retained Earnings for Altman Z-Score

If not explicitly provided, we estimate the "Retained Earnings" item as 40% of Equity. This estimate is based on average ratios for Czech private companies (s.r.o.). For start-ups, this may overestimate the score, for established companies it may underestimate it.

6. Working Capital for Altman Z-Score

If not explicitly provided, we calculate as Current Assets - Current Liabilities. If current assets are also not available, we use the fallback Cash - Current Liabilities, which is less accurate but still usable for indicative analysis.

💻 Local Data Processing

FinSight is designed with emphasis on privacy and security. All calculations take place directly in your browser, except for PDF export and ARES API calls, which go through server-side proxy.

Client-side calculations

FinSight uses pure JavaScript (Vanilla JS) without frameworks. All financial indicators are calculated directly in your browser from the data you enter:

No data storage

All inputs (financial statements) and outputs (calculations, charts) remain only in your browser. Only localStorage is used for:

Instant results

All calculations run synchronously when entering data. Charts are generated using Chart.js directly in the browser without the need for server communication. Results update in real time.

International support (i18n)

FinSight v18 supports three languages: Czech, English and German. Translations are loaded from JSON files (i18n/cs.json, i18n/en.json, i18n/de.json) with a cache-busting parameter to always load the latest version. The language is automatically detected from the browser or stored in localStorage according to user preference.

🔌 Data Retrieval from API (ARES Integration)

FinSight v16 integrates data from official state registers for more comprehensive company analysis.

Public Register (VR)

FinSight uses ARES REST API (https://ares.gov.cz/) to obtain basic company information:

Data is loaded via PHP proxy script (ares.php), which ensures secure API calls and parsing of JSON responses.

Insolvency Register (IR)

Like VR, insolvency data is also obtained via ARES REST API. The proxy script checks whether the company is in insolvency, reorganization or liquidation. Results are displayed in the "Company Profile" tab with a warning if the company is in trouble.

Tax Portal (VAT)

FinSight calls Financial Administration SOAP API (https://adisrws.mfcr.cz/) for:

SOAP requests are generated in PHP proxy and responses are parsed into JSON format for the frontend.

API call security

All API calls go through server-side PHP proxy (ares.php), which ensures:

Cache and optimization

ARES data is stored in localStorage for faster repeated loading. When the ID number changes, the cache is automatically refreshed. API calls run in parallel using Promise.all() for maximum speed.

💰 Advanced Tools

Bank traffic light (DSCR & Net Debt/EBITDA)

Simulation of a bank risk manager's perspective. Evaluates whether the company can "handle" its debts.

DSCR (Debt Service Coverage Ratio):
DSCR = (EBITDA - ΔWorking Capital) / (Interest + Principal repayments)

Net Debt/EBITDA:
Net Debt/EBITDA = (Debt - Cash) / EBITDA

Interpretation:

Heuristic for principal repayments: Since we do not know the company's repayment schedule, we estimate annual principal repayment as 15% of total debt. This corresponds to an average loan of approximately 7 years. For companies with short-term financing, this estimate may be inaccurate.

Valuator (company value estimate)

Quick estimate of company market value using EBITDA multiple. Multiples vary by industry, growth and risk.

Enterprise Value (EV):
EV = EBITDA × Industry multiple

Estimated company value:
Value = EV - Net debt

Industry multiples (indicative):

⚠️ Warning: This is a simplified indicative value, not an official valuation. The actual company value depends on many factors (growth, competition, management, market conditions).

What-If simulator

Interactive sensitivity analysis. Move sliders and watch how changes in sales, prices or costs affect profitability and returns.

Calculations in simulator:

The simulator helps plan scenarios and strategic decisions. All calculations run in real time directly in the browser.

📄 PDF Export

Important change in version 10: PDF is now generated server-side using PHP script export.php and Dompdf library. This change enables more professional formatting and better document quality.

Server-side generation (export.php v10)

PDF is generated on the server using PHP script export.php and Dompdf library (https://github.com/dompdf/dompdf). Data is sent to the server only for PDF generation and immediately deleted after generation.

🔒 Security and privacy: All data is processed only in memory (RAM) and immediately deleted after PDF generation. No data is stored on disk or in a database. Data is received, processed and forgotten within a single HTTP request. PDF is generated and sent back to the browser, where it is downloaded.

Chart capture

Charts from Chart.js are converted to images using native canvas.toDataURL() directly in the browser. Images are sent to the server as base64 data URLs within the JSON payload.

PDF document structure

PDF contains complete analysis:

Styling and formatting

PDF uses professional styling with Dompdf:

International support (i18n)

PDF export supports all languages (Czech, English, German). Language is automatically detected from user settings or passed explicitly in JSON payload.

🛠️ Technical Stack

FinSight v18 is built on modern web technologies with emphasis on performance, security and transparency.

Frontend

Backend (only for API proxy and PDF export)

No database

FinSight does not use any database. All data remains in the user's browser. Only localStorage for ARES data cache, language and theme preferences, and backup of entered data.

Security

✅ Transparency and Openness

FinSight is designed with maximum transparency. All calculations, formulas, models and heuristics are described in detail here. If you have any questions or uncertainties regarding the methodology, please do not hesitate to contact us.

Contact: dvorakh@gmail.com

Web: https://www.finsight.cz

Documentation version: 18 (November 2025)