Lemonade, Inc. (LMND) 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
Lemonade, Inc. (LMND) Bundle
Evaluate Lemonade, Inc.'s (LMND) financial outlook like an expert! This (LMND) DCF Calculator provides pre-filled financial data and offers full flexibility to modify revenue growth, WACC, profit margins, and other essential assumptions to align with your projections.
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 | 67.3 | 94.4 | 128.4 | 256.7 | 429.8 | 691.6 | 1,112.8 | 1,790.7 | 2,881.4 | 4,636.4 |
| Revenue Growth, % | 0 | 40.27 | 36.02 | 99.92 | 67.43 | 60.91 | 60.91 | 60.91 | 60.91 | 60.91 |
| EBITDA | -61.5 | -64.4 | -158.0 | -106.9 | 77.3 | -391.8 | -630.4 | -1,014.5 | -1,632.4 | -2,626.6 |
| EBITDA, % | -91.38 | -68.22 | -123.05 | -41.64 | 17.99 | -56.65 | -56.65 | -56.65 | -56.65 | -56.65 |
| Depreciation | .6 | 1.7 | 3.7 | 12.2 | 20.0 | 20.7 | 33.3 | 53.6 | 86.3 | 138.9 |
| Depreciation, % | 0.89153 | 1.8 | 2.88 | 4.75 | 4.65 | 3 | 3 | 3 | 3 | 3 |
| EBIT | -62.1 | -66.1 | -161.7 | -119.1 | 57.3 | -408.5 | -657.4 | -1,057.8 | -1,702.1 | -2,738.8 |
| EBIT, % | -92.27 | -70.02 | -125.93 | -46.4 | 13.33 | -59.07 | -59.07 | -59.07 | -59.07 | -59.07 |
| Total Cash | 330.6 | 577.4 | 1,072.4 | 1,032.6 | 264.5 | 638.4 | 1,027.2 | 1,652.9 | 2,659.7 | 4,279.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 74.7 | 140.5 | 231.3 | 179.6 | .0 | 511.7 | 823.4 | 1,325.0 | 2,132.0 | 3,430.6 |
| Account Receivables, % | 111 | 148.83 | 180.14 | 69.96 | 0 | 73.99 | 73.99 | 73.99 | 73.99 | 73.99 |
| Inventories | -382.0 | -663.8 | -595.1 | -1,662.7 | .0 | -553.3 | -890.3 | -1,432.5 | -2,305.1 | -3,709.1 |
| Inventories, % | -567.61 | -703.18 | -463.47 | -647.72 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 4.6 | 14.4 | 19.7 | 19.5 | 23.8 | 69.9 | 112.5 | 181.1 | 291.4 | 468.9 |
| Accounts Payable, % | 6.84 | 15.25 | 15.34 | 7.6 | 5.54 | 10.11 | 10.11 | 10.11 | 10.11 | 10.11 |
| Capital Expenditure | -3.3 | -4.4 | -9.4 | -10.1 | -9.2 | -31.8 | -51.1 | -82.2 | -132.3 | -212.9 |
| Capital Expenditure, % | -4.9 | -4.66 | -7.32 | -3.93 | -2.14 | -4.59 | -4.59 | -4.59 | -4.59 | -4.59 |
| Tax Rate, % | -3.09 | -3.09 | -3.09 | -3.09 | -3.09 | -3.09 | -3.09 | -3.09 | -3.09 | -3.09 |
| EBITAT | -62.4 | -66.9 | -167.0 | -120.3 | 59.1 | -408.5 | -657.4 | -1,057.8 | -1,702.1 | -2,738.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 246.8 | 156.2 | -326.9 | 1,000.9 | -1,408.9 | -331.9 | -607.2 | -977.1 | -1,572.2 | -2,529.9 |
| WACC, % | 12.24 | 12.24 | 12.24 | 12.24 | 12.24 | 12.24 | 12.24 | 12.24 | 12.24 | 12.24 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -3,879.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -2,580 | |||||||||
| Terminal Value | -25,193 | |||||||||
| Present Terminal Value | -14,141 | |||||||||
| Enterprise Value | -18,020 | |||||||||
| Net Debt | -221 | |||||||||
| Equity Value | -17,799 | |||||||||
| Diluted Shares Outstanding, MM | 70 | |||||||||
| Equity Value Per Share | -255.51 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Lemonade, Inc.'s (LMND) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life LMND Financials: Pre-filled historical and projected data for Lemonade, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Lemonade’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Lemonade’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Lemonade, Inc.'s (LMND) pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as premium growth, loss ratios, and expense ratios (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the results and leverage the outputs for your investment strategies.
Why Choose This Calculator for Lemonade, Inc. (LMND)?
- Accuracy: Leverages real Lemonade financials to ensure precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use Lemonade, Inc. (LMND)?
- Investors: Gain insights into the insurance market with a forward-thinking platform.
- Insurance Analysts: Streamline your analysis with data-driven tools tailored for the industry.
- Consultants: Effortlessly customize reports and presentations for clients in the insurance sector.
- Tech Enthusiasts: Explore innovative insurance solutions that leverage cutting-edge technology.
- Educators and Students: Utilize it as a valuable resource in courses related to insurtech and finance.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Lemonade, Inc. (LMND) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Lemonade, Inc. (LMND).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.