Build your 2027 budget in 5 steps
December is budget season. This kit gives you three ready Excel templates and a short guide written by a CFO, so you finish with a budget you can actually run the business on.
- Monthly P&L Budget vs Actual
- Headcount & Opex Budget
- 13-Week Cash Flow Forecast
How to build your 2027 budget
Start from your 2026 actuals
Take your actual results for January to October and add your best estimate for November and December. This full-year 2026 picture is your starting point. Mark one-off items (a big one-time order, a legal settlement) so they are not copied into 2027.
Use: Monthly P&L Budget vs Actual
Example (illustrative numbers): If 2026 revenue is EGP 12.0 million including a one-time order of EGP 0.6 million, your recurring base is EGP 11.4 million.
Build revenue from drivers, not "last year plus a percentage"
Write revenue as volume times price for each main product or customer group, month by month. Drivers make the budget easy to challenge and easy to update when reality changes.
Use: Monthly P&L Budget vs Actual
Example (illustrative numbers): 120 active customers × 2 orders a month × EGP 4,500 average order = EGP 1,080,000 revenue a month.
Plan headcount and operating costs line by line
List every role with its monthly cost and start month, then every fixed cost (rent, systems, insurance, fees). Budget new hires from their real start month, not for the full year.
Use: Headcount & Opex Budget
Example (illustrative numbers): A new hire at EGP 30,000 a month starting in April costs 9 months × EGP 30,000 = EGP 270,000 in 2027, not EGP 360,000.
Turn profit into cash
Profit is not cash. Apply your real collection and payment terms, VAT and loan repayments, and set a minimum cash buffer. Then check the first 13 weeks of the year in detail.
Use: 13-Week Cash Flow Forecast
Example (illustrative numbers): With monthly sales of EGP 1,080,000 and 60-day payment terms, about 2 × EGP 1,080,000 = EGP 2,160,000 sits in receivables at any time.
Stress-test it and agree a monthly review
Run a downside case (lower sales, slower collections) and decide in advance what you would cut or delay. Then compare budget against actual every month, by a fixed day, and act on the gaps.
Use: Monthly P&L Budget vs Actual
Example (illustrative numbers): If sales come in 15% below plan, monthly revenue drops from EGP 1,080,000 to EGP 918,000, a gap of EGP 162,000 a month.
The examples use round illustrative figures to show the method. Replace them with your own numbers.
Want a CFO to review your budget before the board sees it?
Book a free 30-minute call and we will go through your assumptions with you.
Book a free 30-minute consultation