Discounted Cash Flow (DCF) Analysis Levered

Touchstone Large Cap Focused Fund C... (SCSCX)

$56.19

+0.19 (+0.34%)
All numbers are in Millions, Currency in USD

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 65,50066,84959,57274,99070,56072,526.4574,547.6976,625.2778,760.7580,955.74
Revenue (%)
Operating Cash Flow 36,952-12,837-23,48847,09025,06913,940.7514,329.2614,728.6115,139.0815,560.99
Operating Cash Flow (%)
Capital Expenditure -3,774-5,336-3,446-4,119-5,632-4,787.21-4,920.62-5,057.76-5,198.71-5,343.60
Capital Expenditure (%)
Free Cash Flow 33,178-18,173-26,93442,97119,4379,153.549,408.649,670.859,940.3710,217.40

Weighted Average Cost Of Capital

Share price $ 56.19
Beta 0.930
Diluted Shares Outstanding 1,964.30
Cost of Debt
Tax Rate 25.93
After-tax Cost of Debt -%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.549
Total Debt -
Total Equity 110,374.02
Total Capital -
Debt Weighting -
Equity Weighting -
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 65,50066,84959,57274,99070,56072,526.4574,547.6976,625.2778,760.7580,955.74
Operating Cash Flow 36,952-12,837-23,48847,09025,06913,940.7514,329.2614,728.6115,139.0815,560.99
Capital Expenditure -3,774-5,336-3,446-4,119-5,632-4,787.21-4,920.62-5,057.76-5,198.71-5,343.60
Free Cash Flow 33,178-18,173-26,93442,97119,4379,153.549,408.649,670.859,940.3710,217.40
WACC
PV LFCF -----
SUM PV LFCF -

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) -
Free cash flow (t + 1) 10,421.75
Terminal Value -
Present Value of Terminal Value -

Intrinsic Value

Enterprise Value -
Net Debt -325,049
Equity Value -
Shares Outstanding 1,964.30
Equity Value Per Share -