Loma Negra Compañía Industrial Argentina Sociedad Anónima (LOMA) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Loma Negra Compañía Industrial Argentina Sociedad Anónima (LOMA) Bundle
Explore the financial prospects of Loma Negra Compañía Industrial Argentina Sociedad Anónima (LOMA) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and expenses to calculate the intrinsic value of LOMA and inform your investment decisions.
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 | 119.6 | 436.8 | 441.7 | 412.6 | 613.3 | 911.6 | 1,354.9 | 2,013.9 | 2,993.4 |
| Revenue Growth, % | 0 | 156.28 | 265.14 | 1.14 | -6.59 | 48.64 | 48.64 | 48.64 | 48.64 | 48.64 |
| EBITDA | 11.9 | 42.1 | 135.6 | 92.3 | 109.9 | 170.8 | 253.8 | 377.3 | 560.8 | 833.5 |
| EBITDA, % | 25.46 | 35.18 | 31.05 | 20.9 | 26.63 | 27.84 | 27.84 | 27.84 | 27.84 | 27.84 |
| Depreciation | 3.7 | 11.5 | 35.3 | 40.4 | 31.5 | 51.9 | 77.2 | 114.7 | 170.5 | 253.5 |
| Depreciation, % | 7.89 | 9.58 | 8.09 | 9.15 | 7.63 | 8.47 | 8.47 | 8.47 | 8.47 | 8.47 |
| EBIT | 8.2 | 30.6 | 100.3 | 51.9 | 78.4 | 118.8 | 176.6 | 262.5 | 390.2 | 580.0 |
| EBIT, % | 17.57 | 25.59 | 22.96 | 11.75 | 19.01 | 19.38 | 19.38 | 19.38 | 19.38 | 19.38 |
| Total Cash | 1.7 | 6.5 | 10.0 | 14.9 | 6.6 | 20.1 | 29.9 | 44.4 | 66.0 | 98.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3.8 | 5.9 | 9.3 | 13.5 | 38.7 | 33.8 | 50.3 | 74.8 | 111.1 | 165.2 |
| Account Receivables, % | 8.07 | 4.93 | 2.13 | 3.07 | 9.39 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 |
| Inventories | 6.5 | 8.1 | 16.6 | 62.1 | 74.8 | 69.5 | 103.2 | 153.4 | 228.1 | 339.0 |
| Inventories, % | 13.88 | 6.77 | 3.79 | 14.06 | 18.12 | 11.32 | 11.32 | 11.32 | 11.32 | 11.32 |
| Accounts Payable | 2.4 | 4.7 | 7.9 | 38.1 | 40.9 | 36.2 | 53.8 | 80.0 | 118.9 | 176.8 |
| Accounts Payable, % | 5.25 | 3.95 | 1.8 | 8.63 | 9.91 | 5.91 | 5.91 | 5.91 | 5.91 | 5.91 |
| Capital Expenditure | -15.6 | -27.9 | -42.6 | -31.4 | -35.9 | -101.0 | -150.1 | -223.1 | -331.6 | -492.8 |
| Capital Expenditure, % | -33.39 | -23.37 | -9.76 | -7.1 | -8.7 | -16.46 | -16.46 | -16.46 | -16.46 | -16.46 |
| Tax Rate, % | 40.84 | 40.84 | 40.84 | 40.84 | 40.84 | 40.84 | 40.84 | 40.84 | 40.84 | 40.84 |
| EBITAT | 6.4 | 40.8 | 40.5 | 9.1 | 46.4 | 70.2 | 104.3 | 155.1 | 230.5 | 342.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -13.3 | 22.8 | 24.5 | -1.3 | 6.9 | 26.7 | -1.2 | -1.7 | -2.6 | -3.9 |
| WACC, % | 10.89 | 11.08 | 10.58 | 10.39 | 10.74 | 10.74 | 10.74 | 10.74 | 10.74 | 10.74 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 17.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -4 | |||||||||
| Terminal Value | -45 | |||||||||
| Present Terminal Value | -27 | |||||||||
| Enterprise Value | -9 | |||||||||
| Net Debt | 143 | |||||||||
| Equity Value | -152 | |||||||||
| Diluted Shares Outstanding, MM | 584 | |||||||||
| Equity Value Per Share | -0.26 |
What You Will Get
- Real Loma Negra 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 Loma Negra’s 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
- Comprehensive DCF Calculator: Provides detailed unlevered and levered DCF valuation models tailored for Loma Negra (LOMA).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to Loma Negra (LOMA).
- Customizable Forecast Assumptions: Allows users to alter growth rates, capital expenditures, and discount rates for precise modeling.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Loma Negra (LOMA).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file for Loma Negra Compañía Industrial Argentina Sociedad Anónima (LOMA).
- Step 2: Review Loma Negra’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust the assumptions.
- Step 5: Evaluate the outputs and utilize the results for your investment strategies.
Why Choose This Calculator for Loma Negra (LOMA)?
- Accurate Data: Up-to-date financials from Loma Negra ensure dependable 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 building from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the industry.
- User-Friendly: Simple design and clear, step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Finance Students: Explore financial modeling techniques and apply them to real-world data from Loma Negra (LOMA).
- Academics: Utilize professional valuation models in your research or teaching focused on Loma Negra (LOMA).
- Investors: Evaluate your investment strategies and assess valuation scenarios for Loma Negra (LOMA).
- Analysts: Enhance your analytical processes with a customizable DCF model tailored for Loma Negra (LOMA).
- Small Business Owners: Understand the valuation approaches used for large public companies like Loma Negra (LOMA).
What the Template Contains
- Preloaded LOMA 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.