ESG, AI Tools & Capstone Project

PART A — ESG-INTEGRATED VALUATION

18.1 Why ESG Matters for Valuation

ESG is not a separate "sustainability" overlay — it is a set of factors that directly affect the value drivers we have studied throughout this course. Environmental regulation changes future capex. Social license determines revenue growth. Governance quality affects the cost of capital. Ignoring ESG means ignoring risks and opportunities that are already priced into some securities and will inevitably be priced into all.

18.3 Integrating ESG into DCF Valuation

ESG factors enter the DCF through three channels: cash flows (revenue, margins, capex), discount rate (WACC), and terminal value (long-run growth). The framework below maps ESG risks to specific DCF adjustments:

import numpy as np
import pandas as pd

def esg_adjusted_dcf(base_fcff, base_wacc, base_terminal_g,
                      esg_scores, forecast_years=5):
    """
    Adjust a DCF valuation for ESG factors.

    Parameters
    ----------
    base_fcff : list — baseline FCFF for forecast years
    base_wacc : float — baseline WACC
    base_terminal_g : float — baseline terminal growth
    esg_scores : dict with keys:
        'environmental_score' : float — 0 to 100 (100 = best)
        'social_score' : float — 0 to 100
        'governance_score' : float — 0 to 100
        'carbon_intensity' : float — tCO2e / Rs. Cr revenue
        'attrition_rate' : float — annual employee attrition %
        'related_party_pct' : float — related-party transactions as % of revenue

    Returns
    -------
    dict with base and ESG-adjusted DCF values.
    """
    # --- ESG Score to Adjustments Mapping ---

    # 1. WACC Adjustment: Governance & Environmental risk
    # A company with governance score of 30/100 gets +150bp to Ke
    # A company with governance score of 90/100 gets +0bp
    governance_risk_premium = max(0, (75 - esg_scores['governance_score']) * 0.04)
    environmental_risk_premium = max(0, (60 - esg_scores['environmental_score']) * 0.03)
    esg_wacc_adj = (governance_risk_premium + environmental_risk_premium) / 100
    adjusted_wacc = base_wacc + esg_wacc_adj

    # 2. Cash Flow Adjustment: Environmental (carbon cost) & Social (attrition)
    carbon_cost_per_tonne = 10  # USD/tonne CO2e; India may introduce carbon pricing
    usd_inr = 83
    carbon_cost = (esg_scores['carbon_intensity'] * carbon_cost_per_tonne * usd_inr
                   / 1e7)  # Convert to Rs. Cr per Rs. Cr revenue

    # Attrition: high attrition → 2-5% margin impact from hiring/training costs
    attrition_impact = max(0, (esg_scores['attrition_rate'] - 15) * 0.001)

    adjusted_fcff = []
    for fcff in base_fcff:
        # Assume FCFF ≈ 15% of revenue; carbon cost as % of revenue
        adjusted_fcff.append(fcff * (1 - carbon_cost - attrition_impact))

    # 3. Terminal Growth Adjustment: Governance (sustainability of moat)
    gov_score = esg_scores['governance_score']
    if gov_score >= 80:
        tg_adj = 0  # Strong governance → no haircut
    elif gov_score >= 50:
        tg_adj = -0.005  # Moderate → -0.5%
    else:
        tg_adj = -0.015  # Weak → -1.5%

    adjusted_terminal_g = base_terminal_g + tg_adj

    # 4. Related-Party Transaction Haircut
    rpt_haircut = max(0, (esg_scores['related_party_pct'] - 5) * 0.01)
    adjusted_fcff = [f * (1 - rpt_haircut) for f in adjusted_fcff]

    # --- Recompute DCF ---
    n = len(adjusted_fcff)
    pv_base = sum(fcff / (1 + base_wacc) ** (t + 0.5) for t, fcff in enumerate(base_fcff, 1))
    tv_base = base_fcff[-1] * (1 + base_terminal_g) / (base_wacc - base_terminal_g)
    ev_base = pv_base + tv_base / (1 + base_wacc) ** n

    pv_adj = sum(fcff / (1 + adjusted_wacc) ** (t + 0.5) for t, fcff in enumerate(adjusted_fcff, 1))
    tv_adj = adjusted_fcff[-1] * (1 + adjusted_terminal_g) / (adjusted_wacc - adjusted_terminal_g)
    ev_adj = pv_adj + tv_adj / (1 + adjusted_wacc) ** n

    esg_discount = (1 - ev_adj / ev_base) * 100

    print(f"ESG-ADJUSTED DCF VALUATION")
    print(f"{'='*55}")
    print(f"  ESG Score: E={esg_scores['environmental_score']:.0f}  "
          f"S={esg_scores['social_score']:.0f}  "
          f"G={esg_scores['governance_score']:.0f}")
    print(f"\n  WACC Adjustment:           +{esg_wacc_adj*100:.1f}%")
    print(f"  Adjusted WACC:             {adjusted_wacc*100:.2f}%")
    print(f"  Terminal Growth Adj:       {tg_adj*100:+.0f}bp")
    print(f"  Carbon Cost Impact:        −{carbon_cost*100:.1f}% of FCFF")
    print(f"  RPT Haircut:               −{rpt_haircut*100:.1f}% of FCFF")
    print(f"\n  Base Enterprise Value:     Rs. {ev_base:,.0f} Cr")
    print(f"  ESG-Adjusted EV:           Rs. {ev_adj:,.0f} Cr")
    print(f"  ESG Discount/Premium:      {esg_discount:.1f}%")
    print(f"  {'⚠ ESG RISK — Value reduced' if esg_discount > 0 else '✓ ESG Strength — Value premium'}")

    return {
        'base_ev': ev_base, 'esg_ev': ev_adj,
        'esg_discount_pct': esg_discount,
        'adj_wacc': adjusted_wacc, 'adj_terminal_g': adjusted_terminal_g,
        'adj_fcff': adjusted_fcff,
    }


# --- Example: ESG-adjusted DCF for an Indian manufacturing company ---
esg_scores_example = {
    'environmental_score': 45,   # Below average — high emissions
    'social_score': 65,          # Average
    'governance_score': 55,      # Below average — related-party concerns
    'carbon_intensity': 120,     # 120 tCO2e / Cr revenue (high — steel/cement)
    'attrition_rate': 18,        # 18% annual attrition (moderate-high)
    'related_party_pct': 12,     # 12% of revenue is RPT (high)
}

base_fcff_example = [800, 920, 1050, 1180, 1300]  # Rs. Cr
esg_result = esg_adjusted_dcf(
    base_fcff_example, base_wacc=0.105, base_terminal_g=0.035,
    esg_scores=esg_scores_example
)

PART B — AI-POWERED VALUATION WITH CHATGPT

PART C — AUTOMATED VALUATION WORKFLOWS IN KNIME

PART D — CAPSTONE PROJECT

18.6 The Capstone Project: End-to-End Corporate Valuation

The capstone project is the culmination of this course. You will value a listed Indian company from scratch — applying every concept, tool, and framework from Chapters 1 through 18. This is the project you will showcase in interviews for investment banking, equity research, private equity, and corporate finance roles.

18.6.1 Capstone Deliverables Checklist

18.6.2 Suggested Capstone Companies

Choose one of these companies (or propose an alternative to your faculty):

18.7 Capstone Report Structure and Grading

18.7.1 Report Structure (8–12 pages)

18.7.2 Presentation Defence (12 minutes + Q&A)

18.8 Course Recap: The Valuation Toolkit

Over 18 chapters, you have built a complete corporate valuation toolkit. Here is what you now know how to do: