**Expanded Financial Projections (Year 1)**

This breakdown clarifies assumptions, identifies gaps, and proposes adjustments to align with the 18% ROI target.

---

### **Revenue Breakdown**

| **Line** | Units Sold | Avg. Price (ETB) | Revenue (ETB) | Notes |

|-------------------------|------------|-------------------|---------------|----------------------------------------|

| **Cannes Collection** | 1,500 | 4,400 | 6,600,000 | Assumes 50% pre-sold via diaspora pre-orders. |

| **Everyday Line** | 24,750 | 400 | 9,900,000 | 2,062 units/month at 300–800 ETB range. |

| **Total Revenue** | — | — | 16,500,000 | |

**Key Assumptions:**

- **Cannes Line**: Limited to 1,500 units due to exclusivity.

- **Everyday Line**: Targets 0.1% market share of Addis Ababa’s 5M residents (2.5M adults).

---

### **Cost of Goods Sold (COGS)**

| **Component** | Cost (ETB) | % of Revenue | Details |

|-----------------------|-------------|-------------|------------------------------------------|

| Materials | 4,950,000 | 30% | Organic cotton (60%), dyes, packaging. |

| Labor | 2,475,000 | 15% | Hawassa factory workers (avg. 3,000 ETB/month). |

| Overhead | 825,000 | 5% | Factory utilities, equipment maintenance. |

| **Total COGS** | 8,250,000 | 50% | Gross margin = 50% |

---

### **Operating Expenses**

| **Category** | Cost (ETB) | % of Revenue | Details |

|-----------------------|-------------|-------------|------------------------------------------|

| Rent (Stores/Factory) | 1,500,000 | 9% | Bole flagship store + Hawassa facility. |

| Salaries | 2,250,000 | 13.6% | 15 employees (avg. 12,500 ETB/month). |

| Marketing | 3,000,000 | 18% | Cannes activation (6.875M ETB not fully expensed in Year 1). |

| Logistics | 1,000,000 | 6% | Local delivery, export shipping. |

| Admin/Misc. | 487,500 | 3% | Legal, software, contingencies. |

| **Total OpEx** | 7,237,500 | 44% | |

---

### **Profitability & ROI**

| **Metric** | Value (ETB) | Notes |

|-----------------------|---------------|----------------------------------------|

| Gross Profit | 8,250,000 | Revenue – COGS |

| Operating Profit | 1,012,500 | Gross Profit – OpEx |

| Taxes (20%) | 202,500 | Assumes Ethiopian corporate tax rate. |

| **Net Profit** | **810,000** | **3% ROI** (810k / 27.5M total investment) |

**Issue**: The original projection of 18% ROI (4.95M ETB profit) is unachievable with current assumptions.

---

### **Adjustments to Achieve 18% ROI**

To reach **4,950,000 ETB net profit** (18% of 27.5M ETB):

1. **Increase Sales Volume**

- **Cannes Line**: Sell 3,000 units (not 1,500) via expanded diaspora outreach.

- New Revenue: 3,000 units x 4,400 ETB = **13,200,000 ETB**.

- **Everyday Line**: Capture 0.25% market share (6,188 units/month).

- New Revenue: 74,250 units x 400 ETB = **29,700,000 ETB**.

2. **Reduce COGS to 40% of Revenue**

- Bulk cotton purchases (-10% material costs).

- Automate stitching (-15% labor costs).

3. **Trim Operating Expenses**

- Negotiate rent (-20%), use hybrid remote staff (-15% salaries).

| **Revised Metric** | Value (ETB) |

|-----------------------|---------------|

| Total Revenue | 42,900,000 |

| COGS (40%) | 17,160,000 |

| OpEx (30%) | 12,870,000 |

| **Net Profit** | **12,870,000**|

| **ROI** | **46.8%** |

---

### **Monthly Cash Flow Considerations**

| **Month** | Inflows (ETB) | Outflows (ETB) | Net Cash Flow (ETB) |

|-----------------|---------------|----------------|----------------------|

| Jan–Mar 2024 | 2,000,000 | 8,000,000 | -6,000,000 | (Initial setup costs)

| Apr–Jun 2024 | 4,500,000 | 3,000,000 | +1,500,000 | (Local launch)

| Jul–Sep 2024 | 5,500,000 | 2,500,000 | +3,000,000 | (Cannes activation)

| Oct–Dec 2024 | 4,500,000 | 2,000,000 | +2,500,000 |

| **Annual Total**| 16,500,000 | 15,500,000 | +1,000,000 |

**Note**: Initial negative cash flow requires a 6M ETB buffer (not included in original plan).

---

### **Recommendations**

1. **Adjust Sales Targets**: Aim for 3,000 Cannes units and 74,250 Everyday units.

2. **Optimize Costs**: Renegotiate supplier contracts and automate production.

3. **Secure Working Capital**: Raise additional 6M ETB to cover setup cash shortfall.

With these revisions, Boaz Trading PLC can realistically achieve its 18% ROI target.

Reply to this note

Please Login to reply.

Discussion

No replies yet.