Corporate Finance • Equity Valuation • Integrated Modeling

Urban Outfitters (URBN) Integrated Financial Model & DCF Valuation

Developed an integrated financial model and discounted cash flow (DCF) valuation for Urban Outfitters (NASDAQ: URBN). The analysis included historical financial statement review, operating driver analysis, forecast assumption development, five-year financial projections, free cash flow modeling, and bear/base/bull valuation scenarios to estimate intrinsic equity value.

01 — Project overview

Determining intrinsic equity value through operating and valuation analysis

Built entirely in Excel, the model integrates historical financial statement analysis, operating driver forecasting, free cash flow projections, and discounted cash flow valuation methodologies. The objective was to assess Urban Outfitters' intrinsic value and evaluate the company's long-term earnings power, cash generation potential, and shareholder value creation.

02 — My approach

From historical analysis to forward-looking valuation

01Built and standardized historical Income Statement, Balance Sheet, and Cash Flow Statement analysis using Urban Outfitters' SEC filings.
02Evaluated profitability, liquidity, efficiency, and return metrics through ratio and KPI analysis to identify key operating trends.
03Developed forecast assumptions and operating drivers based on historical performance, management trends, and business fundamentals.
04Constructed a five-year integrated forecast model projecting revenue, margins, capital expenditures, working capital requirements, and free cash flow.
05Performed discounted cash flow valuation under bear, base, and bull case scenarios to estimate intrinsic enterprise value.
06Derived enterprise value, equity value, and implied share price across multiple valuation outcomes.
07Prepared an executive investment summary outlining valuation conclusions, supporting assumptions, key opportunities, and principal risks.

03 — Model outputs

KPI dashboard, forecast, and scenario valuation

URBN KPI dashboard — historical performance and operating metrics. — KPI Dashboard - Consolidated key performance indicators used to evaluate operating momentum, profitability, and financial health.

URBN forecast assumptions — operating drivers and growth inputs. — Forecast Assumptions - Core forecasting assumptions developed from historical trends and management performance.

URBN five-year forecast model — revenue, profitability, and free cash flow build. — Forecast Model - Integrated operating forecast translating business assumptions into projected earnings and free cash flow.

URBN valuation and scenario analysis — bear, base, and bull case DCF results. — Valuation & Scenario Analysis - bear, base, and bull case DCF outputs with implied share price. Intrinsic value assessment across multiple operating scenarios using discounted cash flow methodology.

04 — Tools & methodologies

Techniques used to build the model

01Microsoft Excel
02Financial Statement Analysis
03DCF Valuation
04Scenario Analysis
05Forecast Modeling
06Free Cash Flow Analysis
07Corporate Finance

Results & takeaways

Translating historical performance into investment conclusions

This project demonstrates end-to-end financial modeling capabilities, from historical statement analysis and operating driver evaluation to forecasting and valuation. Building the model also reinforced the relationship between the Income Statement, Balance Sheet, and Cash Flow Statement, illustrating how operating decisions ultimately impact free cash flow generation and intrinsic value.

Skills demonstrated

Financial Modeling
DCF Valuation
Financial Statement Analysis
Forecasting & Budgeting
Scenario Analysis
Equity Valuation
Excel
Corporate Finance
FP&A

Downloads

Supporting files for reviewers who want the underlying detail.

Download Excel Model

Related projects

← Back to Portfolio