Discounted Cash Flow (DCF) Analysis Levered

The Gap, Inc. (GPS)

$13.2

-0.21 (-1.57%)

All numbers are in Millions, Currency in USD

Stock DCF: 12.52 | 13.2 | overvalue

Free Cash Flow

Year A/P	2018 Actual	2019 Actual	2020 Actual	2021 Actual	2022 Actual	2023 Projected	2024 Projected	2025 Projected	2026 Projected	2027 Projected
Revenue	15,855	16,580	16,383	13,800	16,670	17,020.71	17,378.79	17,744.41	18,117.72	18,498.88
Revenue (%)
Operating Cash Flow	1,380	1,381	1,411	237	1,140.36	1,164.35	1,188.85	1,213.86	1,239.40	1,265.47
Operating Cash Flow (%)
Capital Expenditure	-731	-705	-1,045	-392	-753.56	-769.41	-785.60	-802.13	-819	-836.23
Capital Expenditure (%)
Free Cash Flow	649	676	366	-155	386.80	394.94	403.25	411.73	420.39	429.24

Weighted Average Cost Of Capital

Share price	$ 13.2
Beta	1.888
Diluted Shares Outstanding	383
Cost of Debt
Tax Rate	20.74
After-tax Cost of Debt	1.13%
Risk-Free Rate
Market Risk Premium
Cost of Equity	12.428
Total Debt	11,752
Total Equity	5,055.60
Total Capital	16,807.60
Debt Weighting	69.92
Equity Weighting	30.08
Wacc

Build Up Free Cash Flow

Year A/P	2018 Actual	2019 Actual	2020 Actual	2021 Actual	2022 Actual	2023 Projected	2024 Projected	2025 Projected	2026 Projected	2027 Projected
Revenue	15,855	16,580	16,383	13,800	16,670	17,020.71	17,378.79	17,744.41	18,117.72	18,498.88
Operating Cash Flow	1,380	1,381	1,411	237	1,140.36	1,164.35	1,188.85	1,213.86	1,239.40	1,265.47
Capital Expenditure	-731	-705	-1,045	-392	-753.56	-769.41	-785.60	-802.13	-819	-836.23
Free Cash Flow	649	676	366	-155	386.80	394.94	403.25	411.73	420.39	429.24
WACC
PV LFCF						345.79	337.76	329.92	322.26	314.78
SUM PV LFCF										1,803.44

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%)	4.53
Free cash flow (t + 1)	437.82
Terminal Value	17,305.24
Present Value of Terminal Value	13,866.69

Intrinsic Value

Enterprise Value	15,670.13
Net Debt	10,875
Equity Value	4,795.13
Shares Outstanding	383
Equity Value Per Share	12.52