Financial Modeling & Valuation
NIKE'S NEXT RUN
Integrated Three-Statement Model, FP&A, Scenario Analysis & Valuation
An integrated Excel model evaluating Nike's operating recovery scenario — linking FP&A forecasting, three-statement modeling, scenario and sensitivity analysis, DCF valuation, trading comparables, precedent transactions and investment appraisal.
Project Overview
NIKE'S NEXT RUN is a comprehensive integrated financial model built to evaluate an operating recovery scenario for Nike, Inc. Rather than treating forecasting, FP&A, scenario analysis and valuation as separate workstreams, the model connects them in one workbook with linked assumptions, integrated statements and executive-ready outputs.
Financial & Analytical Framework
FP&A & Forecasting
Driver-based FP&A forecasting covers revenue, gross margin, operating costs and earnings across a six-year horizon.
Integrated Three-Statement Modeling
The model links the income statement, balance sheet and cash flow statement through a circular calculation engine.
Scenario & Sensitivity Analysis
Scenario analysis is controlled through a master scenario selector and independent driver switches with full DCF sensitivity matrices.
Valuation
DCF, trading comparables and precedent transactions contribute to a football-field valuation summary.
Investment Appraisal
Project-level NPV, XIRR and structured recommendation framework support milestone-based funding decisions.
Technologies & Capabilities
Screenshots
