Toolkits02 · Business case and NPV workbook
Item 02 · business case and npv workbook · KSA and GCC consumer healthcare

Business case and NPV workbook: the launch case finance approves

A 26-slide business case with the NPV workbook behind it — price chain to NSP, five-year forecast with its narrative, returns, sensitivities, gates — for a launch, a line extension or a price move.

Slide 3 from the Business case and NPV workbook example (watermarked preview)
From the worked example: slide 3 of 26. Every preview carries a watermark; the files do not.

What you will have written when you finish

  1. 1The price chain from shelf price to net sales price, one basis, every margin visible
  2. 2The five-year forecast with the narrative behind each year: doors, velocity, price, cannibalisation
  3. 3Launch A&P by activity and the cost of goods, landed
  4. 4The P&L by year and the cash line: peak cash, payback, NPV and IRR against the thresholds
  5. 5Sensitivities on price, volume and cost, and the point at which the case fails
  6. 6Phasing and gates: what is decided when, and what stops the launch
  7. 7Risks with an owner, and the decision slide a finance partner signs

7 slides from the example

Slides 1 · 3 · 7 · 11 · 14 · 17 · 21 of 26 · click to enlarge
Slide 1
Slide 3
Slide 7
Slide 11
Slide 14
Slide 17
Slide 21

2 sheets from the workbook

Returns and thresholds · Price waterfall · click to enlarge
Sheet: Returns and thresholds
Sheet: Price waterfall
The problem it solves

A case that finance sends back is a case with a number nobody can trace. Here every figure on a slide is a cell in the workbook: the waterfall, the doors × velocity forecast, NPV, IRR, payback, the four sensitivities and the hard gates.

Who it is for

Brand manager, portfolio lead, finance business partner in consumer healthcare, writing for a Gulf market and presenting to a regional or global team. Also the distributor marketer who co-writes it.

Not for

Prescription brands with a medical-affairs plan, agencies pitching creative work, or anyone who needs a company's proprietary template.

Also useful with this item

Read next on pharmagrowth.co

Every item includes

Fully editable
Text, charts, colours, logo. Move the spine into your company template in an hour; the how-to shows how.
Opens where you work
PowerPoint, Keynote, Google Slides and LibreOffice; the workbooks recalculate in Excel, Numbers, Sheets and LibreOffice. No macros, no passwords.
Instant download
The files arrive by link the moment payment clears.
Updates for twelve months
Corrections and renderer fixes to an item you bought, by email, free.
Refunds for wrong, broken or misdescribed files
Full refund or replacement within 30 days; changed your mind before downloading, 14 days.
Single-user licence, lifetime use
Any brand, any company, any market, for as long as you like. No resale, no redistribution.
Done with you
Writing this in the next eight weeks?

Three working sessions on your own document: inputs and numbers, the draft, and a review against the questions management will ask.

Ask about a session

Every example is set in one fictional world: Meridian Consumer Health, its distributor Northern Gulf Distribution Co., the scalp-care brand Clarisel and its competitors Scalvia, Sebravel, Scalpex and Trichoderm. Nahdi, Al-Dawaa and United are real Saudi pharmacy chains used as market fixtures with invented figures, as are the marketplaces, the quick-commerce apps and the discounter named in item 08. You see every box filled, every chart populated and every number reconciled, without a real company's data.