02 · Excel model
Insurance agency operating model
Fifteen offices, modeled month by month: which make money, where it leaks, and whether a sixteenth is worth opening. Click through the tabs.
Mesa_Ridge_Insurance_Operating_Model.xlsx{{sheetName}}
fx{{formula}}
Net revenue and EBITDA by month
Net revenueEBITDA
{{b.m}}
Office #16:{{verdict}}· {{o16line}}
| Input | Value | Reasoning |
| {{a.l}} |
{{a.v}} |
{{a.w}} |
| Office | Rank | Net revenue | Total costs | Contribution | | Margin | Policies (Oct) |
| {{o.n}} | {{o.rank}} | {{o.rev}} | {{o.cost}} | {{o.con}} |
|
{{o.m}} | {{o.pif}} |
| Office | Policy growth | New policies | Retention | Lead cost / policy | Producer comp % | Chargebacks % |
| {{k.n}} | {{k.growth}} | {{k.newp}} |
{{k.ret}} | {{k.cpp}} |
{{k.prod}} | {{k.cb}} |
Cumulative cash, months 1–24 (after build-out)
M1 · opens Jan-27M24
{{f.t}}
{{f.impact}}
{{f.o}} · {{f.todo}}
Total opportunity{{ftotal}}
Inputs in teal drive every formula. Made-up agency, real model structure.
NextThe NBA’s best contract values →