Hollard MLM Forecast — Campaign Viability & Paid Media Economics

Core Assumptions

Defaults are aligned to Hollard’s example (2 agents × 3 sales/day × 10 days = 60 sales/month).

Scenario Name Client / Insurer Driver Mode Target Policies / Month (if Target mode) Sales Agents (Phase 1) Working Days / Month Sales / Agent / Day Collection Rate (1P) % Average Premium (R / month) FYC % (Year-1 commission on Annualised Premium) Retention Holdback % (cash timing) Revenue Basis Year-2 Uplift % (optional, not in “Y1 cash”) Retention Earned % (optional, not in “Y1 gross”)

Cost Centers

Split into fixed/semi-fixed and variable costs. Keep inputs conservative when viability is uncertain.

Agent Cost (R / agent / month) FSCA Cost (R / agent / year) Compliance Cost / Agent / Month (R) Compliance Management (R / month) Team Leader / Manager (R / month) Other Fixed Overheads (R / month) QA Cost (R / sold policy) Retention Ops Cost (R / collected policy)

Tip: Hollard’s email explicitly lists “QA cost, retention costs, TL/manager cost” as additional levers — keep them at 0 only if they truly don’t apply in your POC.

Executive Snapshot (Base Month)

Instant viability view: revenue vs cost centers, and where the funnel has to land.

Metric	Value

Paid Media Funnel Inputs

Model either on Cost per Accepted or Cost per Fetched (the app will compute effective CPLs both ways).

Fetched → Accepted Rate % Accepted → Sale Conversion % CPL Basis CPL Value (R)

Funnel Totals (Base Month)

Fetched → Accepted → Sold → Collected

Stage	Volume	Rate

Campaign Economics (Base Month)

Per-stage costs and break-even thresholds.

Metric	Value

Funnel Snapshot (Chart)

Hover not needed — values are labelled directly. This mirrors what clients care about: volume + rates.

If you change conversion or acceptance, this chart updates immediately.

Unit Economics

All values are computed from the base month assumptions. Use this to negotiate pricing and targets.

Unit	Revenue	Cost	Profit	Margin

Interpretation: If “Profit per Accepted” is thin, your campaign is structurally fragile — any dip in conversion/collection pushes you negative.

What changes move the needle?

Fast sensitivity knobs (does not overwrite your inputs).

Stress: Accepted→Sale (Δ%) Stress: Collection (Δ%) Stress: CPL (Δ%) Stress: Agents (Δ)

Monthly Forecast (12 months)

Override any month cell (leave blank to use base assumptions). Exports include computed results.

Overrides: Agents, Working Days, Sales/Agent/Day, Collection %, Accepted→Sale %, Fetched→Accepted %, CPL Value.

Month	Agents*	Days*	Sales/Agent/Day*	Collection%*	Acc→Sale%*	Fetch→Acc%*	CPL*	Sold	Collected	Revenue	Total Cost	Profit	Cum Sold	Cum Collected	Cum Revenue	Cum Cost	Cum Profit	Details

* Override inputs (optional). All currency is ZAR.

Charts

Designed for decision-making: revenue vs cost composition vs profit.

Break-even CPL lines show the maximum CPL you can afford before profit turns negative (by month). “Actual” uses your selected CPL basis and effective funnel rates.

Assumption Checks

Flags common modelling pitfalls (units, rate ranges, and example alignment).

Client-ready notes

Export uses these notes (editable).

Prepared By

Narrative Summary (appears in PDF)

The PDF export is a print-to-PDF report (best reliability offline). Use Chrome/Safari: Export Client PDF → Save as PDF.