Discounted Cash Flow (DCF) Analysis Unlevered

Grupo Supervielle S.A. (SUPV)

$2.29

+0.15 (+7.01%)
All numbers are in Millions, Currency in USD
Stock DCF: 351.43 | 2.29 | undervalue

Operating Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 14,264.7127,953.8940,523.7053,191.6270,324.47106,260.59160,560.23242,607.24366,580.63553,905
Revenue (%)
EBITDA 8,691.1415,828.6334,745.2235,157.0163,270.0276,370.73115,396.52174,364.67263,465.80398,098.02
EBITDA (%)
EBIT 8,691.1415,396.2532,930.5532,749.9859,044.8771,972.05108,750.09164,321.87248,291.10375,168.97
EBIT (%)
Depreciation -432.391,814.672,407.034,225.144,398.696,646.4410,042.7915,174.7122,929.05
Depreciation (%)

Balance Sheet Data

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Total Cash 11,617.0833,696.3526,403.1036,674.8732,574.1281,269.15122,798.06185,548.43280,364.51423,632.05
Total Cash (%)
Account Receivables 26,903.0512,978.2912,944.6624,352.6356,379.5583,504.47126,175.63190,651.95288,075.96435,284.08
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 751.32552.612,193.821,362.5412,852.757,118.5010,756.0816,252.4924,557.5937,106.63
Accounts Payable (%)
Capital Expenditure -175.84-1,263.76-1,113.87-4,724.07-5,023.01-5,212.32-7,875.84-11,900.43-17,981.60-27,170.28
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 2.29
Beta 1.856
Diluted Shares Outstanding 91.34
Cost of Debt
Tax Rate -19.09
After-tax Cost of Debt 2,502.56%
Risk-Free Rate
Market Risk Premium
Cost of Equity 12.365
Total Debt 2,417.51
Total Equity 209.18
Total Capital 2,626.68
Debt Weighting 92.04
Equity Weighting 7.96
Wacc

Build Up Free Cash

Year
A/P
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Projected
2023
Projected
2024
Projected
2025
Projected
2026
Projected
Revenue 14,264.7127,953.8940,523.7053,191.6270,324.47106,260.59160,560.23242,607.24366,580.63553,905
EBITDA 8,691.1415,828.6334,745.2235,157.0163,270.0276,370.73115,396.52174,364.67263,465.80398,098.02
EBIT 8,691.1415,396.2532,930.5532,749.9859,044.8771,972.05108,750.09164,321.87248,291.10375,168.97
Tax Rate 24.21%-48.01%-8.40%16.12%-19.09%-7.04%-7.04%-7.04%-7.04%-7.04%
EBIAT 6,587.2322,788.5335,695.7027,470.7270,318.7177,035.52116,401.02175,882.47265,759.20401,563.36
Depreciation -432.391,814.672,407.034,225.144,398.696,646.4410,042.7915,174.7122,929.05
Accounts Receivable -13,924.7633.63-11,407.97-32,026.92-27,124.92-42,671.16-64,476.32-97,424.01-147,208.12
Inventories ----------
Accounts Payable --198.711,641.21-831.2811,490.21-5,734.263,637.595,496.418,305.1012,549.04
Capital Expenditure -175.84-1,263.76-1,113.88-4,724.07-5,023.01-5,212.32-7,875.84-11,900.43-17,981.60-27,170.28
UFCF 6,411.3935,683.2038,071.3412,914.4248,984.1443,362.7176,138.04115,044.92173,833.40262,663.05
WACC
PV UFCF 1,803.59131.728.280.520.03
SUM PV UFCF 1,944.13

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 2,304.25
Free cash flow (t + 1) 267,916.31
Terminal Value 11,637.15
Present Value of Terminal Value 0

Intrinsic Value

Enterprise Value 1,944.14
Net Debt -30,156.61
Equity Value 32,100.75
Shares Outstanding 91.34
Equity Value Per Share 351.43