Most business case templates are a spreadsheet with headings. This one is an appraisal: the arithmetic is answerable, the assumptions are dated, and the file tells you when it has stopped being internally consistent.
The workbook runs 21 tabs from a single Options Register. Capital, run cost, three benefit types, capital avoided, working capital and a risk reserve are typed once and read by formula everywhere else. The engine produces 1,385 discounted rows, and the metrics tab reports NPV, IRR, MIRR with both rates named, discounted and simple payback interpolated on the year's increment, and a benefit-cost ratio – each with its basis printed in the next cell, so a reviewer can re-derive it rather than trust it.
It is built for the five-case model (strategic, economic, commercial, financial, management) and it is honest about the four things that decide an appraisal and usually go unstated: the timing convention, the reserve, capital avoided as a counterfactual rather than income, and the fact that the metrics disagree. Option B wins on NPV in the worked example; Option A wins on value per dollar. The file shows both rankings and says why they differ.
What separates it from a template you could build yourself is the checking. %d live ties compare one tab's answer with another's, and a single master row reports CLEAN or REVIEW. Change an input on purpose and watch which ties move. The limitations tab lists what the model deliberately does not do – no terminal value, simplified tax, working capital reversed at the horizon, benefits modeled rather than measured – because a model that hides its limits cannot be defended when one of them bites.
The pack sells with the model, not after it: a %d-slide deck that can go straight to a committee, a %d-page guide that explains each tab and each formula, a two-page board summary, three one-page cards for the people who will not read anything else, and a written licence.
Every rate is dated and attributed, and the file carries an as-of date instead of TODAY(), so a printed figure can never contradict the formula behind it. Nothing is locked, nothing is hidden, and there are no macros.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Business Case Development, Business Case Example PowerPoint Slides: Business Case Model with Five-Case Appraisal PowerPoint (PPTX) Presentation Slide Deck, WebsiteGeek