Executive Financial Integrated Dashboard

Board Executive Overview

Consolidated Group Performance · Actual vs Budget · IFRS Compliant

All Divisions

🐓 Poultry

🍖 Food

🌾 Agriculture

🏭 Industry

Income Statement — Actual vs Budget

Total Revenue

—

Budget: —

Calculating

Gross Profit

—

Margin: —

—

EBITDA

—

Margin: —

—

EBIT

—

Margin: —

—

Net Profit

—

Margin: —

—

Economic Value Added (EVA)

—

NOPAT − (WACC × IC)

—

Balance Sheet & Financial Solvency

Total Assets

—

Shareholders' Equity

—

Working Capital

—

Current Assets − Current Liabilities

—

Current Ratio

—

Minimum: 1.5x

—

Quick Ratio

—

Minimum: 1.0x

—

Net Debt / EBITDA

—

Covenant: ≤3.5x

—

Returns, Efficiency & Working Capital Cycle

Return on Equity (ROE)

—

Target: ≥13%

—

Return on Invested Capital (ROIC)

—

WACC: 8.2%

—

Days Sales Outstanding (DSO)

—

Target: ≤45 days

—

Days Inventory Outstanding (DIO)

—

Target: ≤60 days

—

Days Payable Outstanding (DPO)

—

Target: ≥50 days

—

Cash Conversion Cycle (CCC)

—

Target: ≤50 days

—

Revenue vs Budget — Monthly TrendActual × Budget × Forecast

Actual Budget Forecast

Revenue Mix by Division4 Sectors

Profit Bridge — Budget vs ActualWaterfall

Key Margins — Rolling 12MTrend

Gross EBITDA Net

KPI Performance Radarvs Target

P&L Summary — IFRS Format

Line Item	Actual	Budget	Var%
Upload trial balance to generate P&L

Capital Structure

Key Ratios — Quick Scorecard

Profit & Loss Dashboard

Income Statement · IFRS 15 · Actual vs Budget vs Forecast

Revenue

—

Gross Profit

—

EBITDA

—

EBIT

—

Net Profit

—

Cost of Sales (COGS)

—

Income Statement — IAS 1 Comparative Format

Line Item (IFRS)	Actual	Budget	Var%
Upload trial balance data

Margin Analysis — Actual vs Target

Revenue & Profit by Division

Expense Analysis

Cost Structure · Cost Center Variance · Contribution Analysis

Total Cost of Sales

—

Raw Materials

—

Manufacturing Overhead

—

Operating Expenses

—

Depreciation & Amortization

—

Finance Costs

—

Monthly Cost Structure — Stacked

Raw Materials Manufacturing OpEx Finance

Cost Contribution as % of Revenue

Raw Materials—

Manufacturing—

Operating Expenses—

Depreciation & Amortization—

Finance Costs—

Net Profit—

Statement of Financial Position

IAS 1 · Consolidated · Capital Structure & Liquidity Analysis

Total Assets

—

Total Liabilities

—

Shareholders' Equity

—

Working Capital

—

Net Debt

—

Debt / Equity Ratio

—

Limit: ≤2.0x

—

Balance Sheet — IAS 1 Format

Line Item	Current	Prior	Δ%
Upload data to view balance sheet

Capital Structure

Liquidity Ratio Trend

Cash Flow & Liquidity

IAS 7 · Direct Method · Cash Burn Analysis · Runway

Operating Cash Flow

—

Investing Cash Flow

—

Financing Cash Flow

—

Free Cash Flow (FCF)

—

Cash Balance

—

Burn Rate / Cash Runway

—

Statement of Cash Flows — IAS 7

Category	Amount
Upload data to view cash flows

Cash Flow Waterfall

Operations & Capital Projects

OEE · Production Efficiency · CAPEX Control · Project ROI

87.4%

Overall Equipment Effectiveness (OEE)

↑ Above target 85%

74.2%

Asset Utilization Rate

Target: 80%

—

YTD Capital Expenditure

—

91.8%

Production Efficiency

↑ Sadat Plant

18

Active Capital Projects

Total: EGP 1.82B

68.3%

Average Project Completion

On schedule

CAPEX vs Budget by Division

Major Project Progress — Burn-down

Feed Mill Expansion — Sadat78%

Production Line 4 — K5462%

Cold Storage — Nubaria91%

Solar Power Plant — Toshka45%

Hatchery Upgrade — Wadi El Natrun33%

Risk Dashboard — Early Warning System

Risk Matrix · KPI Monitoring · Critical Alerts · COSO Framework

● Critical Risks: —

Critical Risks

—

Require immediate action

High Risks

—

Close monitoring required

Medium Risks

—

Under observation

Low Risks

—

Effectively managed

KPI Breaches

—

Threshold violations

Budget Overruns

—

Risk Heatmap — Likelihood × Impact

← Increasing Likelihood →

Market Volatility

Debt Covenant

Feed Costs

FX Risk

Supply Chain

Legal Risk

Budget Overrun

Cash Flow

Margin Decline

