ACTIVITYHUB PROFESSIONAL WORKSPACEFinancial Studio
STEP-BY-STEP HELP
How to build financial forecasts
Step 1: Select a three- or five-year planning period.
1Choose horizon
2Enter assumptions
3Review statements
4Test scenarios
5Check charts
6Export Excel
STEP-BY-STEP HELP
3 & 5 year financial workflow
Step 3: Check the income statement and confirm that revenue, direct costs, overheads, tax and profit are realistic.
✓Connect plan
✓Confirm assumptions
3Review profit
4Reconcile cash
5Check position
6Save & export
CONNECTED ZAR FINANCIAL WORKFLOW
3 & 5 Year Financial Studio
Generate reconciled statements, projections and scenario forecasts for new or imported business plans.
CONNECTED BUSINESS PLAN
General business plan
Not specified · Business plan · Activityhub plan
FORECAST SCENARIOTest uncertainty before approving the plan
REVENUE PROJECTION
5-year base forecast
PROFITABILITY
Net profit trend
Net profitR 1 582 039
FORECAST & SENSITIVITY
Scenario comparison at Year 5
INTEGRATED STATEMENTS
Profit & Loss · 5 years
| Statement line | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Revenue | R 2 160 000 | R 2 916 000 | R 3 936 600 | R 5 314 410 | R 7 174 454 |
| Cost of sales | R 1 188 000 | R 1 603 800 | R 2 165 130 | R 2 922 926 | R 3 945 949 |
| Gross profit | R 972 000 | R 1 312 200 | R 1 771 470 | R 2 391 485 | R 3 228 504 |
| Operating expenses | R 732 000 | R 790 560 | R 853 805 | R 922 109 | R 995 878 |
| EBITDA | R 240 000 | R 521 640 | R 917 665 | R 1 469 375 | R 2 232 626 |
| Depreciation | R 56 000 | R 56 000 | R 56 000 | R 56 000 | R 56 000 |
| Interest | R 47 250 | R 37 800 | R 28 350 | R 18 900 | R 9 450 |
| Profit before tax | R 136 750 | R 427 840 | R 833 315 | R 1 394 475 | R 2 167 176 |
| Tax | R 36 923 | R 115 517 | R 224 995 | R 376 508 | R 585 138 |
| Net profit | R 99 828 | R 312 323 | R 608 320 | R 1 017 967 | R 1 582 039 |