Burning Rock Biotech Limited (BNR) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Burning Rock Biotech Limited (BNR) Bundle
Discover the true potential of Burning Rock Biotech Limited (BNR) with our advanced DCF Calculator! Adjust critical assumptions, explore various scenarios, and evaluate how changes affect Burning Rock's valuation – 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 | 52.3 | 58.9 | 69.6 | 77.2 | 73.6 | 80.5 | 87.9 | 96.1 | 105.0 | 114.7 |
| Revenue Growth, % | 0 | 12.64 | 18.13 | 10.9 | -4.58 | 9.27 | 9.27 | 9.27 | 9.27 | 9.27 |
| EBITDA | -18.7 | -51.1 | -102.3 | -117.3 | -71.0 | -67.4 | -73.7 | -80.5 | -88.0 | -96.1 |
| EBITDA, % | -35.73 | -86.82 | -146.99 | -152.03 | -96.37 | -83.78 | -83.78 | -83.78 | -83.78 | -83.78 |
| Depreciation | 4.3 | 4.6 | 6.5 | 17.0 | 18.3 | 11.6 | 12.7 | 13.9 | 15.2 | 16.6 |
| Depreciation, % | 8.22 | 7.75 | 9.41 | 22.03 | 24.82 | 14.44 | 14.44 | 14.44 | 14.44 | 14.44 |
| EBIT | -23.0 | -55.7 | -108.8 | -134.3 | -89.2 | -70.6 | -77.1 | -84.3 | -92.1 | -100.6 |
| EBIT, % | -43.95 | -94.57 | -156.39 | -174.07 | -121.19 | -87.7 | -87.7 | -87.7 | -87.7 | -87.7 |
| Total Cash | 55.9 | 309.3 | 204.8 | 124.1 | 84.3 | 80.5 | 87.9 | 96.1 | 105.0 | 114.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 12.3 | 15.2 | 22.1 | 23.3 | 20.5 | 22.4 | 24.5 | 26.7 | 29.2 | 31.9 |
| Account Receivables, % | 23.51 | 25.76 | 31.79 | 30.22 | 27.84 | 27.82 | 27.82 | 27.82 | 27.82 | 27.82 |
| Inventories | 8.0 | 9.3 | 16.9 | 17.9 | 9.5 | 14.7 | 16.1 | 17.5 | 19.2 | 20.9 |
| Inventories, % | 15.23 | 15.82 | 24.26 | 23.14 | 12.84 | 18.26 | 18.26 | 18.26 | 18.26 | 18.26 |
| Accounts Payable | 1.7 | 4.9 | 8.6 | 7.0 | 2.5 | 5.8 | 6.4 | 7.0 | 7.6 | 8.3 |
| Accounts Payable, % | 3.24 | 8.25 | 12.42 | 9.05 | 3.36 | 7.26 | 7.26 | 7.26 | 7.26 | 7.26 |
| Capital Expenditure | -6.3 | -10.9 | -29.2 | -8.5 | -1.3 | -13.7 | -15.0 | -16.4 | -17.9 | -19.6 |
| Capital Expenditure, % | -11.98 | -18.5 | -42.03 | -11.01 | -1.75 | -17.05 | -17.05 | -17.05 | -17.05 | -17.05 |
| Tax Rate, % | -0.36665 | -0.36665 | -0.36665 | -0.36665 | -0.36665 | -0.36665 | -0.36665 | -0.36665 | -0.36665 | -0.36665 |
| EBITAT | -22.9 | -51.1 | -108.9 | -134.6 | -89.6 | -69.3 | -75.8 | -82.8 | -90.5 | -98.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -43.4 | -58.5 | -142.4 | -129.9 | -65.9 | -75.2 | -81.0 | -88.5 | -96.7 | -105.6 |
| WACC, % | 5.37 | 5.36 | 5.37 | 5.37 | 5.37 | 5.37 | 5.37 | 5.37 | 5.37 | 5.37 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -379.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -108 | |||||||||
| Terminal Value | -3,196 | |||||||||
| Present Terminal Value | -2,461 | |||||||||
| Enterprise Value | -2,840 | |||||||||
| Net Debt | -83 | |||||||||
| Equity Value | -2,758 | |||||||||
| Diluted Shares Outstanding, MM | 10 | |||||||||
| Equity Value Per Share | -269.31 |
What You Will Receive
- Comprehensive BNR Financial Data: Pre-loaded with Burning Rock Biotech Limited’s historical and projected figures for in-depth analysis.
- Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch BNR’s intrinsic value refresh immediately as you make changes.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Layout: Clear structure and straightforward instructions suitable for all skill levels.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as revenue growth, EBITDA margin, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial outputs.
- High-Precision Accuracy: Leverages Burning Rock Biotech Limited's (BNR) actual financial data for credible valuation results.
- Effortless Scenario Analysis: Easily evaluate various assumptions and assess different outcomes.
- Efficiency Boost: Streamline the valuation process by avoiding the need for complex model construction from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based BNR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Burning Rock Biotech Limited’s intrinsic value.
- Test Scenarios: Explore various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Burning Rock Biotech Limited (BNR)?
- Accurate Data: Up-to-date Burning Rock financials provide trustworthy valuation results.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the biotech sector.
- User-Friendly: Designed with an intuitive interface and clear instructions for users of all experience levels.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Burning Rock Biotech Limited (BNR) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Burning Rock Biotech Limited (BNR).
- Consultants: Deliver professional valuation insights on Burning Rock Biotech Limited (BNR) to clients quickly and accurately.
- Business Owners: Understand how biotech companies like Burning Rock Biotech Limited (BNR) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Burning Rock Biotech Limited (BNR).
What the Template Contains
- Pre-Filled DCF Model: Burning Rock Biotech Limited’s (BNR) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Burning Rock Biotech Limited’s (BNR) 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.