Kura Sushi USA, Inc. (KRUS) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Kura Sushi USA, Inc. (KRUS) Bundle
Engineered for accuracy, our (KRUS) DCF Calculator empowers you to assess Kura Sushi USA, Inc. valuation using real-world financial data and offers complete flexibility to modify all essential parameters for enhanced projections.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 45.2 | 64.9 | 141.1 | 187.4 | 237.9 | 358.8 | 541.3 | 816.6 | 1,231.8 | 1,858.3 |
Revenue Growth, % | 0 | 43.67 | 117.42 | 32.84 | 26.91 | 50.85 | 50.85 | 50.85 | 50.85 | 50.85 |
EBITDA | -13.1 | -5.8 | 5.0 | 9.6 | 3.2 | -20.0 | -30.2 | -45.6 | -68.7 | -103.7 |
EBITDA, % | -28.93 | -9 | 3.55 | 5.14 | 1.34 | -5.58 | -5.58 | -5.58 | -5.58 | -5.58 |
Depreciation | 5.5 | 7.2 | 8.8 | 7.8 | 11.8 | 27.7 | 41.8 | 63.0 | 95.1 | 143.4 |
Depreciation, % | 12.15 | 11.07 | 6.24 | 4.18 | 4.96 | 7.72 | 7.72 | 7.72 | 7.72 | 7.72 |
EBIT | -18.6 | -13.0 | -3.8 | 1.8 | -8.6 | -47.7 | -72.0 | -108.6 | -163.8 | -247.1 |
EBIT, % | -41.08 | -20.08 | -2.69 | 0.9625 | -3.61 | -13.3 | -13.3 | -13.3 | -13.3 | -13.3 |
Total Cash | 9.3 | 40.4 | 35.8 | 78.2 | 51.0 | 123.0 | 185.5 | 279.8 | 422.1 | 636.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2.1 | 2.3 | 2.6 | 5.2 | 4.7 | 10.7 | 16.2 | 24.5 | 36.9 | 55.7 |
Account Receivables, % | 4.74 | 3.62 | 1.87 | 2.75 | 1.99 | 2.99 | 2.99 | 2.99 | 2.99 | 2.99 |
Inventories | .4 | .7 | 1.1 | 1.7 | 2.2 | 3.3 | 5.0 | 7.5 | 11.3 | 17.1 |
Inventories, % | 0.81252 | 1.13 | 0.79383 | 0.93209 | 0.9329 | 0.92018 | 0.92018 | 0.92018 | 0.92018 | 0.92018 |
Accounts Payable | 4.9 | 4.9 | 5.6 | 7.2 | 9.0 | 21.6 | 32.5 | 49.1 | 74.0 | 111.7 |
Accounts Payable, % | 10.89 | 7.58 | 3.94 | 3.87 | 3.77 | 6.01 | 6.01 | 6.01 | 6.01 | 6.01 |
Capital Expenditure | -14.5 | .0 | -27.7 | -40.8 | 2.8 | -52.7 | -79.5 | -119.9 | -180.9 | -272.8 |
Capital Expenditure, % | -32.01 | -0.02193216 | -19.61 | -21.77 | 1.16 | -14.68 | -14.68 | -14.68 | -14.68 | -14.68 |
Tax Rate, % | -1.93 | -1.93 | -1.93 | -1.93 | -1.93 | -1.93 | -1.93 | -1.93 | -1.93 | -1.93 |
EBITAT | -19.9 | -13.2 | -4.2 | 1.6 | -8.8 | -46.4 | -70.1 | -105.7 | -159.4 | -240.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -26.5 | -6.6 | -23.1 | -32.9 | 7.5 | -65.9 | -103.9 | -156.8 | -236.5 | -356.8 |
WACC, % | 12.19 | 12.19 | 12.19 | 12.12 | 12.19 | 12.17 | 12.17 | 12.17 | 12.17 | 12.17 |
PV UFCF | ||||||||||
SUM PV UFCF | -602.7 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -371 | |||||||||
Terminal Value | -4,539 | |||||||||
Present Terminal Value | -2,556 | |||||||||
Enterprise Value | -3,158 | |||||||||
Net Debt | 90 | |||||||||
Equity Value | -3,249 | |||||||||
Diluted Shares Outstanding, MM | 11 | |||||||||
Equity Value Per Share | -289.95 |
What You Will Get
- Pre-Filled Financial Model: Kura Sushi USA's actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Instant Calculations: Automatic updates provide immediate results as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as revenue growth, EBITDA %, and capital expenditures.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial outputs.
- High-Precision Estimates: Leverages Kura Sushi's actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Easily explore various assumptions and their impacts on outcomes.
- Efficiency Booster: Streamlines the valuation process, removing the need for intricate model creation.
How It Works
- Download: Obtain the comprehensive Excel file featuring Kura Sushi USA, Inc.'s (KRUS) financial data.
- Customize: Modify predictions such as sales growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly evaluate different outcomes.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose Kura Sushi USA, Inc. (KRUS)?
- Delicious Experience: Enjoy a unique dining experience with our innovative sushi offerings.
- High-Quality Ingredients: We prioritize fresh and premium ingredients to ensure exceptional taste.
- Interactive Dining: Engage with our revolving sushi bar for a fun and interactive meal.
- Commitment to Sustainability: We focus on sustainable practices to protect our oceans and environment.
- Beloved by Customers: Join the community of sushi lovers who trust and enjoy our brand.
Who Should Use This Product?
- Investors: Accurately estimate Kura Sushi USA, Inc.'s (KRUS) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Kura Sushi USA, Inc. (KRUS).
- Consultants: Quickly adapt the template for valuation reports tailored to Kura Sushi USA, Inc. (KRUS) clients.
- Entrepreneurs: Gain insights into financial modeling practices used by leading restaurant companies like Kura Sushi USA, Inc. (KRUS).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies relevant to Kura Sushi USA, Inc. (KRUS).
What the Template Contains
- Pre-Filled Data: Contains Kura Sushi USA, Inc.'s (KRUS) historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for WACC calculations based on user-defined inputs.
- Key Financial Ratios: Evaluate Kura Sushi USA, Inc.'s (KRUS) profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.