POET Technologies Inc. (POET) DCF Valuation

POET Technologies Inc. (POET) 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

POET Technologies Inc. (POET) 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:

Evaluate POET Technologies Inc.'s financial prospects like an expert! This (POET) DCF Calculator provides pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your predictions.


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 3.9 3.9 .2 .6 .5 .5 .4 .4 .4 .4
Revenue Growth, % 0 0 -94.62 164.35 -15.73 -2.59 -2.59 -2.59 -2.59 -2.59
EBITDA -10.5 -14.7 -14.2 -18.6 -18.3 -.5 -.4 -.4 -.4 -.4
EBITDA, % -270.84 -376.87 -6792.9 -3360.62 -3923.56 -100 -100 -100 -100 -100
Depreciation .2 .9 1.1 1.2 1.9 .3 .3 .3 .3 .3
Depreciation, % 6.41 22.02 521.68 224.68 412.68 65.69 65.69 65.69 65.69 65.69
EBIT -10.8 -15.5 -15.3 -19.8 -20.2 -.5 -.4 -.4 -.4 -.4
EBIT, % -277.25 -398.88 -7314.58 -3585.3 -4336.23 -100 -100 -100 -100 -100
Total Cash 1.4 6.9 21.3 9.2 3.0 .4 .4 .4 .4 .4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 .1 .0 .1 .1
Account Receivables, % 0 3.15 0 11.36 12.28
Inventories .4 .4 -.1 -.1 .0 -.1 -.1 -.1 -.1 -.1
Inventories, % 11.23 11.23 -67.39 -23.22 0 -13.63 -13.63 -13.63 -13.63 -13.63
Accounts Payable 1.5 1.6 1.0 2.7 1.4 .3 .3 .3 .3 .3
Accounts Payable, % 38.77 41.23 472.26 492.73 294.27 76 76 76 76 76
Capital Expenditure -.5 -1.6 -.9 -3.1 -1.2 -.3 -.3 -.3 -.3 -.3
Capital Expenditure, % -13.15 -40.48 -445.19 -556.14 -267.74 -70.73 -70.73 -70.73 -70.73 -70.73
Tax Rate, % 0 0 0 0 0 0 0 0 0 0
EBITAT -10.5 -16.3 -17.1 -19.9 -20.2 -.5 -.4 -.4 -.4 -.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -9.7 -17.1 -16.9 -20.0 -21.0 -1.4 -.5 -.5 -.4 -.4
WACC, % 6.69 6.69 6.69 6.69 6.69 6.69 6.69 6.69 6.69 6.69
PV UFCF
SUM PV UFCF -2.8
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 0
Terminal Value -9
Present Terminal Value -7
Enterprise Value -10
Net Debt -2
Equity Value -7
Diluted Shares Outstanding, MM 40
Equity Value Per Share -0.18

What You Will Get

  • Accurate POET Financials: Access to both historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
  • Scenario Analysis: Evaluate various scenarios to analyze POET's future performance.
  • User-Friendly Design: Designed for professionals while remaining easy for newcomers to navigate.

Key Features

  • Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for POET Technologies Inc. (POET).
  • WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to POET.
  • Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit POET's financial outlook.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to POET Technologies Inc. (POET).
  • Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of POET.

How It Works

  • 1. Access the Template: Download and open the Excel file containing POET Technologies Inc.’s (POET) preloaded data.
  • 2. Modify Assumptions: Adjust key parameters such as growth rates, WACC, and capital expenditures.
  • 3. See Results Instantly: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
  • 4. Explore Scenarios: Evaluate various forecasts to assess different valuation possibilities.
  • 5. Present with Assurance: Deliver professional valuation insights to back your strategic decisions.

Why Choose This Calculator for POET Technologies Inc. (POET)?

  • Accurate Data: Utilize real financial metrics from POET for dependable valuation outcomes.
  • Customizable: Modify essential variables such as growth rates, WACC, and tax rates to align with your forecasts.
  • Time-Saving: Ready-to-use calculations save you the hassle of starting from ground zero.
  • Professional-Grade Tool: Tailored for investors, analysts, and consultants in the tech sector.
  • User-Friendly: The intuitive design and step-by-step guidance make it accessible for everyone.

Who Should Use POET Technologies Inc. (POET)?

  • Professional Investors: Develop comprehensive and accurate valuation models for investment analysis.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decision-making.
  • Consultants and Advisors: Deliver precise valuation insights for POET Technologies Inc. (POET) to clients.
  • Students and Educators: Utilize real-world data to learn and teach financial modeling techniques.
  • Tech Enthusiasts: Gain insights into how technology firms like POET are assessed in the market.

What the Template Contains

  • Pre-Filled DCF Model: POET Technologies Inc.'s (POET) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to POET.
  • Financial Ratios: Assess POET's profitability, leverage, and operational efficiency.
  • Editable Inputs: Adjust assumptions such as growth rates, profit margins, and capital expenditures to align with your scenarios.
  • Financial Statements: Annual and quarterly reports to facilitate in-depth analysis of POET.
  • Interactive Dashboard: Visually represent key valuation metrics and results for POET.

Es wurden keine passenden Produkte gefunden.