Schmitt Industries, Inc. (SMIT) DCF Valuation

Schmitt Industries, Inc. (SMIT) DCF Valuation
  • ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • ✓ Aucune Expertise N'Est Requise; Facile À Suivre

Schmitt Industries, Inc. (SMIT) 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 Schmitt Industries, Inc. (SMIT) valuation analysis using our cutting-edge DCF Calculator! This Excel template comes preloaded with real SMIT data, enabling you to modify forecasts and assumptions to accurately determine Schmitt Industries' intrinsic value.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2018		 AY2
2019		 AY3
2020		 AY4
2021		 AY5
2022		 FY1
2023		 FY2
2024		 FY3
2025		 FY4
2026		 FY5
2027
Revenue 13.9 13.8 4.2 7.9 9.9 11.0 12.1 13.5 14.9 16.5
Revenue Growth, % 0 -0.56093 -69.66 87.7 25.8 10.82 10.82 10.82 10.82 10.82
EBITDA .2 -1.3 -1.7 -8.6 -3.2 -4.0 -4.4 -4.9 -5.4 -6.0
EBITDA, % 1.12 -9.23 -40.47 -109.05 -32.4 -36.2 -36.2 -36.2 -36.2 -36.2
Depreciation .2 .2 .2 .4 .4 .4 .4 .4 .5 .6
Depreciation, % 1.48 1.25 3.85 5.64 4.42 3.33 3.33 3.33 3.33 3.33
EBIT .0 -1.4 -1.9 -9.0 -3.6 -4.2 -4.7 -5.2 -5.7 -6.3
EBIT, % -0.35906 -10.48 -44.32 -114.69 -36.82 -38.4 -38.4 -38.4 -38.4 -38.4
Total Cash 2.1 1.4 10.1 4.0 1.1 4.1 4.5 5.0 5.6 6.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 2.0 .6 .6 .7 .8
Account Receivables, % 14.74 4.57 13.72 9.5 7.6
Inventories 5.7 5.0 1.1 1.6 1.4 3.0 3.3 3.7 4.1 4.5
Inventories, % 41.12 36.34 25.28 19.75 14.59 27.42 27.42 27.42 27.42 27.42
Accounts Payable 1.0 .1 .3 .6 .8 .7 .7 .8 .9 1.0
Accounts Payable, % 7.38 0.74269 6.39 7.4 8.54 6.09 6.09 6.09 6.09 6.09
Capital Expenditure .0 .0 .0 -1.4 -1.0 -.6 -.7 -.8 -.9 -1.0
Capital Expenditure, % -0.06096603 -0.04687129 -0.78717 -17.86 -10.08 -5.77 -5.77 -5.77 -5.77 -5.77
Tax Rate, % 11 11 11 11 11 11 11 11 11 11
EBITAT .0 -1.5 -1.8 -8.6 -3.2 -4.0 -4.4 -4.9 -5.4 -6.0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -6.6 -.1 2.5 -9.9 -3.4 -6.3 -5.1 -5.6 -6.2 -6.9
WACC, % 3.97 4.45 4.42 4.24 3.97 4.21 4.21 4.21 4.21 4.21
PV UFCF
SUM PV UFCF -26.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -7
Terminal Value -319
Present Terminal Value -259
Enterprise Value -286
Net Debt 17
Equity Value -303
Diluted Shares Outstanding, MM 4
Equity Value Per Share -79.65

What You Will Get

  • Real SMIT 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 automatically.
  • Scenario Analysis: Evaluate various scenarios to assess Schmitt Industries' future performance.
  • User-Friendly Design: Tailored for professionals while remaining approachable for newcomers.

Key Features

  • Real-Life SMIT Data: Pre-filled with Schmitt Industries' historical financials and forward-looking projections.
  • Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
  • Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
  • Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
  • User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.

How It Works

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

Why Choose This Calculator for Schmitt Industries, Inc. (SMIT)?

  • Accuracy: Utilizes real Schmitt Industries financials to ensure precise data.
  • Flexibility: Crafted for users to easily test and adjust inputs as needed.
  • Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
  • Professional-Grade: Engineered with CFO-level accuracy and user-friendliness in focus.
  • User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling Schmitt Industries, Inc. (SMIT) stock.
  • Financial Analysts: Streamline valuation processes with ready-to-use financial models for Schmitt Industries, Inc. (SMIT).
  • Consultants: Deliver professional valuation insights on Schmitt Industries, Inc. (SMIT) to clients quickly and accurately.
  • Business Owners: Understand how companies like Schmitt Industries, Inc. (SMIT) are valued to guide your own strategy.
  • Finance Students: Learn valuation techniques using real-world data and scenarios related to Schmitt Industries, Inc. (SMIT).

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Schmitt Industries historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for Schmitt Industries, Inc. (SMIT).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.