FinancialsSalesExpensesInventoryPaymentsBankingReportsDataSettings
Demo company

Forecast

The next

Profit, balance sheet and cash projected together from Oct 2026 to Sep 2027, built from your own figures. Revenue method: Recent trend.

NextForecast drivers reviewed and saved
Using the measured defaults; review growth, margin, days and loans.
What: Check the forecast settings and save.
How: On the Forecast page.
Go there
See every step
Revenue, next 12 months
EGP 14.2M
+14.6% on the last 12 months
Net profit, next 12 months
EGP 1.7M
last 12 months EGP 1.2M
Lowest cash
EGP 1.8M
in Oct 2026
Cash at Sep 27
EGP 3.3M

Cash stays positive throughout. The lowest point is EGP 1,838,298 in Oct 2026.

Revenue

ActualForecastLikely range
EGP 0EGP 250KEGP 500KEGP 750KEGP 1.0MEGP 1.3MEGP 1.5MAug 25Nov 25Feb 26May 26Aug 26Nov 26Feb 27May 27Sep 27

Cash on hand

ActualForecast
EGP 0EGP 1.0MEGP 2.0MEGP 3.0MEGP 4.0MAug 25Nov 25Feb 26May 26Aug 26Nov 26Feb 27May 27Sep 27

How accurate is this?

We hid your last 3 months, forecast them from the months before, and compared. Revenue was off by 4.6% a month on average, and operating profit (EBIT) by 1.6% of revenue. That is a close fit.

Method triedAverage error
Recent trend (used)4.6%
Recent average4.6%
Hidden monthActualForecast
Jul 2026EGP 1.1MEGP 1.1M
Aug 2026EGP 1.1MEGP 1.1M
Sep 2026EGP 1.1MEGP 1.1M

Recent trend: The growth rate of the last twelve months (or fewer), carried forward and gently flattened over time.

Drivers

Leave a box empty to use the figure from your history.
Try any figure: the demo is not saved.
MonthOct 26Nov 26Dec 26Jan 27Feb 27Mar 27Apr 27May 27Jun 27Jul 27Aug 27Sep 27Next 12 months
RevenueEGP 1.1MEGP 1.1MEGP 1.1MEGP 1.2MEGP 1.2MEGP 1.2MEGP 1.2MEGP 1.2MEGP 1.2MEGP 1.2MEGP 1.2MEGP 1.2MEGP 14.2M
Cost of SalesEGP 611KEGP 619KEGP 626KEGP 633KEGP 640KEGP 647KEGP 654KEGP 661KEGP 667KEGP 674KEGP 680KEGP 686KEGP 7.8M
Gross ProfitEGP 501KEGP 507KEGP 514KEGP 520KEGP 525KEGP 531KEGP 537KEGP 542KEGP 548KEGP 553KEGP 559KEGP 564KEGP 6.4M
ExpensesEGP 304KEGP 309KEGP 313KEGP 318KEGP 323KEGP 327KEGP 332KEGP 337KEGP 342KEGP 347KEGP 351KEGP 356KEGP 4.0M
Other Income less Expenses-EGP 20K-EGP 20K-EGP 20K-EGP 20K-EGP 20K-EGP 20K-EGP 20K-EGP 20K-EGP 20K-EGP 20K-EGP 20K-EGP 20K-EGP 240K
EBITEGP 177KEGP 179KEGP 180KEGP 182KEGP 183KEGP 184KEGP 185KEGP 186KEGP 186KEGP 187KEGP 187KEGP 187KEGP 2.2M
Net InterestEGP 3KEGP 3KEGP 3KEGP 3KEGP 3KEGP 3KEGP 3KEGP 3KEGP 3KEGP 3KEGP 3KEGP 3KEGP 36K
TaxEGP 39KEGP 39KEGP 40KEGP 40KEGP 40KEGP 41KEGP 41KEGP 41KEGP 41KEGP 41KEGP 41KEGP 41KEGP 487K
Net ProfitEGP 135KEGP 136KEGP 137KEGP 138KEGP 139KEGP 140KEGP 141KEGP 142KEGP 142KEGP 142KEGP 143KEGP 143KEGP 1.7M
  • With under two years of figures the seasonal pattern rests on one year; 24 months or more make it reliable.
  • Interest in the books is 112% a year of average borrowing; the forecast uses the 24.0% rate entered, so interest changes from the first forecast month.
  • No dividends are assumed.
How this forecast is built

Revenue: each method below is tested by hiding your latest months and forecasting them; the one with the smallest error is used. With 24 months or more a seasonal pattern can be learned.

Costs: variable cost of sales and variable expenses keep their recent share of revenue (last 12 months). Fixed costs and depreciation start from the last 3 months and rise with the cost driver; new investment adds depreciation over the assets' average life.

Interest: borrowing × the rate, on the average balance each month. Tax: the company rate on the year's profit to date, so earlier losses are offset first.

Balance sheet: customers, stock and suppliers follow the days held; fixed assets move with investment and depreciation; loans with drawings and repayments; equity with profit and dividends. Everything else is held. Cash is what is left, so the balance sheet always balances and the cash flow reconciles.

HomeSalesExpenses