Skip to content
The first pages of the Cost-Benefit Analysis template

Cost-Benefit Analysis

Document template for Google Docs and Word

Make a copy in Google Docs
Price
Free
Difficulty
Beginner
Updated
October 30, 2026

Every page (8)

Overview

Managers are often asked to choose between doing nothing, buying and building, and the case rests on assumptions nobody can see. This document lays the decision out in order: purpose, options compared, costs by year, benefits with evidence, NPV and payback, then a recommendation with a sign-off box.

The sample follows Ravenmoor Capital choosing how to replace manual reconciliation. Buying returns a $299K NPV at 8% over five years with a 2.3-year payback, and the sensitivity page shows where the choice flips. Replace the decision, options, yearly costs, benefits and discount rate with your own.

Useful for

  • A build versus buy decision where the committee wants NPV and payback side by side
  • A training or process investment where benefits must be evidenced before funding
  • A capital request to a finance reviewer who will test the discount rate and assumptions

What's included

  • Opening page with the decision required, key figures and the basis of the appraisal
  • Options page comparing do nothing, buy and build on criteria and a weighted score
  • Cost page with a five-year chart, a cost table and a contingency note
  • Benefits scorecard showing each benefit against its target with a status and the evidence
  • NPV and payback page with charts, key figures table and discount rate assumption
  • Recommendation and decision pages with a sign-off box, next steps and a make-it-yours guide

How to use it

  1. 1

    Click Make a copy in Google Docs, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    State the decision, the options and the horizon in the first box, then enter costs by year for each option, including the do-nothing baseline.

  3. 3

    Enter benefits with the evidence for each, discount costs and benefits at your finance policy's rate, and update the charts and the key figures table.

  4. 4

    Run the sensitivity at benefits minus 20% and costs plus 20%, note where the choice flips, and write your recommendation and next steps.

  5. 5

    Delete the guide page, then share the document with your approver or present it at the committee.

What you need

Requirements

  • A Google account with access to Google Drive

Works with

  • Google Docs
  • Microsoft Word (download the .docx)

Questions

Which discount rate should I use in the template?

Use the rate set by your finance policy or treasury, usually 7 to 10 percent. The sample uses 8 percent for every option so the comparison stays fair.

Why is there a do-nothing option?

Doing nothing is the honest baseline. Without it every option looks positive, because benefits that need no investment get credited to the project.

Are the company and figures real?

No. Ravenmoor Capital, the people, the email addresses and every figure in the sample are fictional. Replace them with your own details before sharing.

  • #cost-benefit-analysis
  • #npv
  • #payback
  • #options-appraisal
  • #build-vs-buy
  • #business-case
  • #google-docs

More cost benefit analysis templates

See all 3

Also in Finance

All finance templates
Get this template

Preparing your template…