RubiComps
Company Deep Dives

Historic Financial Analysis. Forecast. Valuation

Our AI Agent sources up to 10 years of filed accounts and delivers analysis, forecasting and valuation in less than 5 minutes per company.

10-Year Financial Analysis

Comprehensive financial analysis. P&L, BS, CF, KPIs, ratios and trends. Dashboards and visualization.

5-Year Forecast

Forecast module with editable assumptions and drivers. P&L, BS, CF, KPIs, ratios and trends.

DCF valuation

DCF valuation with editable inputs. Sensitivity analysis and implied multiples.

Excel File

Up to 11 years of financials and ratios in an editable Excel file. A Checks tab validates the numbers against the filed accounts.

Batch Deep Dives

30+ Deep Dives in less than 10 minutes

Variance analysis

Variance analysis and questions about performance

Year-by-year variance analysis across historical and projected years. AI-generated questions highlight key changes and anomalies.

Variance Analysis
Apr 25 Vs Apr 24
?Generate Questions About Performance
16 Vs 1517 Vs 1618 Vs 1719 Vs 1820 Vs 1921 Vs 2022 Vs 2123 Vs 2224 Vs 2325 Vs 2426 F Vs 2527 F Vs 26 F28 F Vs 27 F29 F Vs 28 F30 F Vs 29 F▦ Custom
Profit and LossBalance SheetCashflowViewIntermediate View ▾
Summary financials (£) LTMActual
Apr 25Previous
Apr 24Diff (£)Diff (%)
Total Sales32,369,23628,425,6803,943,55613.9%
Cost of Sales12,817,26412,006,530810,7346.8%
Cost of Sales % of Sales39.6%42.2%(2.6%)
Gross Profit19,551,97216,419,1503,132,82219.1%
Gross Margin60.4%57.8%2.6%
Total SG&A12,817,34111,318,2231,499,11813.2%
Total SG&A % of Sales39.6%39.8%(0.2%)
EBITDA8,244,5136,513,5771,730,93626.6%
EBITDA Margin25.5%22.9%2.6%
Net Income4,757,3033,474,6101,282,69436.9%
Net Income Margin14.7%12.2%2.5%
Performance
Apr 25 vs Apr 24
Apr 25vsApr 24Total SalesCost of SalesGross ProfitTotal SG&AEBITDAEBITDA Margin
5-year forecast

Integrated P&L, BS and CF forecast

Easily build integrated forecasts. Just input your assumptions and forget about calculations, formulas and copy-and-paste. Get instant P&L, BS, CF, KPIs, ratios and visualisations. Your forecasts will be used in the DCF valuation.

Forecast
Profit & LossBalance SheetCash FlowKPIs & Ratios
▦ Table▥ Charts
Sales
Apr 23Apr 30
EBITDA
Apr 23Apr 30
Cash
Apr 23Apr 30
PROFIT & LOSS — FORECAST (£)
APR 23
ACTUALAPR 24
ACTUALAPR 25
ACTUALAPR 26
FORECASTAPR 27
FORECASTAPR 28
FORECASTAPR 29
FORECASTAPR 30
FORECASTSales28,406,21531,952,38034,118,74236,165,86737,974,16039,872,86841,467,78343,126,494Growth12.5%6.8%6.0%5.0%5.0%4.0%4.0%Cost of Sales16,531,90418,712,06619,653,39520,795,37321,835,14222,926,89923,843,97524,797,734% of Sales58.2%58.6%57.6%57.5%57.5%57.5%57.5%57.5%Gross profit11,874,31113,240,31414,465,34715,370,49316,139,01816,945,96917,623,80818,328,760SG&A9,418,22714,602,41811,245,38011,600,00017,800,00012,400,00012,800,00013,200,000% of Sales33.2%45.7%33.0%32.1%46.9%31.1%30.9%30.6%Operating profit (EBIT)2,456,084(1,362,104)3,219,9673,770,493(1,660,982)4,545,9694,823,8085,128,760EBT2,043,778(1,818,022)2,821,1933,390,493(2,040,982)4,165,9694,443,8084,748,760Tax Rate25.0%25.0%25.0%25.0%25.0%Net Income1,532,834(1,818,022)2,115,8952,542,870(2,040,982)3,124,4773,332,8563,561,570
Actualfiled accountsForecastfitted from historyeditableyour assumption

For the best view, turn your phone to landscape.

Company valuation

DCF Valuation

Your forecasts generate a DCF valuation. Adjust your valuation parameters to get a detailed valuation breakdown, implied multiples and sensitivity tables.

Valuation
DCF Valuation
Valuation Summary
Enterprise Value32,100,578
Present Value of Forecasted FCFs7,379,21223.0%
Present Value of Terminal Value24,721,36677.0%
Minus Debt(2,450,000)
Plus Cash4,518,307
Equity Value34,168,885
Implied Valuation Multiples
Enterprise Value to Sales0.9x
Enterprise Value to EBITDA7.5x
Equity to Net Income (P/E)16.1x
Market Equity to Book Equity3.5x
Valuation Parameters
Terminal Value in Apr 3041,656,939 ✎
Calculated as 6.5x EBITDA, which implies 1.0x Sales and 2.2% Perpetual Growth.
WACC11.0%
Cost of Debt6.0%
Cost of Equity11.5%
Tax Rate25.0%
Debt to Enterprise Value7.1%
Equity to Enterprise Value92.9%
Cost of Equity11.5% ✎
Risk Free Rate4.5%
Beta1.0
Market Risk Premium6.0%
Company Specific Premium1.0%
Enterprise Value Sensitivity · £000
WACC10.0%10.5%11.0%11.5%12.0%12.5%13.0%13.5%Exit EBITDA Multiple ▾5.5x29,50128,89128,29727,71927,15526,60626,07025,5496.0x31,49130,83630,19929,57828,97328,38427,80927,2506.5x33,48132,78232,10131,43730,79130,16229,54928,9517.0x35,47034,72734,00233,29732,61031,94031,28830,6527.5x37,46036,67235,90435,15634,42833,71833,02732,3548.0x39,45038,61737,80637,01636,24635,49734,76634,055

For the best view, turn your phone to landscape.