Quad/Graphics, Inc. (QUAD) 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
Quad/Graphics, Inc. (QUAD) Bundle
Enhance your valuation analysis for Quad/Graphics, Inc. (QUAD) with our cutting-edge DCF Calculator! Loaded with real (QUAD) data, this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of Quad/Graphics, 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,923.4 | 2,929.6 | 2,960.4 | 3,217.0 | 2,957.7 | 2,782.7 | 2,618.0 | 2,463.1 | 2,317.3 | 2,180.2 |
| Revenue Growth, % | 0 | -25.33 | 1.05 | 8.67 | -8.06 | -5.92 | -5.92 | -5.92 | -5.92 | -5.92 |
| EBITDA | 219.7 | 150.4 | 245.6 | 252.2 | 156.2 | 178.9 | 168.3 | 158.4 | 149.0 | 140.2 |
| EBITDA, % | 5.6 | 5.13 | 8.3 | 7.84 | 5.28 | 6.43 | 6.43 | 6.43 | 6.43 | 6.43 |
| Depreciation | 209.5 | 181.6 | 157.3 | 141.3 | 128.8 | 142.5 | 134.0 | 126.1 | 118.6 | 111.6 |
| Depreciation, % | 5.34 | 6.2 | 5.31 | 4.39 | 4.35 | 5.12 | 5.12 | 5.12 | 5.12 | 5.12 |
| EBIT | 10.2 | -31.2 | 88.3 | 110.9 | 27.4 | 36.5 | 34.3 | 32.3 | 30.4 | 28.6 |
| EBIT, % | 0.25998 | -1.06 | 2.98 | 3.45 | 0.9264 | 1.31 | 1.31 | 1.31 | 1.31 | 1.31 |
| Total Cash | 78.7 | 55.2 | 179.9 | 25.2 | 52.9 | 69.8 | 65.7 | 61.8 | 58.1 | 54.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 456.1 | 399.1 | 362.0 | 372.6 | 316.2 | 332.5 | 312.8 | 294.3 | 276.9 | 260.5 |
| Account Receivables, % | 11.63 | 13.62 | 12.23 | 11.58 | 10.69 | 11.95 | 11.95 | 11.95 | 11.95 | 11.95 |
| Inventories | 210.5 | 170.2 | 226.2 | 260.7 | 178.8 | 183.5 | 172.6 | 162.4 | 152.8 | 143.7 |
| Inventories, % | 5.37 | 5.81 | 7.64 | 8.1 | 6.05 | 6.59 | 6.59 | 6.59 | 6.59 | 6.59 |
| Accounts Payable | 416.7 | 320.0 | 367.3 | 456.6 | 373.6 | 338.2 | 318.2 | 299.4 | 281.7 | 265.0 |
| Accounts Payable, % | 10.62 | 10.92 | 12.41 | 14.19 | 12.63 | 12.16 | 12.16 | 12.16 | 12.16 | 12.16 |
| Capital Expenditure | -111.0 | -61.0 | -50.0 | -60.3 | -70.8 | -60.5 | -56.9 | -53.5 | -50.4 | -47.4 |
| Capital Expenditure, % | -2.83 | -2.08 | -1.69 | -1.87 | -2.39 | -2.17 | -2.17 | -2.17 | -2.17 | -2.17 |
| Tax Rate, % | -30.05 | -30.05 | -30.05 | -30.05 | -30.05 | -30.05 | -30.05 | -30.05 | -30.05 | -30.05 |
| EBITAT | 7.1 | -31.3 | 71.0 | 58.3 | 35.6 | 29.3 | 27.6 | 26.0 | 24.4 | 23.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -144.3 | 89.9 | 206.7 | 183.5 | 148.9 | 55.0 | 115.3 | 108.4 | 102.0 | 96.0 |
| WACC, % | 9.24 | 11.46 | 10.04 | 8.02 | 11.46 | 10.04 | 10.04 | 10.04 | 10.04 | 10.04 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 355.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 98 | |||||||||
| Terminal Value | 1,217 | |||||||||
| Present Terminal Value | 754 | |||||||||
| Enterprise Value | 1,110 | |||||||||
| Net Debt | 572 | |||||||||
| Equity Value | 538 | |||||||||
| Diluted Shares Outstanding, MM | 48 | |||||||||
| Equity Value Per Share | 11.11 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Quad/Graphics, Inc. (QUAD)’s 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, validating strategies, and enhancing efficiency.
Key Features
- Customizable Financial Metrics: Adjust essential inputs such as revenue forecasts, operating margins, and capital investments.
- Instant DCF Valuation: Provides immediate calculations for intrinsic value, net present value, and additional financial metrics.
- High-Precision Accuracy: Leverages Quad/Graphics, Inc.'s (QUAD) actual financial data for realistic valuation assessments.
- Effortless Scenario Analysis: Easily explore various assumptions and analyze different outcomes.
- Efficiency Booster: Streamline the valuation process without the hassle of creating complex models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based QUAD DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Quad/Graphics’ intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation fluctuations.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose Quad/Graphics, Inc. (QUAD)?
- Streamlined Processes: Eliminate the hassle of building from the ground up – our tools are ready for immediate use.
- Enhanced Precision: Access to accurate data and proven formulas minimizes valuation discrepancies.
- Completely Adaptable: Modify the tools to align with your specific assumptions and forecasts.
- User-Friendly Design: Intuitive visuals and outputs facilitate straightforward analysis of results.
- Endorsed by Professionals: Crafted for industry experts who prioritize accuracy and functionality.
Who Should Use Quad/Graphics, Inc. (QUAD)?
- Individual Investors: Gain insights for making informed decisions regarding investments in Quad/Graphics, Inc. (QUAD).
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for Quad/Graphics, Inc. (QUAD).
- Consultants: Provide clients with accurate and timely valuation assessments of Quad/Graphics, Inc. (QUAD).
- Business Owners: Learn from the valuation strategies of established companies like Quad/Graphics, Inc. (QUAD) to refine your own business approach.
- Finance Students: Explore real-world valuation techniques using data and case studies related to Quad/Graphics, Inc. (QUAD).
What the Template Contains
- Pre-Filled Data: Includes Quad/Graphics, Inc.'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 Quad/Graphics, Inc.'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.