Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesBusiness & StrategyBusiness Plans & StrategyCost-Benefit Analysis

SpreadsheetBusiness Plans & StrategyFree

Cost-Benefit Analysis

Multi-year costs and benefits, discounted to present value, with NPV, benefit-cost ratio, ROI and payback.

Shown with sample data

Colour

Cost-Benefit Analysis

Multi-year costs and benefits, discounted to present value, with NPV, benefit-cost ratio, ROI and payback.

Total costs
$687,000
Undiscounted
Total benefits
$1,457,000
Undiscounted
PV of costs
$613,577
PV of benefits
$1,148,588
Net present value (NPV)
$534,990
Positive = worth doing
Benefit-cost ratio
1.9
Above 1.0 = benefits exceed costs
Return on investment
112%
Undiscounted, whole period
Payback (years)
1.8
0 = not paid back within 5 years
Cumulative net position by year
05

Latest: $770,000

Net present value by year
  • 0-$309,000
  • 1$100,923
  • 2$206,609
  • 3$194,481
  • 4$169,785
  • 5$172,192

How to use it

  1. 1Set the discount rate on the Settings sheet; your finance team will have a standard rate (often 6–12%).
  2. 2List every cost and benefit on the Line items sheet, one row each, with amounts by year. Year 0 is the up-front investment.
  3. 3Classify each line as One-off cost, Running cost or Benefit.
  4. 4Read the Cash flow by year sheet: a positive NPV and a benefit-cost ratio above 1 mean the benefits outweigh the costs in today’s money.
  5. 5Test the result: cut benefits by 20% and see whether the case still holds.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A cost-benefit analysis tells you whether an investment is worth making and how sure you can be. List one-off costs, running costs and benefits for each year; the workbook discounts every cash flow to today’s money, then calculates net present value, the benefit-cost ratio, ROI and the payback point. The sample appraises a warehouse management system for a freight company.

Who it’s for

  • Business cases for systems, equipment or process changes
  • Comparing a project against doing nothing
  • Public-sector and grant appraisals
  • Capital approval committees

What’s included

  • Line items sheet: Every cost and benefit, by year, with its present value.
  • Cash flow by year sheet: Costs and benefits by year, discounted, with cumulative position and payback.
  • Settings sheet: Discount rate and analysis settings.

How to use it

  1. 1Set the discount rate on the Settings sheet; your finance team will have a standard rate (often 6–12%).
  2. 2List every cost and benefit on the Line items sheet, one row each, with amounts by year. Year 0 is the up-front investment.
  3. 3Classify each line as One-off cost, Running cost or Benefit.
  4. 4Read the Cash flow by year sheet: a positive NPV and a benefit-cost ratio above 1 mean the benefits outweigh the costs in today’s money.
  5. 5Test the result: cut benefits by 20% and see whether the case still holds.

Tips

  • Count only incremental costs and benefits: what changes because of the project compared with doing nothing.
  • Be conservative with benefits and generous with costs. Most business cases overstate the first and miss the second (training, backfill, change management, hardware refresh).
  • Labour savings are only real if the hours are redeployed to valuable work or the cost is actually removed. Say which in the line item.
  • Exclude sunk costs already spent; they do not change the decision.

Questions

What is a good benefit-cost ratio?

Anything above 1.0 means discounted benefits exceed discounted costs. Many organisations look for 1.5 or more to allow for estimation risk.

Why discount future cash flows?

Money received later is worth less than money today, because today’s money could be invested or used to pay down debt. Discounting converts every year’s figures into today’s value so they can be compared fairly.

What is the difference between payback and NPV?

Payback shows how quickly the investment is recovered, ignoring what happens after. NPV values all cash flows over the whole period. Use both: a fast payback with a low NPV can still be a weak investment.

Which discount rate should I use?

Use your organisation’s cost of capital or hurdle rate. Public bodies often have a mandated rate, for example 3.5% in some government appraisal guidance. Rules vary by country and sector.

Related searchescost benefit analysis templatecba templatebenefit cost rationpv calculatorpayback period calculatorinvestment appraisal

Details

Format
Spreadsheet
Category
Business Plans & Strategy
Sheets
3
Setup
30 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBusiness Plans & StrategyFree

Cost-Benefit Analysis

Multi-year costs and benefits, discounted to present value, with NPV, benefit-cost ratio, ROI and payback.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Business Plans & Strategy
Sheets
3
Setup
30 min
Level
Intermediate
Price
Free

Your copy is private to you.

More business plans & strategy templates

View all

Company Name: Business Plan

Prepared by: Founder Name, Title · Date: Month Year · Contact: email@company.com

1. Executive summary

Write this last. In one page, cover the problem, your solution, the market, traction, team, financial highlights and what you are asking for.

Company Name helps target customer achieve outcome by your solution. Since launching in month year, we have key traction: customers, revenue, growth. We are seeking $ amount to use of funds, which will ta

2. Problem

Describe the pain clearly and who feels it. Use evidence.

  • •Customer segment struggle with problem, costing them time/money/risk.
  • •Current alternatives (alternative 1, alternative 2) fall short because reas
DocumentBusiness Plans & Strategy

Business Plan

A lender- and investor-ready business plan with guidance in every section.

90 min setupPreview

Business Model Canvas: Business or idea name

Prepared by: Name Date: Date Version: 1

1. Customer segments

Who are we creating value for? Who are our most important customers?

  • •Segment 1: who they are and what job they need done
  • •Segment 2

2. Value propositions

What problem do we solve and why us rather than the alternative?

  • •For segment 1: What they get and the gain or pain it addresses
  • •For segment 2: Value proposition
DocumentBusiness Plans & Strategy

Business Model Canvas

The nine building blocks of a business on one page, with prompts for each and a list of assumptions to test.

10 min setupPreview

Business Name: Plan on a Page

Period: 2027 · Owner: Name · Last updated: Date

Vision

In three years, Business Name will be where you want to be.

Who we serve

Ideal customer: who they are, where they are, what they value.

Problem we solve

The specific pain or need, in the customer's words.

DocumentBusiness Plans & Strategy

One-Page Business Plan

Your whole strategy on a single page: vision, customers, offer, plan and numbers.

25 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