Loading...

Discounted Cash Flow (DCF) Analysis Unlevered


HP Inc.

HP Inc. (HPQ)

Technology

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 112,298.0056,654.3451,464.8048,237.9652,053.5858,471.7953,238.5648,473.7144,135.3240,185.2036,588.63
Revenue (%)
EBITDA 11,746.3710,679.348,815.923,709.503,872.794,590.046,159.705,608.415,106.464,649.434,233.30
EBITDA (%)
EBIT 7,130.926,345.294,755.353,376.663,518.824,063.794,216.493,839.123,495.523,182.672,897.82
EBIT (%)
Depreciation 4,615.454,334.064,060.57332.84353.96526.251,943.211,769.291,610.941,466.761,335.48
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 12,161.8715,132.377,585.916,290.236,996.005,168.917,772.837,077.166,443.765,867.045,341.94
Total Cash (%)
Account Receivables 28,579.8425,233.844,827.404,114.704,414.145,110.439,327.408,492.597,732.517,040.456,410.33
Account Receivables (%)
Inventories 6,041.636,413.274,287.024,486.135,788.366,063.524,951.194,508.064,104.583,737.223,402.74
Inventories (%)
Accounts Payable 14,014.7915,902.8710,195.1811,104.3813,278.8714,816.7511,909.4710,843.579,873.078,989.438,184.88
Accounts Payable (%)
Capital Expenditure -2,549.16-3,008.35-3,180.52-429.32-333.14-374.22-1,410.82-1,284.55-1,169.59-1,064.91-969.60
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 20.36
Diluted Shares Outstanding 1,615.00
Cost of Debt
Tax Rate -76.80
After-tax Cost of Debt 3.89
Risk-Free Rate
Market Risk Premium
Cost of Equity 14.19
Total Debt 4,524.00
Total Equity 32,881.40
Total Capital 37,405.40
Debt Weighting 12.09
Equity Weighting 87.91
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 112,298.0056,654.3451,464.8048,237.9652,053.5858,471.7953,238.5648,473.7144,135.3240,185.2036,588.63
EBITDA 11,746.3710,679.348,815.923,709.503,872.794,590.046,159.705,608.415,106.464,649.434,233.30
EBIT 7,130.926,345.294,755.353,376.663,518.824,063.794,216.493,839.123,495.523,182.672,897.82
Tax Rate 21.46%15.78%-4.26%30.49%22.89%-76.80%1.59%1.59%1.59%1.59%1.59%
EBIAT 5,600.685,344.244,957.842,347.022,713.237,184.804,149.293,777.933,439.803,131.942,851.63
Depreciation 4,615.454,334.064,060.57332.84353.96526.251,943.211,769.291,610.941,466.761,335.48
Accounts Receivable -3,346.0020,406.44712.70-299.45-696.29-4,216.96834.80760.09692.06630.12
Inventories --371.642,126.25-199.11-1,302.23-275.171,112.34443.13403.47367.36334.48
Accounts Payable -1,888.08-5,707.70909.202,174.491,537.88-2,907.28-1,065.90-970.50-883.64-804.55
Capital Expenditure -459.18172.18-2,751.21-96.1741.081,036.60-126.27-114.97-104.68-95.31
UFCF 10,216.1314,999.9226,015.601,351.443,543.848,318.551,117.195,632.985,128.834,669.804,251.85
WACC
PV UFCF 983.964,369.593,504.062,809.982,253.38
SUM PV UFCF 51,479.75

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 13.54
Free cash flow (t + 1) 4,421.93
Terminal Value 46,351.45
Present Value of Terminal Value 24,565.12

Intrinsic Value

Enterprise Value 76,044.87
Net Debt -644.91
Equity Value 76,689.77
Shares Outstanding 1,615.00
Equity Value Per Share 47.49