Pitney Bowes Inc. (PBI) 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
Pitney Bowes Inc. (PBI) Bundle
Gain insight into your Pitney Bowes Inc. (PBI) valuation analysis using our powerful DCF Calculator! Equipped with up-to-date data for (PBI), this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of Pitney Bowes Inc.
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 | 3,205.1 | 3,554.1 | 3,673.6 | 3,538.0 | 3,266.3 | 3,289.9 | 3,313.6 | 3,337.4 | 3,361.5 | 3,385.7 |
| Revenue Growth, % | 0 | 10.89 | 3.36 | -3.69 | -7.68 | 0.72023 | 0.72023 | 0.72023 | 0.72023 | 0.72023 |
| EBITDA | 207.7 | 83.0 | 108.5 | 148.6 | -135.9 | 77.7 | 78.2 | 78.8 | 79.4 | 79.9 |
| EBITDA, % | 6.48 | 2.34 | 2.95 | 4.2 | -4.16 | 2.36 | 2.36 | 2.36 | 2.36 | 2.36 |
| Depreciation | 159.1 | 160.6 | 162.9 | 163.8 | 160.4 | 154.4 | 155.5 | 156.6 | 157.7 | 158.9 |
| Depreciation, % | 4.97 | 4.52 | 4.43 | 4.63 | 4.91 | 4.69 | 4.69 | 4.69 | 4.69 | 4.69 |
| EBIT | 48.5 | -77.6 | -54.4 | -15.2 | -296.3 | -76.7 | -77.2 | -77.8 | -78.4 | -78.9 |
| EBIT, % | 1.51 | -2.18 | -1.48 | -0.43077 | -9.07 | -2.33 | -2.33 | -2.33 | -2.33 | -2.33 |
| Total Cash | 1,040.3 | 940.4 | 746.9 | 681.2 | 623.2 | 773.7 | 779.2 | 784.9 | 790.5 | 796.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 373.5 | 980.5 | 909.2 | 917.3 | 906.3 | 774.2 | 779.8 | 785.4 | 791.1 | 796.8 |
| Account Receivables, % | 11.65 | 27.59 | 24.75 | 25.93 | 27.75 | 23.53 | 23.53 | 23.53 | 23.53 | 23.53 |
| Inventories | 68.3 | 65.8 | 78.6 | 83.7 | 70.1 | 70.0 | 70.5 | 71.0 | 71.5 | 72.0 |
| Inventories, % | 2.13 | 1.85 | 2.14 | 2.37 | 2.14 | 2.13 | 2.13 | 2.13 | 2.13 | 2.13 |
| Accounts Payable | 282.1 | 295.2 | 311.0 | 315.4 | 282.4 | 283.8 | 285.8 | 287.9 | 290.0 | 292.1 |
| Accounts Payable, % | 8.8 | 8.31 | 8.47 | 8.91 | 8.65 | 8.63 | 8.63 | 8.63 | 8.63 | 8.63 |
| Capital Expenditure | -137.3 | -105.0 | -184.0 | -124.8 | -102.9 | -124.5 | -125.4 | -126.3 | -127.2 | -128.1 |
| Capital Expenditure, % | -4.28 | -2.95 | -5.01 | -3.53 | -3.15 | -3.78 | -3.78 | -3.78 | -3.78 | -3.78 |
| Tax Rate, % | 5.14 | 5.14 | 5.14 | 5.14 | 5.14 | 5.14 | 5.14 | 5.14 | 5.14 | 5.14 |
| EBITAT | 71.8 | -80.4 | 25.7 | -14.1 | -281.1 | -59.4 | -59.9 | -60.3 | -60.7 | -61.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -65.9 | -616.4 | 78.9 | 16.0 | -231.9 | 104.0 | -33.8 | -34.1 | -34.3 | -34.6 |
| WACC, % | 9.01 | 9.01 | 4.66 | 8.69 | 8.79 | 8.04 | 8.04 | 8.04 | 8.04 | 8.04 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -8.4 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | -36 | |||||||||
| Terminal Value | -789 | |||||||||
| Present Terminal Value | -536 | |||||||||
| Enterprise Value | -544 | |||||||||
| Net Debt | 1,883 | |||||||||
| Equity Value | -2,427 | |||||||||
| Diluted Shares Outstanding, MM | 176 | |||||||||
| Equity Value Per Share | -13.82 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real PBI financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Pitney Bowes' valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive PBI Data: Pre-loaded with Pitney Bowes’ historical financial performance and future projections.
- Flexible Input Options: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures as needed.
- Adaptive Valuation Model: Real-time updates to Net Present Value (NPV) and intrinsic value based on user inputs.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Designed to be straightforward and accessible for both seasoned professionals and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based PBI DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional factors.
- Instant Calculations: The model automatically recalculates Pitney Bowes' intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose Pitney Bowes Inc. (PBI)?
- Streamlined Operations: Leverage our solutions to enhance efficiency without starting from scratch.
- Enhanced Precision: Utilize accurate data and methodologies to minimize errors in logistics and shipping.
- Completely Adaptable: Customize our services to align with your specific business needs and goals.
- User-Friendly Interface: Intuitive dashboards and reports make insights easily accessible.
- Preferred by Industry Leaders: Our solutions are trusted by professionals who prioritize accuracy and functionality.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing Pitney Bowes Inc. (PBI) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients considering Pitney Bowes Inc. (PBI) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling related to Pitney Bowes Inc. (PBI).
- Tech Enthusiasts: Gain insights into the valuation of technology companies like Pitney Bowes Inc. (PBI) in the financial market.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Pitney Bowes Inc. (PBI).
- Real-World Data: Pitney Bowes Inc.’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Pitney Bowes Inc. (PBI).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.