SunOpta Inc. (STKL) DCF Valuation

SunOpta Inc. (STKL) 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

SunOpta Inc. (STKL) 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 insights into your SunOpta Inc. (STKL) valuation analysis using our sophisticated DCF Calculator! This Excel template comes preloaded with real STKL data, enabling you to adjust forecasts and assumptions for an accurate calculation of SunOpta Inc.'s intrinsic value.


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 1,190.0 789.2 812.6 934.7 630.3 554.3 487.4 428.6 376.9 331.4
Revenue Growth, % 0 -33.68 2.97 15.02 -32.56 -12.07 -12.07 -12.07 -12.07 -12.07
EBITDA 44.0 11.2 36.1 41.3 38.2 22.2 19.5 17.2 15.1 13.3
EBITDA, % 3.7 1.41 4.44 4.42 6.06 4.01 4.01 4.01 4.01 4.01
Depreciation 29.3 30.3 34.6 23.0 31.0 19.9 17.5 15.4 13.5 11.9
Depreciation, % 2.46 3.84 4.26 2.47 4.92 3.59 3.59 3.59 3.59 3.59
EBIT 14.8 -19.1 1.4 18.3 7.2 2.3 2.0 1.8 1.6 1.4
EBIT, % 1.24 -2.43 0.17696 1.95 1.14 0.41704 0.41704 0.41704 0.41704 0.41704
Total Cash 1.5 .3 .2 .7 .3 .3 .3 .3 .2 .2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 79.3 79.7 93.0 59.5 69.6
Account Receivables, % 6.66 10.09 11.44 6.37 11.04
Inventories 323.5 147.7 220.1 207.0 83.2 120.1 105.6 92.9 81.7 71.8
Inventories, % 27.19 18.72 27.09 22.15 13.2 21.67 21.67 21.67 21.67 21.67
Accounts Payable 64.1 73.2 105.4 76.0 75.8 53.0 46.6 41.0 36.0 31.7
Accounts Payable, % 5.39 9.28 12.97 8.13 12.02 9.56 9.56 9.56 9.56 9.56
Capital Expenditure -32.8 -24.8 -83.4 -128.6 -46.1 -41.3 -36.3 -31.9 -28.1 -24.7
Capital Expenditure, % -2.75 -3.14 -10.26 -13.76 -7.32 -7.45 -7.45 -7.45 -7.45 -7.45
Tax Rate, % -838.89 -838.89 -838.89 -838.89 -838.89 -838.89 -838.89 -838.89 -838.89 -838.89
EBITAT -3.4 -18.1 .8 14.7 67.4 1.5 1.3 1.2 1.0 .9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -345.7 172.0 -101.5 -73.8 165.9 -60.5 -3.2 -2.9 -2.5 -2.2
WACC, % 9.16 11.08 10.29 10.79 11.2 10.5 10.5 10.5 10.5 10.5
PV UFCF
SUM PV UFCF -62.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -2
Terminal Value -26
Present Terminal Value -16
Enterprise Value -79
Net Debt 379
Equity Value -457
Diluted Shares Outstanding, MM 114
Equity Value Per Share -4.00

What You Will Get

  • Editable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: SunOpta Inc.'s (STKL) financial data pre-filled to facilitate your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
  • Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • Comprehensive Data: SunOpta Inc.'s historical financial statements and detailed forecasts.
  • Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
  • Real-Time Insights: View SunOpta Inc.'s intrinsic value update instantly.
  • Visual Analytics: Interactive dashboard charts showcase valuation results and essential metrics.
  • Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.

How It Works

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

Why Choose SunOpta Inc. (STKL)?

  • Save Time: No need to conduct extensive research – our resources are readily available.
  • Enhance Accuracy: Dependable data and analytics minimize errors in your assessments.
  • Completely Customizable: Adjust our offerings to align with your specific needs and forecasts.
  • Simple to Understand: Intuitive visuals and outputs facilitate easy interpretation of results.
  • Endorsed by Professionals: Crafted for experts who prioritize accuracy and efficiency.

Who Should Use This Product?

  • Investors: Evaluate SunOpta Inc.’s (STKL) market position before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
  • Startup Founders: Understand the valuation strategies of established companies like SunOpta Inc.
  • Consultants: Provide detailed valuation analyses and reports for clients in the food industry.
  • Students and Educators: Utilize current market data to explore and teach valuation principles.

What the Template Contains

  • Pre-Filled Data: Includes SunOpta Inc.’s historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Analyze SunOpta Inc.’s profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.

Es wurden keine passenden Produkte gefunden.