Tootsie Roll Industries, Inc. (TR) 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
Tootsie Roll Industries, Inc. (TR) Bundle
Whether you’re an investor or analyst, this Tootsie Roll Industries, Inc. (TR) DCF Calculator is your go-to resource for accurate valuation. Preloaded with real data from Tootsie Roll, you can adjust forecasts and instantly view the effects.
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 | 523.6 | 471.1 | 566.0 | 681.4 | 769.4 | 852.9 | 945.4 | 1,048.1 | 1,161.8 | 1,287.9 |
| Revenue Growth, % | 0 | -10.04 | 20.16 | 20.39 | 12.9 | 10.85 | 10.85 | 10.85 | 10.85 | 10.85 |
| EBITDA | 99.3 | 76.4 | 84.7 | 112.9 | 138.5 | 144.5 | 160.2 | 177.6 | 196.8 | 218.2 |
| EBITDA, % | 18.96 | 16.22 | 14.96 | 16.56 | 18 | 16.94 | 16.94 | 16.94 | 16.94 | 16.94 |
| Depreciation | 18.8 | 18.2 | 17.6 | 17.7 | 18.2 | 26.5 | 29.3 | 32.5 | 36.1 | 40.0 |
| Depreciation, % | 3.59 | 3.86 | 3.1 | 2.59 | 2.37 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 |
| EBIT | 80.5 | 58.2 | 67.1 | 95.2 | 120.2 | 118.0 | 130.8 | 145.0 | 160.8 | 178.2 |
| EBIT, % | 15.37 | 12.36 | 11.86 | 13.97 | 15.63 | 13.84 | 13.84 | 13.84 | 13.84 | 13.84 |
| Total Cash | 239.4 | 208.9 | 145.8 | 149.4 | 171.4 | 273.0 | 302.6 | 335.5 | 371.9 | 412.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 48.5 | 45.1 | 58.8 | 62.9 | 64.7 | 79.9 | 88.6 | 98.2 | 108.9 | 120.7 |
| Account Receivables, % | 9.26 | 9.57 | 10.4 | 9.22 | 8.41 | 9.37 | 9.37 | 9.37 | 9.37 | 9.37 |
| Inventories | 59.1 | 59.6 | 55.5 | 84.3 | 94.9 | 99.7 | 110.5 | 122.5 | 135.8 | 150.5 |
| Inventories, % | 11.28 | 12.65 | 9.81 | 12.37 | 12.34 | 11.69 | 11.69 | 11.69 | 11.69 | 11.69 |
| Accounts Payable | 12.7 | 13.0 | 15.0 | 25.2 | 15.8 | 23.2 | 25.7 | 28.5 | 31.6 | 35.0 |
| Accounts Payable, % | 2.43 | 2.77 | 2.64 | 3.7 | 2.06 | 2.72 | 2.72 | 2.72 | 2.72 | 2.72 |
| Capital Expenditure | -20.3 | -18.0 | -31.4 | -23.4 | -26.8 | -34.4 | -38.1 | -42.2 | -46.8 | -51.9 |
| Capital Expenditure, % | -3.87 | -3.81 | -5.55 | -3.43 | -3.48 | -4.03 | -4.03 | -4.03 | -4.03 | -4.03 |
| Tax Rate, % | 23.34 | 23.34 | 23.34 | 23.34 | 23.34 | 23.34 | 23.34 | 23.34 | 23.34 | 23.34 |
| EBITAT | 61.2 | 45.1 | 51.2 | 73.7 | 92.2 | 90.6 | 100.4 | 111.3 | 123.4 | 136.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -35.1 | 48.4 | 29.6 | 45.5 | 61.7 | 70.1 | 74.6 | 82.7 | 91.7 | 101.7 |
| WACC, % | 5.38 | 5.38 | 5.38 | 5.38 | 5.38 | 5.38 | 5.38 | 5.38 | 5.38 | 5.38 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 357.0 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 102 | |||||||||
| Terminal Value | 2,094 | |||||||||
| Present Terminal Value | 1,611 | |||||||||
| Enterprise Value | 1,968 | |||||||||
| Net Debt | -60 | |||||||||
| Equity Value | 2,028 | |||||||||
| Diluted Shares Outstanding, MM | 72 | |||||||||
| Equity Value Per Share | 28.20 |
What You Will Get
- Real Tootsie Roll Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Tootsie Roll Industries, Inc. (TR).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit Tootsie Roll's financial model.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Tootsie Roll's fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to Tootsie Roll Industries, Inc. (TR).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Tootsie Roll's financial analysis.
Key Features
- Real-Life TR Data: Pre-filled with Tootsie Roll's historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, profit 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
- Download the Template: Gain immediate access to the Excel-based TR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Tootsie Roll Industries’ intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the findings to inform your investment or financial analysis.
Why Choose Tootsie Roll Industries, Inc. (TR)?
- Time Efficiency: Skip the hassle of building financial models from the ground up – we provide ready-to-use solutions.
- Enhanced Precision: Our dependable financial data and calculations minimize valuation errors.
- Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
- User-Friendly: Intuitive charts and outputs simplify the analysis of results.
- Endorsed by Professionals: Crafted for industry experts who prioritize accuracy and ease of use.
Who Should Use Tootsie Roll Industries, Inc. (TR)?
- Investors: Make informed choices with insights from a leading confectionery company.
- Market Analysts: Utilize comprehensive data to evaluate market trends and performance.
- Retailers: Adapt promotional strategies based on Tootsie Roll's product offerings and consumer preferences.
- Food Enthusiasts: Explore the brand's rich history and its impact on the candy industry.
- Educators and Students: Incorporate case studies of Tootsie Roll in business and marketing courses.
What the Template Contains
- Preloaded TR Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.