CAPEX Delay

Audit Risk

Tax Risk

Production Halt

Labor Dispute

Customer Default

Cyber Risk

Regulatory Change

ESG Risk

Energy Costs

Inflation Risk

Weather

Crop Pests

Export Risk

Logistics

Pricing Risk

Critical High Medium Low

Early Warning Alerts

!

Net Debt / EBITDA Covenant Breach Risk

Upload data to calculate vs 3.5x bank covenant limit

▲

Feed Cost Pressure — Poultry Division

Rising feed costs compressing gross profit margin

▲

USD/EGP Exchange Rate Volatility

USD payables exposure — hedge ratio review required

i

Receivables Concentration Risk

ECL review under IFRS 9 required — top 3 clients = 38% of AR

Risk Score Trend by Category

KPI Breach Radar

Data Input Trial Balance

Trial Balance years current Budget .

years current (Actual)

📊

xlsx / csv

required: Account Code – Account Name – Balance

Budget File (Budget)

📋

xlsx / csv

required: Account Code – Account Name – Balance

Account Code	Account Name	Account Name (EN)	years current	Budget

financial ( classification automatic)

Trial Balance – comparative

Account Code	Account Name	years current	Budget	Variance ()	Variance (%)	classification
No . income .

Executive Summary

performance financial executives board management.

Income Statement

—

Balance Sheet

—

Cash Flows Risk

—

financial

— / 100

Upload data

– chairman/CEO

Variance: Actual Budget

	Actual	Budget	Variance	Variance	Status
No .

IFRS – standards reports financial

standards – liquidity profitability financial efficiency valuation flow .

			Benchmark	Company	value Actual	Variance Risk

CMA – financial and markets

disclosure governance share financial (CMA – / / UAE).

			Benchmark	Company	value Actual	Variance Risk

FPRS – reports financial control

internal COSO – Variance No.

	/	COSO		Company	value calculated	Risk

charts interactive

No executive.

Revenue Budget

expenses

liquidity

profitability standards

No – Variance

financial No ()

CMA – share

FPRS – Risk

CFO Report executive No

strategy board management indicators financial calculated.

CFO Report executive

performance financial

—

🧠

" Analysis " CFO Report .

System Architecture

Star Schema · IFRS COA · Hierarchical Coding · Technical Reference

Fact Tables — 11 Core Tables

#	Fact Table	Primary Keys	Grain
1	Fact_GL_Transactions	CompanyID · LocationID · AcctID	Transaction
2	Fact_Budget	CompanyID · AcctID · PeriodID	Monthly
3	Fact_Forecast	CompanyID · ScenarioID	Rolling
4	Fact_CashFlow	CompanyID · CFCategoryID	Daily
5	Fact_CAPEX	ProjectID · AssetID	Project
6	Fact_Projects	ProjectID · MilestoneID	Milestone
7	Fact_Operations	LocationID · ProductionID	Shift
8	Fact_Inventory	InventoryID · LocationID	Daily
9	Fact_Sales	ClientID · ItemID · SaleDate	Invoice
10	Fact_Ratios	CompanyID · RatioID	Monthly
11	Fact_RiskIndicators	RiskID · CompanyID	Weekly

Dimension Tables — 15 Dimensions

#	Dimension	Key Attributes
1	Dim_Companies	Code · Division · Name · Description
2	Dim_Locations	Code · Group · Name
3	Dim_SubAccounts	Code · Group · Name
4	Dim_CostCenters	Code · Group · Name
5	Dim_Productions	Code · Group · Name
6	Dim_Projects	Code · Group · Status
7	Dim_Resources	Code · Group · Type
8	Dim_SalesItems	Code · Master · Category
9	Dim_Clients	Code · Category · Country
10	Dim_Inventory	Code · Category · UOM
11	Dim_Calendar	Year · Quarter · Month · Week
12	Dim_IFRS_Statement	StatementType · L1–L7
13	Dim_Risk	Category · Level · Owner
14	Dim_KPI	Name · Formula · Threshold
15	Dim_Sector	Poultry · Food · Agriculture · Industry

Chart of Accounts — 7-Level IFRS Hierarchy

▶1ASSETSL1 – Statement

▶2LIABILITIESL1

▶3EQUITYL1

4REVENUE — IFRS 15L1

5COST OF SALESL1

6OPERATING EXPENSESL1

7FINANCE INCOME / COSTSL1

8CASH FLOWS — IAS 7L1

9CAPITAL EXPENDITUREL1

Example: 1-1000-1100-1110-111001 = Assets / Current / Cash / Banks / NBE Main Account

IFRS Standards Applied

IAS 1

Presentation of Financial Statements

IAS 2

Inventories

IAS 7

Statement of Cash Flows

IAS 16

Property, Plant & Equipment

IAS 36

Impairment of Assets

IAS 38

Intangible Assets

IFRS 9

Financial Instruments & ECL

IFRS 15

Revenue from Contracts

IFRS 16

Leases & ROU Assets

IFRS 10

Consolidated Financial Statements