FibroGen, Inc. (FGEN) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
FibroGen, Inc. (FGEN) Bundle
Gain insight into your FibroGen, Inc. (FGEN) valuation analysis using our sophisticated DCF Calculator! Featuring real-time data for (FGEN), this Excel template enables you to adjust forecasts and assumptions, allowing for an accurate calculation of FibroGen's intrinsic value.
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 | 256.6 | 176.3 | 235.3 | 140.7 | 147.8 | 135.6 | 124.4 | 114.1 | 104.7 | 96.0 |
Revenue Growth, % | 0 | -31.28 | 33.46 | -40.19 | 4.99 | -8.26 | -8.26 | -8.26 | -8.26 | -8.26 |
EBITDA | -52.3 | -164.3 | -274.8 | -282.8 | -261.4 | -112.1 | -102.9 | -94.4 | -86.6 | -79.4 |
EBITDA, % | -20.39 | -93.17 | -116.78 | -200.96 | -176.92 | -82.71 | -82.71 | -82.71 | -82.71 | -82.71 |
Depreciation | 21.5 | 22.0 | 14.8 | 10.6 | 9.9 | 11.2 | 10.3 | 9.5 | 8.7 | 8.0 |
Depreciation, % | 8.36 | 12.5 | 6.29 | 7.53 | 6.72 | 8.28 | 8.28 | 8.28 | 8.28 | 8.28 |
EBIT | -73.8 | -186.3 | -289.6 | -293.4 | -271.3 | -116.2 | -106.6 | -97.8 | -89.8 | -82.3 |
EBIT, % | -28.75 | -105.68 | -123.08 | -208.5 | -183.64 | -85.75 | -85.75 | -85.75 | -85.75 | -85.75 |
Total Cash | 533.8 | 686.5 | 405.2 | 422.0 | 235.6 | 135.6 | 124.4 | 114.1 | 104.7 | 96.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 153.7 | 41.9 | 25.4 | 16.3 | 41.1 | 36.3 | 33.3 | 30.5 | 28.0 | 25.7 |
Account Receivables, % | 59.89 | 23.75 | 10.79 | 11.58 | 27.79 | 26.76 | 26.76 | 26.76 | 26.76 | 26.76 |
Inventories | 6.9 | 16.5 | 31.0 | 40.4 | 41.6 | 22.3 | 20.4 | 18.7 | 17.2 | 15.8 |
Inventories, % | 2.68 | 9.38 | 13.18 | 28.73 | 28.13 | 16.42 | 16.42 | 16.42 | 16.42 | 16.42 |
Accounts Payable | 6.1 | 24.8 | 26.1 | 30.8 | 18.0 | 16.7 | 15.3 | 14.0 | 12.9 | 11.8 |
Accounts Payable, % | 2.37 | 14.06 | 11.09 | 21.86 | 12.16 | 12.31 | 12.31 | 12.31 | 12.31 | 12.31 |
Capital Expenditure | -5.8 | -4.0 | -30.2 | -38.7 | -2.5 | -12.6 | -11.6 | -10.6 | -9.7 | -8.9 |
Capital Expenditure, % | -2.25 | -2.27 | -12.83 | -27.53 | -1.7 | -9.31 | -9.31 | -9.31 | -9.31 | -9.31 |
Tax Rate, % | 0.91854 | 0.91854 | 0.91854 | 0.91854 | 0.91854 | 0.91854 | 0.91854 | 0.91854 | 0.91854 | 0.91854 |
EBITAT | -74.1 | -186.7 | -290.0 | -293.8 | -268.8 | -116.0 | -106.4 | -97.7 | -89.6 | -82.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -212.9 | -47.8 | -302.0 | -317.6 | -300.1 | -94.6 | -104.3 | -95.7 | -87.8 | -80.5 |
WACC, % | 8.8 | 8.8 | 8.8 | 8.8 | 8.74 | 8.79 | 8.79 | 8.79 | 8.79 | 8.79 |
PV UFCF | ||||||||||
SUM PV UFCF | -364.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -82 | |||||||||
Terminal Value | -1,209 | |||||||||
Present Terminal Value | -793 | |||||||||
Enterprise Value | -1,158 | |||||||||
Net Debt | 57 | |||||||||
Equity Value | -1,215 | |||||||||
Diluted Shares Outstanding, MM | 97 | |||||||||
Equity Value Per Share | -12.49 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real FibroGen (FGEN) financials.
- Real-World Data: Historical data and forward-looking estimates (as displayed in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Quickly observe how your inputs affect FibroGen’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and simplicity, complete with step-by-step instructions.
Key Features
- Comprehensive FGEN Data: Pre-filled with FibroGen’s historical financials and future projections.
- Flexible Input Options: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures as needed.
- Interactive Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on user inputs.
- Scenario Analysis: Develop various forecast scenarios to evaluate different valuation results.
- Intuitive User Interface: Designed to be simple and structured for both professionals and newcomers.
How It Works
- 1. Access the Template: Download and open the Excel file containing FibroGen, Inc.'s (FGEN) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. See Results in Real-Time: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
- 5. Present with Assurance: Share professional valuation insights to bolster your decision-making process.
Why Choose This Calculator?
- Accurate Data: Real FibroGen financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to match your projections.
- Time-Saving: Pre-built calculations eliminate the need to start from scratch.
- Professional-Grade Tool: Designed for investors, analysts, and consultants.
- User-Friendly: Intuitive layout and step-by-step instructions make it easy for all users.
Who Should Use This Product?
- Investors: Assess FibroGen, Inc.'s (FGEN) valuation prior to making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and evaluate financial forecasts.
- Startup Founders: Understand the valuation strategies of established biopharmaceutical companies like FibroGen, Inc.
- Consultants: Provide comprehensive valuation analyses and reports for clients in the healthcare sector.
- Students and Educators: Utilize real-time data from FibroGen, Inc. (FGEN) to learn and teach valuation principles.
What the Template Contains
- Pre-Filled Data: Includes FibroGen’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze FibroGen’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.