ManpowerGroup Inc. (MAN) 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
ManpowerGroup Inc. (MAN) Bundle
Designed for accuracy, our (MAN) DCF Calculator enables you to evaluate ManpowerGroup Inc. valuation using real-world financial insights and complete flexibility to modify all essential parameters for improved projections.
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 | 20,863.5 | 18,001.0 | 20,724.4 | 19,827.5 | 18,914.5 | 18,558.7 | 18,209.7 | 17,867.2 | 17,531.1 | 17,201.4 |
Revenue Growth, % | 0 | -13.72 | 15.13 | -4.33 | -4.6 | -1.88 | -1.88 | -1.88 | -1.88 | -1.88 |
EBITDA | 807.1 | 267.3 | 680.3 | 688.6 | 374.2 | 522.9 | 513.1 | 503.4 | 493.9 | 484.6 |
EBITDA, % | 3.87 | 1.48 | 3.28 | 3.47 | 1.98 | 2.82 | 2.82 | 2.82 | 2.82 | 2.82 |
Depreciation | 77.2 | 76.3 | 73.4 | 84.6 | 88.6 | 75.8 | 74.4 | 73.0 | 71.6 | 70.3 |
Depreciation, % | 0.37002 | 0.42387 | 0.35417 | 0.42668 | 0.46842 | 0.40863 | 0.40863 | 0.40863 | 0.40863 | 0.40863 |
EBIT | 729.9 | 191.0 | 606.9 | 604.0 | 285.6 | 447.0 | 438.6 | 430.4 | 422.3 | 414.4 |
EBIT, % | 3.5 | 1.06 | 2.93 | 3.05 | 1.51 | 2.41 | 2.41 | 2.41 | 2.41 | 2.41 |
Total Cash | 1,025.8 | 1,567.1 | 847.8 | 639.0 | 581.3 | 891.2 | 874.4 | 858.0 | 841.8 | 826.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 5,273.1 | 4,912.4 | 5,448.2 | 5,137.4 | 4,830.0 | 4,836.4 | 4,745.4 | 4,656.2 | 4,568.6 | 4,482.7 |
Account Receivables, % | 25.27 | 27.29 | 26.29 | 25.91 | 25.54 | 26.06 | 26.06 | 26.06 | 26.06 | 26.06 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0.00000000479 | 0.00000000556 | 0.00000000483 | 0 | 0 | 0.00000000303 | 0.00000000303 | 0.00000000303 | 0.00000000303 | 0.00000000303 |
Accounts Payable | 2,474.9 | 2,527.4 | 3,039.2 | 2,831.4 | 2,723.0 | 2,570.2 | 2,521.8 | 2,474.4 | 2,427.9 | 2,382.2 |
Accounts Payable, % | 11.86 | 14.04 | 14.66 | 14.28 | 14.4 | 13.85 | 13.85 | 13.85 | 13.85 | 13.85 |
Capital Expenditure | -52.9 | -50.7 | -64.2 | -75.6 | -78.2 | -60.9 | -59.7 | -58.6 | -57.5 | -56.4 |
Capital Expenditure, % | -0.25355 | -0.28165 | -0.30978 | -0.38129 | -0.41344 | -0.32794 | -0.32794 | -0.32794 | -0.32794 | -0.32794 |
Tax Rate, % | 56.87 | 56.87 | 56.87 | 56.87 | 56.87 | 56.87 | 56.87 | 56.87 | 56.87 | 56.87 |
EBITAT | 495.9 | 30.8 | 408.5 | 405.3 | 123.2 | 233.9 | 229.5 | 225.2 | 220.9 | 216.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -2,278.0 | 469.6 | 393.7 | 517.3 | 332.6 | 89.6 | 286.8 | 281.4 | 276.1 | 270.9 |
WACC, % | 8.78 | 7.82 | 8.77 | 8.76 | 8.32 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 |
PV UFCF | ||||||||||
SUM PV UFCF | 926.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 276 | |||||||||
Terminal Value | 4,259 | |||||||||
Present Terminal Value | 2,834 | |||||||||
Enterprise Value | 3,760 | |||||||||
Net Debt | 845 | |||||||||
Equity Value | 2,915 | |||||||||
Diluted Shares Outstanding, MM | 50 | |||||||||
Equity Value Per Share | 57.84 |
What You Will Get
- Real MAN Financial Data: Pre-filled with ManpowerGroup’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See ManpowerGroup’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Workforce Data: Access reliable pre-loaded historical metrics and future workforce trends.
- Adjustable Workforce Assumptions: Modify highlighted cells for factors like turnover rates, hiring costs, and productivity metrics.
- Real-Time Analytics: Instant updates to workforce projections, cost analyses, and efficiency assessments.
- Interactive Dashboard: User-friendly charts and summaries to visualize your workforce planning results.
- Suitable for All Levels: An intuitive layout designed for HR professionals, business leaders, and consultants.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered ManpowerGroup Inc. (MAN) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for ManpowerGroup Inc. (MAN)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for ManpowerGroup Inc. (MAN)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your specific analysis.
- Real-Time Updates: Monitor immediate changes to ManpowerGroup’s valuation as you modify inputs.
- Preloaded Data: Comes with ManpowerGroup’s actual financial information for swift evaluations.
- Relied Upon by Experts: Utilized by analysts and investors for well-informed decision-making.
Who Should Use This Product?
- Investors: Assess the fair value of ManpowerGroup Inc. (MAN) to inform your investment choices.
- CFOs: Utilize a high-quality DCF model for accurate financial reporting and analysis.
- Consultants: Effortlessly customize the template for client valuation reports.
- Entrepreneurs: Discover financial modeling techniques employed by leading firms.
- Educators: Employ it as a resource to illustrate valuation methods in the classroom.
What the Template Contains
- Pre-Filled DCF Model: ManpowerGroup Inc.’s (MAN) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate ManpowerGroup Inc.’s (MAN) 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.