1-800-FLOWERS.COM, Inc. (FLWS) 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
1-800-FLOWERS.COM, Inc. (FLWS) Bundle
Designed for accuracy, our (FLWS) DCF Calculator empowers you to assess the valuation of 1-800-FLOWERS.COM, Inc. using real-time financial data and complete flexibility to modify all key variables for improved forecasts.
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,489.6 | 2,122.2 | 2,207.9 | 2,017.9 | 1,831.4 | 1,962.6 | 2,103.2 | 2,253.9 | 2,415.4 | 2,588.4 |
Revenue Growth, % | 0 | 42.47 | 4.04 | -8.61 | -9.24 | 7.16 | 7.16 | 7.16 | 7.16 | 7.16 |
EBITDA | 112.8 | 197.5 | 85.8 | 17.9 | 58.5 | 97.5 | 104.5 | 112.0 | 120.0 | 128.6 |
EBITDA, % | 7.57 | 9.31 | 3.89 | 0.88495 | 3.19 | 4.97 | 4.97 | 4.97 | 4.97 | 4.97 |
Depreciation | 32.5 | 42.5 | 49.1 | 53.7 | 53.8 | 47.1 | 50.5 | 54.1 | 58.0 | 62.1 |
Depreciation, % | 2.18 | 2 | 2.22 | 2.66 | 2.93 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 |
EBIT | 80.3 | 155.0 | 36.8 | -35.8 | 4.7 | 50.4 | 54.0 | 57.9 | 62.0 | 66.5 |
EBIT, % | 5.39 | 7.3 | 1.67 | -1.77 | 0.25778 | 2.57 | 2.57 | 2.57 | 2.57 | 2.57 |
Total Cash | 240.5 | 173.6 | 31.5 | 126.8 | 159.4 | 159.9 | 171.4 | 183.6 | 196.8 | 210.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 15.2 | 20.8 | 23.8 | 20.4 | 18.0 | 19.9 | 21.3 | 22.9 | 24.5 | 26.3 |
Account Receivables, % | 1.02 | 0.98155 | 1.08 | 1.01 | 0.98415 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 |
Inventories | 97.8 | 153.9 | 247.6 | 191.3 | 176.6 | 173.3 | 185.7 | 199.0 | 213.3 | 228.6 |
Inventories, % | 6.56 | 7.25 | 11.21 | 9.48 | 9.64 | 8.83 | 8.83 | 8.83 | 8.83 | 8.83 |
Accounts Payable | 25.3 | 57.4 | 57.4 | 52.6 | 80.0 | 54.9 | 58.8 | 63.0 | 67.5 | 72.4 |
Accounts Payable, % | 1.7 | 2.71 | 2.6 | 2.61 | 4.37 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 |
Capital Expenditure | -34.7 | -55.2 | -66.4 | -44.6 | -38.6 | -48.1 | -51.6 | -55.3 | -59.2 | -63.5 |
Capital Expenditure, % | -2.33 | -2.6 | -3.01 | -2.21 | -2.11 | -2.45 | -2.45 | -2.45 | -2.45 | -2.45 |
Tax Rate, % | -3.44 | -3.44 | -3.44 | -3.44 | -3.44 | -3.44 | -3.44 | -3.44 | -3.44 | -3.44 |
EBITAT | 60.8 | 123.3 | 35.0 | -34.2 | 4.9 | 45.0 | 48.2 | 51.6 | 55.3 | 59.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -29.0 | 81.0 | -79.1 | 29.6 | 64.6 | 20.2 | 37.2 | 39.9 | 42.7 | 45.8 |
WACC, % | 8.75 | 8.82 | 9.08 | 9.09 | 9.16 | 8.98 | 8.98 | 8.98 | 8.98 | 8.98 |
PV UFCF | ||||||||||
SUM PV UFCF | 140.7 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 47 | |||||||||
Terminal Value | 864 | |||||||||
Present Terminal Value | 562 | |||||||||
Enterprise Value | 703 | |||||||||
Net Debt | 150 | |||||||||
Equity Value | 553 | |||||||||
Diluted Shares Outstanding, MM | 65 | |||||||||
Equity Value Per Share | 8.56 |
What You Will Get
- Real FLWS Financials: Access historical and projected data to ensure precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess 1-800-FLOWERS.COM’s future performance.
- User-Friendly Design: Designed for industry experts while remaining approachable for newcomers.
Key Features
- Comprehensive Floral Data: Gain access to reliable pre-loaded historical performance metrics and future growth forecasts.
- Adjustable Business Assumptions: Modify highlighted cells for key metrics such as revenue growth, cost of goods sold, and operating margins.
- Real-Time Analytics: Automatic recalculations for Discounted Cash Flow (DCF), Net Present Value (NPV), and profit margin analysis.
- User-Friendly Dashboard: Intuitive charts and summaries designed to help you interpret your valuation outcomes effortlessly.
- Suitable for All Skill Levels: A straightforward, user-centric design tailored for investors, financial analysts, and business consultants.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review 1-800-FLOWERS.COM, Inc.'s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Evaluate the outputs and leverage the results for investment decisions regarding 1-800-FLOWERS.COM, Inc. (FLWS).
Why Choose This Floral Service?
- Convenient and User-Friendly: Perfect for both novice and seasoned users.
- Customizable Options: Tailor your selections to suit your specific gifting needs.
- Real-Time Availability: Get instant updates on flower and gift availability as you shop.
- Ready-to-Order: Features a wide array of pre-arranged floral options for quick selection.
- Preferred by Customers: Trusted by many for delivering quality flowers and gifts.
Who Should Use This Product?
- Floral Retail Professionals: Create comprehensive pricing strategies for floral arrangements and gifts.
- Marketing Teams: Analyze customer trends to enhance promotional campaigns for 1-800-FLOWERS.COM (FLWS).
- Event Planners: Utilize accurate floral cost estimates to budget for weddings and corporate events.
- Students and Educators: Explore real-life case studies to learn about e-commerce and supply chain management.
- Gift Enthusiasts: Discover how floral and gift services like 1-800-FLOWERS.COM (FLWS) operate in the market.
What the Template Contains
- Preloaded FLWS 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.