Tilly's, Inc. (TLYS) DCF Valuation

Tilly's, Inc. (TLYS) DCF Valuation
  • ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
  • ✓ No Se Necesita Experiencia; Fáciles De Seguir

Tilly's, Inc. (TLYS) 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 insight into your Tilly's, Inc. (TLYS) valuation analysis using our sophisticated DCF Calculator! This Excel template comes preloaded with real (TLYS) data, enabling you to adjust forecasts and assumptions to accurately determine the intrinsic value of Tilly's, Inc. (TLYS).


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 619.3 531.3 775.7 672.3 623.1 640.4 658.3 676.6 695.4 714.8
Revenue Growth, % 0 -14.2 45.99 -13.33 -7.32 2.78 2.78 2.78 2.78 2.78
EBITDA 49.4 16.0 104.4 25.6 -18.1 32.5 33.4 34.3 35.3 36.2
EBITDA, % 7.98 3.01 13.46 3.81 -2.91 5.07 5.07 5.07 5.07 5.07
Depreciation 20.9 19.1 16.8 14.1 12.8 17.0 17.5 18.0 18.5 19.0
Depreciation, % 3.38 3.59 2.17 2.1 2.06 2.66 2.66 2.66 2.66 2.66
EBIT 28.5 -3.0 87.6 11.5 -31.0 15.4 15.9 16.3 16.8 17.2
EBIT, % 4.59 -0.57215 11.29 1.7 -4.97 2.41 2.41 2.41 2.41 2.41
Total Cash 139.9 141.1 139.2 113.3 95.0 127.1 130.6 134.2 138.0 141.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 7.5 8.7 6.7 9.2 5.9
Account Receivables, % 1.21 1.64 0.86439 1.37 0.95445
Inventories 56.9 55.7 65.6 62.1 63.2 60.9 62.5 64.3 66.1 67.9
Inventories, % 9.19 10.48 8.46 9.24 10.14 9.5 9.5 9.5 9.5 9.5
Accounts Payable 20.6 25.0 28.1 16.0 14.5 20.9 21.5 22.1 22.7 23.4
Accounts Payable, % 3.32 4.7 3.63 2.37 2.33 3.27 3.27 3.27 3.27 3.27
Capital Expenditure -14.3 -8.5 -13.4 -15.1 -14.0 -13.0 -13.3 -13.7 -14.1 -14.5
Capital Expenditure, % -2.31 -1.59 -1.73 -2.25 -2.24 -2.02 -2.02 -2.02 -2.02 -2.02
Tax Rate, % -33.78 -33.78 -33.78 -33.78 -33.78 -33.78 -33.78 -33.78 -33.78 -33.78
EBITAT 20.5 -1.4 64.7 8.3 -41.4 11.3 11.6 11.9 12.2 12.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -16.6 13.6 63.3 -3.9 -41.8 22.3 14.4 14.8 15.2 15.7
WACC, % 6.2 5.45 6.25 6.2 7.03 6.23 6.23 6.23 6.23 6.23
PV UFCF
SUM PV UFCF 69.7
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 16
Terminal Value 378
Present Terminal Value 279
Enterprise Value 349
Net Debt 185
Equity Value 165
Diluted Shares Outstanding, MM 30
Equity Value Per Share 5.51

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real TLYS financials.
  • Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Instantly observe how your inputs affect Tilly's valuation.
  • Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.

Key Features

  • Customizable Financial Inputs: Adjust essential metrics such as sales growth, gross margin %, and operating expenses.
  • Instant DCF Valuation: Provides immediate calculations for intrinsic value, NPV, and various financial outputs.
  • High-Precision Accuracy: Leverages Tilly's real-world financial data for authentic valuation results.
  • Effortless Scenario Analysis: Easily explore different scenarios and evaluate their impacts side by side.
  • Efficiency Booster: Streamlines the process, removing the need to construct intricate valuation models from the ground up.

How It Works

  1. Step 1: Download the Excel file for Tilly's, Inc. (TLYS).
  2. Step 2: Review Tilly's pre-filled financial data and forecasts.
  3. Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you modify assumptions.
  5. Step 5: Evaluate the outputs and leverage the results for investment decisions.

Why Choose This Calculator?

  • Accurate Data: Up-to-date Tilly's financials provide dependable valuation outcomes.
  • Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
  • Time-Saving: Pre-configured calculations save you from starting from the ground up.
  • Professional-Grade Tool: Tailored for investors, analysts, and consultants focused on Tilly's, Inc. (TLYS).
  • User-Friendly: Easy-to-navigate design and clear instructions make it accessible for everyone.

Who Should Use This Product?

  • Investors: Accurately assess Tilly's, Inc. (TLYS) fair value prior to making investment choices.
  • CFOs: Utilize a professional-grade DCF model for financial analysis and reporting.
  • Consultants: Quickly modify the template for client valuation reports.
  • Entrepreneurs: Acquire insights into financial modeling techniques employed by leading retail companies.
  • Educators: Implement it as a teaching resource to illustrate valuation methods.

What the Template Contains

  • Historical Data: Includes Tilly's past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Tilly's intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of Tilly's financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.