Etsy, Inc. (ETSY) DCF Valuation

Etsy, Inc. (ETSY) 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

Etsy, Inc. (ETSY) 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:

Discover Etsy, Inc.'s (ETSY) true value with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and examine how changes affect Etsy, Inc.'s (ETSY) valuation – all within one comprehensive Excel template.


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 818.4 1,725.6 2,329.1 2,566.1 2,748.4 3,794.5 5,238.8 7,232.8 9,985.7 13,786.6
Revenue Growth, % 0 110.86 34.97 10.18 7.1 38.06 38.06 38.06 38.06 38.06
EBITDA 153.0 465.9 555.8 -551.1 398.2 474.8 655.6 905.1 1,249.6 1,725.3
EBITDA, % 18.7 27 23.86 -21.48 14.49 12.51 12.51 12.51 12.51 12.51
Depreciation 48.0 58.2 74.3 96.7 91.3 148.1 204.5 282.4 389.9 538.3
Depreciation, % 5.87 3.37 3.19 3.77 3.32 3.9 3.9 3.9 3.9 3.9
EBIT 105.0 407.7 481.5 -647.8 306.9 326.7 451.1 622.7 859.8 1,187.0
EBIT, % 12.83 23.63 20.67 -25.24 11.17 8.61 8.61 8.61 8.61 8.61
Total Cash 817.3 1,669.2 984.6 1,171.7 1,150.4 2,476.9 3,419.7 4,721.4 6,518.4 8,999.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 65.2 169.4 247.5 261.8 290.1
Account Receivables, % 7.96 9.82 10.63 10.2 10.56
Inventories .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0.000000058 0.0000000429 0.000000039 0 0.000000028 0.000000028 0.000000028 0.000000028 0.000000028
Accounts Payable 76.1 187.7 248.2 262.7 295.3 393.2 542.9 749.6 1,034.9 1,428.7
Accounts Payable, % 9.3 10.88 10.66 10.24 10.74 10.36 10.36 10.36 10.36 10.36
Capital Expenditure -15.3 -7.1 -28.2 -30.7 -39.9 -46.6 -64.3 -88.8 -122.6 -169.3
Capital Expenditure, % -1.87 -0.41202 -1.21 -1.2 -1.45 -1.23 -1.23 -1.23 -1.23 -1.23
Tax Rate, % -5.04 -5.04 -5.04 -5.04 -5.04 -5.04 -5.04 -5.04 -5.04 -5.04
EBITAT 124.8 389.4 503.8 -679.4 322.3 323.8 447.0 617.1 852.0 1,176.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 168.5 447.8 532.4 -613.3 378.0 440.2 594.9 821.3 1,133.9 1,565.5
WACC, % 11.55 11.51 11.55 11.55 11.55 11.54 11.54 11.54 11.54 11.54
PV UFCF
SUM PV UFCF 3,103.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 1,597
Terminal Value 16,730
Present Terminal Value 9,688
Enterprise Value 12,792
Net Debt 1,475
Equity Value 11,317
Diluted Shares Outstanding, MM 140
Equity Value Per Share 80.75

What You Will Get

  • Real ETSY Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Instant Calculations: Intrinsic value and NPV are computed automatically.
  • Scenario Analysis: Explore various scenarios to assess Etsy’s future potential.
  • User-Friendly Interface: Designed for professionals but easy to use for newcomers.

Key Features

  • Customizable Sales Projections: Adjust essential metrics such as marketplace growth, gross merchandise sales, and marketing expenses.
  • Instant DCF Valuation: Quickly computes intrinsic value, net present value (NPV), and additional financial metrics.
  • High-Precision Accuracy: Leverages Etsy’s actual financial data for dependable valuation results.
  • Effortless Scenario Analysis: Evaluate various assumptions and assess results with ease.
  • Efficiency Booster: Streamline the valuation process without the hassle of creating intricate models from the ground up.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based ETSY DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
  3. Instant Calculations: The model automatically recalculates Etsy’s intrinsic value.
  4. Test Scenarios: Experiment with different assumptions to assess potential valuation variations.
  5. Analyze and Decide: Utilize the results to inform your investment or financial analysis.

Why Choose This Etsy Calculator?

  • Accuracy: Utilizes real Etsy financial data for precise calculations.
  • Flexibility: Allows users to experiment and adjust inputs with ease.
  • Time-Saving: Eliminate the need to create a DCF model from the ground up.
  • Professional-Grade: Crafted with the expertise and usability expected by CFOs.
  • User-Friendly: Simple interface designed for users of all financial backgrounds.

Who Should Use Etsy, Inc. (ETSY)?

  • Artisans and Crafters: Showcase your unique products to a global audience on a trusted platform.
  • Small Business Owners: Leverage Etsy's tools to manage and grow your online shop efficiently.
  • Buyers: Discover one-of-a-kind items and support independent creators from around the world.
  • Marketing Professionals: Utilize Etsy's insights to enhance your strategies and reach targeted customers.
  • Students and Educators: Explore real-world applications of e-commerce and entrepreneurship through Etsy's marketplace.

What the Template Contains

  • Pre-Filled Data: Features Etsy’s historical financials and projections.
  • Discounted Cash Flow Model: An 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: Evaluate Etsy’s profitability, efficiency, and leverage.
  • Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
  • Clear Dashboard: Visuals and tables summarizing essential valuation results.

No products were found matching.