Financial Modelling

A fully linked model means the profit and loss statement, balance sheet, and cash flow statement are built as one integrated system rather than three separate calculations — change a revenue growth assumption and the effect flows automatically through gross profit, tax, net income, retained earnings, and the resulting cash balance, without a manual override breaking the chain anywhere. It matters because a reviewer will inevitably want to flex an assumption to test sensitivity, and a model that requires manual patching to stay consistent after that change cannot be trusted for the decision it is meant to support.

Under Federal Decree-Law No. 47 of 2022, taxable income up to AED 375,000 is taxed at 0% and income above that threshold at 9%, applied for financial years starting on or after 1 June 2023. For a Free Zone entity that qualifies as a Qualifying Free Zone Person, qualifying income can remain at 0% while non-qualifying income is taxed at the standard rate — so the model needs a genuine split between these income streams, not a single blended tax percentage applied to total projected profit, or the projected post-tax cash flow will be materially wrong.

End-of-service gratuity is a statutory liability under UAE labour law that builds progressively from an employee's first day of service, based on length of service and final salary — it is a real, growing balance-sheet obligation long before it is actually paid out on an employee's departure. A model that only recognises gratuity as a cash cost at the point of payment understates the liability building up on the balance sheet throughout the projection period and overstates retained profitability in the interim years.

The base case represents management's most likely, defensible set of assumptions; the upside case tests a realistic better-than-expected outcome (faster growth, better margin); the downside case tests a realistic worse-than-expected outcome (slower growth, margin compression, delayed break-even) and is often the case a lender or cautious investor cares about most. Beyond these three, additional scenarios add complexity without necessarily adding insight — PNPC typically builds a sensitivity table on the two or three highest-impact variables instead of proliferating discrete named scenarios beyond what the audience actually needs.

VAT under Federal Decree-Law No. 8 of 2017, at the standard 5% rate, is not a cost to the business in the way a purchase or expense is — it is collected on sales (output VAT) and reclaimed on eligible purchases (input VAT), with the net position settled with the Federal Tax Authority. This creates a working capital timing effect: VAT collected sits as a liability until remitted, and VAT paid on purchases sits as a receivable until reclaimed, which affects the cash flow statement and working capital schedule distinctly from the revenue and cost lines themselves. Mandatory VAT registration is also a modelled trigger point once projected taxable turnover crosses the AED 375,000 threshold for a growing venture not yet registered.

Yes, and this is a common transaction-support use case. The model projects the specific metric the consideration adjustment depends on — often normalised EBITDA, working capital, or net debt at a defined completion or earn-out measurement date — using the same normalisation methodology applied during due diligence, so the acquirer and seller are working from a consistent, pre-agreed calculation basis rather than disputing methodology after the fact.

For a standard transaction, fundraising, or feasibility model, 2 to 4 weeks from receipt of historical data and confirmed assumptions to final delivery is typical, depending on business complexity, entity count, and how quickly management confirms driver assumptions. Multi-entity consolidation models, or models requiring extensive iteration with investors or lenders during the build, take longer.

Fees are scoped and quoted based on model purpose, business complexity, entity count, and the level of documentation and stress-testing the intended audience requires — an internal board discussion and an institutional investor's own diligence team expect materially different depth. PNPC agrees a fixed or capped fee in writing at the engagement letter stage, after an initial scoping discussion, rather than open-ended time billing.

We build from a proven modelling architecture and structure, but every model is customised to the specific business's actual drivers, entity structure, and tax position rather than populated into a generic off-the-shelf template. A trading business's inventory and gross margin dynamics, a services business's utilisation and billing-rate dynamics, and a subscription business's churn and lifetime-value dynamics each require a genuinely different driver structure, not the same revenue-growth-percentage line dressed differently.

Circular references — most commonly where interest expense on a revolving facility depends on the cash balance, which in turn depends on interest expense already paid — are resolved deliberately using an iterative calculation setting or a circularity switch, and documented so a reviewer understands the mechanism rather than encountering an unexplained calculation loop. We do not leave circular references unresolved for Excel to silently calculate around, since this can produce unstable or incorrect results depending on calculation settings.

Yes. A model review engagement checks formula integrity (hard-coded overrides, broken links, unresolved circularity), tests whether the balance sheet genuinely balances across all projected periods, verifies UAE tax and payroll treatment is correctly applied, and assesses whether the underlying assumptions are sourced and defensible rather than simply plausible-looking. This is a common request from investors or acquirers who have received a model from a counterparty and want an independent check before relying on it.

