|
Guild Holdings Company (GHLD) DCF Valuation
US | Financial Services | Financial - Mortgages | NYSE
|
- ✓ 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
Guild Holdings Company (GHLD) Bundle
Evaluate the financial outlook of Guild Holdings Company (GHLD) like an expert! This (GHLD) DCF Calculator provides pre-filled financial data and offers you the flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your 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 | 419.4 | 1,622.0 | 1,576.3 | 1,164.8 | 663.9 | 710.4 | 760.3 | 813.6 | 870.7 | 931.8 |
| Revenue Growth, % | 0 | 286.79 | -2.82 | -26.1 | -43.01 | 7.02 | 7.02 | 7.02 | 7.02 | 7.02 |
| EBITDA | .0 | 619.9 | 486.2 | 840.8 | 59.5 | 213.4 | 228.4 | 244.4 | 261.6 | 279.9 |
| EBITDA, % | 0 | 38.22 | 30.84 | 72.18 | 8.96 | 30.04 | 30.04 | 30.04 | 30.04 | 30.04 |
| Depreciation | 801.5 | 967.5 | 1,108.1 | 416.3 | 36.0 | 385.2 | 412.2 | 441.2 | 472.1 | 505.2 |
| Depreciation, % | 191.13 | 59.64 | 70.29 | 35.74 | 5.42 | 54.22 | 54.22 | 54.22 | 54.22 | 54.22 |
| EBIT | -801.5 | -347.5 | -621.9 | 424.5 | 23.5 | -171.8 | -183.8 | -196.7 | -210.5 | -225.3 |
| EBIT, % | -191.13 | -21.42 | -39.45 | 36.44 | 3.54 | -24.18 | -24.18 | -24.18 | -24.18 | -24.18 |
| Total Cash | 101.7 | 334.6 | 243.1 | 137.9 | 136.8 | 131.8 | 141.0 | 150.9 | 161.5 | 172.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 13.3 | 43.4 | 44.7 | 28.4 | .0 | 15.8 | 16.9 | 18.1 | 19.3 | 20.7 |
| Account Receivables, % | 3.16 | 2.68 | 2.83 | 2.43 | 0 | 2.22 | 2.22 | 2.22 | 2.22 | 2.22 |
| Inventories | 9.0 | 1.4 | .5 | .3 | .0 | 3.2 | 3.5 | 3.7 | 4.0 | 4.3 |
| Inventories, % | 2.15 | 0.08347477 | 0.02987991 | 0.02627013 | 0 | 0.45706 | 0.45706 | 0.45706 | 0.45706 | 0.45706 |
| Accounts Payable | 35.3 | 41.1 | 56.8 | 34.1 | 32.6 | 31.8 | 34.1 | 36.5 | 39.0 | 41.8 |
| Accounts Payable, % | 8.43 | 2.53 | 3.61 | 2.93 | 4.92 | 4.48 | 4.48 | 4.48 | 4.48 | 4.48 |
| Capital Expenditure | -3.7 | -8.2 | -4.6 | -3.9 | -5.5 | -4.0 | -4.3 | -4.6 | -5.0 | -5.3 |
| Capital Expenditure, % | -0.8835 | -0.50757 | -0.29214 | -0.33147 | -0.83029 | -0.56899 | -0.56899 | -0.56899 | -0.56899 | -0.56899 |
| Tax Rate, % | 15.44 | 15.44 | 15.44 | 15.44 | 15.44 | 15.44 | 15.44 | 15.44 | 15.44 | 15.44 |
| EBITAT | -766.7 | -260.7 | -456.1 | 332.1 | 19.9 | -139.8 | -149.6 | -160.1 | -171.3 | -183.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 44.2 | 681.8 | 662.7 | 738.3 | 77.6 | 221.6 | 259.2 | 277.4 | 296.9 | 317.7 |
| WACC, % | 10.85 | 9.8 | 9.71 | 9.96 | 10.29 | 10.12 | 10.12 | 10.12 | 10.12 | 10.12 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,020.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 324 | |||||||||
| Terminal Value | 3,990 | |||||||||
| Present Terminal Value | 2,463 | |||||||||
| Enterprise Value | 3,484 | |||||||||
| Net Debt | 407 | |||||||||
| Equity Value | 3,078 | |||||||||
| Diluted Shares Outstanding, MM | 61 | |||||||||
| Equity Value Per Share | 50.48 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real GHLD financials.
- Authentic Data: Historical data and future estimates (as indicated in the highlighted cells).
- Flexible Forecasting: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect the valuation of Guild Holdings Company (GHLD).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Interface: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Comprehensive Financial Data: Guild Holdings Company’s historical financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Observe Guild Holdings Company’s intrinsic value recalibrate instantly.
- Intuitive Visualizations: Dashboard graphs present valuation outcomes and essential metrics clearly.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- Download: Obtain the comprehensive Excel file featuring Guild Holdings Company's (GHLD) financial data.
- Customize: Tailor your forecasts by modifying revenue growth, EBITDA %, and WACC parameters.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly analyze the outcomes.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for Guild Holdings Company (GHLD)?
- Accuracy: Utilizes real Guild Holdings financials to ensure precise data.
- Flexibility: Built to allow users to experiment and adjust inputs easily.
- Time-Saving: Eliminate the need to construct a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling knowledge.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing portfolios with Guild Holdings Company (GHLD).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Equip clients with precise valuation insights regarding Guild Holdings Company (GHLD).
- Students and Educators: Utilize real-world data to practice and instruct on financial modeling techniques.
- Real Estate Enthusiasts: Gain insights into how companies like Guild Holdings Company (GHLD) are valued in the real estate market.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
- Real-World Data: Guild Holdings Company's (GHLD) historical and projected financials preloaded for analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Graphs and tables presenting clear, actionable results.