Alpha Pro Tech, Ltd. (APT) 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
Alpha Pro Tech, Ltd. (APT) Bundle
Whether you’re an investor or analyst, this (APT) DCF Calculator is your go-to tool for accurate valuation. Filled with real data from Alpha Pro Tech, Ltd., you can adjust forecasts and instantly observe the effects.
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 | 46.7 | 102.7 | 68.6 | 62.0 | 61.2 | 69.8 | 79.6 | 90.7 | 103.4 | 117.8 |
Revenue Growth, % | 0 | 120.08 | -33.17 | -9.7 | -1.21 | 13.98 | 13.98 | 13.98 | 13.98 | 13.98 |
EBITDA | 3.6 | 32.3 | 8.7 | 5.5 | 5.1 | 9.6 | 11.0 | 12.5 | 14.3 | 16.3 |
EBITDA, % | 7.77 | 31.46 | 12.74 | 8.82 | 8.26 | 13.81 | 13.81 | 13.81 | 13.81 | 13.81 |
Depreciation | .6 | .7 | .8 | .8 | .9 | .8 | 1.0 | 1.1 | 1.2 | 1.4 |
Depreciation, % | 1.29 | 0.70983 | 1.19 | 1.31 | 1.51 | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |
EBIT | 3.0 | 31.6 | 7.9 | 4.7 | 4.1 | 8.8 | 10.0 | 11.4 | 13.0 | 14.8 |
EBIT, % | 6.48 | 30.75 | 11.55 | 7.5 | 6.75 | 12.61 | 12.61 | 12.61 | 12.61 | 12.61 |
Total Cash | 6.9 | 23.3 | 16.3 | 16.3 | 20.4 | 16.9 | 19.2 | 21.9 | 25.0 | 28.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 4.3 | 9.0 | 4.8 | 7.0 | 6.5 | 6.5 | 7.5 | 8.5 | 9.7 | 11.0 |
Account Receivables, % | 9.2 | 8.8 | 6.96 | 11.25 | 10.69 | 9.38 | 9.38 | 9.38 | 9.38 | 9.38 |
Inventories | 11.3 | 16.7 | 25.0 | 24.4 | 20.1 | 20.8 | 23.7 | 27.0 | 30.8 | 35.1 |
Inventories, % | 24.22 | 16.31 | 36.38 | 39.36 | 32.88 | 29.83 | 29.83 | 29.83 | 29.83 | 29.83 |
Accounts Payable | .5 | 2.0 | .5 | .7 | .8 | .9 | 1.0 | 1.1 | 1.3 | 1.5 |
Accounts Payable, % | 1.07 | 1.93 | 0.76926 | 1.09 | 1.31 | 1.23 | 1.23 | 1.23 | 1.23 | 1.23 |
Capital Expenditure | -1.3 | -1.1 | -2.5 | -.5 | -.8 | -1.3 | -1.5 | -1.7 | -2.0 | -2.3 |
Capital Expenditure, % | -2.78 | -1.11 | -3.68 | -0.79379 | -1.29 | -1.93 | -1.93 | -1.93 | -1.93 | -1.93 |
Tax Rate, % | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 |
EBITAT | 2.5 | 26.3 | 6.3 | 3.5 | 3.2 | 7.0 | 7.9 | 9.1 | 10.3 | 11.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -13.3 | 17.2 | -.8 | 2.3 | 8.1 | 5.8 | 3.7 | 4.2 | 4.8 | 5.4 |
WACC, % | 5.27 | 5.27 | 5.26 | 5.24 | 5.25 | 5.26 | 5.26 | 5.26 | 5.26 | 5.26 |
PV UFCF | ||||||||||
SUM PV UFCF | 20.5 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 5 | |||||||||
Terminal Value | 115 | |||||||||
Present Terminal Value | 89 | |||||||||
Enterprise Value | 109 | |||||||||
Net Debt | -16 | |||||||||
Equity Value | 125 | |||||||||
Diluted Shares Outstanding, MM | 12 | |||||||||
Equity Value Per Share | 10.52 |
What You Will Get
- Real Alpha Pro Tech Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Alpha Pro Tech, Ltd. (APT).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Alpha Pro Tech, Ltd. (APT).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Alpha Pro Tech, Ltd. (APT)'s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Alpha Pro Tech, Ltd. (APT).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Alpha Pro Tech, Ltd. (APT).
Key Features
- 🔍 Real-Life APT Financials: Pre-filled historical and projected data for Alpha Pro Tech, Ltd. (APT).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Alpha Pro Tech's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Alpha Pro Tech's 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 Alpha Pro Tech data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Alpha Pro Tech’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator?
- Accurate Data: Up-to-date Alpha Pro Tech financials guarantee trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the industry.
- User-Friendly: Simple design and straightforward instructions make it accessible for all users.
Who Should Use Alpha Pro Tech, Ltd. (APT)?
- Health and Safety Professionals: Discover innovative protective solutions and their applications in various industries.
- Researchers: Utilize advanced materials in studies related to infection control and personal protective equipment.
- Investors: Evaluate market trends and performance metrics specific to Alpha Pro Tech, Ltd. (APT).
- Supply Chain Managers: Optimize procurement processes with insights into the manufacturing of protective gear.
- Small Business Owners: Learn how to implement effective health and safety measures inspired by industry leaders like Alpha Pro Tech, Ltd. (APT).
What the Template Contains
- Historical Data: Includes Alpha Pro Tech's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Alpha Pro Tech's 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 Alpha Pro Tech's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.