Porch Group, Inc. (PRCH) 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
Porch Group, Inc. (PRCH) Bundle
Designed for accuracy, our [PRCH] DCF Calculator enables you to evaluate Porch Group, Inc. valuation using real-world financial data, offering 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 | 77.6 | 73.2 | 192.4 | 275.9 | 430.3 | 638.7 | 947.9 | 1,406.9 | 2,088.2 | 3,099.4 |
Revenue Growth, % | 0 | -5.64 | 162.83 | 43.4 | 55.94 | 48.42 | 48.42 | 48.42 | 48.42 | 48.42 |
EBITDA | -74.9 | -34.3 | -94.4 | -116.9 | -77.1 | -322.8 | -479.1 | -711.1 | -1,055.5 | -1,566.6 |
EBITDA, % | -96.46 | -46.91 | -49.07 | -42.38 | -17.91 | -50.55 | -50.55 | -50.55 | -50.55 | -50.55 |
Depreciation | 7.4 | 6.6 | 16.7 | 30.0 | 24.4 | 56.0 | 83.1 | 123.3 | 183.0 | 271.6 |
Depreciation, % | 9.51 | 9.07 | 8.68 | 10.89 | 5.67 | 8.76 | 8.76 | 8.76 | 8.76 | 8.76 |
EBIT | -82.2 | -41.0 | -111.1 | -147.0 | -101.5 | -371.2 | -550.9 | -817.7 | -1,213.6 | -1,801.3 |
EBIT, % | -105.97 | -55.98 | -57.75 | -53.27 | -23.58 | -58.12 | -58.12 | -58.12 | -58.12 | -58.12 |
Total Cash | 4.2 | 196.0 | 325.0 | 251.6 | 332.8 | 477.6 | 708.9 | 1,052.1 | 1,561.6 | 2,317.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 4.7 | 4.3 | 257.2 | 325.5 | 107.9 | 302.7 | 449.3 | 666.8 | 989.7 | 1,468.9 |
Account Receivables, % | 6.07 | 5.83 | 133.65 | 117.96 | 25.07 | 47.39 | 47.39 | 47.39 | 47.39 | 47.39 |
Inventories | .0 | 11.4 | 8.6 | 13.5 | .0 | 31.8 | 47.3 | 70.2 | 104.1 | 154.5 |
Inventories, % | 0.000001288743 | 15.58 | 4.44 | 4.91 | 0 | 4.99 | 4.99 | 4.99 | 4.99 | 4.99 |
Accounts Payable | 4.8 | 9.2 | 7.0 | 6.3 | 8.8 | 34.1 | 50.6 | 75.1 | 111.5 | 165.4 |
Accounts Payable, % | 6.19 | 12.57 | 3.62 | 2.27 | 2.04 | 5.34 | 5.34 | 5.34 | 5.34 | 5.34 |
Capital Expenditure | -4.6 | -2.9 | -4.7 | -10.5 | -10.1 | -23.5 | -34.9 | -51.8 | -76.8 | -114.1 |
Capital Expenditure, % | -5.89 | -3.93 | -2.44 | -3.79 | -2.35 | -3.68 | -3.68 | -3.68 | -3.68 | -3.68 |
Tax Rate, % | -0.46658 | -0.46658 | -0.46658 | -0.46658 | -0.46658 | -0.46658 | -0.46658 | -0.46658 | -0.46658 | -0.46658 |
EBITAT | -82.3 | -39.7 | -101.6 | -147.8 | -102.0 | -362.4 | -537.9 | -798.4 | -1,185.0 | -1,758.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -79.4 | -42.5 | -341.8 | -202.2 | 146.0 | -531.3 | -635.2 | -942.8 | -1,399.3 | -2,076.9 |
WACC, % | 10.81 | 10.71 | 10.52 | 10.81 | 10.81 | 10.73 | 10.73 | 10.73 | 10.73 | 10.73 |
PV UFCF | ||||||||||
SUM PV UFCF | -3,870.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -2,118 | |||||||||
Terminal Value | -24,260 | |||||||||
Present Terminal Value | -14,572 | |||||||||
Enterprise Value | -18,442 | |||||||||
Net Debt | 142 | |||||||||
Equity Value | -18,584 | |||||||||
Diluted Shares Outstanding, MM | 96 | |||||||||
Equity Value Per Share | -193.47 |
What You Will Get
- Real PRCH Financial Data: Pre-filled with Porch Group’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 Porch Group’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 PRCH Data: Pre-loaded with Porch Group’s historical performance metrics and future projections.
- Customizable Variables: Modify revenue growth rates, profit margins, discount rates, tax implications, and capital investments.
- Interactive Valuation Model: Real-time updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- User-Centric Interface: Intuitive design that caters to both experts and newcomers in the field.
How It Works
- 1. Access the Template: Download and open the Excel file containing Porch Group, Inc.'s (PRCH) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures as needed.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Analyze various forecasts to assess different valuation outcomes.
- 5. Present with Confidence: Share professional valuation insights to enhance your decision-making process.
Why Choose This Calculator for Porch Group, Inc. (PRCH)?
- Accuracy: Reliable financial data ensures precision in calculations.
- Flexibility: Tailored for users to easily adjust and test their inputs.
- Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Engineered with the expertise and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users with varying levels of financial knowledge.
Who Should Use Porch Group, Inc. (PRCH)?
- Real Estate Professionals: Utilize advanced analytics to enhance property valuation and investment strategies.
- Researchers: Integrate industry-specific models into academic studies or publications.
- Investors: Evaluate your investment hypotheses and assess the financial performance of Porch Group, Inc. (PRCH).
- Market Analysts: Optimize your analysis process with a tailored, ready-to-use financial model.
- Entrepreneurs: Understand the evaluation methods used for public companies like Porch Group, Inc. (PRCH) to inform your business decisions.
What the Template Contains
- Historical Data: Includes Porch Group, Inc. (PRCH)’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Porch Group, Inc. (PRCH)’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Porch Group, Inc. (PRCH)’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.