|
Arthur J. Gallagher & Co. (AJG) DCF Valuation
US | Financial Services | Insurance - Brokers | NYSE
|
- ✓ 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
Arthur J. Gallagher & Co. (AJG) Bundle
Whether you’re an investor or analyst, this [AJG] DCF Calculator is your essential tool for accurate valuation. Preloaded with Arthur J. Gallagher & Co. real data, you can adjust forecasts and observe the effects in real-time.
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 | 7,195.0 | 7,003.6 | 8,209.4 | 8,550.6 | 10,071.9 | 10,991.1 | 11,994.1 | 13,088.7 | 14,283.2 | 15,586.8 |
| Revenue Growth, % | 0 | -2.66 | 17.22 | 4.16 | 17.79 | 9.13 | 9.13 | 9.13 | 9.13 | 9.13 |
| EBITDA | 1,310.9 | 1,563.9 | 2,039.1 | 2,349.5 | 2,178.3 | 2,516.8 | 2,746.5 | 2,997.1 | 3,270.7 | 3,569.2 |
| EBITDA, % | 18.22 | 22.33 | 24.84 | 27.48 | 21.63 | 22.9 | 22.9 | 22.9 | 22.9 | 22.9 |
| Depreciation | 6,235.2 | 5,817.5 | 6,739.4 | 6,753.2 | 696.5 | 7,423.7 | 8,101.2 | 8,840.5 | 9,647.3 | 10,527.7 |
| Depreciation, % | 86.66 | 83.06 | 82.09 | 78.98 | 6.92 | 67.54 | 67.54 | 67.54 | 67.54 | 67.54 |
| EBIT | -4,924.3 | -4,253.6 | -4,700.3 | -4,403.7 | 1,481.8 | -4,906.8 | -5,354.7 | -5,843.3 | -6,376.6 | -6,958.5 |
| EBIT, % | -68.44 | -60.73 | -57.26 | -51.5 | 14.71 | -44.64 | -44.64 | -44.64 | -44.64 | -44.64 |
| Total Cash | 604.8 | 664.6 | 402.6 | 342.3 | 971.5 | 801.2 | 874.3 | 954.1 | 1,041.2 | 1,136.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 5,891.7 | 6,893.1 | 12,393.0 | 2,911.1 | 3,786.6 | 7,736.6 | 8,442.7 | 9,213.2 | 10,054.0 | 10,971.5 |
| Account Receivables, % | 81.89 | 98.42 | 150.96 | 34.05 | 37.6 | 70.39 | 70.39 | 70.39 | 70.39 | 70.39 |
| Inventories | 2,019.1 | 2,909.7 | 4,063.7 | 4,621.9 | .0 | 3,806.5 | 4,153.9 | 4,533.0 | 4,946.6 | 5,398.1 |
| Inventories, % | 28.06 | 41.55 | 49.5 | 54.05 | 0 | 34.63 | 34.63 | 34.63 | 34.63 | 34.63 |
| Accounts Payable | 6,348.5 | 7,784.6 | 13,845.6 | 18,698.2 | .0 | 8,534.2 | 9,313.1 | 10,163.0 | 11,090.5 | 12,102.6 |
| Accounts Payable, % | 88.23 | 111.15 | 168.66 | 218.68 | 0 | 77.65 | 77.65 | 77.65 | 77.65 | 77.65 |
| Capital Expenditure | -138.8 | -99.3 | -128.6 | -182.7 | -193.6 | -197.2 | -215.2 | -234.9 | -256.3 | -279.7 |
| Capital Expenditure, % | -1.93 | -1.42 | -1.57 | -2.14 | -1.92 | -1.79 | -1.79 | -1.79 | -1.79 | -1.79 |
| Tax Rate, % | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 |
| EBITAT | -5,260.1 | -3,999.1 | -4,371.1 | -3,697.5 | 1,212.2 | -4,443.5 | -4,849.0 | -5,291.5 | -5,774.5 | -6,301.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -726.0 | 1,263.2 | 1,646.8 | 16,649.3 | -13,236.7 | 3,560.7 | 2,762.3 | 3,014.4 | 3,289.5 | 3,589.7 |
| WACC, % | 7.48 | 7.45 | 7.44 | 7.4 | 7.39 | 7.43 | 7.43 | 7.43 | 7.43 | 7.43 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 13,116.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 3,662 | |||||||||
| Terminal Value | 67,416 | |||||||||
| Present Terminal Value | 47,110 | |||||||||
| Enterprise Value | 60,226 | |||||||||
| Net Debt | 7,346 | |||||||||
| Equity Value | 52,881 | |||||||||
| Diluted Shares Outstanding, MM | 219 | |||||||||
| Equity Value Per Share | 241.13 |
What You Will Receive
- Comprehensive Financial Model: Utilize Arthur J. Gallagher & Co. (AJG)’s actual data for accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other essential variables.
- Real-Time Calculations: Instant updates allow you to view results as you adjust parameters.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Adaptable and Repeatable: Designed for versatility, enabling ongoing use for in-depth forecasts.
Key Features
- Accurate Financial Data for AJG: Gain access to reliable historical data and future forecasts tailored for Arthur J. Gallagher & Co. (AJG).
- Tailored Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help you visualize valuation outcomes.
- Designed for All Skill Levels: An intuitive framework suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Arthur J. Gallagher & Co. (AJG).
- Step 2: Review the pre-filled financial data and forecasts for Arthur J. Gallagher & Co. (AJG).
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the results and leverage the outputs for your investment strategies.
Why Choose This Calculator for Arthur J. Gallagher & Co. (AJG)?
- Designed for Experts: A sophisticated tool favored by financial analysts, CFOs, and industry consultants.
- Up-to-Date Data: Comprehensive historical and projected financials for AJG preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly model various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance leads you through each calculation.
Who Should Use This Product?
- Investors: Evaluate Arthur J. Gallagher & Co.'s (AJG) market position before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts for AJG.
- Insurance Brokers: Understand how leading firms like Arthur J. Gallagher & Co. (AJG) are valued in the industry.
- Consultants: Provide comprehensive valuation analyses and reports for clients in the insurance sector.
- Students and Educators: Utilize current data to learn and teach valuation practices relevant to the insurance industry.
What the Template Contains
- Pre-Filled DCF Model: Arthur J. Gallagher & Co. (AJG)’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Arthur J. Gallagher & Co. (AJG)’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.