Data Contract

This file documents the minimum data contract to run the valuation pipeline.

1) Mandatory Preliminary Input

Canonical file: data/preliminary-data/WALMART_FM/wmt_prelim_financials_fy2015_2025.csv
Recommended convention for new cutoffs: wmt_prelim_financials_<cutoff>.csv
Type: financial statement export in Bloomberg-like format (raw table).
Automatic validation: Rscript Code/00_Validate_Inputs.R

Compatibility:

The pipeline also recognizes legacy name Raw-Tabla 1.csv.

The validator requires, at minimum:

Year coverage (minimum 5 years)
Presence of key financial labels:
- Total revenues
- Operating income
- Consolidated net income attributable to Walmart
- Cash and cash equivalents
- Total current assets
- Total current liabilities
- Total assets
- Total Walmart shareholders' equity
- Net cash provided by operating activities
- Payments for property and equipment
- Dividends paid

2) Assumptions (optional, recommended)

Versioned template: config/assumptions.example.csv
Local override (not versioned): config/assumptions.csv
Latest cutoff config: config/latest_period_basis.csv (optional)
- latest_period_mode: auto, ltm, or fy_actual
- target_fiscal_year: target fiscal year to force cutover (e.g., 2026)

If config/assumptions.csv does not exist, conservative defaults are used.

3) `data/processed` Outputs

Validator:

validation_report.txt

Models:

preliminary_master_financials.csv
preliminary_data_basis.csv
preliminary_dcf_summary.csv
preliminary_dcf_forecast.csv
preliminary_rim_summary.csv
preliminary_rim_forecast.csv
preliminary_valuation_metrics_by_year.csv
preliminary_valuation_snapshot.csv
preliminary_multiples_summary.csv
preliminary_peer_comp_set_used.csv
preliminary_sotp_summary.csv
preliminary_sotp_breakdown.csv
preliminary_ddm_summary.csv
preliminary_ddm_forecast.csv
preliminary_bsm_summary.csv
preliminary_football_field_values.csv
preliminary_football_field.pdf
preliminary_valuation_charts.pdf

4) Recommended Flow

From the repo root:

make all

For step-by-step debugging:

make validate
make valuation
make charts
make tables
make moi