Answer first: A 3-statement model links the income statement, balance sheet, and cash flow statement so that one set of assumptions flows through all three. Net income flows to retained earnings and cash; the balance sheet must balance - if it doesn't, the model is broken. Every startup founder seeking funding, every SME applying for a bank facility, and every CFO managing a board pack relies on this structure because it forces consistency: you cannot claim a profit on the income statement while bleeding cash without the statements revealing the disconnect.
Official context: UAE corporate tax context.
Who this is for
UAE founders, operators, CFOs, and finance teams preparing for hiring, fundraising, bank facilities, expansion, pricing, or cash runway decisions.
Key takeaways
- The Three Statements: What Each Shows.
- How the Three Statements Link.
- Building It in Order.
- UAE-Specific Lines That Other Models Miss.
UAE considerations
For UAE businesses, a useful model should reflect AED cash timing, VAT where relevant, corporate tax exposure, payroll and end-of-service obligations, licence and setup costs, and the funding or banking question being answered. Connect this guide to Finsera's financial modeling service and the finance growth engine guide so a Dubai startup, Abu Dhabi enterprise supplier, or Sharjah trading company can keep assumptions local to the decision.
Common questions
- What is a 3-statement financial model? A 3-statement financial model is a linked spreadsheet containing an income statement, balance sheet, and cash flow statement. All three are driven by the same set of assumptions so that changing one input updates every statement automatically. The balance sheet must balance - assets equal liabilities plus equity - confirming the model's mathematical integrity.
- Why do the three statements need to link? Linked statements enforce consistency. If revenue increases, the income statement shows higher profit, the balance sheet shows higher receivables (if on credit), and the cash flow statement shows the cash impact. Unlinked statements allow contradictions - a business cannot simultaneously claim rising profit and falling cash without the statements explaining why.
This article assumes you have built your revenue and cost assumptions. For the full five-layer build process, see our guide to building a UAE startup financial model.
The Three Statements: What Each Shows
| Statement | Core Question | Key Lines | Period |
|---|---|---|---|
| Income Statement (P&L) | Is the business profitable? | Revenue, COGS, gross profit, opex, EBITDA, tax, net income | Monthly / quarterly / annual |
| Balance Sheet | What does the company own and owe? | Assets, liabilities, equity; must balance | Snapshot at period end |
| Cash Flow Statement | Where did cash go? | Operating, investing, financing; ending cash balance | Matches P&L period |
The income statement measures performance over time. The balance sheet captures financial position at a single point. The cash flow statement explains the change in the cash balance between two balance sheet dates. All three are necessary - no single statement tells the full story.
A UAE business with AED 2 million in revenue, AED 1.4 million in costs, and a AED 375,000 tax threshold will show different pictures on each statement. The P&L might show AED 120,000 in net profit after the 9% corporate tax (on profit above AED 375,000). The balance sheet holds the gratuity liability and VAT payable that the P&L ignores. The cash flow statement captures the licence paid upfront and the customer invoice still outstanding.
How the Three Statements Link
The connections between the statements are formulaic, not optional. Break any link and the model is technically wrong - investors and bankers catch this in diligence.
Net income -> Retained earnings. Net income from the bottom of the income statement flows directly into retained earnings on the balance sheet (under equity). This is the primary link between profitability and financial position.
Depreciation -> Fixed assets. Depreciation expense on the income statement reduces the net book value of fixed assets on the balance sheet. Capex adds to fixed assets; depreciation reduces them.
Capex -> Cash flow and balance sheet. Capital expenditure appears as an outflow in the investing section of the cash flow statement and increases fixed assets on the balance sheet simultaneously.
Working capital -> Cash flow. Changes in receivables, payables, and inventory (or VAT payable) bridge net income to operating cash flow. An increase in receivables means revenue was recognised but cash not yet collected - this reduces operating cash flow relative to net income.
The cash plug. The cash flow statement's ending cash balance flows to the cash line on the balance sheet. If the balance sheet does not balance (Assets ≠ Liabilities + Equity), the error is usually in this link - a forgotten retained earnings entry, a miscoded working capital change, or a formula referencing the wrong period.
Building It in Order
Build the statements in this sequence every time. Skipping steps produces circular references and debugging nightmares.
- Income statement. Revenue, COGS, operating expenses, depreciation, interest, tax, net income. All driven by the assumptions tab.
- Balance sheet. Start with prior-period balances. Add net income to retained earnings. Add capex to fixed assets and depreciate. Accrue gratuity. Adjust receivables and payables for the period's activity. The cash line remains blank for now.
- Cash flow statement. Begin with net income. Add back depreciation and gratuity accrual (non-cash items). Capture working capital changes. Record capex and financing inflows/outflows. The result is ending cash.
- Balance the balance sheet. Transfer ending cash from the cash flow statement to the cash line on the balance sheet. Total assets must equal total liabilities plus equity. If they don't, trace backward through the links above.
A common error: building the cash flow statement before the balance sheet. You need the balance sheet's opening balances and period changes to construct the working capital section of the cash flow statement correctly.
UAE-Specific Lines That Other Models Miss
Three UAE accounting treatments must appear in a 3-statement model for a local business. Global templates omit them; UAE investors and auditors expect them.
VAT as Working Capital
VAT-registered businesses (mandatory at AED 375,000 in taxable supplies) collect 5% VAT on sales and reclaim VAT paid on purchases. The net VAT position sits on the balance sheet as a liability (if collectible > reclaimable) or an asset (if reclaimable > collectible). The cash flow statement captures the actual FTA remittance quarterly - often 30-60 days after the VAT period ends. This timing gap is a working capital item, not a P&L expense. Models that treat VAT as an expense double-count it and understate cash.
Gratuity Liability
Under UAE Labour Law Federal Decree-Law No. 33 of 2021, employees accrue end-of-service gratuity at 21 days' basic salary per year for the first five years, and 30 days per year thereafter. This accrues monthly on the balance sheet as a liability and hits the income statement as an expense - but it is a non-cash charge until the employee leaves. In the cash flow statement, add back the gratuity accrual to net income (like depreciation). A 15-person team with average basic salaries of AED 12,000 accrues roughly AED 37,800 annually in gratuity - material enough to affect runway calculations.
Corporate Tax Provision
Federal Decree-Law No. 47 of 2022 levies 9% corporate tax on taxable profit exceeding AED 375,000. The provision appears on the income statement, creating a liability on the balance sheet until paid within 9 months of financial year-end. For a December year-end, the cash outflow hits in September of the following year - model this lag in the cash flow statement. Small Business Relief (revenue ≤ AED 3 million for periods ending on or before 31 December 2026) allows a 0% election, but the model should still contain the provision logic for post-2026 periods.
How to Sanity-Check the Model Balances
Run these checks every time you change an assumption. A model that balances today can break tomorrow with one wrong cell reference.
Check 1: Balance sheet equality. Total assets must equal total liabilities plus equity in every period. A variance of even AED 0.01 indicates a formula error. Use Excel's ROUND function to avoid floating-point drift, but never use it to mask real errors.
Check 2: Cash reconciliation. The cash balance on the balance sheet must equal the ending cash on the cash flow statement. These are the same number referenced twice - if they differ, the link is broken.
Check 3: Directional logic. Increase revenue by 10%. Net income should rise. Receivables should rise (if you have payment terms). Cash from operations should rise but by less than the net income increase (due to the receivable buildup). If any line moves in the wrong direction, trace the formula.
Check 4: No hard-coded numbers in formulas. Every number in the body of the model should reference the assumptions tab. Hard-coded figures survive assumption changes and silently produce stale outputs. Use Ctrl+F to search for raw numbers in formula cells.
Check 5: Circular reference check. Enable Excel's iterative calculation only if your model intentionally uses circularity (e.g., interest calculated on average debt balance). Unintended circular references break scenario switching and slow calculation to a crawl.
Related Finsera guides
Decision checklist
- The Three Statements: What Each Shows
- How the Three Statements Link
- Building It in Order
- UAE-Specific Lines That Other Models Miss
