Budgeting and Financial Forecasting for Iranian Companies

Most budgets I am shown are attractive spreadsheets that nobody opens after the second month of the year. This article explains how to build a 12-month financial model that is defensible, easy to update, and genuinely useful for decisions once the year is under way.

Why budgets fail

Three causes repeat. The budget is built as "last year plus thirty per cent" with no underlying driver. Only the income statement is budgeted, so the plan shows profit while the company runs out of cash. And there is no monthly ritual comparing plan to actual, so variances surface only when the year is over.

Three layers of a healthy model

• Assumptions. Every manually entered number lives here: volume growth, wage inflation, exchange rate, collection days, headcount, tax rate.
• Calculations. No hard-coded figures inside formulas — everything references the assumption layer.
• Outputs. Income statement, cash flow, a summarised balance sheet, and a handful of key indicators.

The test I give clients is simple: if changing one assumption requires editing more than one cell, you do not have a model, you have a photograph.

Building the 12-month budget

1. Clean the base year. Pull current-year actuals by month and strip out one-off items.
2. Choose a revenue driver. Manufacturers: units or tonnes × price. Retail: transactions × average basket. Contractors: certifiable progress billings per project.
3. Add seasonality from historical data — Nowruz, summer and year-end patterns — not from intuition.
4. Budget cost of sales on volume, then apply purchase prices separately.
5. Split operating costs into fixed, variable and semi-variable.
6. Build payroll person by person, including start month, annual increase, statutory year-end benefits and the employer's insurance share.
7. Separate the capital expenditure budget and feed depreciation and prepayments back into the model.
8. Place tax and insurance payments in their due month, not as a smoothed average.
9. Model working capital through collection, payment and inventory day assumptions so cash builds itself.
10. Define three scenarios and stress the model.

Cost behaviour

Getting this split right makes the break-even point computable: fixed costs divided by contribution margin. Once a manager knows how many units per month cover fixed costs, pricing and discount decisions change immediately. For manufacturers, that calculation rests on a reliable product costing system.

Cash, not just profit

A budgeted profit means little until it is translated into a calendar of receipts and payments. The cash output should show a closing balance and financing requirement for every month. If month eight has a shortfall, the decision belongs in month two. The detailed method is in cash flow and working capital management.

Budget the tax burden properly

Companies routinely under-budget tax because they apply the rate to book profit. Model these separately:

• Corporate income tax at the 25 per cent rate under Article 105, applied to estimated taxable income.
• Likely disallowed expenses — undocumented items, payments outside official channels, costs unrelated to the business.
• Net VAT at the 10 per cent standard rate, output tax less recoverable input credit.
• Contract withholding tax deducted from your receipts, which affects cash timing.
• Employer social security contributions and possible assessment differences after a books inspection.

For current rates and thresholds, always check the latest circular from the tax administration. Legitimate ways to reduce the burden are discussed in legal tax planning.

Scenarios: three columns, not thirty

The conservative column exists to answer one question: at what point does the company need external financing, and how many months away is that point? That single answer justifies the whole exercise.

The monthly control ritual

By the fifteenth of the following month, hold a one-hour meeting: compare actual to budget at revenue, gross margin, operating cost and cash levels; split each variance into volume and price effects; refresh the forecast for remaining months; and record three corrective actions with an owner and a deadline. The indicators worth reviewing are listed in 12 financial KPIs for CEOs.

If you would like help building your budget model from scratch or simplifying the one you already have, I am available to work through it with you.

Key takeaways

• Without a separate assumption layer, a budget loses credibility at the first change in conditions.
• Budget volumes and keep prices apart so the model survives inflation.
• Budgeted profit without a cash plan gives an incomplete picture of the year.
• Budget tax on estimated taxable income, including likely disallowed costs, in the correct month.
• With no monthly variance meeting, a budget is just an archived file.