Asia Pacific Wire & Cable Corporation Limited (APWC) 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
Asia Pacific Wire & Cable Corporation Limited (APWC) Bundle
Designed for accuracy, our (APWC) DCF Calculator empowers you to evaluate the valuation of Asia Pacific Wire & Cable Corporation Limited using real-world financial data, offering complete flexibility to modify all key parameters for enhanced projections.
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 | 338.2 | 313.6 | 476.7 | 433.9 | 425.8 | 411.9 | 398.4 | 385.4 | 372.8 | 360.7 |
Revenue Growth, % | 0 | -7.27 | 52.01 | -8.97 | -1.87 | -3.26 | -3.26 | -3.26 | -3.26 | -3.26 |
EBITDA | 5.1 | 13.7 | -3.3 | 14.9 | 8.6 | 8.8 | 8.5 | 8.2 | 7.9 | 7.7 |
EBITDA, % | 1.52 | 4.38 | -0.69379 | 3.43 | 2.03 | 2.13 | 2.13 | 2.13 | 2.13 | 2.13 |
Depreciation | 5.3 | 5.3 | 5.3 | 5.7 | 6.2 | 5.9 | 5.7 | 5.5 | 5.3 | 5.1 |
Depreciation, % | 1.56 | 1.68 | 1.11 | 1.3 | 1.46 | 1.42 | 1.42 | 1.42 | 1.42 | 1.42 |
EBIT | -.2 | 8.5 | -8.6 | 9.2 | 2.4 | 2.9 | 2.8 | 2.7 | 2.6 | 2.6 |
EBIT, % | -0.04672344 | 2.7 | -1.81 | 2.12 | 0.5665 | 0.70795 | 0.70795 | 0.70795 | 0.70795 | 0.70795 |
Total Cash | 53.7 | 52.2 | 44.8 | 54.1 | 38.3 | 52.2 | 50.5 | 48.8 | 47.3 | 45.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 97.2 | 109.5 | 131.6 | 107.8 | 121.9 | 119.2 | 115.3 | 111.6 | 107.9 | 104.4 |
Account Receivables, % | 28.74 | 34.92 | 27.6 | 24.86 | 28.64 | 28.95 | 28.95 | 28.95 | 28.95 | 28.95 |
Inventories | 85.2 | 96.4 | 128.8 | 130.6 | 128.2 | 117.9 | 114.1 | 110.4 | 106.8 | 103.3 |
Inventories, % | 25.19 | 30.73 | 27.02 | 30.1 | 30.12 | 28.63 | 28.63 | 28.63 | 28.63 | 28.63 |
Accounts Payable | 10.5 | 17.4 | 32.4 | 29.3 | 41.0 | 26.2 | 25.4 | 24.5 | 23.7 | 22.9 |
Accounts Payable, % | 3.11 | 5.54 | 6.8 | 6.74 | 9.62 | 6.36 | 6.36 | 6.36 | 6.36 | 6.36 |
Capital Expenditure | -5.5 | -14.6 | -8.6 | -3.8 | -4.3 | -8.2 | -7.9 | -7.7 | -7.4 | -7.2 |
Capital Expenditure, % | -1.62 | -4.66 | -1.79 | -0.87764 | -1.01 | -1.99 | -1.99 | -1.99 | -1.99 | -1.99 |
Tax Rate, % | -733.41 | -733.41 | -733.41 | -733.41 | -733.41 | -733.41 | -733.41 | -733.41 | -733.41 | -733.41 |
EBITAT | .1 | 4.1 | -7.4 | 4.7 | 20.1 | 1.7 | 1.6 | 1.6 | 1.5 | 1.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -171.9 | -21.9 | -50.1 | 25.3 | 22.0 | -2.4 | 6.2 | 6.0 | 5.8 | 5.6 |
WACC, % | 2.65 | 4.06 | 5.19 | 4.16 | 5.59 | 4.33 | 4.33 | 4.33 | 4.33 | 4.33 |
PV UFCF | ||||||||||
SUM PV UFCF | 18.2 | |||||||||
Long Term Growth Rate, % | 1.00 | |||||||||
Free cash flow (T + 1) | 6 | |||||||||
Terminal Value | 171 | |||||||||
Present Terminal Value | 139 | |||||||||
Enterprise Value | 157 | |||||||||
Net Debt | 18 | |||||||||
Equity Value | 139 | |||||||||
Diluted Shares Outstanding, MM | 21 | |||||||||
Equity Value Per Share | 6.74 |
What You Will Receive
- Comprehensive Financial Model: APWC’s actual data facilitates accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, enabling repeated application for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Asia Pacific Wire & Cable Corporation Limited (APWC).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters for precise analysis.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to fit your analysis needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Asia Pacific Wire & Cable Corporation Limited (APWC).
- Interactive Dashboard and Charts: Visual representations that condense key valuation metrics for streamlined analysis.
How It Works
- Download: Obtain the comprehensive Excel file featuring Asia Pacific Wire & Cable Corporation Limited's (APWC) financial data.
- Customize: Tailor your forecasts, including revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: Enjoy real-time updates for intrinsic value and NPV calculations as you make adjustments.
- Test Scenarios: Generate various projections and instantly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose This Calculator for Asia Pacific Wire & Cable Corporation Limited (APWC)?
- Accurate Data: Utilize real financials from APWC for dependable valuation outcomes.
- Customizable: Tailor 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 beginning.
- Professional-Grade Tool: Created for investors, analysts, and consultants focused on APWC.
- User-Friendly: An intuitive design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Finance Students: Understand the intricacies of cable manufacturing and apply financial models using real-world data.
- Academics: Utilize industry-specific metrics in your research or teaching materials.
- Investors: Evaluate your investment strategies and analyze valuation metrics for Asia Pacific Wire & Cable Corporation Limited (APWC).
- Analysts: Enhance your analysis with a customizable model tailored for the wire and cable sector.
- Small Business Owners: Learn from the operational strategies of public companies like Asia Pacific Wire & Cable Corporation Limited (APWC).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Asia Pacific Wire & Cable Corporation Limited (APWC).
- Real-World Data: APWC’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into APWC's performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to APWC.
- Dashboard with Visual Outputs: Charts and tables presenting clear, actionable results for stakeholders.