Discounted Cash Flow (DCF) Analysis Unlevered

National Rural Utilities Cooper (NRUC)

$24.8993

+0.06 (+0.24%)
All numbers are in Millions, Currency in USD
Stock DCF: - | 24.8993 | 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 284.62299.46330.20433.47452.90510.91576.36650.18733.47827.42
Revenue (%)
EBITDA 1,284.12722.86268.891,505.651,169.811,409.751,590.321,794.032,023.832,283.06
EBITDA (%)
EBIT 1,250.23687.19234.691,515.041,142.391,370.851,546.441,744.531,967.982,220.07
EBIT (%)
Depreciation 33.9035.6734.20-9.3927.4238.9043.8849.5055.8462.99
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 839.85830.90732.11295.060.75881.32994.211,121.561,265.221,427.29
Total Cash (%)
Account Receivables 127.44133.60117.14107.860.11153.04172.65194.76219.71247.85
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable ----------
Accounts Payable (%)
Capital Expenditure ---9.57-12.56-13.12-14.80-16.70-18.83-21.25-23.97
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 24.8,993
Beta 0.000
Diluted Shares Outstanding -
Cost of Debt
Tax Rate 45.51
After-tax Cost of Debt 1,449.15%
Risk-Free Rate
Market Risk Premium
Cost of Equity 2.849
Total Debt 26.53
Total Equity -
Total Capital -
Debt Weighting -
Equity Weighting -
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 284.62299.46330.20433.47452.90510.91576.36650.18733.47827.42
EBITDA 1,284.12722.86268.891,505.651,169.811,409.751,590.321,794.032,023.832,283.06
EBIT 1,250.23687.19234.691,515.041,142.391,370.851,546.441,744.531,967.982,220.07
Tax Rate 0.98%1.17%0.91%0.12%45.51%9.74%9.74%9.74%9.74%9.74%
EBIAT 1,238.03679.14232.561,513.19622.431,237.361,395.851,574.651,776.342,003.88
Depreciation 33.9035.6734.20-9.3927.4238.9043.8849.5055.8462.99
Accounts Receivable --6.1616.479.28107.74-152.93-19.60-22.11-24.95-28.14
Inventories ----------
Accounts Payable ----------
Capital Expenditure ---9.56-12.56-13.12-14.80-16.70-18.83-21.25-23.97
UFCF 1,271.93708.65273.671,500.52744.471,108.531,403.431,583.201,785.992,014.76
WACC
PV UFCF -----
SUM PV UFCF -

Terminal Value

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

Intrinsic Value

Enterprise Value -
Net Debt 26.37
Equity Value -
Shares Outstanding -
Equity Value Per Share -