At minimum, audited or management-prepared financial statements for the past three financial years, current management accounts and trial balance, and bank statements for recent operating periods to support revenue and cash verification. For a business without prior audited financials — common among UAE SMEs and free zone entities below the mandatory audit threshold — we work from management accounts with additional weight placed on bank statement and VAT return reconciliation to validate the historical baseline.

A debt-facility model is built to demonstrate debt service capacity — the debt service coverage ratio, covenant headroom under a downside scenario, and security coverage a UAE bank or lender's credit team will assess — with the downside case carrying particular weight, since lenders care most about the business's ability to service debt when things go wrong, not the upside. An equity-fundraising model instead emphasises growth trajectory, capital efficiency, and investor return metrics (IRR, MOIC, exit multiple sensitivity), since equity investors are underwriting upside potential in exchange for risk capital, not principal and interest repayment.

Yes, where relevant to the specific business. Beyond the Corporate Tax qualifying-income treatment for free zone entities, mainland and free zone structures can carry different licensing cost profiles, lease and Ejari cost assumptions, and — depending on the activity — different market-access considerations that affect the revenue build. Where a venture is genuinely choosing between mainland and free zone routes, PNPC can model both structures side by side as part of a feasibility engagement so the licensing decision is informed by the financial outcome, not made independently of it.

The model is the engine that feeds a valuation — a discounted cash flow valuation, for example, is built directly from the model's projected free cash flows and discount rate assumptions, while a comparable-multiple valuation applies a market multiple to the model's normalised earnings output. PNPC frequently delivers modelling and valuation together as one engagement, since a valuation built on an unlinked or unnormalised model inherits every weakness in that underlying model.

PNPC operates from Dubai, Abu Dhabi, Chennai, Bangalore, and Hyderabad, and builds consolidated models for groups spanning both jurisdictions as one coordinated engagement rather than two disconnected country models. This matters particularly for intercompany transactions, transfer pricing consistency between the UAE Corporate Tax regime and Indian tax treatment, and presenting a single, internally consistent group picture to investors or lenders who need to see the whole structure, not just one entity in isolation.

The assumptions memo documents every material driver in the model — revenue growth basis, margin assumptions, headcount and payroll build, capital expenditure plan, tax treatment, and working capital assumptions — together with its source: historical trend, management guidance, market benchmark, or a specific statutory rate. This lets a reviewer unfamiliar with the underlying file understand and, if needed, challenge each assumption directly, rather than treating the model's outputs as an unexplained black box.

Yes. For a first-time venture with no operating history, the model relies more heavily on market-benchmark assumptions, comparable business economics, and management's own bottom-up cost and revenue build, clearly flagged as forward-looking assumptions rather than historically validated figures. This is typically paired with a feasibility study, so the qualitative market assessment and the quantitative financial model inform each other rather than being built in isolation.

The model is delivered as a fully editable, unlocked file (typically Excel), so you and your team can update inputs and roll it forward yourselves once handed over. Where a business wants ongoing support — converting the model into a maintained rolling budget-to-actual tool, or updating it for each new financing round or planning cycle — PNPC can provide that as a follow-on engagement, but the base deliverable is not a locked black box you are dependent on us to open.

PNPC builds models on defensible, sourced assumptions rather than tuning them to reach a predetermined answer. If the outputs are lower than hoped, that is information the business needs before committing capital, approaching investors, or negotiating a deal price — not a reason to revise the model's assumptions until the answer changes. We discuss the drivers behind a disappointing output directly, since understanding why the number is what it is often matters more than the number itself.

A freelance modeller or template provider typically builds mechanically sound spreadsheets without the underlying UAE tax, payroll, and regulatory knowledge that determines whether the numbers themselves are correct — Corporate Tax qualifying-income treatment, VAT working capital timing, and statutory gratuity accrual are easy to get wrong without practising CA-level familiarity with UAE compliance. PNPC has practised as a Chartered Accountancy firm since 1986, with offices across Dubai, Abu Dhabi, and India, meaning the same team that builds your model also understands the tax filings, due diligence findings, and compliance obligations the model needs to reflect accurately — and can carry the engagement through into valuation, transaction support, or ongoing advisory without a handoff gap.