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.

A business plan is primarily a narrative document — market opportunity, strategy, team, competitive positioning — with financial projections typically included as one supporting section, often built to a level of detail proportionate to the plan's persuasive purpose. A financial model is the quantitative engine behind those projections: a fully linked, formula-driven three-statement build that a reader can stress-test by changing assumptions. PNPC frequently builds the model as the rigorous quantitative backbone that a business plan's financial section then summarises, rather than as two disconnected documents that happen to show similar numbers.

Scenario analysis tests a small number of complete, internally consistent sets of assumptions together — a base case, an upside case, a downside case — each representing a coherent story about how the business might perform. Sensitivity analysis instead isolates one or two individual variables and shows how the key output (valuation, DSCR, IRR) responds as that single variable moves, holding everything else constant, typically presented as a data table. PNPC builds both into a model: scenarios for the narrative discussion with a board or investor, and sensitivity tables to answer the specific 'what if' question a reviewer is most likely to ask.

To an extent. The UAE dirham has been pegged to the US dollar by the UAE Central Bank since 1997, which removes AED/USD exchange-rate risk from a model for a purely AED-denominated, UAE-only business — a meaningful simplification compared to modelling for a freely floating currency. It does not remove currency risk entirely: a UAE business that invoices in other GCC currencies, holds USD-denominated offshore debt priced against a different benchmark, or trades cross-border with India or Europe still needs an explicit, sourced FX assumption for those specific exposures.

UAE bank lending is commonly priced with reference to EIBOR (the Emirates Interbank Offered Rate) plus a margin, rather than a fixed rate, so a debt schedule for a facility priced this way needs a documented base-rate assumption plus the specific margin agreed or indicated by the lender, rather than a single static interest rate line. Where facility terms are not yet finalised, PNPC builds the debt schedule with the rate structure as an explicit, flagged assumption and stress-tests the downside case against a plausible rate increase, since debt service coverage is exactly the output a lender's credit team will pressure-test against a rising-rate scenario.

Yes, and this is common for a feasibility or fundraising model supporting the decision to incorporate in the first place. Licensing costs and the entity's projected tax position (mainland versus free zone, and whether Qualifying Free Zone Person conditions are realistically achievable given the intended activity) are built as forward-looking, clearly-flagged assumptions rather than confirmed figures, since there is no existing trade licence or FTA registration to reference yet. Once incorporation and registration are complete, the model is updated to reflect the actual licence terms and confirmed tax position.

For a group consolidation model, intercompany loans, management fees, and trading balances between group entities are tracked on a dedicated intercompany schedule and eliminated at the consolidated level, so the group's consolidated P&L and balance sheet reflect only transactions with genuinely external parties, while each entity's standalone statements retain the intercompany detail for entity-level reporting and tax purposes. Getting this elimination right matters for both the accuracy of the consolidated output and for transfer pricing consistency between the UAE Corporate Tax regime and any other jurisdiction the group operates in.

EBITDA (earnings before interest, tax, depreciation, and amortisation) is a profitability measure that excludes non-cash items and financing/tax effects, commonly used as a valuation and covenant benchmark. Cash flow reflects what actually moves through the bank account — EBITDA adjusted for working capital movements, capital expenditure, tax paid, and debt service — and is what determines whether the business can actually fund its operations, service debt, or make distributions. A model that reports strong EBITDA growth without a corresponding cash flow statement can mask a business that is profitable on paper but genuinely short of cash.

Where relevant to the business type — particularly trading, distribution, and manufacturing businesses — yes. Days sales outstanding, days payable outstanding, and days inventory outstanding are modelled explicitly and derived from historical trend data rather than assumed as a single working-capital percentage of revenue, since the cash conversion cycle drives the actual funding gap between paying suppliers and collecting from customers. This is one of the working capital movements that should be derived from the balance sheet build rather than layered on as a standalone assumption that can silently break reconciliation.

