Discounted Cash Flow (DCF) Analysis Unlevered
Prothena Corporation plc (PRTA)
$57.75
+2.20 (+3.96%)
All numbers are in Millions, Currency in USD
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 | 27.52 | 0.96 | 0.81 | 0.85 | 200.58 | 11,888.10 | 704,601.71 | 41,761,390.32 | 2,475,176,676.18 | 146,702,481,212.04 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
EBITDA | -150.85 | -149.20 | -62.27 | -103.08 | 78.77 | -852,784.47 | -50,544,108.06 | -2,995,723,955.64 | -177,555,057,603.90 | -10,523,599,286,016.97 |
EBITDA (%) | ||||||||||
EBIT | -153.91 | -152.42 | -69.09 | -110.06 | 71.96 | -900,504.84 | -53,372,470.88 | -3,163,359,602.43 | -187,490,738,381.80 | -11,112,482,106,655.47 |
EBIT (%) | ||||||||||
Depreciation | 3.07 | 3.22 | 6.82 | 6.98 | 6.80 | 47,720.38 | 2,828,362.82 | 167,635,646.79 | 9,935,680,777.90 | 588,882,820,638.50 |
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 | 417.62 | 427.66 | 375.72 | 295.38 | 579.09 | 3,028,453.05 | 179,494,894.74 | 10,638,572,460.88 | 630,542,858,448.37 | 37,371,959,236,292.16 |
---|---|---|---|---|---|---|---|---|---|---|
Total Cash (%) | ||||||||||
Account Receivables | 0.24 | 0 | 0.07 | 0.01 | 5.61 | 332.68 | 19,718.03 | 1,168,677.47 | 69,266,928.22 | 4,105,416,123.83 |
Account Receivables (%) | ||||||||||
Inventories | - | - | - | - | - | - | - | - | - | - |
Inventories (%) | ||||||||||
Accounts Payable | 13.63 | 1.47 | 1.24 | 4.12 | 3.69 | 19,984.76 | 1,184,486.83 | 70,203,940.69 | 4,160,952,383.54 | 246,617,562,594.27 |
Accounts Payable (%) | ||||||||||
Capital Expenditure | -3.63 | -1.77 | -0.55 | -0.20 | -0.58 | -6,889.24 | -408,321.52 | -24,201,011.75 | -1,434,381,838.81 | -85,015,092,774.37 |
Capital Expenditure (%) |
Weighted Average Cost Of Capital
Share price | $ 57.75 |
---|---|
Beta | 0.502 |
Diluted Shares Outstanding | 48.46 |
Cost of Debt | |
Tax Rate | 6.88 |
After-tax Cost of Debt | 0.32% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 5.903 |
Total Debt | 12.33 |
Total Equity | 2,798.80 |
Total Capital | 2,811.12 |
Debt Weighting | 0.44 |
Equity Weighting | 99.56 |
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 | 27.52 | 0.96 | 0.81 | 0.85 | 200.58 | 11,888.10 | 704,601.71 | 41,761,390.32 | 2,475,176,676.18 | 146,702,481,212.04 |
---|---|---|---|---|---|---|---|---|---|---|
EBITDA | -150.85 | -149.20 | -62.27 | -103.08 | 78.77 | -852,784.47 | -50,544,108.06 | -2,995,723,955.64 | -177,555,057,603.90 | -10,523,599,286,016.97 |
EBIT | -153.91 | -152.42 | -69.09 | -110.06 | 71.96 | -900,504.84 | -53,372,470.88 | -3,163,359,602.43 | -187,490,738,381.80 | -11,112,482,106,655.47 |
Tax Rate | 2.77% | 0.30% | -0.49% | 0.25% | 6.88% | 1.94% | 1.94% | 1.94% | 1.94% | 1.94% |
EBIAT | -149.65 | -151.96 | -69.43 | -109.78 | 67.01 | -883,013.49 | -52,335,767.24 | -3,101,914,697.25 | -183,848,929,643.38 | -10,896,633,927,749.08 |
Depreciation | 3.07 | 3.22 | 6.82 | 6.98 | 6.80 | 47,720.38 | 2,828,362.82 | 167,635,646.79 | 9,935,680,777.90 | 588,882,820,638.50 |
Accounts Receivable | - | 0.24 | -0.07 | 0.05 | -5.60 | -327.07 | -19,385.34 | -1,148,959.45 | -68,098,250.75 | -4,036,149,195.61 |
Inventories | - | - | - | - | - | - | - | - | - | - |
Accounts Payable | - | -12.16 | -0.23 | 2.87 | -0.43 | 19,981.07 | 1,164,502.07 | 69,019,453.86 | 4,090,748,442.85 | 242,456,610,210.73 |
Capital Expenditure | -3.63 | -1.77 | -0.56 | -0.20 | -0.57 | -6,889.24 | -408,321.52 | -24,201,011.75 | -1,434,381,838.81 | -85,015,092,774.37 |
UFCF | -150.21 | -162.44 | -63.46 | -100.07 | 67.22 | -822,528.35 | -48,770,609.22 | -2,890,609,567.80 | -171,324,980,512.19 | -10,154,345,738,869.83 |
WACC | ||||||||||
PV UFCF | -776,849.60 | -43,504,112.70 | -2,435,272,911.46 | -136,321,689,718.68 | -7,631,014,577,576.54 | |||||
SUM PV UFCF | -7,769,815,821,168.99 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 5.88 |
Free cash flow (t + 1) | -10,357,432,653,647.23 |
Terminal Value | -266,944,140,557,918.28 |
Present Value of Terminal Value | -200,609,146,111,548.31 |
Intrinsic Value
Enterprise Value | -208,378,961,932,717.31 |
---|---|
Net Debt | -566.77 |
Equity Value | -208,378,961,932,150.56 |
Shares Outstanding | 48.46 |
Equity Value Per Share | -4,299,664,945,777.29 |