Fresenius Medical Care AG & Co. KGaA (FMS) 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
Fresenius Medical Care AG & Co. KGaA (FMS) Bundle
Whether you're an investor or analyst, this (FMS) DCF Calculator is your essential tool for accurate valuation. Preloaded with real data from Fresenius Medical Care AG & Co. KGaA, you can adjust forecasts and instantly observe the effects.
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 | 18,215.8 | 18,614.0 | 18,363.8 | 20,218.0 | 20,276.0 | 20,845.0 | 21,430.0 | 22,031.5 | 22,649.7 | 23,285.4 |
| Revenue Growth, % | 0 | 2.19 | -1.34 | 10.1 | 0.28672 | 2.81 | 2.81 | 2.81 | 2.81 | 2.81 |
| EBITDA | 4,090.2 | 4,307.0 | 3,699.2 | 1,646.8 | 3,345.3 | 3,768.0 | 3,873.7 | 3,982.4 | 4,094.2 | 4,209.1 |
| EBITDA, % | 22.45 | 23.14 | 20.14 | 8.15 | 16.5 | 18.08 | 18.08 | 18.08 | 18.08 | 18.08 |
| Depreciation | 1,619.1 | 1,654.0 | 1,652.4 | 1,792.9 | 1,826.0 | 1,861.3 | 1,913.5 | 1,967.2 | 2,022.4 | 2,079.2 |
| Depreciation, % | 8.89 | 8.89 | 9 | 8.87 | 9.01 | 8.93 | 8.93 | 8.93 | 8.93 | 8.93 |
| EBIT | 2,471.2 | 2,653.0 | 2,046.8 | -146.1 | 1,519.3 | 1,906.7 | 1,960.2 | 2,015.2 | 2,071.8 | 2,129.9 |
| EBIT, % | 13.57 | 14.25 | 11.15 | -0.72242 | 7.49 | 9.15 | 9.15 | 9.15 | 9.15 | 9.15 |
| Total Cash | 1,189.3 | 1,295.8 | 1,686.4 | 1,504.8 | 1,604.9 | 1,585.5 | 1,630.0 | 1,675.8 | 1,722.8 | 1,771.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3,743.8 | 3,401.6 | 3,731.8 | 3,877.1 | 3,791.8 | 4,045.0 | 4,158.5 | 4,275.2 | 4,395.2 | 4,518.6 |
| Account Receivables, % | 20.55 | 18.27 | 20.32 | 19.18 | 18.7 | 19.41 | 19.41 | 19.41 | 19.41 | 19.41 |
| Inventories | 1,733.6 | 1,975.4 | 2,124.2 | 2,393.3 | 2,271.3 | 2,281.9 | 2,346.0 | 2,411.8 | 2,479.5 | 2,549.1 |
| Inventories, % | 9.52 | 10.61 | 11.57 | 11.84 | 11.2 | 10.95 | 10.95 | 10.95 | 10.95 | 10.95 |
| Accounts Payable | 788.2 | 828.5 | 853.1 | 930.4 | 874.5 | 931.3 | 957.4 | 984.3 | 1,011.9 | 1,040.3 |
| Accounts Payable, % | 4.33 | 4.45 | 4.65 | 4.6 | 4.31 | 4.47 | 4.47 | 4.47 | 4.47 | 4.47 |
| Capital Expenditure | -2,332.6 | -2,176.3 | -1,754.1 | -1,470.6 | -713.5 | -1,869.5 | -1,921.9 | -1,975.9 | -2,031.3 | -2,088.3 |
| Capital Expenditure, % | -12.81 | -11.69 | -9.55 | -7.27 | -3.52 | -8.97 | -8.97 | -8.97 | -8.97 | -8.97 |
| Tax Rate, % | 51.7 | 51.7 | 51.7 | 51.7 | 51.7 | 51.7 | 51.7 | 51.7 | 51.7 | 51.7 |
| EBITAT | 1,610.7 | 1,595.6 | 1,262.1 | -80.6 | 733.9 | 1,107.7 | 1,138.8 | 1,170.8 | 1,203.7 | 1,237.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -3,792.0 | 1,214.0 | 706.0 | -95.6 | 1,997.8 | 892.4 | 979.0 | 1,006.4 | 1,034.7 | 1,063.7 |
| WACC, % | 4.85 | 4.7 | 4.75 | 4.56 | 4.36 | 4.64 | 4.64 | 4.64 | 4.64 | 4.64 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 4,335.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,085 | |||||||||
| Terminal Value | 41,060 | |||||||||
| Present Terminal Value | 32,725 | |||||||||
| Enterprise Value | 37,060 | |||||||||
| Net Debt | 11,097 | |||||||||
| Equity Value | 25,963 | |||||||||
| Diluted Shares Outstanding, MM | 293 | |||||||||
| Equity Value Per Share | 88.49 |
What You Will Get
- Real FMS Financial Data: Pre-filled with Fresenius Medical Care'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 Fresenius Medical Care'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
- Customizable Financial Inputs: Adjust essential metrics such as patient growth rates, revenue per treatment, and operational costs.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Leverages Fresenius Medical Care’s actual financial data for precise valuation results.
- Effortless Scenario Analysis: Evaluate various scenarios and analyze the results with ease.
- Efficiency Booster: Streamline the valuation process without the need for intricate model development.
How It Works
- Step 1: Download the Excel file for Fresenius Medical Care AG & Co. KGaA (FMS).
- Step 2: Review the pre-filled financial data and forecasts for Fresenius Medical Care.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model refresh in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose Fresenius Medical Care AG & Co. KGaA (FMS)?
- Enhance Efficiency: Quickly access comprehensive healthcare solutions without the hassle of lengthy procedures.
- Boost Reliability: Our advanced medical technologies ensure precise and dependable patient care.
- Highly Adaptable: Customize services to meet the unique needs of healthcare providers and patients.
- User-Friendly Interface: Intuitive designs and clear information streamline the decision-making process.
- Endorsed by Professionals: Preferred by healthcare experts for its commitment to excellence and innovation.
Who Should Use This Product?
- Healthcare Investors: Develop comprehensive valuation models for analyzing Fresenius Medical Care AG & Co. KGaA (FMS) stock.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the healthcare sector.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Fresenius Medical Care AG & Co. KGaA (FMS).
- Students and Educators: Utilize real-world financial data to enhance learning and practice in financial modeling.
- Healthcare Industry Enthusiasts: Gain insights into how healthcare companies like Fresenius Medical Care AG & Co. KGaA (FMS) are valued in the market.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Fresenius Medical Care AG & Co. KGaA (FMS).
- Real-World Data: Fresenius Medical Care's historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Fresenius Medical Care.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results specific to (FMS).