CVS Health Corporation (CVS) 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
CVS Health Corporation (CVS) Bundle
Explore the financial potential of CVS Health Corporation (CVS) with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to calculate the intrinsic value of CVS Health Corporation (CVS) and refine your investment approach.
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 | 256,776.0 | 268,706.0 | 292,111.0 | 322,467.0 | 357,776.0 | 373,420.8 | 389,749.7 | 406,792.6 | 424,580.7 | 443,146.7 |
| Revenue Growth, % | 0 | 4.65 | 8.71 | 10.39 | 10.95 | 4.37 | 4.37 | 4.37 | 4.37 | 4.37 |
| EBITDA | 16,403.0 | 17,118.0 | 17,526.0 | 12,347.0 | 18,197.0 | 20,667.7 | 21,571.4 | 22,514.7 | 23,499.2 | 24,526.8 |
| EBITDA, % | 6.39 | 6.37 | 6 | 3.83 | 5.09 | 5.53 | 5.53 | 5.53 | 5.53 | 5.53 |
| Depreciation | 4,371.0 | 4,441.0 | 4,486.0 | 4,224.0 | 4,366.0 | 5,542.3 | 5,784.6 | 6,037.6 | 6,301.6 | 6,577.1 |
| Depreciation, % | 1.7 | 1.65 | 1.54 | 1.31 | 1.22 | 1.48 | 1.48 | 1.48 | 1.48 | 1.48 |
| EBIT | 12,032.0 | 12,677.0 | 13,040.0 | 8,123.0 | 13,831.0 | 15,125.4 | 15,786.8 | 16,477.1 | 17,197.6 | 17,949.7 |
| EBIT, % | 4.69 | 4.72 | 4.46 | 2.52 | 3.87 | 4.05 | 4.05 | 4.05 | 4.05 | 4.05 |
| Total Cash | 8,056.0 | 10,854.0 | 12,525.0 | 15,723.0 | 11,455.0 | 14,594.8 | 15,233.0 | 15,899.1 | 16,594.4 | 17,320.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 19,617.0 | 21,742.0 | 24,431.0 | 27,276.0 | 35,227.0 | 31,665.6 | 33,050.3 | 34,495.5 | 36,003.9 | 37,578.3 |
| Account Receivables, % | 7.64 | 8.09 | 8.36 | 8.46 | 9.85 | 8.48 | 8.48 | 8.48 | 8.48 | 8.48 |
| Inventories | 17,516.0 | 18,496.0 | 17,760.0 | 19,090.0 | 18,025.0 | 22,960.0 | 23,964.0 | 25,011.9 | 26,105.6 | 27,247.1 |
| Inventories, % | 6.82 | 6.88 | 6.08 | 5.92 | 5.04 | 6.15 | 6.15 | 6.15 | 6.15 | 6.15 |
| Accounts Payable | 10,492.0 | 11,138.0 | 12,544.0 | 14,838.0 | 14,897.0 | 15,900.7 | 16,596.0 | 17,321.7 | 18,079.1 | 18,869.7 |
| Accounts Payable, % | 4.09 | 4.15 | 4.29 | 4.6 | 4.16 | 4.26 | 4.26 | 4.26 | 4.26 | 4.26 |
| Capital Expenditure | -2,457.0 | -2,437.0 | -2,520.0 | -2,727.0 | -3,031.0 | -3,300.5 | -3,444.9 | -3,595.5 | -3,752.7 | -3,916.8 |
| Capital Expenditure, % | -0.95687 | -0.90694 | -0.86269 | -0.84567 | -0.84718 | -0.88387 | -0.88387 | -0.88387 | -0.88387 | -0.88387 |
| Tax Rate, % | 25.32 | 25.32 | 25.32 | 25.32 | 25.32 | 25.32 | 25.32 | 25.32 | 25.32 | 25.32 |
| EBITAT | 8,871.9 | 9,315.1 | 9,901.6 | 6,000.4 | 10,329.0 | 11,244.1 | 11,735.8 | 12,249.0 | 12,784.6 | 13,343.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -15,855.1 | 8,860.1 | 11,320.6 | 5,616.4 | 4,837.0 | 13,115.9 | 12,382.2 | 12,923.7 | 13,488.8 | 14,078.6 |
| WACC, % | 4.85 | 4.84 | 4.9 | 4.85 | 4.87 | 4.86 | 4.86 | 4.86 | 4.86 | 4.86 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 57,234.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 14,360 | |||||||||
| Terminal Value | 501,635 | |||||||||
| Present Terminal Value | 395,625 | |||||||||
| Enterprise Value | 452,860 | |||||||||
| Net Debt | 71,189 | |||||||||
| Equity Value | 381,671 | |||||||||
| Diluted Shares Outstanding, MM | 1,290 | |||||||||
| Equity Value Per Share | 295.87 |
What You Will Get
- Real CVS Financial Data: Pre-filled with CVS Health Corporation’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 CVS’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
- Real-Life CVS Data: Pre-filled with CVS Health Corporation's historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop multiple forecast scenarios to evaluate various valuation outcomes.
- User-Friendly Design: Intuitive, organized, and tailored for both professionals and novices.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review CVS Health Corporation’s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose This Calculator for CVS Health Corporation (CVS)?
- Reliable Data: Access to accurate CVS financials ensures trustworthy valuation outcomes.
- Flexible Settings: Tailor essential variables such as growth rates, WACC, and tax rates to fit your forecasts.
- Efficiency Boost: Built-in calculations save you the hassle of starting from the ground up.
- Expert-Level Tool: Crafted for investors, analysts, and financial consultants.
- Easy to Use: User-friendly design and clear, step-by-step guidance cater to all experience levels.
Who Should Use CVS Health Corporation (CVS)?
- Investors: Gain insights into the healthcare market and make informed investment choices with CVS's comprehensive data.
- Healthcare Analysts: Utilize CVS's extensive resources to streamline research and analysis processes.
- Consultants: Easily tailor CVS's offerings for client engagements or strategic presentations.
- Health Enthusiasts: Enhance your knowledge of the pharmaceutical and retail health sectors through CVS's innovative solutions.
- Educators and Students: Leverage CVS as a case study for understanding healthcare management and business practices.
What the Template Contains
- Pre-Filled Data: Contains CVS Health Corporation's historical financials and projections.
- Discounted Cash Flow Model: An editable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using custom inputs.
- Key Financial Ratios: Evaluate CVS's profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.