Lightspeed Commerce Inc. (LSPD) 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
Lightspeed Commerce Inc. (LSPD) Bundle
Whether you’re an investor or analyst, this (LSPD) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from Lightspeed Commerce Inc., you can adjust forecasts and instantly observe the effects.
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 | 120.6 | 221.7 | 548.4 | 730.5 | 909.3 | 1,458.2 | 2,338.5 | 3,750.3 | 6,014.4 | 9,645.3 |
| Revenue Growth, % | 0 | 83.8 | 147.32 | 33.21 | 24.47 | 60.37 | 60.37 | 60.37 | 60.37 | 60.37 |
| EBITDA | -34.2 | -95.4 | -208.4 | -936.2 | -49.2 | -626.5 | -1,004.7 | -1,611.3 | -2,584.1 | -4,144.1 |
| EBITDA, % | -28.39 | -43.02 | -38 | -128.16 | -5.41 | -42.96 | -42.96 | -42.96 | -42.96 | -42.96 |
| Depreciation | 12.6 | 38.4 | 104.8 | 112.8 | 109.6 | 216.8 | 347.7 | 557.6 | 894.3 | 1,434.1 |
| Depreciation, % | 10.44 | 17.31 | 19.11 | 15.44 | 12.06 | 14.87 | 14.87 | 14.87 | 14.87 | 14.87 |
| EBIT | -46.8 | -133.8 | -313.1 | -1,049.0 | -158.8 | -798.3 | -1,280.3 | -2,053.1 | -3,292.6 | -5,280.4 |
| EBIT, % | -38.83 | -60.33 | -57.1 | -143.59 | -17.47 | -54.75 | -54.75 | -54.75 | -54.75 | -54.75 |
| Total Cash | 211.0 | 807.2 | 953.7 | 800.2 | 722.1 | 1,398.2 | 2,242.3 | 3,595.9 | 5,766.8 | 9,248.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4.8 | 12.0 | 44.0 | 42.4 | 55.4 | 85.5 | 137.2 | 220.0 | 352.8 | 565.7 |
| Account Receivables, % | 4.01 | 5.39 | 8.03 | 5.8 | 6.09 | 5.87 | 5.87 | 5.87 | 5.87 | 5.87 |
| Inventories | .9 | 1.6 | 7.5 | 12.8 | 16.5 | 18.7 | 30.1 | 48.2 | 77.3 | 124.0 |
| Inventories, % | 0.77257 | 0.70943 | 1.37 | 1.76 | 1.81 | 1.29 | 1.29 | 1.29 | 1.29 | 1.29 |
| Accounts Payable | 12.3 | 22.1 | 39.2 | 37.0 | 33.5 | 105.2 | 168.7 | 270.6 | 434.0 | 695.9 |
| Accounts Payable, % | 10.22 | 9.96 | 7.16 | 5.06 | 3.68 | 7.22 | 7.22 | 7.22 | 7.22 | 7.22 |
| Capital Expenditure | -3.6 | -1.8 | -10.7 | -13.1 | -18.2 | -27.8 | -44.6 | -71.6 | -114.7 | -184.0 |
| Capital Expenditure, % | -2.99 | -0.8091 | -1.94 | -1.8 | -2 | -1.91 | -1.91 | -1.91 | -1.91 | -1.91 |
| Tax Rate, % | -2.17 | -2.17 | -2.17 | -2.17 | -2.17 | -2.17 | -2.17 | -2.17 | -2.17 | -2.17 |
| EBITAT | -44.3 | -127.8 | -286.4 | -1,044.8 | -162.3 | -768.2 | -1,231.9 | -1,975.6 | -3,168.4 | -5,081.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -28.7 | -89.2 | -213.2 | -951.1 | -91.0 | -539.9 | -928.3 | -1,488.7 | -2,387.4 | -3,828.7 |
| WACC, % | 17.13 | 17.13 | 17.13 | 17.14 | 17.14 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -5,068.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -3,905 | |||||||||
| Terminal Value | -25,803 | |||||||||
| Present Terminal Value | -11,702 | |||||||||
| Enterprise Value | -16,770 | |||||||||
| Net Debt | -699 | |||||||||
| Equity Value | -16,071 | |||||||||
| Diluted Shares Outstanding, MM | 154 | |||||||||
| Equity Value Per Share | -104.52 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Lightspeed Commerce Inc.’s (LSPD) financial data pre-filled to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- 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
- Comprehensive Financial Data: Lightspeed Commerce Inc.'s historical financial statements and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Instantly view Lightspeed's intrinsic value as it updates live.
- Intuitive Visualizations: Dashboard graphs present valuation outcomes and essential metrics clearly.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing Lightspeed Commerce Inc.'s (LSPD) preloaded data.
- 2. Adjust Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates the intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Present with Confidence: Deliver professional valuation insights to back your decisions.
Why Choose This Calculator for Lightspeed Commerce Inc. (LSPD)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Lightspeed Commerce.
- Flexible Inputs: Modify yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Lightspeed's intrinsic value and Net Present Value.
- Preloaded Information: Access historical and projected data for precise analysis.
- High Standards: Perfect for financial analysts, investors, and business consultants focused on (LSPD).
Who Should Use This Product?
- Investors: Evaluate Lightspeed Commerce Inc.’s (LSPD) market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for (LSPD).
- Startup Founders: Gain insights into how leading companies like Lightspeed Commerce Inc. (LSPD) are appraised.
- Consultants: Provide detailed valuation analyses and reports for clients involving (LSPD).
- Students and Educators: Utilize current data from (LSPD) to enhance learning and practice in valuation strategies.
What the Template Contains
- Historical Data: Includes Lightspeed Commerce Inc.’s (LSPD) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Lightspeed Commerce Inc.’s (LSPD) 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 Lightspeed Commerce Inc.’s (LSPD) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.