Business Case Financial Model

A revenue, cost and NPV model to support an innovation business case, with assumptions isolated on their own tab so reviewers can argue with the inputs instead of the output.

InnoLead · February 14, 2022 · Microsoft Excel workbook (.xlsx)

Financial models for new businesses are wrong by definition. The useful ones make it obvious where they're wrong. This model puts every assumption on a single tab and drives all projections from there.

It covers revenue build, cost structure, headcount, capital requirements, and a five-year NPV with adjustable discount rate, plus upside and downside scenarios.

Walk finance through the assumptions tab first. Reviews go materially better when the conversation starts there.

Revenue, cost and NPV model to support an innovation business case. This tool is part of the InnoLead Tools library — a set of editable templates drawn from what our members use to run innovation functions inside large organizations.

How to use it
  • Download the workbook and save a copy under your team's naming convention.
  • Replace the sample rows with your own initiatives, then adjust the column headers to match how your organization tracks work.
  • Refresh it on a set cadence — most teams update monthly and review with leadership quarterly.
Download
Download the excel file
More like this

Thanks to our strategic partners

AIPath logoAucctus logoDisruptive Edge logoEzassi logoHYPE logoITONICS logoPeer Insight logoQmarkets logoWellspring logo