Compugen Ltd. (CGEN) DCF Valuation

Compugen Ltd. (CGEN) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Compugen Ltd. (CGEN) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Designed for accuracy, our (CGEN) DCF Calculator empowers you to assess Compugen Ltd. valuation using real-world financial data while offering complete flexibility to modify all essential parameters for improved projections.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2019		 AY2
2020		 AY3
2021		 AY4
2022		 AY5
2023		 FY1
2024		 FY2
2025		 FY3
2026		 FY4
2027		 FY5
2028
Revenue .0 2.0 6.0 7.5 33.5 52.3 81.7 127.6 199.4 311.6
Revenue Growth, % 0 0 200 25 346.12 56.25 56.25 56.25 56.25 56.25
EBITDA -27.0 -31.5 -34.6 -35.4 -12.5 -24.8 -38.8 -60.6 -94.7 -148.0
EBITDA, % 100 -1574.8 -576.88 -471.65 -37.41 -47.48 -47.48 -47.48 -47.48 -47.48
Depreciation 1.0 .7 .5 .5 .5 15.8 24.7 38.6 60.3 94.3
Depreciation, % 100 35.75 7.68 6.43 1.42 30.26 30.26 30.26 30.26 30.26
EBIT -28.0 -32.2 -35.1 -35.9 -13.0 -25.0 -39.0 -61.0 -95.3 -148.8
EBIT, % 100 -1610.55 -584.57 -478.08 -38.83 -47.77 -47.77 -47.77 -47.77 -47.77
Total Cash 43.9 124.4 117.8 83.7 50.7 52.3 81.7 127.6 199.4 311.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .3 2.2 .2 .3 61.3
Account Receivables, % 100 108.8 3.13 4.23 183.26
Inventories -.8 -119.3 -110.0 -72.6 .0 -20.9 -32.7 -51.1 -79.8 -124.6
Inventories, % 100 -5964.45 -1832.68 -968.65 0 -40 -40 -40 -40 -40
Accounts Payable 1.1 1.4 4.6 1.8 3.5 29.5 46.0 71.9 112.4 175.6
Accounts Payable, % 100 70.65 77.02 23.64 10.47 56.35 56.35 56.35 56.35 56.35
Capital Expenditure -.2 -.2 -.3 -.5 -.2 -2.1 -3.3 -5.1 -8.0 -12.6
Capital Expenditure, % 100 -8.3 -4.87 -6.49 -0.51406 -4.03 -4.03 -4.03 -4.03 -4.03
Tax Rate, % -91.68 -91.68 -91.68 -91.68 -91.68 -91.68 -91.68 -91.68 -91.68 -91.68
EBITAT -27.3 -29.6 -33.7 -35.9 -24.9 -24.2 -37.9 -59.2 -92.5 -144.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -24.9 88.0 -37.7 -76.2 -156.5 65.5 -6.2 -9.7 -15.1 -23.6
WACC, % 16.82 16.82 16.82 16.82 16.82 16.82 16.82 16.82 16.82 16.82
PV UFCF
SUM PV UFCF 26.5
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -24
Terminal Value -163
Present Terminal Value -75
Enterprise Value -48
Net Debt -13
Equity Value -36
Diluted Shares Outstanding, MM 88
Equity Value Per Share -0.41

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator with pre-filled real CGEN financials.
  • Real-World Data: Historical data and forward-looking estimates (as shown in the yellow cells).
  • Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Instantly observe how your inputs affect Compugen's valuation.
  • Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.

Key Features

  • Comprehensive Financial Data: Gain access to precise pre-loaded historical performance and future estimates for Compugen Ltd. (CGEN).
  • Adjustable Forecast Parameters: Modify highlighted cells for metrics such as WACC, growth rates, and profit margins.
  • Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow assessments.
  • User-Friendly Dashboard: Clear and concise charts and summaries to help you interpret your valuation findings.
  • Suitable for All Skill Levels: A straightforward, intuitive layout designed for investors, CFOs, and consultants alike.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review Compugen Ltd.'s pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
  5. Step 5: Analyze the results and utilize the insights for investment decisions regarding Compugen Ltd. (CGEN).

Why Choose Compugen Ltd. (CGEN) Calculator?

  • Precision: Utilizes real Compugen financial data for reliable results.
  • Versatility: Allows users to easily adjust and experiment with various inputs.
  • Efficiency: Eliminate the need to create a DCF model from the ground up.
  • Expert-Level: Crafted with the accuracy and functionality expected by finance professionals.
  • Intuitive: Simple interface suitable for users with varying levels of financial expertise.

Who Should Use Compugen Ltd. (CGEN)?

  • Investors: Gain insights and make informed decisions with our advanced analytics tools.
  • Biotech Analysts: Streamline your research process with access to comprehensive data and reports.
  • Consultants: Efficiently customize our resources for client projects and strategic presentations.
  • Biotechnology Enthusiasts: Enhance your knowledge of the biotech industry through detailed case studies.
  • Educators and Students: Utilize our resources as a hands-on learning tool in life sciences and biotechnology courses.

What the Template Contains

  • Historical Data: Includes Compugen Ltd.'s (CGEN) past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Compugen Ltd.'s (CGEN) intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of Compugen Ltd.'s (CGEN) financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.