The historical baseline is converted to AED (or the model's chosen presentation currency) using a documented, consistent exchange-rate methodology, and the conversion basis is stated explicitly in the assumptions memo so a reviewer understands how the historical figures were derived. Going forward, projected figures for the non-UAE entity are built in their local currency and then converted, rather than projected directly in AED, since local cost inflation and pricing dynamics do not track UAE conditions.

PNPC's standard deliverable is built in Excel, since it remains the format most UAE banks, investors, and boards expect to receive, review, and be able to edit themselves without needing a specific proprietary platform. Where a client's own team works primarily in Google Sheets or another platform, the model can generally be adapted, though very large or heavily formula-linked models sometimes perform and audit more reliably in Excel's native environment. This is discussed and agreed at the scoping stage.

Each material version is dated and saved with a clear version reference, and a running log tracks what assumption changed between versions and why, so that if a negotiation reopens a point discussed several rounds earlier, both the current position and the reasoning behind an earlier version can be reconstructed rather than lost in an untracked chain of ad hoc edits. This discipline matters most in live negotiations, where multiple parties may be proposing different assumption changes over a short period.

Where instructed, PNPC converts the original model into a rolling budget-to-actual tracking tool, so each period's actual results are compared against the original base case, variances are identified, and the assumptions driving the forward projection are refreshed based on what has actually happened rather than left as a static file that becomes progressively less relevant. This is a distinct, ongoing engagement from the original model build, typically integrated with the business's monthly management reporting.

Yes, wherever audited or externally reviewed financials exist. The model's opening balance sheet and historical baseline should tie directly to the last set of audited figures, since a model that starts from an unreconciled or independently-derived opening position undermines confidence in every projected period built on top of it — a sophisticated reviewer will typically check this reconciliation early. Where a business has never had an audit (common among UAE SMEs below the mandatory audit threshold applicable to them), the historical baseline instead relies more heavily on bank statement and VAT return reconciliation as the best available independent verification.

The royalty or franchise fee structure — typically a percentage of gross revenue, a fixed fee, or a hybrid — is modelled against projected unit-level economics for each outlet or territory, so the franchisor and franchisee (or master licensee) can each see the underlying unit economics that support the fee structure, not just the aggregate royalty income. Where multiple territories or units are involved, the model rolls up individual unit projections into a consolidated royalty income forecast, with unit-level assumptions (footfall, average transaction value, occupancy cost) sourced and documented separately for each territory rather than applied uniformly.

Yes, where known — licensing and registration cost inputs are built into the model's opening capital expenditure and ongoing overhead lines as sourced figures where the client has already obtained quotes or fee schedules from the relevant DED or free zone authority, or as clearly flagged estimates pending confirmation where they have not. PNPC does not itself quote specific government licensing fees within the model, since these vary by authority, activity, and change over time — the model reflects the figures the client provides or that PNPC's business setup colleagues confirm directly with the relevant authority as part of a coordinated engagement.

Where a business is planning or has adopted an ESOP, the model incorporates the option pool's dilutive effect on the cap table and, for fundraising or exit scenarios, the effect on existing shareholders' and investors' fully-diluted ownership and return calculations. UAE free zones including ADGM and DIFC have their own frameworks for structuring equity incentive plans, and the model reflects the specific structure adopted (option pool size, vesting schedule assumptions) as sourced from the legal documentation governing the plan, rather than a generic assumption.

A covenant headroom schedule shows, period by period, how close the business's projected financial metrics (typically debt service coverage ratio, leverage ratio, or a minimum liquidity level) sit relative to the specific thresholds a lender's facility agreement requires the borrower to maintain, under both the base case and the downside scenario. Lenders use this to assess how much operational underperformance the business can absorb before breaching a covenant, which directly affects facility pricing, structure, and the lender's willingness to approve the facility at all.

Yes. This is modelled as a structural comparison — the projected tax position under each structure (including whether Qualifying Free Zone Person status would realistically be maintained or lost), licensing and renewal cost differences, and any change in market-access or activity-scope implications relevant to the specific business — so the financial impact of a restructuring decision is quantified rather than assessed only qualitatively. This is typically scoped as an extension of feasibility or restructuring advisory rather than a standalone model.

There is no fixed interval — refresh timing depends on how quickly actual results diverge from the base case, whether a material change in strategy, tax law, or financing terms occurs, and whether the model is feeding a live decision (an active fundraise or facility negotiation) versus sitting as a static planning reference. For a rolling budget-and-forecast model, monthly or quarterly refresh against actuals is typical. For a static transaction or feasibility model, refresh is usually triggered by a new financing round, a new acquisition, or a material change in circumstances, rather than run on a fixed calendar.

In our experience, it is rarely a calculation error — it is an assumption the model cannot defend when challenged, because it was never sourced or documented, or because the model was built to reach a predetermined answer rather than from defensible inputs. A technically flawless spreadsheet with an unsupported growth assumption fails the same way a poorly-linked model does: the reader stops trusting the output the moment one input cannot be explained. This is why PNPC treats the assumptions memo and the sourcing behind each driver as being at least as important as the mechanical build itself.