Discounted Cash Flow (DCF) Analysis Unlevered

Radian Group Inc. (RDN)

$20.93

+0.56 (+2.75%)
All numbers are in Millions, Currency in USD
Stock DCF: 34.39 | 20.93 | undervalue

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,273.011,526.961,438.621,329.931,190.731,179.241,167.871,156.601,145.441,134.39
Revenue (%)
EBITDA 814.77978.03622.32924.65489.96665.06658.64652.29646639.77
EBITDA (%)
EBIT 745.68905.30550.59849.18413.38600.71594.92589.18583.50577.87
EBIT (%)
Depreciation 69.0972.7371.7375.4776.5864.3463.7263.1162.5061.90
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 4,645.375,300.036,429.266,219.735,749.674,975.124,927.134,879.604,832.544,785.92
Total Cash (%)
Account Receivables 137.56110.61194.50191.91119.83132.22130.95129.69128.43127.20
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable ----------
Accounts Payable (%)
Capital Expenditure -26.01-27.63-17.02-12.60-17.67-17.61-17.44-17.27-17.11-16.94
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 20.93
Beta 1.162
Diluted Shares Outstanding 190.26
Cost of Debt
Tax Rate 51.75
After-tax Cost of Debt 2.41%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.968
Total Debt -
Total Equity 3,982.20
Total Capital 3,982.20
Debt Weighting 0.00
Equity Weighting 100.00
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,273.011,526.961,438.621,329.931,190.731,179.241,167.871,156.601,145.441,134.39
EBITDA 814.77978.03622.32924.65489.96665.06658.64652.29646639.77
EBIT 745.68905.30550.59849.18413.38600.71594.92589.18583.50577.87
Tax Rate 11.43%20.81%17.90%21.46%51.75%24.67%24.67%24.67%24.67%24.67%
EBIAT 660.48716.90452.04666.91199.46452.52448.15443.83439.55435.31
Depreciation 69.0972.7371.7375.4776.5864.3463.7263.1162.5061.90
Accounts Receivable -26.95-83.892.5872.08-12.391.281.261.251.24
Inventories ----------
Accounts Payable ----------
Capital Expenditure -26.01-27.63-17.02-12.60-17.67-17.61-17.44-17.27-17.11-16.94
UFCF 703.56788.96422.86732.36330.44486.86495.71490.93486.20481.51
WACC
PV UFCF 446.79417.46379.40344.81313.38
SUM PV UFCF 1,901.84

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 8.97
Free cash flow (t + 1) 491.14
Terminal Value 7,046.43
Present Value of Terminal Value 4,586

Intrinsic Value

Enterprise Value 6,487.84
Net Debt -56.18
Equity Value 6,544.02
Shares Outstanding 190.26
Equity Value Per Share 34.39