Automated DCF, WACC & LBO Schedules with Python Execution

import numpy as np

def calculate_dcf_valuation(
    ebit_projections: list[float],
    tax_rate: float,
    d_and_a: list[float],
    capex: list[float],
    nwc_change: list[float],
    wacc: float,
    terminal_growth_rate: float
) -> dict:
    years = len(ebit_projections)
    ufcf = []
    
    for i in range(years):
        nopat = ebit_projections[i] * (1 - tax_rate)
        fcf = nopat + d_and_a[i] - capex[i] - nwc_change[i]
        ufcf.append(fcf)
        
    discount_factors = [(1 + wacc) ** (t + 1) for t in range(years)]
    pv_fcf = [ufcf[t] / discount_factors[t] for t in range(years)]
    cumulative_pv_fcf = sum(pv_fcf)
    
    # Gordon Growth Terminal Value
    terminal_fcf = ufcf[-1] * (1 + terminal_growth_rate)
    terminal_value = terminal_fcf / (wacc - terminal_growth_rate)
    pv_terminal_value = terminal_value / discount_factors[-1]
    
    enterprise_value = cumulative_pv_fcf + pv_terminal_value
    
    return {
        "projected_ufcf": ufcf,
        "pv_fcf_sum": round(cumulative_pv_fcf, 2),
        "terminal_value": round(terminal_value, 2),
        "pv_terminal_value": round(pv_terminal_value, 2),
        "enterprise_value": round(enterprise_value, 2)
    }