Discounted Cash Flow (DCF) Analysis Unlevered

Innospec Inc. (IOSP)

$107.07

+2.00 (+1.90%)
All numbers are in Millions, Currency in USD
Stock DCF: 74.17 | 107.07 | overvalue

Operating Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 1,476.901,513.301,193.101,483.401,963.702,150.332,354.692,578.482,823.533,091.88
Revenue (%)
EBITDA 195.20202.80128.60176.80225.80261.54286.40313.61343.42376.06
EBITDA (%)
EBIT 145.60155.2082.60134.10185.70195.83214.44234.82257.13281.57
EBIT (%)
Depreciation 49.6047.604642.7040.1065.7171.9678.8086.2994.49
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 123.1075.70105.30141.80147.10168.64184.67202.22221.44242.48
Total Cash (%)
Account Receivables 279.70292221.40284.50334.60400438.01479.64525.23575.14
Account Receivables (%)
Inventories 248244.60220277.60373.10383.22419.64459.53503.20551.02
Inventories (%)
Accounts Payable 126.8012298.70148.70165.30186.49204.21223.62244.87268.14
Accounts Payable (%)
Capital Expenditure -30.10-31-29.70-39.10-42.30-48.88-53.53-58.61-64.18-70.28
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 107.07
Beta 1.156
Diluted Shares Outstanding 24.98
Cost of Debt
Tax Rate 27.95
After-tax Cost of Debt 2.99%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.612
Total Debt 45.30
Total Equity 2,674.82
Total Capital 2,720.12
Debt Weighting 1.67
Equity Weighting 98.33
Wacc

Build Up Free Cash

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 1,476.901,513.301,193.101,483.401,963.702,150.332,354.692,578.482,823.533,091.88
EBITDA 195.20202.80128.60176.80225.80261.54286.40313.61343.42376.06
EBIT 145.60155.2082.60134.10185.70195.83214.44234.82257.13281.57
Tax Rate 35.41%25.40%27.71%30.73%27.95%29.44%29.44%29.44%29.44%29.44%
EBIAT 94.04115.7859.7192.89133.79138.18151.31165.69181.43198.68
Depreciation 49.6047.604642.7040.1065.7171.9678.8086.2994.49
Accounts Receivable --12.3070.60-63.10-50.10-65.40-38.02-41.63-45.58-49.92
Inventories -3.4024.60-57.60-95.50-10.12-36.42-39.88-43.67-47.82
Accounts Payable --4.80-23.305016.6021.1917.7219.4121.2523.27
Capital Expenditure -30.10-31-29.70-39.10-42.30-48.88-53.53-58.61-64.18-70.28
UFCF 113.54118.68147.9125.792.59100.67113.03123.77135.53148.41
WACC
PV UFCF 91.9494.2794.2794.2794.28
SUM PV UFCF 469.02

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 9.50
Free cash flow (t + 1) 151.38
Terminal Value 2,018.42
Present Value of Terminal Value 1,282.16

Intrinsic Value

Enterprise Value 1,751.18
Net Debt -101.80
Equity Value 1,852.98
Shares Outstanding 24.98
Equity Value Per Share 74.17