Portillo's Inc. (PTLO) 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
Portillo's Inc. (PTLO) Bundle
Looking to assess Portillo's Inc. (PTLO) intrinsic value? Our PTLO DCF Calculator merges real-world data with complete customization features, enabling you to refine your forecasts and enhance your 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 | 479.4 | 455.5 | 535.0 | 587.1 | 679.9 | 744.5 | 815.3 | 892.7 | 977.6 | 1,070.5 |
Revenue Growth, % | 0 | -4.99 | 17.45 | 9.75 | 15.81 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 |
EBITDA | 72.8 | 81.2 | 52.8 | 61.5 | 79.8 | 96.9 | 106.1 | 116.2 | 127.3 | 139.4 |
EBITDA, % | 15.18 | 17.83 | 9.87 | 10.48 | 11.74 | 13.02 | 13.02 | 13.02 | 13.02 | 13.02 |
Depreciation | 24.4 | 24.6 | 23.3 | 20.9 | 24.3 | 32.7 | 35.8 | 39.2 | 43.0 | 47.0 |
Depreciation, % | 5.08 | 5.4 | 4.36 | 3.56 | 3.58 | 4.39 | 4.39 | 4.39 | 4.39 | 4.39 |
EBIT | 48.4 | 56.6 | 29.5 | 40.6 | 55.5 | 64.2 | 70.3 | 77.0 | 84.3 | 92.3 |
EBIT, % | 10.1 | 12.43 | 5.51 | 6.91 | 8.17 | 8.63 | 8.63 | 8.63 | 8.63 | 8.63 |
Total Cash | 22.4 | 41.2 | 39.3 | 44.4 | 10.4 | 44.9 | 49.2 | 53.9 | 59.0 | 64.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 3.7 | 5.2 | 7.8 | 8.6 | 14.2 | 10.3 | 11.3 | 12.4 | 13.5 | 14.8 |
Account Receivables, % | 0.76426 | 1.14 | 1.47 | 1.46 | 2.09 | 1.38 | 1.38 | 1.38 | 1.38 | 1.38 |
Inventories | 3.9 | 5.1 | 6.1 | 7.4 | 8.7 | 8.3 | 9.1 | 10.0 | 11.0 | 12.0 |
Inventories, % | 0.81245 | 1.11 | 1.14 | 1.26 | 1.28 | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 |
Accounts Payable | 15.9 | 21.4 | 27.2 | 30.3 | 33.2 | 34.5 | 37.7 | 41.3 | 45.3 | 49.6 |
Accounts Payable, % | 3.31 | 4.7 | 5.09 | 5.16 | 4.88 | 4.63 | 4.63 | 4.63 | 4.63 | 4.63 |
Capital Expenditure | -22.0 | -21.5 | -36.2 | -47.1 | -87.9 | -55.1 | -60.4 | -66.1 | -72.4 | -79.3 |
Capital Expenditure, % | -4.6 | -4.71 | -6.76 | -8.02 | -12.93 | -7.4 | -7.4 | -7.4 | -7.4 | -7.4 |
Tax Rate, % | 34.35 | 34.35 | 34.35 | 34.35 | 34.35 | 34.35 | 34.35 | 34.35 | 34.35 | 34.35 |
EBITAT | -112.2 | -38.2 | 93.9 | 23.2 | 36.5 | 28.6 | 31.3 | 34.3 | 37.6 | 41.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -101.5 | -32.2 | 83.2 | -2.0 | -31.2 | 11.8 | 8.3 | 9.1 | 10.0 | 10.9 |
WACC, % | 6.23 | 6.23 | 8.81 | 7.7 | 7.92 | 7.38 | 7.38 | 7.38 | 7.38 | 7.38 |
PV UFCF | ||||||||||
SUM PV UFCF | 40.6 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 11 | |||||||||
Terminal Value | 336 | |||||||||
Present Terminal Value | 236 | |||||||||
Enterprise Value | 276 | |||||||||
Net Debt | 540 | |||||||||
Equity Value | -264 | |||||||||
Diluted Shares Outstanding, MM | 57 | |||||||||
Equity Value Per Share | -4.60 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Portillo's Inc. (PTLO) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template calculates Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for assessing projections, validating strategies, and enhancing efficiency.
Key Features
- Accurate Financial Data: Gain access to reliable pre-loaded historical records and future forecasts for Portillo's Inc. (PTLO).
- Adjustable Forecast Parameters: Modify highlighted cells such as WACC, growth rates, and profit margins to suit your analysis.
- Automated Calculations: Real-time updates for DCF, Net Present Value (NPV), and cash flow evaluations.
- User-Friendly Dashboard: Intuitive charts and summaries that make it easy to interpret your valuation findings.
- Designed for All Skill Levels: A straightforward structure tailored for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file containing Portillo's Inc. (PTLO) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Immediate Results: The DCF model automatically calculates the intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Present with Assurance: Deliver professional valuation insights to reinforce your decision-making.
Why Choose This Calculator for Portillo's Inc. (PTLO)?
- User-Friendly Interface: Tailored for both novice users and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis needs.
- Real-Time Feedback: Monitor immediate changes to Portillo's valuation as you modify inputs.
- Pre-Configured Data: Comes with Portillo's actual financial metrics for swift evaluations.
- Relied Upon by Experts: Utilized by investors and analysts for making strategic decisions.
Who Should Use Portillo's Inc. (PTLO)?
- Food Enthusiasts: Discover and enjoy a diverse menu of delicious offerings from a beloved brand.
- Investors: Analyze growth potential and market trends with insights specific to the fast-casual dining sector.
- Business Analysts: Evaluate operational performance and customer satisfaction metrics to inform strategic decisions.
- Franchise Owners: Leverage proven business models and support systems to maximize success in the restaurant industry.
- Students and Educators: Utilize case studies and real-world examples to learn about the food service industry and entrepreneurship.
What the Template Contains
- Preloaded PTLO Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.