Brunswick Corporation (BC) 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
Brunswick Corporation (BC) Bundle
Gain mastery over your Brunswick Corporation (BC) valuation analysis with our cutting-edge DCF Calculator! Featuring real BC data preloaded, this Excel template enables you to adjust forecasts and assumptions for a precise calculation of Brunswick's intrinsic value.
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 | 4,108.4 | 4,347.5 | 5,846.2 | 6,812.2 | 6,401.4 | 7,214.1 | 8,130.1 | 9,162.3 | 10,325.6 | 11,636.6 |
| Revenue Growth, % | 0 | 5.82 | 34.47 | 16.52 | -6.03 | 12.7 | 12.7 | 12.7 | 12.7 | 12.7 |
| EBITDA | 324.9 | 693.5 | 980.5 | 1,183.3 | 1,014.5 | 1,065.5 | 1,200.8 | 1,353.3 | 1,525.1 | 1,718.7 |
| EBITDA, % | 7.91 | 15.95 | 16.77 | 17.37 | 15.85 | 14.77 | 14.77 | 14.77 | 14.77 | 14.77 |
| Depreciation | 138.7 | 153.4 | 178.1 | 231.2 | 272.9 | 254.1 | 286.3 | 322.7 | 363.6 | 409.8 |
| Depreciation, % | 3.38 | 3.53 | 3.05 | 3.39 | 4.26 | 3.52 | 3.52 | 3.52 | 3.52 | 3.52 |
| EBIT | 186.2 | 540.1 | 802.4 | 952.1 | 741.6 | 811.5 | 914.5 | 1,030.6 | 1,161.5 | 1,308.9 |
| EBIT, % | 4.53 | 12.42 | 13.73 | 13.98 | 11.58 | 11.25 | 11.25 | 11.25 | 11.25 | 11.25 |
| Total Cash | 321.1 | 576.3 | 355.3 | 600.1 | 468.6 | 624.4 | 703.7 | 793.1 | 893.8 | 1,007.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 331.8 | 337.6 | 485.3 | 543.0 | 493.2 | 574.5 | 647.5 | 729.7 | 822.3 | 926.7 |
| Account Receivables, % | 8.08 | 7.77 | 8.3 | 7.97 | 7.7 | 7.96 | 7.96 | 7.96 | 7.96 | 7.96 |
| Inventories | 824.5 | 711.8 | 1,208.0 | 1,471.4 | 1,476.8 | 1,468.4 | 1,654.9 | 1,865.0 | 2,101.7 | 2,368.6 |
| Inventories, % | 20.07 | 16.37 | 20.66 | 21.6 | 23.07 | 20.35 | 20.35 | 20.35 | 20.35 | 20.35 |
| Accounts Payable | 393.5 | 457.6 | 693.5 | 662.6 | 558.0 | 727.3 | 819.7 | 923.7 | 1,041.0 | 1,173.2 |
| Accounts Payable, % | 9.58 | 10.53 | 11.86 | 9.73 | 8.72 | 10.08 | 10.08 | 10.08 | 10.08 | 10.08 |
| Capital Expenditure | -232.6 | -182.4 | -267.1 | -388.3 | -289.3 | -355.6 | -400.7 | -451.6 | -509.0 | -573.6 |
| Capital Expenditure, % | -5.66 | -4.2 | -4.57 | -5.7 | -4.52 | -4.93 | -4.93 | -4.93 | -4.93 | -4.93 |
| Tax Rate, % | 33.15 | 33.15 | 33.15 | 33.15 | 33.15 | 33.15 | 33.15 | 33.15 | 33.15 | 33.15 |
| EBITAT | -396.6 | 425.8 | 646.5 | 755.1 | 495.7 | 495.9 | 558.9 | 629.8 | 709.8 | 799.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,253.3 | 567.8 | 149.5 | 246.0 | 419.1 | 490.8 | 277.4 | 312.7 | 352.3 | 397.1 |
| WACC, % | 7.39 | 8.66 | 8.69 | 8.67 | 8.47 | 8.37 | 8.37 | 8.37 | 8.37 | 8.37 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,455.8 | |||||||||
| Long Term Growth Rate, % | 1.00 | |||||||||
| Free cash flow (T + 1) | 401 | |||||||||
| Terminal Value | 5,439 | |||||||||
| Present Terminal Value | 3,639 | |||||||||
| Enterprise Value | 5,094 | |||||||||
| Net Debt | 2,125 | |||||||||
| Equity Value | 2,970 | |||||||||
| Diluted Shares Outstanding, MM | 71 | |||||||||
| Equity Value Per Share | 42.12 |
What You Will Get
- Real BC Financials: Access to both historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures to fit your analysis.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Brunswick Corporation's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Customizable Financial Metrics: Adjust essential factors like sales growth, operating margin, and capital investments.
- Instant DCF Analysis: Quickly computes intrinsic value, net present value (NPV), and other financial metrics.
- High-Precision Valuation: Leverages Brunswick Corporation's (BC) actual financial data for accurate valuation results.
- Effortless Scenario Testing: Evaluate various assumptions and analyze results with ease.
- Efficiency Booster: Avoid the complexity of creating detailed valuation models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based BC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Brunswick Corporation’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial decisions.
Why Choose This Calculator for Brunswick Corporation (BC)?
- Accurate Data: Utilize real Brunswick Corporation financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants focused on Brunswick Corporation (BC).
- User-Friendly: Designed with an intuitive layout and step-by-step guidance for all users.
Who Should Use This Product?
- Investors: Accurately assess Brunswick Corporation’s (BC) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for accurate financial reporting and analysis related to Brunswick Corporation (BC).
- Consultants: Easily modify the template for valuation reports tailored to clients interested in Brunswick Corporation (BC).
- Entrepreneurs: Discover financial modeling techniques employed by leading companies like Brunswick Corporation (BC).
- Educators: Implement it as a teaching resource to illustrate valuation methodologies using Brunswick Corporation (BC) as a case study.
What the Template Contains
- Preloaded BC Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.