Kirkland's, Inc. (KIRK) DCF Valuation

Kirkland's, Inc. (KIRK) 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

Kirkland's, Inc. (KIRK) 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:

Enhance your investment strategies with the Kirkland's, Inc. (KIRK) DCF Calculator! Utilize actual Kirkland's financial data, adjust growth projections and expenses, and instantly observe how these modifications affect the intrinsic value of Kirkland's, Inc. (KIRK).


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 603.9 543.5 558.2 498.8 468.7 440.6 414.2 389.4 366.0 344.1
Revenue Growth, % 0 -10 2.7 -10.63 -6.04 -5.99 -5.99 -5.99 -5.99 -5.99
EBITDA -24.4 31.9 46.1 -25.9 -11.9 2.1 2.0 1.8 1.7 1.6
EBITDA, % -4.04 5.87 8.26 -5.19 -2.55 0.47116 0.47116 0.47116 0.47116 0.47116
Depreciation 27.7 23.3 20.4 16.5 12.0 16.2 15.2 14.3 13.5 12.7
Depreciation, % 4.59 4.28 3.66 3.31 2.56 3.68 3.68 3.68 3.68 3.68
EBIT -52.1 8.7 25.7 -42.4 -23.9 -14.1 -13.3 -12.5 -11.7 -11.0
EBIT, % -8.63 1.59 4.6 -8.5 -5.1 -3.21 -3.21 -3.21 -3.21 -3.21
Total Cash 30.1 100.3 25.0 5.2 3.8 26.2 24.7 23.2 21.8 20.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 -8.3 .0 .0 .0
Account Receivables, % 0 -1.52 0 0 0
Inventories 94.7 62.1 114.0 84.1 74.1 70.7 66.4 62.4 58.7 55.2
Inventories, % 15.68 11.42 20.43 16.85 15.81 16.04 16.04 16.04 16.04 16.04
Accounts Payable 59.5 55.2 62.5 43.7 46.0 43.9 41.2 38.8 36.5 34.3
Accounts Payable, % 9.86 10.15 11.2 8.77 9.82 9.96 9.96 9.96 9.96 9.96
Capital Expenditure -15.7 -8.7 -7.1 -8.1 -4.8 -7.2 -6.7 -6.3 -5.9 -5.6
Capital Expenditure, % -2.6 -1.6 -1.28 -1.63 -1.02 -1.62 -1.62 -1.62 -1.62 -1.62
Tax Rate, % -1.91 -1.91 -1.91 -1.91 -1.91 -1.91 -1.91 -1.91 -1.91 -1.91
EBITAT -52.8 18.9 22.3 -42.9 -24.4 -13.8 -12.9 -12.2 -11.4 -10.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -75.9 70.0 -17.3 -23.4 -4.9 -2.1 -2.9 -2.7 -2.6 -2.4
WACC, % 5.73 5.73 5.2 5.73 5.73 5.62 5.62 5.62 5.62 5.62
PV UFCF
SUM PV UFCF -10.8
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -2
Terminal Value -68
Present Terminal Value -52
Enterprise Value -62
Net Debt 170
Equity Value -232
Diluted Shares Outstanding, MM 13
Equity Value Per Share -18.06

What You Will Get

  • Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: Kirkland's financial data pre-filled to kickstart your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
  • Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
  • Built for Analysts and Investors: Perfect for testing projections, validating strategies, and optimizing your time.

Key Features

  • Comprehensive Historical Data: Kirkland's, Inc. (KIRK) financial statements and past performance metrics.
  • Customizable Assumptions: Modify discount rates, tax implications, sales growth, and profit margins.
  • Real-Time Valuation: Instantly view the intrinsic value of Kirkland's, Inc. (KIRK) as it updates live.
  • Intuitive Visualizations: Interactive dashboard showcases valuation outcomes and essential indicators.
  • Designed for Precision: A robust tool tailored for analysts, investors, and financial professionals.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Kirkland's, Inc. (KIRK) data.
  • Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
  • Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Instantly see the recalculated results, including Kirkland's, Inc. (KIRK) intrinsic value.
  • Step 5: Utilize the outputs to make informed investment decisions or create detailed reports.

Why Choose This Calculator for Kirkland's, Inc. (KIRK)?

  • Accuracy: Utilizes real Kirkland's financial data for precise calculations.
  • Flexibility: Allows users to easily adjust and experiment with various inputs.
  • Time-Saving: Eliminates the need to create a DCF model from the ground up.
  • Professional-Grade: Crafted with the expertise and standards expected at the CFO level.
  • User-Friendly: Intuitive interface suitable for users with varying levels of financial knowledge.

Who Should Use This Product?

  • Investors: Accurately estimate Kirkland's, Inc. (KIRK) fair value before making investment decisions.
  • CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to Kirkland's, Inc. (KIRK).
  • Consultants: Quickly adapt the template for valuation reports for clients interested in Kirkland's, Inc. (KIRK).
  • Entrepreneurs: Gain insights into financial modeling used by successful retail companies like Kirkland's, Inc. (KIRK).
  • Educators: Use it as a teaching tool to demonstrate valuation methodologies applicable to Kirkland's, Inc. (KIRK).

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Kirkland's, Inc. (KIRK).
  • Real-World Data: Kirkland's historical and projected financials preloaded for thorough analysis.
  • Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into the business.
  • Key Ratios: Integrated analysis for assessing profitability, efficiency, and leverage metrics.
  • Dashboard with Visual Outputs: Graphs and tables designed for clear, actionable results.

No products were found matching.