THE ESG INSTITUTECapstone online workbookDIPLOMA IN SAUDI CORPORATE SUSTAINABILITY · MODULE 8The Saudi ESG Compliance and Disclosure PackRecord your obligations, materiality scores, risks, metrics, targets, disclosure index, roadmap and self-review. The workbook calculates as you type. Write your analysis in the dossier template and attach the calculation report as an appendix.Saved in this browserNot saved yetThis browser is not saving your entries. They stay in this tab only. Export saved progress before you close the page.Another tab saved this workbook. Saving in this tab is paused to protect both versions. Export this tab's progress, then reload the page to continue with the saved version.Reload saved versionDownloadsLoad the Hadeel Valley starting dataExport saved progressImport saved progressThis replaces every entry in the workbook. Export saved progress first if you want to keep the current entries.Loading the Hadeel Valley starting data replaces your Profile, emission sources, metric inputs and evidence references, target T1, the budget ceiling, the financing fields, the loan KPIs and the three draft statements with the case figures (HV01 to HV08). Your obligations, scores, risks, index, roadmap actions and self-review stay as they are.CancelContinueCloseHadeel Valley starting data loaded. Check each figure against the case evidence pack, rate the data quality of each metric, and build your own register, scores, risks, targets, index and roadmap.Saved progress imported.This file could not be imported. Choose a JSON file exported from this workbook.Add a rowRemove this rowRemove this row and its entries?This sheet has reached its maximum number of rows. Use a dossier appendix for further rows.Not availableIncompleteSelectEnter a number in your selected number format, or leave the cell blank.Enter zero or a positive number.Enter a whole number from 1 to 5.Enter a four-digit year from 1990 to 2100.Enter a whole month number from 1 to 24.Some numbers need correcting before you download. Look for the messages marked with an exclamation mark.Input cell: you type hereCalculated: the workbook fills thisWorkbook sheetsGuideProfileObligationsMaterialityRisk RegisterMetricsTargetsDisclosure IndexRoadmapSelf ReviewRoute 3 ExampleDownloadsCalculation ReportStage 1: Organisation profile, boundary and obligations mapStage 2: Materiality and stakeholdersStage 3: Compliance gap and risk assessmentStage 4: Metrics, baseline and targetsStage 5: Disclosure and assurance readinessStage 6: Roadmap, governance, finance and reflectionSupported self-reviewHow the workbook fits the capstone. Work through the sheets in stage order and keep the dossier open beside it.Identify your organisation, reporting boundary and base year. Revenue and headcounts feed the intensity, Saudisation and women-in-workforce calculations.Register at least 12 applicable obligations. Give each one its instrument, issuer, status, owner and evidence. Status follows the course distinction: binding law or regulation, supervisory expectation, voluntary guideline or standard, and proposal or consultation.Score each topic on impact and financial materiality. Severity is the average of scale, scope and irremediable character. A topic is material when either score reaches 12 of 25, or when it is a potential human rights impact with severity of 4 or more.Record each compliance gap or risk once, with its obligation, inherent and residual scores (likelihood × impact, each 1 to 5), owner, actions and evidence.Enter activity data and emission factors for each source. Emissions = activity × factor ÷ unit divisor. Scope 2 is location-based. Rate the data quality of every metric.Set each target and its linear annual trajectory from the base year to the target year. Change is entered as a percentage of the base value, for example -25 for a 25% cut.Map material topics to Saudi Exchange key issues, GRI disclosures and IFRS S2 paragraphs. Complete the assurance readiness checklist and test three public statements.Plan 24 months of actions with owners, months and budgets. Record the financing option, its KPIs and targets, and the governance arrangements.Rate your dossier against the eight rubric criteria. Support each rating with a reference and a reason.Hadeel Valley Foods Company is the supplied fictional case for route 3. The values below are calculated live from the case figures. Use the case evidence pack (records HV01 to HV08) for the full facts.Prepare your submission files. Check the download headings first if you use the page in another language.Choose your route: 1 your own organisation, 2 a real Saudi-listed or Saudi-operating organisation with enough public evidence, or 3 the supplied Hadeel Valley Foods case. For route 3, select Load the Hadeel Valley starting data.Work through the sheets in stage order. Each sheet names the dossier stage it supports.Leave a number blank when the information is not available. Enter 0 only for a measured zero. Blank values show as Not available, count in the data quality summary and are never treated as zero.Choose your number format in Profile. You can type Arabic-Indic digits, and a comma or a point as the decimal mark.Pale gold cells are inputs. Pale blue cells calculate. In the Excel file, do not type over the pale blue cells.Your work is saved in this browser on this device. Export saved progress (JSON) before you change device or clear browser data, and import it to continue.Submit two files in Teachable: your dossier as one PDF with the calculation report as Appendix A, and the editable Excel workbook.The workbook does the arithmetic. It does not judge your analysis, your evidence or your prose. Check your reasoning against the rubric and review guide.Colour keyMissing or zeroSheets and stagesStudent nameRouteRoute 1: own organisationRoute 2: real organisation (public evidence)Route 3: Hadeel Valley Foods (supplied case)OrganisationSector and main activitiesListing status and marketSites in the reporting boundaryReporting boundary and consolidation approachBase year (reporting year)CurrencyTarget yearRevenue in the base year (SAR million)Employees (headcount)Saudi nationals (headcount)Women employees (headcount)Contractor workers (approximate number)Number format1,234.5 (decimal point)1.234,5 (decimal comma)1 234,5 (space and decimal comma)Arabic-Indic digits ١٬٢٣٤٫٥Layout directionFollow the pageLeft to rightRight to leftVersion and dateWorkbook settingsFieldEntryIDInstrument and provisionIssuerDate or version relied onStatusBindingSupervisoryVoluntaryProposalWhy it applies (trigger)OwnerEvidence heldNext review dateRow checkCompleteComplete rowsComplete rows excluding proposalsAt least 12 complete applicable obligationsProposals and consultations belong on the watch list. They are counted separately and not in the 12 applicable obligations.YesNoSummaryBinding: law or regulation that applies to you. Supervisory: a regulator's stated expectation. Voluntary: a guideline or standard you choose to follow. Proposal: a draft or consultation.TopicStakeholders raising itScale (1 to 5)Scope (1 to 5)Irremediable character (1 to 5)Severity (average)Actual impact?Likelihood of a potential impact (1 to 5)Impact score (of 25)Financial magnitude (1 to 5)Financial likelihood (1 to 5)Financial score (of 25)Potential human rights impact?ResultMaterialBelow thresholdScored by, evidence and reasonMaterial topicsTopics below thresholdImpact score = severity × likelihood (5 for an actual impact). Financial score = magnitude × likelihood. Material if either score is 12 or more, or a potential human rights impact has severity of 4 or more.Risk or gap statement (cause, event, consequence)AreaEnvironmentalLabour and human rightsGovernanceDisclosureLinked obligation or topic IDInherent likelihood (1 to 5)Inherent impact (1 to 5)Inherent scoreInherent ratingControls and actions, with datesResidual likelihood (1 to 5)Residual impact (1 to 5)Residual scoreResidual ratingDue dateHighMediumLowCheckResidual above inherentHigh inherent risksHigh residual risksRisks by areaScore = likelihood × impact. Rating bands: High 15 to 25, Medium 8 to 14, Low 1 to 7.GHG baseline by sourceEmission sourceScope (1 or 2)SiteActivity amountActivity unitEmission factorFactor unitUnit divisor (1000 for kg factors, 1 for t factors)Factor source and statusEmissions (tCO2e)Data quality (A to D)ABCDEvidence refData quality summaryRated ARated BRated CRated DMetrics with no value (not available)Not available: rate DAdd a ratingValue entered: D means not availableA: measured and reconciled to a source record, with evidence held. B: measured, but with partial coverage or not yet reconciled. C: estimated with a stated method and assumptions. D: not available; leave the value blank and plan how to capture it.Metrics and data qualityMetricInput AInput BResultUnitCalculationScope 1 emissionsScope 2 emissions (location-based)Scope 1 and 2 emissionsGHG intensity (Scope 1 and 2 per SAR million revenue)Water withdrawalGroundwater share of withdrawalWaste generatedWaste diversion rateEmployee LTIFRContractor LTIFRSaudisation rate (headcount)Women in the workforceNitaqat counted Saudisation rateCounted Saudis needed at the band requirementGap in counted SaudisGroundwater withdrawal against licensed volumeMetric inputsWater withdrawal (m3)Groundwater withdrawal (m3)Waste generated (t)Waste diverted from disposal (t)Employee lost-time injuriesEmployee hours workedContractor lost-time injuriesContractor hours workedSaudis counted under NitaqatNitaqat band requirement (%)Licensed groundwater volume (m3 a year)Sum of Scope 1 rows; blank if any Scope 1 row is incompleteSum of Scope 2 rows; blank if any Scope 2 row is incompleteScope 1 + Scope 2Scope 1 and 2 ÷ revenue (SAR million)Total withdrawalGroundwater ÷ total withdrawalTotal wasteDiverted ÷ generatedLost-time injuries × 1,000,000 ÷ hours workedSaudi nationals ÷ employees (Profile)Women ÷ employees (Profile)Counted Saudis ÷ employeesRequirement (%) × employees ÷ 100, rounded upCounted Saudis needed − counted SaudisGroundwater withdrawal ÷ licensed volumecounted Saudis% of licensed volumeActivity × factor ÷ unit divisorSource rows with missing inputstCO2etCO2e per SAR millionm3%tper million hoursMetricBase value sourceEnter manuallyScope 1 and 2 emissions (Metrics)Scope 1 emissions (Metrics)Scope 2 emissions (Metrics)GHG intensity (Metrics)Water withdrawal (Metrics)Employee LTIFR (Metrics)Base yearBase valueTarget yearChange by the target year (%)Target value entered directlyTarget value usedAnnual linear changeLinear trajectoryLeave a base year or target year blank to use the Profile years. Enter percentage metrics in percentage points, for example 34.9.Scope 1 and 2 emissions (absolute)Linked base values and default years are formulas. Type over them to enter your own value.Refrigerated trucksGroundwater withdrawal (Qassim)Municipal water (Jeddah)Plastic packaging wasteEU dates exports (SAR million a year)Sustainability-linked loan offered (SAR million)Diesel totalTarget reduction (%)Target value in the target yearSheetStageWhat to recordStudentExportedMaterial topic (ID and name)Saudi Exchange key issueGRI disclosureIFRS S2 paragraphWhere disclosed (dossier section or page)ReadyPartialGapNot applicableAssurance scopeIn scopeOut of scopeNotes and ownerReporting indexReady share of applicable rowsRows with a statusAssurance readiness checklistCheckPartlyAction and ownerReporting boundary and consolidation approach documentedBase year and recalculation policy setEmission factors sourced, dated and version-controlledActivity data reconciled to invoices, meters or payrollWritten definition for every metric in assurance scopeData owner and reviewer named for every metricEvidence files retained and indexedInternal review or internal audit dry run completedAssurance provider independence checked (IESSA)Approval route for the report agreed with the board or committeeChecks answeredReadiness scoreYes = 1, Partly = 0.5, No = 0, divided by 10. Shown when all ten checks are answered.Claims checkPublic statement (quoted exactly)Source and dateEvidence heldProblemLegal and reputational riskVerdictSupportedNeeds qualificationUnsupportedCorrected wordingActionWorkstreamEnvironmentPeople and supply chainGovernanceDisclosure and assuranceData and systemsFinanceStart month (1 to 24)End month (1 to 24)Year 1 budget (SAR)Year 2 budget (SAR)Total budget (SAR)DependencyGap or risk ID closedMilestone that shows it is doneTimeline by quarter24-month roadmapTotalsYear 1 total (SAR)Year 2 total (SAR)24-month total (SAR)Rows with budget missingBudget ceiling for 24 months (SAR)Headroom under the ceiling (SAR)End before startDates missingMetFinancing optionInstrument typeLender, arranger or investorsAmount (SAR million)Tenor (years)Margin adjustment per KPI (basis points)Annual margin effect per KPI (SAR million)Maximum annual margin effect, all KPIs (SAR million)Use of proceeds or general corporate purposeExternal review or verificationKPIs and sustainability performance targets (SPTs)KPI IDKPIBaseline valueBaseline yearSPT 1SPT 1 yearSPT 2SPT 2 yearSPT 3SPT 3 yearUnitVerificationGovernanceBoard committee responsibleCommittee chair and independenceMeetings a yearManagement leadBoard reporting frequency and contentCriterionWeightYour rating (0 to 4)Evidence reference (dossier section or workbook cell)Reason for ratingWeighted pointsGate (at least 2 of 4)MetBelow 2Not metObligations map and status accuracyMaterialityCompliance gaps and risk registerMetrics, calculations and targetsDisclosure index and claims integrityRoadmap, governance and financeEvidence, referencing and data qualityPresentation and reflectionTotal points (of 100)Criteria 1 to 6 all rated at least 2 of 4Material unresolved issuePoints benchmark (60 of 100)Benchmark statusResolve the material issueComplete the reviewSelf-review benchmark metRevise and review againReview notes and significant revisionsBenchmark: 60 of 100 weighted points, at least 2 of 4 on each of criteria 1 to 6, and no material unresolved submission issue. Points count only when a rating has an evidence reference and a reason. Points = rating ÷ 4 × weight.Add a reference and a reasonCase figures (FY2025)Calculated valuesLive issuesExpected valueMatchesHadeel Valley Foods case (fictional). Emission factors and thresholds marked as supplied for the exercise apply only to this case. Source: case evidence pack HV01 to HV08.Site splitsMilestones from rounded inputs (96,708 and 72,531), as in the review guideMilestones from unrounded inputs (workbook formulas)Jeddah wastewater inspection (case permit limits)ParameterCase limitSample resultTimes the limitNitaqat (case assumptions)Current band requirement (case assumption)Expected requirement in 2027 (case assumption)Sustainability-linked loan (HV07b)Board budget ceiling, 24 months (SAR)Value of the margin adjustment per KPI (SAR a year)Capstone calculation reportAppendix A to the capstone dossier, generated from the online workbook. Figures shown as Not available were left blank and are not counted as zero.Report preparedPrint or save as PDFItemValueFormulaWorkbook cellCheck download languageThe Excel file and the report use these headings. If you translated this page, the headings follow the translation. Edit any heading directly, then confirm.Use these headingsReset to page textDownload headings confirmed. Downloads use your latest entries.Download editable Excel workbookOpen report to print or save as PDFSave report as HTML fileBack up or move your workYour browser blocked the report window. Select Save report as HTML file, open the file and print it.Your file is prepared. If it did not download automatically, select the link.Save prepared fileSubmit your dossier PDF (with this report as Appendix A) and the Excel workbook in the two upload fields in Teachable.GuideHow to use this workbookExported from the ESGI online capstone workbook. Formulas recalculate when inputs change.Offline Excel template for the DSCS capstone. Type only in the pale gold cells; the pale blue cells calculate. The online workbook offers the same sheets with translated headings.Values at the time of export, with the formula and cell for each result.Hadeel Valley Foods Company
Assess, navigate and measure sustainability performance in minutes. Explore published reports and curated films, articles and courses, then read the analysis behind the rules. Everything here is free to use.
Not sure where to start?
Describe your challenge and Terra points you to the right tool or programme.