Molecular Templates, Inc. (MTEM) DCF Valuation

Molecular Templates, Inc. (MTEM) 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

Molecular Templates, Inc. (MTEM) 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:

Gain mastery over your Molecular Templates, Inc. (MTEM) valuation analysis using our sophisticated DCF Calculator! Loaded with real MTEM data, this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of Molecular Templates, Inc. (MTEM).


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 19.5 15.6 38.7 19.8 57.3 76.1 101.1 134.2 178.3 236.8
Revenue Growth, % 0 -19.82 147.5 -48.95 190.1 32.81 32.81 32.81 32.81 32.81
EBITDA -66.0 -99.0 -72.9 -80.1 1.4 -60.5 -80.4 -106.7 -141.7 -188.2
EBITDA, % -338.6 -633.23 -188.49 -405.4 2.5 -79.5 -79.5 -79.5 -79.5 -79.5
Depreciation 2.1 4.2 6.7 7.8 6.9 16.2 21.5 28.6 38.0 50.4
Depreciation, % 10.77 26.86 17.31 39.49 12.06 21.3 21.3 21.3 21.3 21.3
EBIT -68.1 -103.2 -79.6 -87.9 -5.5 -62.3 -82.8 -110.0 -146.0 -193.9
EBIT, % -349.37 -660.1 -205.8 -444.89 -9.56 -81.91 -81.91 -81.91 -81.91 -81.91
Total Cash 125.1 93.9 143.0 61.0 11.5 63.9 84.9 112.8 149.8 198.9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 7.5 .2 .0 .0 .3
Account Receivables, % 38.5 1.5 0 0 0.43625
Inventories 6.8 6.1 .0 .0 .0 11.2 14.9 19.8 26.3 35.0
Inventories, % 34.97 38.89 0 0 0 14.77 14.77 14.77 14.77 14.77
Accounts Payable 1.5 2.4 1.6 .5 1.5 4.9 6.5 8.6 11.4 15.1
Accounts Payable, % 7.51 15.03 4.17 2.55 2.66 6.38 6.38 6.38 6.38 6.38
Capital Expenditure -9.6 -7.4 -4.0 -3.2 -.2 -18.8 -25.0 -33.2 -44.1 -58.5
Capital Expenditure, % -49.48 -47.28 -10.33 -16.19 -0.349 -24.73 -24.73 -24.73 -24.73 -24.73
Tax Rate, % 0.13522 0.13522 0.13522 0.13522 0.13522 0.13522 0.13522 0.13522 0.13522 0.13522
EBITAT -68.2 -103.2 -76.1 -87.9 -5.5 -61.8 -82.0 -108.9 -144.7 -192.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -88.6 -97.5 -67.8 -84.4 2.0 -78.2 -89.6 -119.0 -158.1 -209.9
WACC, % 21.26 21.26 20.34 21.26 21.24 21.07 21.07 21.07 21.07 21.07
PV UFCF
SUM PV UFCF -347.0
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -214
Terminal Value -1,123
Present Terminal Value -432
Enterprise Value -779
Net Debt 1
Equity Value -779
Diluted Shares Outstanding, MM 5
Equity Value Per Share -173.12

What You Will Get

  • Real MTEM Financial Data: Pre-filled with Molecular Templates’ historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See Molecular Templates’ intrinsic value update instantly based on your changes.
  • Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
  • User-Friendly Design: Simple structure and clear instructions for all experience levels.

Key Features

  • 🔍 Real-Life MTEM Financials: Pre-filled historical and projected data for Molecular Templates, Inc.
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate Molecular Templates’ intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize Molecular Templates’ valuation instantly after making changes.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Molecular Templates, Inc. (MTEM) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Molecular Templates, Inc. (MTEM)’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for Molecular Templates, Inc. (MTEM)?

  • Accuracy: Utilizes actual Molecular Templates financial data for precise calculations.
  • Flexibility: Allows users to easily adjust and experiment with various inputs.
  • Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
  • Professional-Grade: Crafted with the expertise and attention to detail expected at the CFO level.
  • User-Friendly: Intuitive design makes it accessible for users with limited financial modeling skills.

Who Should Use This Product?

  • Individual Investors: Gain insights to make informed decisions regarding investments in Molecular Templates, Inc. (MTEM).
  • Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for Molecular Templates, Inc. (MTEM).
  • Consultants: Provide clients with accurate and timely valuation insights related to Molecular Templates, Inc. (MTEM).
  • Business Owners: Learn about the valuation of biotech firms like Molecular Templates, Inc. (MTEM) to inform your own business strategies.
  • Finance Students: Explore valuation methodologies using real-world examples from Molecular Templates, Inc. (MTEM).

What the Template Contains

  • Pre-Filled Data: Includes Molecular Templates, Inc.'s (MTEM) historical financials and projections.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for (MTEM).
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs relevant to (MTEM).
  • Key Financial Ratios: Analyze (MTEM)'s profitability, efficiency, and leverage metrics.
  • Customizable Inputs: Easily adjust revenue growth, profit margins, and tax rates for (MTEM).
  • Clear Dashboard: Visuals and tables summarizing key valuation outcomes for (MTEM).

No products were found matching.