Marathon Petroleum Corporation (MPC) 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
Marathon Petroleum Corporation (MPC) Bundle
Looking to assess the intrinsic value of Marathon Petroleum Corporation? Our (MPC) DCF Calculator integrates real-world data with comprehensive customization features, enabling you to refine your projections and make more informed investment choices.
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 | 111,275.0 | 69,896.0 | 120,451.0 | 178,236.0 | 149,348.0 | 174,329.7 | 203,490.2 | 237,528.4 | 277,260.2 | 323,638.1 |
Revenue Growth, % | 0 | -37.19 | 72.33 | 47.97 | -16.21 | 16.73 | 16.73 | 16.73 | 16.73 | 16.73 |
EBITDA | 8,290.0 | -8,904.0 | 7,425.0 | 22,965.0 | 18,646.0 | 9,150.6 | 10,681.2 | 12,467.8 | 14,553.4 | 16,987.7 |
EBITDA, % | 7.45 | -12.74 | 6.16 | 12.88 | 12.48 | 5.25 | 5.25 | 5.25 | 5.25 | 5.25 |
Depreciation | 3,225.0 | 3,375.0 | 3,308.0 | 3,215.0 | 3,307.0 | 5,052.5 | 5,897.7 | 6,884.2 | 8,035.7 | 9,379.8 |
Depreciation, % | 2.9 | 4.83 | 2.75 | 1.8 | 2.21 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 |
EBIT | 5,065.0 | -12,279.0 | 4,117.0 | 19,750.0 | 15,339.0 | 4,098.0 | 4,783.5 | 5,583.7 | 6,517.7 | 7,607.9 |
EBIT, % | 4.55 | -17.57 | 3.42 | 11.08 | 10.27 | 2.35 | 2.35 | 2.35 | 2.35 | 2.35 |
Total Cash | 1,527.0 | 555.0 | 10,839.0 | 11,770.0 | 10,224.0 | 8,582.0 | 10,017.6 | 11,693.2 | 13,649.2 | 15,932.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 7,233.0 | 5,760.0 | 11,034.0 | 13,477.0 | 11,619.0 | 13,682.3 | 15,971.0 | 18,642.5 | 21,760.8 | 25,400.8 |
Account Receivables, % | 6.5 | 8.24 | 9.16 | 7.56 | 7.78 | 7.85 | 7.85 | 7.85 | 7.85 | 7.85 |
Inventories | 10,243.0 | 7,999.0 | 8,055.0 | 8,827.0 | 9,317.0 | 13,433.0 | 15,679.9 | 18,302.8 | 21,364.3 | 24,937.9 |
Inventories, % | 9.21 | 11.44 | 6.69 | 4.95 | 6.24 | 7.71 | 7.71 | 7.71 | 7.71 | 7.71 |
Accounts Payable | 11,222.0 | 7,803.0 | 13,700.0 | 15,312.0 | 13,761.0 | 17,582.0 | 20,523.0 | 23,955.9 | 27,963.1 | 32,640.5 |
Accounts Payable, % | 10.08 | 11.16 | 11.37 | 8.59 | 9.21 | 10.09 | 10.09 | 10.09 | 10.09 | 10.09 |
Capital Expenditure | -4,810.0 | -2,787.0 | -1,464.0 | -2,420.0 | -1,890.0 | -4,235.7 | -4,944.3 | -5,771.3 | -6,736.7 | -7,863.5 |
Capital Expenditure, % | -4.32 | -3.99 | -1.22 | -1.36 | -1.27 | -2.43 | -2.43 | -2.43 | -2.43 | -2.43 |
Tax Rate, % | 30.8 | 30.8 | 30.8 | 30.8 | 30.8 | 30.8 | 30.8 | 30.8 | 30.8 | 30.8 |
EBITAT | 2,867.0 | -9,951.7 | 1,882.4 | 14,006.1 | 10,615.3 | 2,651.4 | 3,094.9 | 3,612.6 | 4,216.8 | 4,922.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -4,972.0 | -9,065.7 | 4,293.4 | 13,198.1 | 11,849.3 | 1,109.9 | 2,453.6 | 2,864.0 | 3,343.1 | 3,902.3 |
WACC, % | 8.08 | 8.45 | 7.91 | 8.29 | 8.27 | 8.2 | 8.2 | 8.2 | 8.2 | 8.2 |
PV UFCF | ||||||||||
SUM PV UFCF | 10,453.5 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 3,922 | |||||||||
Terminal Value | 50,940 | |||||||||
Present Terminal Value | 34,352 | |||||||||
Enterprise Value | 44,805 | |||||||||
Net Debt | 23,058 | |||||||||
Equity Value | 21,747 | |||||||||
Diluted Shares Outstanding, MM | 409 | |||||||||
Equity Value Per Share | 53.17 |
What You Will Get
- Real Marathon Petroleum Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Marathon Petroleum’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Real-Life MPC Data: Pre-filled with Marathon Petroleum’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: Generate multiple forecast scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive, organized, and crafted for both professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template with Marathon Petroleum Corporation's (MPC) data included.
- Step 2: Explore the pre-filled sheets to understand the key metrics relevant to (MPC).
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins) for (MPC).
- Step 4: Instantly view recalculated results, including Marathon Petroleum Corporation's (MPC) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs for (MPC).
Why Choose This Calculator for Marathon Petroleum Corporation (MPC)?
- Accurate Data: Access to real Marathon Petroleum financials ensures dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the energy sector.
- User-Friendly: An intuitive design and guided instructions make it accessible for all users.
Who Should Utilize Marathon Petroleum Corporation (MPC)?
- Investors: Gain insights into the energy sector with a reliable resource for investment decisions.
- Financial Analysts: Streamline your analysis with comprehensive data on petroleum market trends.
- Consultants: Easily modify reports and presentations tailored to client needs in the energy industry.
- Energy Enthusiasts: Enhance your knowledge of the petroleum sector through detailed case studies and reports.
- Educators and Students: Leverage it as a valuable educational resource in energy economics and finance courses.
What the Template Contains
- Pre-Filled DCF Model: Marathon Petroleum Corporation’s (MPC) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Marathon Petroleum Corporation’s (MPC) 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.