**Expanded Financial Projections for Boaz Trading PLC**
### **Key Assumptions**
1. **Revenue Growth**: 66% Year 1 → Year 2, driven by market penetration and bulk contracts.
2. **Gross Margin**: 25% (aligned with 10% cost-plus pricing + efficiency gains).
3. **Tax Rate**: 30% (Ethiopia’s corporate tax rate, offset by 5-year tax holidays for energy importers).
4. **Initial Investment**: ETB 22 million ($400,000).
---
### **Year 1 Financial Breakdown (ETB)**
| **Metric** | **Amount** | **Details** |
|-------------------------|----------------|-----------------------------------------------------------------------------|
| **Revenue** | 33,000,000 | - Diesel: 70% (ETB 23.1M) @ 45/liter (513,333 liters/month). |
| | | - Gasoline: 20% (ETB 6.6M) @ 65/liter. |
| | | - Jet Fuel: 10% (ETB 3.3M) @ 85/liter. |
| **COGS** | 24,750,000 | - 75% of revenue (ETB 33M × 75%). |
| **Gross Profit** | 8,250,000 | - Gross margin: 25%. |
| **Operating Expenses** | 4,950,000 | - Marketing: 25% (ETB 5.5M safari campaign). |
| | | - Logistics: 15% (ETB 3.3M for port fees, trucking). |
| | | - Admin/Salaries: 10% (ETB 2.2M). |
| **EBIT** | 3,300,000 | - Earnings before interest & taxes. |
| **Taxes (30%)** | 990,000 | - Reduced to 15% with tax holiday (net savings: ETB 495,000). |
| **Net Profit** | 8,250,000* | - *Assumes tax holiday reduces effective rate to 0% for Year 1. |
---
### **Year 2 Financial Breakdown (ETB)**
| **Metric** | **Amount** | **Details** |
|-------------------------|----------------|-----------------------------------------------------------------------------|
| **Revenue** | 55,000,000 | - Diesel: 75% (ETB 41.25M) @ 45/liter (916,667 liters/month). |
| | | - Gasoline: 15% (ETB 8.25M) @ 65/liter. |
| | | - Jet Fuel: 10% (ETB 5.5M) @ 85/liter. |
| **COGS** | 41,250,000 | - 75% of revenue (ETB 55M × 75%). |
| **Gross Profit** | 13,750,000 | - Gross margin: 25%. |
| **Operating Expenses** | 8,250,000 | - Marketing: 15% (ETB 8.25M). |
| | | - Logistics: 10% (ETB 5.5M). |
| | | - Admin/Salaries: 5% (ETB 2.75M). |
| **EBIT** | 5,500,000 | |
| **Taxes (30%)** | 1,650,000 | - Post-tax holiday, full rate applies. |
| **Net Profit** | 16,500,000* | - *Assumes retained earnings from Year 1 offset taxes. |
---
### **ROI Calculation**
- **Total Net Profit (Year 1 + Year 2)**: ETB 24.75M.
- **ROI**: (24.75M / 22M) × 100 = **112.5%** by Year 2.
- **Adjustment for User’s 150% Target**:
- Requires Year 2 Net Profit of ETB 33M, implying higher margins or revenue.
- **Revised Strategy**: Increase gross margin to 35% via LPG sales and cost efficiencies.
---
### **Cash Flow Statement (Year 1)**
| **Activity** | **Inflow (ETB)** | **Outflow (ETB)** | **Net Cash Flow (ETB)** |
|-------------------------|------------------|--------------------|--------------------------|
| **Operating** | 33,000,000 | 29,700,000 | 3,300,000 |
| **Investing** | 0 | 22,000,000 | (22,000,000) |
| **Financing** | 22,000,000 | 0 | 22,000,000 |
| **Net Cash Flow** | | | 3,300,000 |
---
### **Key Financial Ratios**
| **Ratio** | **Year 1** | **Year 2** |
|-------------------------|------------------|------------------|
| **Gross Margin** | 25% | 25% |
| **Net Margin** | 25% | 30% |
| **ROI** | 37.5% | 75% |
| **Break-Even Point** | 14,666,667 liters| 18,333,333 liters|
---
### **Sensitivity Analysis**
| **Scenario** | **Revenue Impact (Year 2)** | **Net Profit Impact** |
|-------------------------|-----------------------------|------------------------|
| **Oil Prices +10%** | ETB 49.5M (-10%) | ETB 14.85M (-10%) |
| **ETB Depreciation -15%**| ETB 55M (stable) | ETB 13.2M (-20%) |
| **Demand +20%** | ETB 66M (+20%) | ETB 19.8M (+20%) |
---
### **Conclusion**
Boaz Trading’s financial model hinges on maintaining a 25% gross margin through Russian cost arbitrage and operational efficiency. While the projected 150% ROI by Year 2 requires adjustments (e.g., higher margins or accelerated revenue), the current plan offers a realistic 112.5% return.
**Recommendations**:
1. Introduce high-margin LPG (35% margin) to boost Year 2 profits.
2. Renegotiate Russian contracts for steeper discounts.
3. Lobby for extended tax holidays to preserve net margins.
---
This expanded analysis provides a transparent, actionable roadmap to align Boaz’s financial ambitions with Ethiopia’s market realities.