A worked DCF of Insulet

Built from the company's annual filing for the fiscal year ended 31 December 2025, with market inputs as of 4 November 2026. Every figure below carries a tag saying where it came from, and every result is computed by the same engine as the VALUATIO terminal. A worked example of the method, not a view on the stock.

Open this model in the terminalFree account. Change any input and every figure moves with it.

What went in

Every input the model uses is here. The tag beside each one says where it came from, so you can tell a number Insulet filed from one this page assumed.

Filed by INSULET CORPORATION, CIK 0001145197, for the year ended 31 December 2025. Check any SEC figure against the filing on SEC EDGAR.

Inputs to the Insulet valuation, with their sources
The business
Revenue, filed year$2,708mSEC
Revenue growth, years one to five25.0%, 19.5%, 14.0%, 8.5%, 3.0%EST
EBITDA margin20.8%SEC
Depreciation and amortisation, share of revenue3.3%SEC
Capital spending, share of revenue7.1%SEC
Working capital, share of the change in revenue10.0%DEF
Tax rate27.2%SEC
The discount rate
Risk-free rate4.95%UST
Equity risk premium5.00%DEF
Beta0.87CALC
Pre-tax cost of debt5.79%IDX
Debt share of the capital structure25%DEF
Terminal growth2.25%DEF
The balance sheet
Borrowings$949mSEC
Cash$716mSEC
Net debt$233mSEC
Shares outstanding69.4mSEC
SEC
Reported in the company’s annual SEC filing
UST
US Treasury par yield curve, published daily by the Treasury
IDX
ICE BofA corporate bond index effective yield, published daily via FRED
CALC
Computed here from five years of weekly returns against the S&P 500 (SPY)
EST
Estimated: a projection, not a reported figure
DEF
House default: a documented assumption, not data

Five years of free cash flow

Revenue grows along the path above; margins, capital spending and tax stay at the filed year's proportions. Free cash flow is what is left for every provider of capital, and each year is discounted back at the WACC below, from the middle of the year, because cash arrives through it rather than on the last day.

Projected free cash flow for Insulet, years one to five, in $ millions
$ millionsYear 1Year 2Year 3Year 4Year 5
Revenue$3,385$4,045$4,611$5,003$5,153
EBITDA$704$841$959$1,041$1,072
Less depreciation and amortisation($112)($133)($152)($165)($170)
EBIT$592$708$807$876$902
Less tax on EBIT($161)($193)($220)($238)($245)
Plus depreciation and amortisation$112$133$152$165$170
Less capital spending($240)($287)($327)($355)($366)
Less increase in working capital($68)($66)($57)($39)($15)
Free cash flow$235$296$356$408$446
Discount factor0.9620.8910.8240.7630.706
Present value$226$263$293$311$315

The discount rate

The weighted average cost of capital blends what shareholders and lenders expect to earn, weighted by how much of the company each finances.

Cost of equity: 4.95% + 0.87 × 5.00%9.30%
After-tax cost of debt: 5.79% × (1 − 27.2%)4.22%
WACC: 75% equity, 25% debt8.03%

From cash flow to one value per share

After year five the model assumes free cash flow grows at 2.25% a year for ever: the Gordon growth terminal value, which is year-five free cash flow of $446m grown one year, divided by WACC less growth.

Present value of five years of free cash flow$1,409m
Terminal value at the end of year five$7,886m
Present value of the terminal value$5,571m
Enterprise value$6,980m
Less net debt($233)m
Equity value$6,747m
Divided by shares outstanding69.4m
Value per share$97.22

The terminal value is 80% of enterprise value, so most of this answer rests on the years after the forecast. That is normal for a DCF, and it is why the next table matters.

How much the answer depends on two inputs

Value per share across a range of discount rates and terminal growth rates. The centre is the model above. Move the discount rate one point either way and the value runs from $82.11 to $118.68 a share: small inputs, large answers.

Insulet value per share by WACC (rows) and terminal growth (columns)
WACC by growth1.75%2.00%2.25%2.50%2.75%
7.03%$108.64$113.41$118.68$124.53$131.06
7.53%$98.76$102.66$106.93$111.62$116.80
8.03%$90.47$93.70$97.22$101.05$105.25
8.53%$83.39$86.12$89.06$92.24$95.71
9.03%$77.30$79.62$82.11$84.79$87.68

What this model does not know

  • The growth path is an estimate, not anyone's forecast: it starts at last year's revenue growth, 25.0%, and tapers to 3% by year five.
  • The equity risk premium, the debt share of the capital structure, working capital and terminal growth are house defaults, the same documented assumptions the terminal starts from. They are tagged DEF above.
  • Capital spending stays at 7.1% of revenue for all five years. A company in a heavy investment cycle looks worth less here than it will if that spending falls.
  • Net debt is borrowings less cash, as filed. Operating leases are left out.
  • No share price appears on this page, on purpose. It teaches how a DCF is built; it does not say whether the stock is cheap or dear.

Now change it

The terminal opens this exact model with Insulet's filing already loaded. Change the growth path, the margin or the discount rate, and every figure on this page moves with it. Market inputs there are live, so they may have moved since 4 November 2026.

Open this model in the terminal

Learn the method behind each step: Discounted cash flow, Free cash flow, Weighted average cost of capital and Terminal value.

All worked valuations