Inventory valuation: the number that decides your profit
How stock is valued changes reported profit and tax without anything physical changing. FIFO against weighted average, what cost includes, and the write-down nobody wants to make.
A SWOT analysis is four boxes almost everyone fills in badly. The fix is a fifth column: what you will actually do about each point.
A SWOT analysis sorts what you know about a business into four boxes: Strengths and Weaknesses, which are internal and mostly within your control, and Opportunities and Threats, which are external and are not. It is the most widely used strategy tool in existence and, in most companies, the least useful — because the standard version ends with sixteen adjectives on a slide and nobody doing anything differently.
The failure is structural rather than intellectual. Four boxes invite listing, listing invites vagueness, and nothing in the format asks the only question that matters: so what? Add a column for the action each point implies and the same exercise becomes a planning session.
Keep internal and external strictly separated. The most common error is putting a market condition in Weaknesses — "the market is competitive" is a threat, not a weakness, and mixing them hides the distinction the tool exists to draw: what you can change versus what you must respond to.
The step most people skip has its own name. A TOWS analysis takes the same four boxes and pairs them: strengths that could exploit opportunities, strengths that defend against threats, weaknesses that opportunities are blocked by, weaknesses that threats would make dangerous. Those four combinations are where strategies come from — the plain SWOT is only the raw material. It takes twenty extra minutes and it is the difference between a list and a plan.
Ettex Sheets suits the working version: import an existing XLSX with formulas intact, one row per point with columns for quadrant, evidence, action and owner, dropdown validation so the quadrant stays consistent, filters to read all actions at once regardless of which box they came from, conditional formatting to flag points with no action, and cell comments so a disputed claim is argued next to it. Version history means last quarter's analysis is recoverable for comparison — which is the only way to see whether anything changed. The narrative version belongs in Ettex Docs, the resulting actions go in Ettex Board with owners and due dates, and if the analysis is presented, Ettex Slides handles the deck.
Plainly: Ettex has no strategy tooling. There is no SWOT feature, no competitor data, no market intelligence, no automatic analysis of your numbers, and nothing here will suggest what belongs in a quadrant. It is a spreadsheet with structure and a board for what follows. The thinking, and the evidence, are yours. Where the output is a decision to bid or not, it feeds straight into bid writing rather than sitting in a strategy deck.
A framework sorting what you know into Strengths, Weaknesses, Opportunities and Threats — the first two internal and controllable, the second two external — as an input to strategy.
A weakness is internal and yours to fix; a threat is external and must be responded to. Competitive pressure is a threat; depending on one specialist is a weakness.
About five. The constraint forces prioritisation, which is where the value is — unlimited lists are comfortable and useless.
The step after SWOT: pairing the quadrants to generate strategies — strengths that exploit opportunities, strengths that counter threats, weaknesses exposed by opportunities or threats. It is where the plan comes from.
Quarterly for a fast-moving business, annually otherwise — and always compared with the previous one, since the change is more informative than the snapshot.
An evidence column and an action column with owners and dates. Without them it produces a slide; with them it produces a work list.
A SWOT analysis is worth doing when every point carries evidence and an action. Five per box, internal separated from external, then twenty minutes of TOWS — and the output goes on the board, not into the deck. Where the output is a decision to pursue an opportunity, it belongs next to the business proposal template rather than in a strategy deck.
How stock is valued changes reported profit and tax without anything physical changing. FIFO against weighted average, what cost includes, and the write-down nobody wants to make.
Staff turnover is easy to calculate and easy to misread. How to work it out, why voluntary and involuntary must be separated, and what a replacement actually costs.
Business interruption cover replaces lost profit while you cannot trade. How the sum insured is calculated, why the indemnity period is the number that matters, and what is usually excluded.