Braemar Hotels & Resorts Inc. (BHR) 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
Braemar Hotels & Resorts Inc. (BHR) Bundle
Discover the true potential of Braemar Hotels & Resorts Inc. (BHR) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect the valuation of Braemar Hotels & Resorts Inc. (BHR) – all within a single Excel template.
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 | 487.6 | 227.0 | 427.5 | 669.6 | 739.3 | 927.8 | 1,164.2 | 1,460.9 | 1,833.3 | 2,300.5 |
| Revenue Growth, % | 0 | -53.45 | 88.37 | 56.61 | 10.42 | 25.49 | 25.49 | 25.49 | 25.49 | 25.49 |
| EBITDA | 97.5 | -25.2 | 73.6 | 146.9 | 154.7 | 127.9 | 160.6 | 201.5 | 252.8 | 317.3 |
| EBITDA, % | 19.99 | -11.1 | 17.21 | 21.94 | 20.92 | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 |
| Depreciation | 441.6 | 312.0 | 427.7 | 601.3 | 93.7 | 729.3 | 915.2 | 1,148.4 | 1,441.1 | 1,808.4 |
| Depreciation, % | 90.56 | 137.47 | 100.03 | 89.8 | 12.68 | 78.61 | 78.61 | 78.61 | 78.61 | 78.61 |
| EBIT | -344.1 | -337.2 | -354.1 | -454.4 | 60.9 | -580.8 | -728.8 | -914.6 | -1,147.7 | -1,440.2 |
| EBIT, % | -70.58 | -148.57 | -82.82 | -67.87 | 8.24 | -62.6 | -62.6 | -62.6 | -62.6 | -62.6 |
| Total Cash | 72.0 | 78.6 | 216.0 | 261.5 | 85.6 | 279.4 | 350.6 | 439.9 | 552.0 | 692.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 36.2 | 26.8 | 52.9 | 79.0 | 56.9 | 94.9 | 119.1 | 149.4 | 187.5 | 235.3 |
| Account Receivables, % | 7.43 | 11.82 | 12.38 | 11.8 | 7.7 | 10.23 | 10.23 | 10.23 | 10.23 | 10.23 |
| Inventories | 2.8 | 2.6 | 3.1 | 5.2 | 5.0 | 7.2 | 9.1 | 11.4 | 14.3 | 17.9 |
| Inventories, % | 0.57299 | 1.12 | 0.73162 | 0.78228 | 0.67668 | 0.7775 | 0.7775 | 0.7775 | 0.7775 | 0.7775 |
| Accounts Payable | 78.7 | 54.7 | 96.3 | 134.0 | 100.5 | 178.8 | 224.4 | 281.6 | 353.4 | 443.4 |
| Accounts Payable, % | 16.13 | 24.12 | 22.53 | 20.01 | 13.59 | 19.28 | 19.28 | 19.28 | 19.28 | 19.28 |
| Capital Expenditure | -136.3 | -25.6 | -25.6 | -49.1 | -.1 | -97.5 | -122.4 | -153.5 | -192.7 | -241.8 |
| Capital Expenditure, % | -27.94 | -11.26 | -6 | -7.34 | -0.01014414 | -10.51 | -10.51 | -10.51 | -10.51 | -10.51 |
| Tax Rate, % | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 | 3.3 |
| EBITAT | -139.0 | -325.7 | -368.9 | -345.1 | 58.9 | -475.8 | -597.1 | -749.3 | -940.3 | -1,179.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 205.9 | -53.5 | 48.0 | 216.6 | 141.4 | 194.2 | 215.3 | 270.2 | 339.0 | 425.4 |
| WACC, % | 4.71 | 8.4 | 8.62 | 7.04 | 8.41 | 7.44 | 7.44 | 7.44 | 7.44 | 7.44 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,136.8 | |||||||||
| Long Term Growth Rate, % | 3.40 | |||||||||
| Free cash flow (T + 1) | 440 | |||||||||
| Terminal Value | 10,899 | |||||||||
| Present Terminal Value | 7,615 | |||||||||
| Enterprise Value | 8,751 | |||||||||
| Net Debt | 1,137 | |||||||||
| Equity Value | 7,614 | |||||||||
| Diluted Shares Outstanding, MM | 66 | |||||||||
| Equity Value Per Share | 115.38 |
What You Will Get
- Real Braemar Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Braemar Hotels & Resorts Inc. (BHR).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Braemar's fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections.
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility in your evaluations.
Key Features
- Comprehensive Financial Data: Gain access to reliable historical data and future forecasts for Braemar Hotels & Resorts Inc. (BHR).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins to tailor your analysis.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Utilize intuitive charts and summaries for a clear view of your valuation outcomes.
- Designed for All Skill Levels: A straightforward and accessible layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring Braemar Hotels & Resorts Inc. (BHR) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Update projections and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including the intrinsic value of Braemar Hotels & Resorts Inc. (BHR).
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose Braemar Hotels & Resorts Inc. (BHR) Calculator?
- Accuracy: Utilizes real financial data from Braemar Hotels & Resorts for precise calculations.
- Flexibility: Allows users to easily adjust and test various input parameters.
- Time-Saving: Eliminates the need to create complex financial models from the ground up.
- Professional-Grade: Built with the expertise and standards expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users of all financial backgrounds.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Braemar Hotels & Resorts Inc. (BHR) stock.
- Financial Analysts: Enhance valuation assessments with comprehensive financial models tailored for Braemar Hotels & Resorts Inc. (BHR).
- Consultants: Provide precise valuation insights for clients focused on the hospitality sector, particularly Braemar Hotels & Resorts Inc. (BHR).
- Business Owners: Gain insights into the valuation of hospitality companies like Braemar Hotels & Resorts Inc. (BHR) to inform your own business strategies.
- Finance Students: Explore valuation methodologies using real-time data and case studies related to Braemar Hotels & Resorts Inc. (BHR).
What the Template Contains
- Historical Data: Includes Braemar Hotels & Resorts Inc.'s (BHR) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Braemar Hotels & Resorts Inc.'s (BHR) 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 Braemar Hotels & Resorts Inc.'s (BHR) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.