Cerillion PLC
LSE:CER
| US |
|
Johnson & Johnson
NYSE:JNJ
|
Pharmaceuticals
|
| US |
|
Berkshire Hathaway Inc
NYSE:BRK.A
|
Financial Services
|
| US |
|
Bank of America Corp
NYSE:BAC
|
Banking
|
| US |
|
Mastercard Inc
NYSE:MA
|
Technology
|
| US |
|
UnitedHealth Group Inc
NYSE:UNH
|
Health Care
|
| US |
|
Exxon Mobil Corp
NYSE:XOM
|
Energy
|
| US |
|
Pfizer Inc
NYSE:PFE
|
Pharmaceuticals
|
| US |
|
Palantir Technologies Inc
NYSE:PLTR
|
Technology
|
| US |
|
Nike Inc
NYSE:NKE
|
Textiles, Apparel & Luxury Goods
|
| US |
|
Visa Inc
NYSE:V
|
Technology
|
| CN |
|
Alibaba Group Holding Ltd
NYSE:BABA
|
Retail
|
| US |
|
3M Co
NYSE:MMM
|
Industrial Conglomerates
|
| US |
|
JPMorgan Chase & Co
NYSE:JPM
|
Banking
|
| US |
|
Coca-Cola Co
NYSE:KO
|
Beverages
|
| US |
|
Walmart Inc
NYSE:WMT
|
Retail
|
| US |
|
Verizon Communications Inc
NYSE:VZ
|
Telecommunication
|
If you don’t study any companies, you have the same success buying stocks as you do in a poker game if you bet without looking at your cards.
Utilize notes to systematically review your investment decisions. By reflecting on past outcomes, you can discern effective strategies and identify those that underperformed. This continuous feedback loop enables you to adapt and refine your approach, optimizing for future success.
Each note serves as a learning point, offering insights into your decision-making processes. Over time, you'll accumulate a personalized database of knowledge, enhancing your ability to make informed decisions quickly and effectively.
With a comprehensive record of your investment history at your fingertips, you can compare current opportunities against past experiences. This not only bolsters your confidence but also ensures that each decision is grounded in a well-documented rationale.
Do you really want to delete this note?
This action cannot be undone.
| 52 Week Range |
1 405
1 950
|
| Price Target |
|
We'll email you a reminder when the closing price reaches GBX.
Choose the stock you wish to monitor with a price alert.
|
|
Johnson & Johnson
NYSE:JNJ
|
US |
|
|
Berkshire Hathaway Inc
NYSE:BRK.A
|
US |
|
|
Bank of America Corp
NYSE:BAC
|
US |
|
|
Mastercard Inc
NYSE:MA
|
US |
|
|
UnitedHealth Group Inc
NYSE:UNH
|
US |
|
|
Exxon Mobil Corp
NYSE:XOM
|
US |
|
|
Pfizer Inc
NYSE:PFE
|
US |
|
|
Palantir Technologies Inc
NYSE:PLTR
|
US |
|
|
Nike Inc
NYSE:NKE
|
US |
|
|
Visa Inc
NYSE:V
|
US |
|
|
Alibaba Group Holding Ltd
NYSE:BABA
|
CN |
|
|
3M Co
NYSE:MMM
|
US |
|
|
JPMorgan Chase & Co
NYSE:JPM
|
US |
|
|
Coca-Cola Co
NYSE:KO
|
US |
|
|
Walmart Inc
NYSE:WMT
|
US |
|
|
Verizon Communications Inc
NYSE:VZ
|
US |
This alert will be permanently deleted.
Cerillion PLC
DCF Value
This DCF valuation model was created by
Alpha Spread
and was last updated on
Dec 22, 2024.
Estimated DCF Value of one
CER
stock is
922.66
GBX.
Compared to the current market price of 1 730 GBX, the stock is
Overvalued by 47%.
Present Value Calculation
This block is the starting point of the DCF valuation process. It calculates the present value of a company's forecasted cash flows based on selected operating model. Adjust key parameters like discount rate and terminal growth, and alter inputs such as revenue growth and margins to see their impact on valuation.
DCF Model
Base Case Scenario
Switching the operating model will discard any changes made to the current valuation.
You already have a valuation model for Cerillion PLC.
Do you want to replace it with the current valuation model?
Do you really want to delete your valuation model? This operation cannot be undone.
DCF Value Calculation
This stage translates the present value into DCF value per share. For firm valuation models, it adjusts present value for debt and assets to derive equity value (skipped if using equity valuation model). Finally, this equity value is divided by the number of shares to determine the DCF value per share.
Present Value to DCF Value
Capital Structure
| Present Value | 248.6m GBP |
| + Cash & Equivalents | 26.6m GBP |
| Firm Value | 275.2m GBP |
| - Debt | 1.9m GBP |
| Equity Value | 273.3m GBP |
| / Shares Outstanding | 29.6m |
| Value per Share | 9.23 GBP |
| GBP / GBX Exchange Rate | 100 |
| CER DCF Value | 922.66 GBX |
Valuation Analysis
Sensitivity Analysis
DCF Value Sensitivity Analysis
Sensitivity Analysis assesses how changes in key factors like revenue growth, margin, and discount rate affect a stock's DCF value. By visualizing various scenarios, from significant downturns to optimistic growth, this tool helps you understand potential valuation shifts, aiding in risk assessment and strategic decision-making.
DCF Financials
Financials used in DCF Calculation
What is the DCF value of one CER stock?
Estimated DCF Value of one
CER
stock is
922.66
GBX.
Compared to the current market price of 1 730 GBX, the stock is
Overvalued by 47%.
The true DCF Value lies somewhere between the worst-case and best-case scenario values. This is because the future is not predetermined, and the stock's DCF Value is based almost entirely on the future of the company. Knowing the full range of possible stock DCF values gives a complete picture of the investment risks and opportunities.
How was the DCF Value calculated?
1. Present Value Calculation.
Utilizing the DCF operating model, Cerillion PLC's future cash flows are projected and then discounted using a chosen discount rate to determine its Present Value, which is calculated at
248.6m GBP.
2. DCF Value Calculation. The company's capital structure is employed to derive the total Equity Value from the previously calculated Present Value of the cash flow. This Equity Value, when divided by the total number of outstanding shares, yields the DCF Value of 922.66 GBX per share.
You don't have any saved screeners yet
