Salesforce, Inc. (CRM) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Salesforce, Inc. (CRM) Bundle
As an investor or analyst, the Salesforce, Inc. (CRM) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Salesforce, you can easily adjust forecasts and instantly observe the effects.
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 | 17,098.0 | 21,252.0 | 26,492.0 | 31,352.0 | 34,857.0 | 41,695.6 | 49,875.9 | 59,661.2 | 71,366.1 | 85,367.5 |
Revenue Growth, % | 0 | 24.3 | 24.66 | 18.35 | 11.18 | 19.62 | 19.62 | 19.62 | 19.62 | 19.62 |
EBITDA | 2,598.0 | 3,301.0 | 3,846.0 | 5,644.0 | 9,221.0 | 7,480.3 | 8,947.8 | 10,703.3 | 12,803.2 | 15,315.1 |
EBITDA, % | 15.19 | 15.53 | 14.52 | 18 | 26.45 | 17.94 | 17.94 | 17.94 | 17.94 | 17.94 |
Depreciation | 2,135.0 | 2,846.0 | 3,298.0 | 3,786.0 | 3,222.0 | 4,974.0 | 5,949.9 | 7,117.2 | 8,513.5 | 10,183.8 |
Depreciation, % | 12.49 | 13.39 | 12.45 | 12.08 | 9.24 | 11.93 | 11.93 | 11.93 | 11.93 | 11.93 |
EBIT | 463.0 | 455.0 | 548.0 | 1,858.0 | 5,999.0 | 2,506.2 | 2,997.9 | 3,586.1 | 4,289.7 | 5,131.3 |
EBIT, % | 2.71 | 2.14 | 2.07 | 5.93 | 17.21 | 6.01 | 6.01 | 6.01 | 6.01 | 6.01 |
Total Cash | 7,947.0 | 11,966.0 | 10,537.0 | 12,508.0 | 14,194.0 | 18,610.8 | 22,262.1 | 26,629.7 | 31,854.2 | 38,103.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 6,174.0 | 7,786.0 | 9,739.0 | 10,755.0 | 11,414.0 | 14,723.3 | 17,611.9 | 21,067.2 | 25,200.4 | 30,144.5 |
Account Receivables, % | 36.11 | 36.64 | 36.76 | 34.3 | 32.75 | 35.31 | 35.31 | 35.31 | 35.31 | 35.31 |
Inventories | 926.0 | 1,146.0 | 1,454.0 | 1,776.0 | .0 | 1,831.4 | 2,190.7 | 2,620.5 | 3,134.6 | 3,749.6 |
Inventories, % | 5.42 | 5.39 | 5.49 | 5.66 | 0 | 4.39 | 4.39 | 4.39 | 4.39 | 4.39 |
Accounts Payable | 1,876.0 | 2,616.0 | 2,956.0 | 3,886.0 | 3,239.0 | 4,680.5 | 5,598.7 | 6,697.1 | 8,011.1 | 9,582.8 |
Accounts Payable, % | 10.97 | 12.31 | 11.16 | 12.39 | 9.29 | 11.23 | 11.23 | 11.23 | 11.23 | 11.23 |
Capital Expenditure | -643.0 | -710.0 | -717.0 | -798.0 | -736.0 | -1,206.2 | -1,442.9 | -1,726.0 | -2,064.6 | -2,469.6 |
Capital Expenditure, % | -3.76 | -3.34 | -2.71 | -2.55 | -2.11 | -2.89 | -2.89 | -2.89 | -2.89 | -2.89 |
Tax Rate, % | 16.44 | 16.44 | 16.44 | 16.44 | 16.44 | 16.44 | 16.44 | 16.44 | 16.44 | 16.44 |
EBITAT | 82.6 | 723.5 | 516.5 | 585.6 | 5,012.5 | 1,640.0 | 1,961.7 | 2,346.6 | 2,806.9 | 3,357.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -3,649.4 | 1,767.5 | 1,176.5 | 3,165.6 | 7,968.5 | 1,708.5 | 4,139.1 | 4,951.1 | 5,922.5 | 7,084.4 |
WACC, % | 10.15 | 10.29 | 10.28 | 10.17 | 10.26 | 10.23 | 10.23 | 10.23 | 10.23 | 10.23 |
PV UFCF | ||||||||||
SUM PV UFCF | 17,016.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 7,226 | |||||||||
Terminal Value | 87,788 | |||||||||
Present Terminal Value | 53,940 | |||||||||
Enterprise Value | 70,957 | |||||||||
Net Debt | 5,090 | |||||||||
Equity Value | 65,867 | |||||||||
Diluted Shares Outstanding, MM | 984 | |||||||||
Equity Value Per Share | 66.94 |
What You Will Get
- Real CRM Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Salesforce’s future performance.
- User-Friendly Design: Designed for professionals while remaining accessible to newcomers.
Key Features
- 🔍 Real-Life CRM Financials: Pre-filled historical and projected data for Salesforce, Inc. (CRM).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Salesforce’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Salesforce’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file containing Salesforce's preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Analyze multiple forecasts to evaluate different valuation outcomes.
- 5. Present with Assurance: Deliver professional valuation insights to inform your decisions.
Why Choose Salesforce, Inc. (CRM)?
- Streamlined Processes: Effortlessly manage customer relationships with our intuitive platform.
- Enhanced Insights: Utilize powerful analytics to drive informed decision-making.
- Highly Adaptable: Customize solutions to meet the unique needs of your business.
- User-Friendly Interface: Navigate easily through a clean and organized dashboard.
- Industry Leader: Trusted by thousands of organizations for its reliability and performance.
Who Should Use This Product?
- Investors: Accurately estimate Salesforce’s fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis.
- Consultants: Easily customize the template for valuation reports tailored to clients.
- Entrepreneurs: Gain insights into financial modeling practices employed by leading tech companies.
- Educators: Implement it as a teaching resource to illustrate valuation methodologies.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
- Real-World Data: Salesforce’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Visualizations and tables for clear, actionable insights.