Applied Therapeutics, Inc. (APLT) 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
Applied Therapeutics, Inc. (APLT) Bundle
Looking to calculate the intrinsic value of Applied Therapeutics, Inc.? Our APLT DCF Calculator integrates real-world data with extensive customization features, enabling you to adjust forecasts and enhance your investment strategies.
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 | .0 | .0 | .0 | .0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 |
Revenue Growth, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITDA | -45.6 | -94.5 | -105.2 | -82.1 | -64.5 | 6.0 | 6.0 | 6.0 | 6.0 | 6.0 |
EBITDA, % | 100 | 100 | 100 | 100 | -645.8 | 60 | 60 | 60 | 60 | 60 |
Depreciation | .0 | .4 | .4 | .4 | .0 | 8.0 | 8.0 | 8.0 | 8.0 | 8.0 |
Depreciation, % | 100 | 100 | 100 | 100 | 0 | 80 | 80 | 80 | 80 | 80 |
EBIT | -45.6 | -94.8 | -105.6 | -82.5 | -64.5 | 6.0 | 6.0 | 6.0 | 6.0 | 6.0 |
EBIT, % | 100 | 100 | 100 | 100 | -645.8 | 60 | 60 | 60 | 60 | 60 |
Total Cash | 38.9 | 96.8 | 80.8 | 30.6 | 49.9 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .5 | .5 | .3 | .3 | 8.1 | 8.1 | 8.1 | 8.1 | 8.1 |
Account Receivables, % | 100 | 100 | 100 | 100 | 2.85 | 80.57 | 80.57 | 80.57 | 80.57 | 80.57 |
Inventories | .0 | -.5 | -.5 | -.3 | .0 | 8.0 | 8.0 | 8.0 | 8.0 | 8.0 |
Inventories, % | 100 | 100 | 100 | 100 | 0 | 80 | 80 | 80 | 80 | 80 |
Accounts Payable | 8.8 | .6 | 9.5 | 4.5 | 1.7 | 8.3 | 8.3 | 8.3 | 8.3 | 8.3 |
Accounts Payable, % | 100 | 100 | 100 | 100 | 17.43 | 83.49 | 83.49 | 83.49 | 83.49 | 83.49 |
Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | 100 | 100 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -45.5 | -93.9 | -104.6 | -81.7 | -64.5 | 6.0 | 6.0 | 6.0 | 6.0 | 6.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -36.7 | -101.7 | -95.4 | -86.2 | -67.6 | 4.8 | 14.0 | 14.0 | 14.0 | 14.0 |
WACC, % | 13.87 | 13.87 | 13.87 | 13.87 | 13.87 | 13.87 | 13.87 | 13.87 | 13.87 | 13.87 |
PV UFCF | ||||||||||
SUM PV UFCF | 40.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 14 | |||||||||
Terminal Value | 120 | |||||||||
Present Terminal Value | 63 | |||||||||
Enterprise Value | 103 | |||||||||
Net Debt | -49 | |||||||||
Equity Value | 152 | |||||||||
Diluted Shares Outstanding, MM | 84 | |||||||||
Equity Value Per Share | 1.80 |
What You Will Get
- Real Applied Therapeutics Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Applied Therapeutics’ fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- 🔍 Real-Life APLT Financials: Pre-filled historical and projected data for Applied Therapeutics, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Applied Therapeutics’ intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Applied Therapeutics’ valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Applied Therapeutics data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Applied Therapeutics’ intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose the Applied Therapeutics Calculator?
- Accuracy: Utilizes real Applied Therapeutics financials for precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the complexity of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive interface suitable for users with varying levels of financial modeling expertise.
Who Should Use Applied Therapeutics, Inc. (APLT)?
- Investors: Gain insights into cutting-edge therapies and make informed investment choices.
- Healthcare Analysts: Streamline your analysis with comprehensive data on innovative treatments.
- Consultants: Easily modify reports and presentations to showcase the latest advancements in therapeutics.
- Pharmaceutical Enthusiasts: Enhance your knowledge of drug development processes and market trends.
- Educators and Students: Utilize it as a valuable resource for learning about biotechnology and pharmaceuticals.
What the Template Contains
- Preloaded APLT Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.