1 · PARAMETERS (edit any field — everything recalculates live)
capital is in Rupiah — converts for display
flat per-litre fee on small orders — deducted after operating costs
1× = working capital cycled buy→sell→collect once/month · weekly cycle ≈ 4×
drawn upfront, held as reserve (not deployed)
informational accrual (no longer part of investor return)
1 = Sunk repacker build (Rp 655.5M); 0 = No build, all capital goes to working capital / volume
in selected display currency · default 75,000 USD
appears on The Investor prospectus · max 50 characters
M3 · %
M6 · %
M9 · %
M12 · %
fixed investor return = investment × exit ROI% · operator keeps all trading profits above this
Net margin per cycle = of capital deployed. Monthly net = working capital × cycle margin × turns. Edits auto-save in this browser.
2 · Per-Litre Cost (% of Gross) — key driver: edit the % to set net margin
| Line | % of gross | Rp / litre | Running |
|---|
Percentages are of the gross margin (Rp /L), matching the xlsx. Transport+Insurance+Tax give the FOB; rental+manpower+machine+material take FOB down to NET.
Sell priceRp /L
− Buy / cost priceRp /L
= Gross marginRp /L
− Transport / Insurance / TaxRp /L
= FOBRp /L
− Rental / Manpower / Machine / MaterialRp /L
− Small order feeRp /L
= NET MARGINRp /L
Net on cost basis
At full MOQ 500,000 L → gross Rp , net Rp per batch.
3 · Reconciliation to Bulk (reference only)
| OPEX — material / batch | Rp |
|---|---|
| Palm oil (20,000 kg × 19,250) | 385,000,000 |
| Botol (50,000 × 1,500) | 75,000,000 |
| Kardus (4,167 × 2,000) | 8,333,333 |
| Label sticker (50,000 × 150) | 7,500,000 |
| Employee (24 org) | 6,250,000 |
| Electricity | 2,500,000 |
| OPEX total | 484,583,333 |
| CAPEX — repacker build | Rp |
|---|---|
| Tanks (stainless + 24 IBC) | 113,000,000 |
| Filter / pipe / installation | 75,000,000 |
| Filling / pump / heater / sealer / mixing | 217,500,000 |
| Perizinan (permits, permanent) | 250,000,000 |
| CAPEX total | 655,500,000 |
| Tie-out | Rp | Note |
|---|---|---|
| Grand total (OPEX + CAPEX) | 1,140,083,333 | one full repacker + first batch |
| Tier 1 capital (Rp 1.35 bn) | 1,350,000,000 | smallest capital tier (gross) |
| Less 5% mobilization | −67,500,000 | held as reserve |
| Deployable capital | 1,282,500,000 | after mobilization reserve |
| Contingency over budget | +142,416,667 | Tier 1 covers the full build |
✓ Tier 1 (Rp 1.35 bn), net of the 5% mobilization, funds one complete repacker line (CAPEX) plus the first material batch (OPEX), with ~Rp 142M to spare. CAPEX is treated as sunk in the model; larger tiers (Rp 2.70 / 4.05 / 8.10 bn) add revolving working capital on top of the same single build.
4 · Scenario Summary (fixed ROI by exit quarter; operator keeps all trading profit)
5 · Month-by-Month Detail
6 · Result — Returns & Valuation (reflects the investment & exit selected above)
7 · Notes & Open Parameters
- Inventory turns/month is the single biggest lever. Default is set to a conservative 1×. The flow chart describes a weekly buy→sell→collect cycle (≈4×) and up to 2–3×/week. Tell me the realistic collection cycle and I'll lock it.
- CAPEX defaults to the repacker build-out (tanks, filling/sealing machines, permits) ≈ Rp 655.5 mn per FM_bulk.pdf. It is treated as a sunk asset — it reduces deployable working capital but is not charged again against profit. Set it to 0 for a pure bulk-trade / toll-repack scenario.
- Mobilization cost (5%) is drawn upfront and modelled as a cash reserve held by the operator (nets out of the deal). If it's instead a fee paid away, the operator profit drops by that amount — confirm where it goes.
- Investor receives principal + a fixed ROI that varies by exit quarter (editable in Parameters: M3/M6/M9/M12). Return is fixed regardless of trading; all upside/downside accrues to the operator.
- Valuation: Project IRR is the unlevered annualized return on total capital (margins each month, full capital recovered at exit). Equity IRR is the investor's annualized return on principal. CAPEX is recovered at book at exit; adjust if salvage differs.
- Capital currency can be set to MYR, USD, EUR or AUD; the Rp exchange rate is pulled live from the internet (with an offline fallback). Trading profit accumulates as cash each month — there is no reinvestment into working capital.
- Operating costs (rental, manpower, machine) are modelled per-litre exactly as in fm_units.xlsx. If rental/manpower are actually fixed monthly costs, flag it and we can switch to a fixed-cost block.