Reference

Templates and checklists

Part of the Market Competitive Intelligence skill · loaded on demand from SKILL.md

Read this when you are producing any of the skill's outputs and want the copy-ready structure: the source ledger, boundary statement, value-chain table, profit-pool table and chart specification, sizing sheet, force-by-force evidence table, competitor profile, competitor comparison table, fact-base summary, and the partner review checklist. Placeholders in angle brackets are to be replaced; every quantitative field carries a source and an evidence grade.

1. Source ledger

One row per number that appears in any output. Keep it as the first tab of the workbook if the fact base is rendered with xlsx.

| ID | Number | Value | Source (document, date, page or table) | Grade (A-D) | Used in | Upgrade path |
|---|---|---|---|---|---|---|
| S1 | <what the number is> | <value and unit> | <source> | <A/B/C/D> | <pool / sizing / forces / competitor> | <what would raise the grade> |

Evidence grades: A, hard data from primary or audited sources. B, triangulated from two or more independent secondary sources or several consistent expert accounts. C, single source or reasoned inference. D, opinion.

The three numbers the recommendation is most sensitive to: <S-, S-, S->. Current grades: <>. Target: B or better before presentation.

2. Boundary statement

Decision question: <one sentence: the decision this fact base informs and who makes it>

Profit-pool boundary (the value chain)
- Products/services: <by customer function>
- Customers: <buyer groups included>
- Geography: <scope>
- Included activities: <list>
- Excluded: <item, reason> (one line each)

