Skip to content
value.today

Macy's, Inc.: DCF model

A discounted-cash-flow model filled in from Macy's, Inc.'s filings as reported. Change any assumption; the values follow at once.

A tool for your own analysis, not investment advice. It does arithmetic on the figures the company filed and on assumptions you choose; it does not forecast, and the result is only as good as those assumptions. Every formula is on the methodology page.

Weighted 25/50/25USD 47.3596.5% above the price

Market price USD 24.10 on Oct 26, 2026: Closing price the SEC publishes with its fails-to-deliver data (M).

Assumptions: Base case

Change any figure; the values follow at once.

Revenue and margins

USD M

From the filings10-K filed Mar 27, 2026

Revenue growth%%

The years between change on a straight line.

From the filingsThe first year starts at Revenue growth a year from FY2022 to FY2025 (3 years): -3.85% a year; the years after are your assumption.

Operating margin%%

The years between change on a straight line.

From the filingsAverage operating margin, FY2023–FY2025: 3.26%; the years ahead are your assumption.

Tax and reinvestment

%

From the filingsIncome tax over income before tax, FY2023–FY2025

%

From the filingsAverage share of revenue, FY2023–FY2025

%

From the filingsAverage share of revenue, FY2023–FY2025

%

From the filingsAverage operating working capital (current assets less cash and short-term investments, less current liabilities other than debt) as a share of revenue, FY2023–FY2025

Discount rate

How the discount rate is set

Your assumption1.0 to start with

%

Your assumption5% to start with

Cost of equity5.15% + 1 × 5%10.15%
%

From the filingsInterest expense of FY2025 over its average debt

%

From the filingsDebt over debt plus market value on Oct 26, 2026

Discount rate (WACC)72.12% × 10.15% + 27.88% × 4.09% after tax8.46%

After the last year

How the value after the last year is worked out
%

Your assumptionImplies 9.9× the last year's EBITDA.

From value to shares (every case)

Balance sheet of Q2FY2026, Aug 1, 2026 · 10-Q filed Sep 10, 2026

USD M

From the filings

USD M

From the filings

USD M

From the filings

USD M

From the filings

USD M

Your assumption

The three cases

%
%
%

Base case: value per share

Discount rate 8.46%; long-run growth 2.50%. Values as at the end of FY2025.

From the business's value to the value per share
Present value of the 5 projected yearsUSD 3.6 B
Present value after the last year74% of the business's valueUSD 10.2 B
Enterprise value (the whole business)USD 13.8 B
Less debtUSD 2.4 B
Plus cash and short-term investmentsUSD 1.3 B
Equity value (the shareholders')USD 12.7 B
Divided by shares (millions)271.9
Value per shareUSD 46.57

Value per share

USD 46.57

93.3% above the price

Price USD 24.10 on Oct 26, 2026

Base case: year by year

Millions of USD. The FY2025 column is as reported; the years after are projected. Tax, capital spending and working capital are signed as they add to (+) or take from (−) free cash flow.

Projection year by year, in millions of USD
USD millionsFY2025reportedFY2026projectedFY2027projectedFY2028projectedFY2029projectedFY2030projected
Revenue22,62121,75021,25921,11421,30621,839
Growth-1.7%-3.9%-2.3%-0.7%0.9%2.5%
Operating income (EBIT)1,030709693688695712
Operating margin4.6%3.3%3.3%3.3%3.3%3.3%
Tax on operating income−165−162−161−162−166
Depreciation and amortisation894837818813820841
Capital spending−373−474−463−460−464−476
Change in working capital27154.4−5.9−16
Free cash flow to the firm1,021934901885883894
Discount factor0.92200.85010.78380.72260.6663
Present value861766694638596

Base case: sensitivity

How the value per share moves when one pair of figures changes and the rest stay as they are.

Discount rate and long-run growth

Value per share in USD; your figures in the outlined middle; green at or above the market price, red below it.

Value per share for discount rates (rows) and long-run growth rates (columns)
Discount rate ↓ · Long-run growth →1.5%2.0%2.5%3.0%3.5%
6.46%58.8264.671.8581.293.71
7.46%48.3252.1156.6762.2469.23
8.46%40.8443.4946.5850.2354.62
9.46%35.2437.1739.3841.9344.9
10.46%30.8932.3533.9935.8537.98

Revenue growth and operating margin

Value per share in USD; your figures in the outlined middle; green at or above the market price, red below it.

Value per share for changes to every year's revenue growth (rows) and operating margin (columns)
Growth, every year ↓ · Margin, every year →−4 pt−2 pt±0 pt+2 pt+4 pt
−4 pt6.1623.6739.4155.1570.89
−2 pt6.4325.6242.8860.1377.39
±0 pt6.6727.6946.5765.4684.35
+2 pt6.8929.8650.5171.1791.82
+4 pt7.0732.1654.7177.2699.81

Where the figures come from

The statements as reported, in millions of USD; hover a figure for its filing.

The fiscal years the model starts from, as reported, in millions of USD
USD millionsFY2025to Jan 31, 2026FY2024to Feb 1, 2025FY2023to Feb 3, 2024FY2022to Jan 28, 2023FY2021to Jan 29, 2022FY2020to Jan 30, 2021
Revenue22,62123,00623,86625,44925,39917,346
Growth-1.7%-3.6%-6.2%0.2%46.4%—
Operating income1,0309093011,6892,350−4,475
Operating margin4.6%4.0%1.3%6.6%9.3%-25.8%
Effective tax rate24.4%23.7%-4.7%22.4%23.4%—
D&A, % of revenue4.0%3.8%3.8%3.4%3.4%5.5%
Capital spending, % of revenue1.6%2.3%2.6%3.5%1.4%1.9%
Working capital, % of revenue4.1%2.8%2.2%0.5%-1.5%-2.3%
Free cash flow to the firm1,0219241747792,291—
Filing10-K10-K10-K10-K10-K10-K
  • From the filings: revenue, margins, tax rate, depreciation, capital spending and working capital (fiscal years above), debt, cash, leases and minority interests (balance sheet of Q2FY2026), and the share count (Q2FY2026).
  • Market data: US Treasury daily par yield curve, 10-year (Nov 13, 2026); Market price USD 24.10 on Oct 26, 2026: Closing price the SEC publishes with its fails-to-deliver data (M).
  • Your assumptions: the growth path and margins ahead, beta, the equity risk premium, long-run growth or the exit multiple, and the weights of the cases. How each figure is worked out: methodology.