Three-Year NPV Worksheet#

Purpose#

The ROI Framework gives the single-year view an engineering VP quotes. This worksheet produces the multi-year, discounted view a CFO asks for: the three-year net present value (NPV) and payback of a Claude Enterprise seat purchase. Fill in your own numbers; the worked example carries the framework’s illustrative figures across three years so the two pages reconcile.

Every dollar figure below is an illustrative placeholder. Replace each with your negotiated seat quote and your own measured inputs.

The Discount Mechanic#

A dollar of benefit in Year 3 is worth less than a dollar today. NPV restates every future net cash flow in today’s dollars using your cost of capital r (weighted-average cost of capital, or the hurdle rate finance hands you).

Discount factor (year t) = 1 / (1 + r)^t

NPV = sum over t of ( net cash flow_t x discount factor_t )

where net cash flow_t = benefit_t - cost_t

This worksheet uses end-of-year discounting (each year’s net flow is discounted as if it lands on the last day of the year) and puts one-time setup in Year 0 at a discount factor of 1.0. State the convention next to the result so it is not re-derived differently later.

Inputs to Gather#

The risk-adjusted benefit per active user per year is the spine of the model:

Benefit / active user / year =
  hours saved/week x working weeks x loaded hourly cost
  x value-conversion factor x risk multiplier

Example: 2 x 48 x $75 x 0.6 x 0.75 = $3,240 / active user / year

Year-by-Year Build#

Active users = purchased seats x active-seat ratio. Benefit = active users x risk-adjusted benefit per user. Recurring cost = subscription + enablement + admin, with enablement tapering after the ramp.

Headline Results#

For this cash-flow shape – a small upfront cost recovered within months – IRR runs into the hundreds of percent and stops being informative. NPV and payback are the numbers to present.

Sensitivity#

NPV is most sensitive to the two multipliers that scale the benefit line: the active-seat ratio and the value-conversion factor. Both are linear, so a percentage change in either moves total benefit PV by the same percentage. The discount rate moves the result far less over a three-year horizon.

The break-even point is the honest headline: realized benefit (adoption x conversion) can fall to about 42% of plan before three-year NPV reaches zero.

Break-even benefit multiplier = cost PV / benefit PV
                              = $1.10M / $2.65M
                              = ~0.42

That margin of safety is the argument for the purchase, not the base-case NPV. If you cannot defend hitting 42% of the adoption plan, the inputs are wrong, not the deal.

How to Use It#

1. Copy the input table and replace every value with your quote and your measured numbers.
2. Compute risk-adjusted benefit per active user once, then fill the year-by-year build.
3. Apply discount factors for your own r and sum the present-value row for NPV.
4. Run the sensitivity rows by scaling the benefit line and recomputing – find your own break-even multiplier.
5. Forecast the active-seat ratio from pilot data, not from hope. It is the input that decides the result. See Cohort Strategy for producing that number, and the ROI Framework for the underlying benefit and cost definitions.

References#

• ROI Framework – benefit categories, the value-conversion factor, and risk adjustment.
• Context Budget Worksheet – the companion fill-in worksheet for context, not cost.
• Forrester Total Economic Impact (TEI) methodology – risk-adjusted NPV for software business cases.