Discounted Cash Flow (DCF) Analysis Unlevered

Banco BBVA Argentina S.A. (BBAR)

$5.48

-0.11 (-1.97%)
All numbers are in Millions, Currency in USD
Stock DCF: 1,456.01 | 5.48 | 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 40,634.9382,652.70107,807159,741.22433,599816,736.351,538,422.062,897,804.705,458,366.9110,281,496.66
Revenue (%)
EBITDA 29,507.1337,469.0424,74026,685.35363,621394,423.55742,944.631,399,426.392,635,989.484,965,206.17
EBITDA (%)
EBIT 28,630.7535,470.4320,674.0221,103.59352,647.77370,948.43698,726.391,316,135.982,479,101.884,669,689.33
EBIT (%)
Depreciation 876.371,998.614,065.985,581.7610,973.2223,475.1244,218.2383,290.41156,887.60295,516.84
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,669.81201,483.20279,680.35385,420.48296,2921,824,838.293,437,304.446,474,580.1612,195,657.6822,972,001.67
Total Cash (%)
Account Receivables 4,215.665,410.171,8675,166.686,42738,171.9571,901.51135,435.22255,108.68480,528.16
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 95.67378.2641.5435.2040.851,246.452,347.854,422.468,330.2315,691
Accounts Payable (%)
Capital Expenditure -1,742.60-2,659.26-3,147.27-8,042.92-16,410-31,435.77-59,213.10-111,535.05-210,089.81-395,729.67
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 5.48
Beta 1.629
Diluted Shares Outstanding 204.24
Cost of Debt
Tax Rate 4.92
After-tax Cost of Debt 144,320.81%
Risk-Free Rate
Market Risk Premium
Cost of Equity 11.845
Total Debt 191
Total Equity 1,119.22
Total Capital 1,310.22
Debt Weighting 14.58
Equity Weighting 85.42
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 40,634.9382,652.70107,807159,741.22433,599816,736.351,538,422.062,897,804.705,458,366.9110,281,496.66
EBITDA 29,507.1337,469.0424,74026,685.35363,621394,423.55742,944.631,399,426.392,635,989.484,965,206.17
EBIT 28,630.7535,470.4320,674.0221,103.59352,647.77370,948.43698,726.391,316,135.982,479,101.884,669,689.33
Tax Rate 29.99%13.42%41.70%-0.48%4.92%17.91%17.91%17.91%17.91%17.91%
EBIAT 20,043.3530,711.0412,052.0121,204.39335,305.20304,506.89573,575.691,080,399.452,035,063.513,833,289.15
Depreciation 876.371,998.614,065.985,581.7610,973.2223,475.1244,218.2383,290.41156,887.60295,516.84
Accounts Receivable --1,194.513,543.17-3,299.68-1,260.32-31,744.95-33,729.55-63,533.71-119,673.46-225,419.48
Inventories ----------
Accounts Payable -282.59-336.72-6.345.651,205.611,101.392,074.613,907.787,360.77
Capital Expenditure -1,742.60-2,659.26-3,147.27-8,042.92-16,410-31,435.77-59,213.10-111,535.05-210,089.81-395,729.67
UFCF 19,177.1229,138.4716,177.1715,437.20328,613.75266,006.89525,952.67990,695.701,866,095.623,515,017.62
WACC
PV UFCF 1,257.7911.760.1000
SUM PV UFCF 1,269.65

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 21,048.83
Free cash flow (t + 1) 3,585,317.97
Terminal Value 17,034.95
Present Value of Terminal Value 0

Intrinsic Value

Enterprise Value 1,269.65
Net Debt -296,101
Equity Value 297,370.65
Shares Outstanding 204.24
Equity Value Per Share 1,456.01