|
The Brink's Company (BCO) DCF Valuation
US | Industrials | Security & Protection Services | NYSE
|
- ✓ 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
The Brink's Company (BCO) Bundle
Explore The Brink's Company's (BCO) financial prospects with our user-friendly DCF Calculator! Enter your estimates for growth, margins, and costs to determine The Brink's Company's (BCO) intrinsic value and refine your investment approach.
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,683.2 | 3,690.9 | 4,200.2 | 4,535.5 | 4,874.6 | 5,233.7 | 5,619.3 | 6,033.2 | 6,477.7 | 6,954.9 |
Revenue Growth, % | 0 | 0.20906 | 13.8 | 7.98 | 7.48 | 7.37 | 7.37 | 7.37 | 7.37 | 7.37 |
EBITDA | 364.0 | 373.0 | 576.1 | 613.0 | 739.7 | 653.1 | 701.2 | 752.9 | 808.3 | 867.9 |
EBITDA, % | 9.88 | 10.11 | 13.72 | 13.52 | 15.17 | 12.48 | 12.48 | 12.48 | 12.48 | 12.48 |
Depreciation | 185.0 | 206.8 | 239.5 | 245.8 | 275.8 | 286.9 | 308.0 | 330.7 | 355.0 | 381.2 |
Depreciation, % | 5.02 | 5.6 | 5.7 | 5.42 | 5.66 | 5.48 | 5.48 | 5.48 | 5.48 | 5.48 |
EBIT | 179.0 | 166.2 | 336.6 | 367.2 | 463.9 | 366.3 | 393.2 | 422.2 | 453.3 | 486.7 |
EBIT, % | 4.86 | 4.5 | 8.01 | 8.1 | 9.52 | 7 | 7 | 7 | 7 | 7 |
Total Cash | 311.0 | 620.9 | 710.3 | 972.0 | 1,176.6 | 918.5 | 986.1 | 1,058.8 | 1,136.8 | 1,220.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 661.3 | 598.8 | 612.2 | 733.8 | 796.3 | 850.7 | 913.3 | 980.6 | 1,052.9 | 1,130.4 |
Account Receivables, % | 17.95 | 16.22 | 14.58 | 16.18 | 16.34 | 16.25 | 16.25 | 16.25 | 16.25 | 16.25 |
Inventories | 137.3 | 279.1 | 333.4 | .0 | .0 | 201.3 | 216.1 | 232.0 | 249.1 | 267.4 |
Inventories, % | 3.73 | 7.56 | 7.94 | 0 | 0 | 3.85 | 3.85 | 3.85 | 3.85 | 3.85 |
Accounts Payable | 184.5 | 206.0 | 211.2 | 296.5 | 249.7 | 285.5 | 306.6 | 329.2 | 353.4 | 379.4 |
Accounts Payable, % | 5.01 | 5.58 | 5.03 | 6.54 | 5.12 | 5.46 | 5.46 | 5.46 | 5.46 | 5.46 |
Capital Expenditure | -164.8 | -118.5 | -167.9 | -182.6 | -202.7 | -208.0 | -223.3 | -239.7 | -257.4 | -276.3 |
Capital Expenditure, % | -4.47 | -3.21 | -4 | -4.03 | -4.16 | -3.97 | -3.97 | -3.97 | -3.97 | -3.97 |
Tax Rate, % | 62.81 | 62.81 | 62.81 | 62.81 | 62.81 | 62.81 | 62.81 | 62.81 | 62.81 | 62.81 |
EBITAT | 55.5 | 47.6 | 150.4 | 276.9 | 172.5 | 158.9 | 170.6 | 183.2 | 196.7 | 211.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -538.4 | 78.1 | 159.5 | 637.2 | 136.3 | 18.0 | 198.9 | 213.5 | 229.2 | 246.1 |
WACC, % | 6.69 | 6.63 | 7.03 | 7.79 | 6.84 | 6.99 | 6.99 | 6.99 | 6.99 | 6.99 |
PV UFCF | ||||||||||
SUM PV UFCF | 715.3 | |||||||||
Long Term Growth Rate, % | 3.50 | |||||||||
Free cash flow (T + 1) | 255 | |||||||||
Terminal Value | 7,291 | |||||||||
Present Terminal Value | 5,200 | |||||||||
Enterprise Value | 5,915 | |||||||||
Net Debt | 2,700 | |||||||||
Equity Value | 3,215 | |||||||||
Diluted Shares Outstanding, MM | 47 | |||||||||
Equity Value Per Share | 68.56 |
What You Will Get
- Real BCO Financials: Access historical and projected data for precise valuation.
- Adjustable Inputs: Customize WACC, tax rates, revenue growth, and capital expenditures.
- Automatic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess The Brink's Company's future performance.
- Clear and Intuitive Design: Designed for professionals while remaining user-friendly for newcomers.
Key Features
- Pre-Loaded Data: The Brink's Company’s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: View The Brink's Company’s intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and key metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Step 1: Download the prebuilt Excel template featuring The Brink's Company’s (BCO) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the key metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including The Brink's Company’s (BCO) intrinsic value.
- Step 5: Make informed investment choices or create reports based on the outputs.
Why Choose This Calculator for The Brink's Company (BCO)?
- Accuracy: Utilizes real financial data from The Brink's Company for reliable results.
- Flexibility: Tailored for users to easily adjust and test various inputs.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and precision expected at the CFO level.
- User-Friendly: Intuitive interface suitable for users regardless of financial modeling background.
Who Should Use This Product?
- Security Industry Professionals: Develop comprehensive and accurate risk assessment models for investment analysis.
- Corporate Finance Departments: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Financial Advisors: Offer clients precise valuation insights for The Brink's Company (BCO) stock.
- Students and Instructors: Utilize real-world data to enhance learning and practice in financial modeling.
- Investors in Security Services: Gain insights into how companies like The Brink's Company (BCO) are valued in the market.
What the Template Contains
- Pre-Filled Data: Includes The Brink's Company’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze The Brink's Company’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.