Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceBusiness FinanceCapital Budgeting NPV and Payback Analysis

SpreadsheetBusiness FinanceFree

Capital Budgeting NPV and Payback Analysis

Evaluate an investment the way a CFO does: after-tax cash flows, NPV, approximate IRR, profitability index and simple and discounted payback.

Shown with sample data

Colour

Capital Budgeting NPV and Payback Analysis

Evaluate an investment the way a CFO does: after-tax cash flows, NPV, approximate IRR, profitability index and simple and discounted payback.

NPV
$118,225
IRR (approx.)
15%
Profitability index
1.2
Payback (years)
4.2
Capital for accepted projects
$810,000
NPV of accepted projects
$182,225
Cumulative cash by year
010

Latest: $376,750

NPV by discount rate
0%30%

Latest: -$169,112.88

How to use it

  1. 1On Assumptions, type your discount (hurdle) rate, tax rate, depreciation life and the longest payback you will accept.
  2. 2On Cash flows, enter the investment in year 0 (and any later years), yearly cash inflows or savings, operating costs, and other flows such as salvage value or working capital released.
  3. 3Read the Results sheet: accept projects with a positive NPV; use payback as a risk check.
  4. 4Check the Rate sensitivity sheet to see how NPV changes with the discount rate and where it crosses zero (the IRR).
  5. 5Add competing proposals to Project comparison to rank them by profitability index.

In this workbook

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

About this template

Should you buy the machine, build the warehouse or upgrade the system? Enter the investment, the cash it brings in and costs each year; the model works out depreciation, tax and after-tax cash flow, discounts every year at your hurdle rate, and gives NPV, an approximate IRR from a rate sensitivity table, the profitability index, and simple and discounted payback, then ranks the project against your other proposals.

Who it’s for

  • Capital expenditure (capex) requests and board papers
  • Comparing competing projects when capital is limited
  • Teaching discounted cash flow and payback

What’s included

  • Results sheet: NPV, IRR, profitability index and payback for the project.
  • Cash flows sheet: After-tax cash flow, discount factor and present value for each year. Sample: warehouse automation.
  • Rate sensitivity sheet: NPV at every discount rate from 0% to 30%; IRR is where NPV crosses zero.
  • Project comparison sheet: This project ranked against other proposals by profitability index.
  • Assumptions sheet: Rates and policy limits used throughout.

How to use it

  1. 1On Assumptions, type your discount (hurdle) rate, tax rate, depreciation life and the longest payback you will accept.
  2. 2On Cash flows, enter the investment in year 0 (and any later years), yearly cash inflows or savings, operating costs, and other flows such as salvage value or working capital released.
  3. 3Read the Results sheet: accept projects with a positive NPV; use payback as a risk check.
  4. 4Check the Rate sensitivity sheet to see how NPV changes with the discount rate and where it crosses zero (the IRR).
  5. 5Add competing proposals to Project comparison to rank them by profitability index.

Tips

  • Use incremental cash flows only: what changes because of the project. Sunk costs and allocated overheads that exist anyway do not count.
  • Include working capital tied up at the start (stock, receivables) and released at the end; it changes NPV more than people expect.
  • Run a downside case (inflows 20% lower) before presenting. A project that only works in the base case is a risky project.

Questions

How is NPV calculated here?

Each year’s net cash flow is multiplied by a discount factor of 1 ÷ (1 + rate)^year, and the present values are summed with SUMPRODUCT. A positive NPV means the project earns more than your hurdle rate.

How is IRR worked out without an IRR function?

The Rate sensitivity sheet calculates NPV at every rate from 0% to 30% and interpolates between the two rates where NPV changes from positive to negative. It is accurate to within a small fraction of a percent for normal projects.

What is a good payback period?

It depends on the risk and life of the asset. Many companies want three to five years for equipment; technology projects often need less. Payback ignores the time value of money and later cash flows, so use it alongside NPV.

What is the profitability index?

Present value of future cash flows ÷ initial investment. Above 1.0 means positive NPV; when capital is limited, rank projects by PI to get the most value per dollar invested.

Related searchesnpv calculatorcapital budgeting templatepayback period calculatordiscounted cash flow analysisprofitability indexirr calculatorcapex justification

Details

Format
Spreadsheet
Category
Business Finance
Sheets
5
Setup
10 min
Level
Advanced
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBusiness FinanceFree

Capital Budgeting NPV and Payback Analysis

Evaluate an investment the way a CFO does: after-tax cash flows, NPV, approximate IRR, profitability index and simple and discounted 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 Finance
Sheets
5
Setup
10 min
Level
Advanced
Price
Free

Your copy is private to you.

More business finance templates

View all
Subscription Revenue (MRR) Tracker4 sheets

Current MRR

$281,700

ARR

$3,380,400

MRR growth, last month

5%

Net new MRR by month
$6,200
$4,300
$7,800
$8,500
$8,500
Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026
SpreadsheetBusiness Finance

Subscription Revenue (MRR) Tracker

Monthly MRR bridge with new, expansion, contraction and churn, plus churn rate, net revenue retention, quick ratio and ARR.

10 min setupPreview
Freelance Income & Tax Set-Aside4 sheets

Income this year

$33,050

Tax reserved

$9,254

Tax still to pay

$2,234

Income by client
44%
  • Brightline Media
  • Granite Partners
  • Cedar Health
  • Oak & Pine Studio
SpreadsheetBusiness Finance

Freelance Income & Tax Set-Aside

Split every client payment into tax, savings and spending, and plan each quarterly tax payment.

10 min setupPreview
Startup Runway & Burn Rate Tracker2 sheets

Cash today

$821,600

Average net burn (3 months)

$71,900

Runway (months)

11.4

Net burn by month
$71k
$71k
$71k
$73k
$74k
Jun 2026Jul 2026Aug 2026Sep 2026Oct 2026
SpreadsheetBusiness Finance

Startup Runway & Burn Rate Tracker

Monthly revenue, spend and cash with net burn, runway in months and the date the money runs out.

10 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