111, Inc. (YI) 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
111, Inc. (YI) Bundle
Explore the financial future of 111, Inc. (YI) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and costs to determine the intrinsic value of 111, Inc. (YI) and enhance your investment strategy.
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 | 541.4 | 1,123.8 | 1,702.3 | 1,851.7 | 2,047.8 | 2,922.5 | 4,170.7 | 5,952.1 | 8,494.3 | 12,122.4 |
| Revenue Growth, % | 0 | 107.57 | 51.48 | 8.78 | 10.59 | 42.71 | 42.71 | 42.71 | 42.71 | 42.71 |
| EBITDA | -66.0 | -62.9 | -84.2 | -45.2 | -42.6 | -159.4 | -227.4 | -324.6 | -463.2 | -661.0 |
| EBITDA, % | -12.19 | -5.6 | -4.95 | -2.44 | -2.08 | -5.45 | -5.45 | -5.45 | -5.45 | -5.45 |
| Depreciation | 1.6 | 1.9 | 3.7 | 5.6 | 3.0 | 6.6 | 9.4 | 13.5 | 19.2 | 27.5 |
| Depreciation, % | 0.29524 | 0.17087 | 0.21907 | 0.30199 | 0.1457 | 0.22657 | 0.22657 | 0.22657 | 0.22657 | 0.22657 |
| EBIT | -67.6 | -64.8 | -88.0 | -50.8 | -45.6 | -166.0 | -236.9 | -338.1 | -482.4 | -688.5 |
| EBIT, % | -12.49 | -5.77 | -5.17 | -2.74 | -2.23 | -5.68 | -5.68 | -5.68 | -5.68 | -5.68 |
| Total Cash | 84.1 | 204.1 | 115.6 | 120.5 | 89.5 | 300.2 | 428.4 | 611.4 | 872.6 | 1,245.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 12.2 | 24.1 | 67.8 | 82.3 | 88.7 | 100.2 | 143.0 | 204.1 | 291.3 | 415.8 |
| Account Receivables, % | 2.25 | 2.14 | 3.99 | 4.44 | 4.33 | 3.43 | 3.43 | 3.43 | 3.43 | 3.43 |
| Inventories | 66.6 | 105.0 | 153.6 | 205.3 | 194.5 | 299.6 | 427.5 | 610.2 | 870.8 | 1,242.7 |
| Inventories, % | 12.3 | 9.34 | 9.02 | 11.09 | 9.5 | 10.25 | 10.25 | 10.25 | 10.25 | 10.25 |
| Accounts Payable | 60.9 | 147.0 | 184.6 | 241.8 | 217.6 | 344.0 | 490.9 | 700.6 | 999.9 | 1,426.9 |
| Accounts Payable, % | 11.24 | 13.08 | 10.84 | 13.06 | 10.63 | 11.77 | 11.77 | 11.77 | 11.77 | 11.77 |
| Capital Expenditure | -3.4 | -3.5 | -8.6 | -4.3 | -1.3 | -10.2 | -14.5 | -20.7 | -29.5 | -42.1 |
| Capital Expenditure, % | -0.62271 | -0.31092 | -0.50453 | -0.23359 | -0.06572729 | -0.3475 | -0.3475 | -0.3475 | -0.3475 | -0.3475 |
| Tax Rate, % | -11.19 | -11.19 | -11.19 | -11.19 | -11.19 | -11.19 | -11.19 | -11.19 | -11.19 | -11.19 |
| EBITAT | -66.3 | -63.7 | -93.9 | -55.2 | -50.7 | -164.8 | -235.2 | -335.6 | -479.0 | -683.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -86.0 | -29.4 | -153.6 | -62.9 | -68.8 | -158.6 | -264.1 | -376.8 | -537.8 | -767.5 |
| WACC, % | 5.39 | 5.39 | 5.43 | 5.43 | 5.43 | 5.41 | 5.41 | 5.41 | 5.41 | 5.41 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,735.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -783 | |||||||||
| Terminal Value | -22,940 | |||||||||
| Present Terminal Value | -17,625 | |||||||||
| Enterprise Value | -19,360 | |||||||||
| Net Debt | -22 | |||||||||
| Equity Value | -19,338 | |||||||||
| Diluted Shares Outstanding, MM | 84 | |||||||||
| Equity Value Per Share | -229.39 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled financial data for 111, Inc. (YI).
- Accurate Data Insights: Access to historical performance metrics and projected estimates (highlighted in the yellow cells).
- Flexible Forecasting: Modify key assumptions such as revenue growth, EBITDA %, and WACC as needed.
- Instant Calculations: Quickly observe how your inputs affect the valuation of 111, Inc. (YI).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Interface: Organized for simplicity and usability, complete with detailed instructions.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for 111, Inc. (YI).
- WACC Estimator: Features a pre-built Weighted Average Cost of Capital sheet with options for customizable inputs.
- Adjustable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to suit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for 111, Inc. (YI).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based 111, Inc. (YI) DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional factors.
- Instant Calculations: The model automatically recalculates 111, Inc.'s (YI) intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the findings to inform your investment or financial analysis.
Why Choose This Calculator for 111, Inc. (YI)?
- Accurate Data: Up-to-date financials for 111, Inc. ensure dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from scratch.
- Professional-Grade Tool: Ideal for investors, analysts, and consultants focused on 111, Inc. (YI).
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Evaluate 111, Inc. (YI)'s valuation prior to making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Startup Founders: Discover how established companies like 111, Inc. (YI) are assessed in the market.
- Consultants: Provide expert valuation analyses and reports for clients.
- Students and Educators: Utilize current data to practice and instruct on valuation strategies.
What the Template Contains
- Pre-Filled Data: Includes 111, Inc.'s (YI) 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 111, Inc.'s (YI) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.