Loading...

Discounted Cash Flow (DCF) Analysis Unlevered


Bank of America Corporation

Bank of America Corporation (BAC)

Financial Services

Operating Data

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 88,942.0085,891.2982,962.4083,700.7687,350.1191,245.9391,766.0392,289.1092,815.1593,344.1993,876.25
Revenue (%)
EBITDA 18,855.7010,487.3324,573.4627,261.3431,315.0236,644.3726,245.0926,394.6826,545.1326,696.4426,848.61
EBITDA (%)
EBIT 16,169.667,962.1222,184.1425,018.1629,209.8834,582.2123,767.4023,902.8824,039.1224,176.1524,313.95
EBIT (%)
Depreciation 2,686.052,525.202,389.322,243.182,105.142,062.162,477.682,491.812,506.012,520.292,534.66
Depreciation (%)

Balance Sheet Data

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Total Cash --559,805.36563,908.77605,231.48711,736.50647,271.71650,961.15654,671.63658,403.26662,156.16
Total Cash (%)
Account Receivables 59,448.8361,841.7358,314.2758,757.9361,625.5165,815.6964,539.0564,906.9265,276.8965,648.9766,023.17
Account Receivables (%)
Inventories -----------
Inventories (%)
Accounts Payable -----------
Accounts Payable (%)
Capital Expenditure -----------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 34.45
Diluted Shares Outstanding 10,096.50
Cost of Debt
Tax Rate 18.61
After-tax Cost of Debt -0.88
Risk-Free Rate
Market Risk Premium
Cost of Equity 14.30
Total Debt 229,392.00
Total Equity 347,824.42
Total Capital 577,216.43
Debt Weighting 39.74
Equity Weighting 60.26
Wacc

Build Up Free Cash

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 88,942.0085,891.2982,962.4083,700.7687,350.1191,245.9391,766.0392,289.1092,815.1593,344.1993,876.25
EBITDA 18,855.7010,487.3324,573.4627,261.3431,315.0236,644.3726,245.0926,394.6826,545.1326,696.4426,848.61
EBIT 16,169.667,962.1222,184.1425,018.1629,209.8834,582.2123,767.4023,902.8824,039.1224,176.1524,313.95
Tax Rate 29.32%30.68%28.29%28.77%37.59%18.61%28.88%28.88%28.88%28.88%28.88%
EBIAT 11,429.345,519.3915,907.9517,819.9818,230.0528,145.5416,904.1417,000.4917,097.4017,194.8517,292.86
Depreciation 2,686.052,525.202,389.322,243.182,105.142,062.162,477.682,491.812,506.012,520.292,534.66
Accounts Receivable --2,392.903,527.46-443.67-2,867.57-4,190.181,276.64-367.87-369.97-372.08-374.20
Inventories -----------
Accounts Payable -----------
Capital Expenditure -----------
UFCF 14,115.395,651.7021,824.7319,619.4917,467.6226,017.5220,658.4619,124.4319,233.4319,343.0719,453.32
WACC
PV UFCF 18,741.2315,739.4214,360.1013,101.6511,953.49
SUM PV UFCF 113,469.91

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 10.23
Free cash flow (t + 1) 20,231.45
Terminal Value 324,742.44
Present Value of Terminal Value 199,544.61

Intrinsic Value

Enterprise Value 313,014.52
Net Debt -482,344.50
Equity Value 795,359.02
Shares Outstanding 10,096.50
Equity Value Per Share 78.78