Aurinia Pharmaceuticals Inc. (AUPH) 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
Aurinia Pharmaceuticals Inc. (AUPH) Bundle
Looking to assess Aurinia Pharmaceuticals Inc.'s intrinsic value? Our AUPH DCF Calculator integrates real-time data with extensive customization features, allowing you to adjust forecasts and enhance your investment choices.
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 | .3 | 50.1 | 45.6 | 134.0 | 175.5 | 272.9 | 424.3 | 659.8 | 1,025.8 | 1,595.0 |
Revenue Growth, % | 0 | 15660.38 | -9 | 193.89 | 30.95 | 55.49 | 55.49 | 55.49 | 55.49 | 55.49 |
EBITDA | -89.8 | -102.9 | -177.4 | -103.6 | -63.0 | -225.6 | -350.7 | -545.3 | -847.9 | -1,318.3 |
EBITDA, % | -28230.19 | -205.35 | -389.09 | -77.33 | -35.92 | -82.65 | -82.65 | -82.65 | -82.65 | -82.65 |
Depreciation | 1.2 | 1.4 | 2.8 | 2.7 | 11.6 | 64.1 | 99.7 | 155.0 | 241.0 | 374.7 |
Depreciation, % | 368.24 | 2.74 | 6.05 | 2.02 | 6.64 | 23.49 | 23.49 | 23.49 | 23.49 | 23.49 |
EBIT | -90.9 | -104.3 | -180.2 | -106.4 | -74.7 | -230.3 | -358.0 | -556.7 | -865.6 | -1,345.9 |
EBIT, % | -28598.43 | -208.09 | -395.15 | -79.35 | -42.56 | -84.38 | -84.38 | -84.38 | -84.38 | -84.38 |
Total Cash | 306.0 | 398.3 | 466.1 | 389.4 | 350.5 | 272.9 | 424.3 | 659.8 | 1,025.8 | 1,595.0 |
Total Cash, percent | .1 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .4 | .0 | 15.4 | 13.5 | 24.1 | 86.0 | 133.7 | 207.9 | 323.3 | 502.7 |
Account Receivables, % | 115.72 | 0 | 33.8 | 10.06 | 13.72 | 31.52 | 31.52 | 31.52 | 31.52 | 31.52 |
Inventories | .0 | 13.9 | 19.3 | 24.8 | 39.7 | 60.7 | 94.4 | 146.8 | 228.3 | 354.9 |
Inventories, % | 0 | 27.79 | 42.38 | 18.47 | 22.62 | 22.25 | 22.25 | 22.25 | 22.25 | 22.25 |
Accounts Payable | 4.2 | 2.6 | 3.9 | 3.1 | 4.3 | 64.7 | 100.6 | 156.4 | 243.2 | 378.1 |
Accounts Payable, % | 1305.97 | 5.26 | 8.51 | 2.3 | 2.47 | 23.71 | 23.71 | 23.71 | 23.71 | 23.71 |
Capital Expenditure | -.1 | -7.3 | -1.5 | -.3 | -.7 | -28.0 | -43.5 | -67.7 | -105.2 | -163.6 |
Capital Expenditure, % | -32.7 | -14.65 | -3.29 | -0.21786 | -0.40909 | -10.25 | -10.25 | -10.25 | -10.25 | -10.25 |
Tax Rate, % | -0.71125 | -0.71125 | -0.71125 | -0.71125 | -0.71125 | -0.71125 | -0.71125 | -0.71125 | -0.71125 | -0.71125 |
EBITAT | -91.0 | -104.2 | -181.0 | -108.2 | -75.2 | -230.2 | -358.0 | -556.6 | -865.5 | -1,345.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -86.2 | -125.2 | -199.3 | -110.1 | -88.6 | -216.7 | -347.3 | -540.1 | -839.7 | -1,305.7 |
WACC, % | 10.85 | 10.85 | 10.85 | 10.85 | 10.85 | 10.85 | 10.85 | 10.85 | 10.85 | 10.85 |
PV UFCF | ||||||||||
SUM PV UFCF | -2,211.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -1,332 | |||||||||
Terminal Value | -15,051 | |||||||||
Present Terminal Value | -8,994 | |||||||||
Enterprise Value | -11,205 | |||||||||
Net Debt | 49 | |||||||||
Equity Value | -11,253 | |||||||||
Diluted Shares Outstanding, MM | 143 | |||||||||
Equity Value Per Share | -78.57 |
What You Will Get
- Comprehensive AUPH Financials: Access historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Aurinia’s future performance.
- User-Friendly Interface: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Data: Aurinia Pharmaceuticals Inc.'s historical financial statements and pre-filled forecasts.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Observe Aurinia's intrinsic value recalculating instantly.
- Intuitive Visuals: Dashboard charts present valuation results and essential metrics clearly.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance specialists.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Aurinia Pharmaceuticals Inc. (AUPH) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Aurinia Pharmaceuticals Inc.'s (AUPH) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Aurinia Pharmaceuticals Inc. (AUPH)?
- Innovative Solutions: Pioneering therapies that address unmet medical needs in kidney diseases.
- Strong Pipeline: Robust research and development efforts aimed at delivering impactful treatments.
- Expert Team: Led by industry veterans with extensive experience in pharmaceuticals and biotechnology.
- Commitment to Quality: Adherence to the highest standards in clinical trials and product development.
- Proven Track Record: Demonstrated success in bringing effective therapies to market.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Aurinia Pharmaceuticals Inc. (AUPH) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Aurinia Pharmaceuticals Inc. (AUPH).
- Consultants: Deliver professional valuation insights on Aurinia Pharmaceuticals Inc. (AUPH) to clients quickly and accurately.
- Business Owners: Understand how biotech companies like Aurinia Pharmaceuticals Inc. (AUPH) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Aurinia Pharmaceuticals Inc. (AUPH).
What the Template Contains
- Historical Data: Includes Aurinia Pharmaceuticals Inc.'s (AUPH) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Aurinia Pharmaceuticals Inc.'s (AUPH) 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 Aurinia Pharmaceuticals Inc.'s (AUPH) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.