Forces boundary (the client's industry within the chain)
- Activity: <the activity the client performs>
- Rivals inside the boundary: <types of firm, named where relevant>
- Treated as substitutes rather than rivals: <types, with the reason>
- Boundary judgment calls that could change the answer: <one or two, with what changes>

Boundary test: of <n> lost bids / lost customers in <period>, <n> went to firms inside the boundary. <Any outside: explain.>

3. Value-chain table

| # | Activity | Performers (types, count, top names) | Revenue basis at this stage | Same firms perform adjacent activities? | Data availability and grade |
|---|---|---|---|---|---|
| 1 | <activity> | <performers> | <what is invoiced to whom> | <yes/no, which> | <source type, grade> |

Six to twelve rows. Include activities beside the main flow (financing, insurance, logistics, service, consumables, data).

4. Profit-pool table and chart specification

Profit measure: <operating profit / economic profit>, period: <normalised year>, currency: <>.

| Activity | Revenue ($) | Operating margin | Profit ($) | Share of revenue* | Share of profit | Depth (profit share / revenue share) | 5-yr trend (revenue, margin, driver) | Grade |
|---|---|---|---|---|---|---|---|---|
| <activity> | | | | | | | | |
| Total | | <blended> | | 100% | 100% | | | |

*Revenue shares are computed only across activities with a common revenue basis (for example, all activities that invoice the end customer). Upstream and pass-through activities are marked as such.

Control total (step 2): <value>, method: <>, grade: <>.
Activity sum (step 3): <value>. Gap: <n%>, explained by: <factor>.
Value identity: <upstream revenue> + <downstream gross margin> = <end-customer spend>: <holds / gap and reason>.
Sensitivities: <activity margin> +/-1 pt = +/-<$>; <activity margin> +/-1 pt = +/-<$>.
Why each pool is deep or shallow (hypotheses for the forces): <one line per activity>.
Client position: share of <activity> revenue <n%>; margin <n%> vs pool average <n%>; share of profit <n%>.

Chart specification (for xlsx or pptx): horizontal axis is cumulative revenue with one bar per activity, bar width proportional to the activity's revenue at its stage; vertical axis is operating margin; bar height is the activity's margin; bar area is therefore profit. Order bars along the value chain from upstream to downstream. Shade the client's activity. Add a small secondary table under the chart with share of revenue and share of profit side by side. Title states the profit measure, year and total pool.

5. Market sizing sheet

Definition: revenue earned by <whom> from <what> sold to <which customers> in <geography> in <year>.

| Method | Factor | Value | Source | Grade | Running result |
|---|---|---|---|---|---|
| Top-down | <aggregate> | | | | |
| | x <share factor 1> | | | | |
| | x <share factor 2> | | | | <result> |
| Bottom-up | <unit count> | | | | |
| | x adoption | | | | |
| | x spend per unit | | | | |
| | x share in scope | | | | |
| | x yield | | | | <result> |
| Comparable | <ratio from analogous market> | | | | |
| | x <base it is applied to> | | | | <result> |

Reconciliation
- Spread: <low> to <high>, <n%>.
- <Method A> vs <Method B>: gap explained by <factor>; adjusted <method> = <value>.
- Method with best-graded factors: <>.
- Reconciled estimate: <value>; range <low> to <high>.
- Growth: <n%> a year, sources <>, grade <>.
- Profit equivalent: <estimate> x <pool margin> = <>.
- Client position: <client revenue in this market> = <n%> share; addressable from existing customers: <>.

6. Force-by-force evidence table

One block per force. Rate strength only after the drivers are filled.

| Force | Driver | Indicator | Value | Source | Grade |
|---|---|---|---|---|---|
| <force> | <driver from the Porter list> | <measurable indicator> | <value> | <S-id> | <A-D> |
| | <driver> | | | | |
| **<Force> strength: <1-5>, trend: <rising/stable/falling>, cause: <>** | | | | | |

After the five blocks:

Factors, not forces: <growth, technology, government, complements: which force each acts through, and direction>.
Cyclical vs structural: <which of the observed changes are cyclical and excluded from the ratings>.
Consistency test: <does the structure explain observed profitability in each pool? one sentence per pool>.
Binding forces: <one or two>, because <>.
Implication for the client's segment: <how the binding forces bear on the client specifically>.

Driver lists per force (condensed from Porter, 2008):

  • Entry: supply-side scale economies, demand-side benefits of scale, switching costs, capital requirements, incumbency advantages independent of size, channel access, restrictive policy, expected retaliation.
  • Suppliers: concentration relative to the industry, dependence on the industry, switching costs, differentiation, no substitute for the input, forward-integration threat.
  • Buyers: concentration or purchase volume, standardised product, low switching costs, backward-integration threat; price sensitivity where the product is a large share of buyer cost, buyer margins are thin, or the product has little effect on the buyer's own quality or costs.
  • Substitutes: price-performance trade-off, buyer switching cost to the substitute.
  • Rivalry: number and balance of rivals, slow growth, exit barriers, commitment beyond economics, poor signal reading; price-based where products are near-identical, fixed costs high and marginal costs low, capacity lumpy, product perishable.

7. Competitor profile

## <Competitor name>
Type and ownership: <national / regional / entrant / specialist; listed / private / PE / family>
Size and growth: revenue <>, growth <n%> (organic <n%>), source <>, grade <>
Profitability: operating margin <n%>, source <>, grade <>
Footprint: <sites, geographies, overlap with client>
Customers: <segments served, concentration, overlap with client's accounts; how often met in bids>
Proposition: <what they sell on; pricing relative to client>
Cost position: <relative gross margin, cost to serve, scale advantages>
Capabilities: <the two or three that matter for the decision; the one or two gaps>
Recent moves (3 years): <acquisitions, launches, exits, pricing actions>
Stated goals: <from filings, investor material, interviews; cite>
Assumptions they appear to hold about the industry: <inferred from capital allocation and public statements; cite>
Likely next moves: <one to three, with the reasoning>
Response profile: if the client <move A>: <response>; if the client <move B>: <response>
Grades: numbers <>, goals and assumptions <>

8. Competitor comparison table

| Competitor | Type | Revenue, growth | Margin | Overlap with client | What they believe | Likely next move | Threat to client's target pool (H/M/L) | Grade |
|---|---|---|---|---|---|---|---|---|
| <name> | | | | | | | | |

9. Fact-base summary (one page)

# <Industry> fact base: <client>, <date>

Question: <decision this informs>
Boundary: <products, customers, geography; exclusions and why>

1. Where the profit sits. <Pool sizes and shares, depth ratios, direction of migration. Two or three sentences with numbers.>
2. Why. <Binding forces, strength, decisive evidence, grade. Two sentences.>
3. Where the client sits. <Share of revenue vs share of profit; margin vs pool average; exposure to binding forces. Two sentences.>
4. Who is positioned to take the pools that matter. <One line per competitor.>
5. What this opens or closes. <Two to four options, each: what it is, which Porter response it represents (position / exploit change / shape structure), the condition under which it works.>

Hypotheses tested: <H1: supported/refuted, grade, evidence>; <H2 ...>
Evidence gaps: <C and D grade items that matter; what would upgrade them>
Handed to: `strategic-choice` <what>, `war-gaming` <what>, `value-driver-modeling` <what>

10. Partner review checklist

Run before the fact base goes to executive-communication.

Boundary
[ ] Boundary stated on products, customers, geography, with exclusions and reasons
[ ] Every competitor the client loses to is inside the boundary
[ ] Boundary judgment calls listed with their effect on the answer

Profit pool
[ ] Profit measure and normalised year stated
[ ] Each activity's margin comes from a proxy, segment or sample, not a uniform assumption
[ ] Activity sum reconciles to the control total within tolerance, gap explained
[ ] Value identity along the chain holds
[ ] At least one activity's profit share differs materially from its revenue share
[ ] Five-year trend and driver given for each pool
[ ] Client's share of revenue and share of profit stated separately

Market sizing
[ ] Definition sentence written
[ ] Three methods, arithmetic shown, every factor sourced and graded
[ ] Gaps explained by factors, not averaged
[ ] Range, growth rate and profit equivalent given

Forces
[ ] Every rating rests on drivers with indicator, value, source and grade
[ ] Growth, technology, government, complements recorded as factors, not forces
[ ] Effects (price sensitivity, low margins) not used as evidence
[ ] Cyclical changes separated from structural
[ ] One or two binding forces named
[ ] Forces explain the pool map (consistency test passed for every pool)

Competitors
[ ] Three to six profiles, selection rule stated
[ ] Goals and assumptions fields filled with cited evidence
[ ] Response profile given for each option under consideration

Summary
[ ] Says where the profit is, why, where the client is, what it opens or closes
[ ] Options mapped to Porter's three responses; no choice made
[ ] Hypotheses from hypothesis-stress-testing answered with grades
[ ] Evidence gaps listed
[ ] No em dashes, no emojis, no placeholders in client-facing text