Best Value Complete Financial Planning Bundle →
✓ Financial Planning✓ Net Worth Tracker✓ Monthly Budgeting✓ Travel Budget Planner✓ Annual Budgeting Planner✓ Monthly Expense Tracker✓ Annual Tax Planner✓ Retirement Planning
$139 One purchase, no subscription
View Bundle →
by Segmio
View Bundles
Language
ENEnglishDEDeutschESEspañolFRFrançaisPTPortuguêsITItalianoARالعربيةNLNederlandsZH中文
NPV & IRR Calculator ›

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials NPV & IRR Calculator Spreadsheet Template for Google Sheets & Excel

Ten years of expected cash flow, each discounted back to today beside the amount you entered. The Essentials NPV & IRR Calculator spreadsheet template adds the internal rate of return, which the free build does not calculate, reads the payback period from the discounted flows rather than the raw ones, and gives a profitability index for comparing projects of different sizes. Google Sheets and Excel, one file. No macros, no VBA.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

View Ultimate NPV & IRR Calculator Spreadsheet Template
$29
Essentials NPV & IRR Calculator spreadsheet template - Google Sheets and Excel preview

What's Included

  • Ten years of expected cash flow
  • Internal rate of return, which the free build does not calculate
  • Payback period, read from the discounted flows rather than the raw ones
  • Profitability index, for comparing projects of different sizes
  • Each year discounted back to today, beside the amount you entered
  • Running totals both before and after discounting
  • Net present value, initial investment and total cash flows on a dashboard
  • Two charts - the annual flows, and the value building over time
  • A currency dropdown on the Dashboard that relabels money columns on both sheets
  • Works in Microsoft Excel and Google Sheets with no setup required
Ultimate Version Available

Need more from this template?

The Essentials Spreadsheet Template covers everyday tracking. The Ultimate Spreadsheet Template gives each part of the template its own sheet, with more capacity and deeper reporting on top.

Essentials - $19
  • Ten years of expected cash flow
  • Internal rate of return, which the free build does not calculate
  • Payback period, read from the discounted flows rather than the raw ones
  • Profitability index, for comparing projects of different sizes
Ultimate - $29
  • Three project sheets, pre-named as examples and yours to rename
  • Fifteen years of cash flow on each
  • A separate discount rate per project, so different risks are not held to one hurdle
  • The discount factor shown beside every year, so the discounting is legible
  • Value, rate of return, payback, profitability index and simple return for all three
See what's in the Ultimate version› One-time purchase. No subscription.

The FinancialAha Essentials NPV & IRR Calculator Spreadsheet Template for Google Sheets and Excel is a two-sheet workbook covering ten years of cash flow, with a How to Use guide on a third tab. It works as an Essentials NPV & IRR Calculator Excel template and an Essentials NPV & IRR Calculator Google Sheets template from the same download. This Essentials NPV & IRR Calculator spreadsheet template produces the internal rate of return the free build does not, alongside net present value, the payback period and the profitability index. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials NPV & IRR Calculator spreadsheet template

The FinancialAha Essentials NPV & IRR Calculator Spreadsheet Template runs on two working sheets - one you fill in, one that reports back - plus the guide. It works in both Microsoft Excel and Google Sheets and here is what the Essentials NPV & IRR Calculator spreadsheet holds.

  1. 01 of 02

    Cash Flows

    The initial investment and the discount rate at the top, then ten years of expected cash flow beneath. Each year carries three worked figures beside the amount you entered: what it is worth discounted back to today, the running total undiscounted, and the running total discounted. That last column is the one that answers when an investment actually turns - not the year the raw cash adds up to the investment, but the year the discounted cash does, which is later and is the number that matters.

    FinancialAha NPV & IRR Calculator spreadsheet template - Cash Flows sheet

  2. 02 of 02

    Dashboard

    Six figures for the project: net present value, internal rate of return, payback period, the initial investment, the total of the cash flows, and the profitability index. The rate of return is what the free build lacks entirely - it is the discount rate at which the value would come out at exactly zero, so it answers how much room the assumptions have before the case stops working. Two charts sit alongside, one showing the annual flows and one tracing the cumulative value over the ten years.

    FinancialAha NPV & IRR Calculator Google Sheets template - Dashboard sheet

  3. Included guide

    How to Use

    A step-by-step guide on its own tab, covering what each input expects, what every metric means, and how the discounted and cumulative columns read. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Essentials NPV & IRR Calculator Spreadsheet template for Google Sheets

Upload the Essentials NPV & IRR Calculator Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials NPV & IRR Calculator Google Sheets template needs no conversion step and both charts survive the trip intact - the rate of return recalculates exactly as it does in Excel. The currency dropdown on the Dashboard relabels the money columns on both sheets at once.

Essentials NPV & IRR Calculator Google Sheets template setup

A shared copy of the Essentials NPV & IRR Calculator Google Sheets template suits a decision being weighed by more than one person, since the discount rate and the cash flow estimates are where the disagreement tends to sit, and both are visible inputs. Sheets version history covers a figure typed over.

Sharing the Essentials NPV & IRR Calculator Google Sheet

The Essentials NPV & IRR Calculator Google Sheet is built for sittings rather than daily use: enter the flows once, then move the discount rate and watch the value, the payback point and the index respond together.

Also available as:

Essentials NPV & IRR Calculator Spreadsheet template for Excel

The Essentials NPV & IRR Calculator spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials NPV & IRR Calculator Excel template directly, with no import step and no compatibility prompt, and both charts are native Excel charts that redraw as the inputs change. There are no macros and no VBA in the file, so it opens without a security warning.

Essentials NPV & IRR Calculator Excel template setup

The same Essentials NPV & IRR Calculator Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Essentials NPV & IRR Calculator spreadsheet download to choose between.

Essentials NPV & IRR Calculator spreadsheet Excel notes

The Essentials NPV & IRR Calculator spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt. The same Essentials NPV & IRR Calculator spreadsheet Excel download also opens in Excel for the web.

Opening the Essentials NPV & IRR Calculator spreadsheet Excel file

Nothing in the Essentials NPV & IRR Calculator Excel template is version-specific, so this Essentials NPV & IRR Calculator spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Also available as:

Spreadsheet template highlights

What the Essentials NPV & IRR Calculator spreadsheet template tracks

Ten years of flows, four columns each. These are the columns the Essentials NPV & IRR Calculator Spreadsheet Template carries:

Year
each of the ten periods
Cash Flow
what you expect that year to produce
Discounted CF auto
derived, that amount valued back to today
Cumulative CF auto
derived, the running total before discounting
Cumulative DCF auto
derived, the running total after it, which is where payback really lands

Compare builds

FinancialAha NPV & IRR Calculator spreadsheet template: Free, Essentials, and Ultimate compared

Feature Free View Spreadsheet Template Essentials This page Ultimate View Spreadsheet Template
Working sheets 1 2 6
Projects One One Three, compared
Years of cash flow 5 10 15 per project
NPV Yes Yes Per project
IRR – Yes Per project
Payback period – Yes Per project
Profitability index – Yes Per project
Discounted and cumulative cash flow – Yes Yes, with discount factors
Ranking across metrics – – Yes
NPV across a range of rates – – Yes
Charts – 2 1

The FinancialAha Essentials NPV & IRR Calculator Spreadsheet Template covers two working sheets and ten years for one project. Against the Free NPV & IRR Calculator Spreadsheet Template, which discounts five years and returns net present value with no rate of return at all, this build adds the internal rate of return, the payback period and the profitability index, lays out each year discounted and cumulative, and charts the value building over time. The Ultimate NPV & IRR Calculator Spreadsheet Template takes three projects of fifteen years each, ranks them against one another on every metric, and shows the value across a whole range of discount rates rather than the single one you picked.

Compare the other builds: Free NPV & IRR Calculator spreadsheet template or the Ultimate NPV & IRR Calculator spreadsheet template .

Good to know

Notes on working in the Essentials NPV & IRR Calculator spreadsheet template

  • The cumulative discounted column is where payback really lands, and it lands later than the undiscounted one suggests.
  • The internal rate of return is the discount rate at which the value would be exactly zero, so it says how much room the assumptions have.
  • The profitability index expresses return per unit invested, which is what makes projects of different sizes comparable.
  • This build covers one project. Setting several against each other is what the Ultimate build does.
  • The currency dropdown sits on the Dashboard and relabels money columns across the whole Essentials NPV & IRR Calculator spreadsheet. It changes the label only and does not convert the numbers.

How to Use the Essentials NPV & IRR Calculator Spreadsheet Template

1

Enter the investment

What goes out at the start, on the cash flows sheet.

2

Set the discount rate

The required return the project is being measured against.

3

Enter ten years of flows

Each year gets its discounted and cumulative figures automatically.

4

Read the dashboard

Value, rate of return, payback and index, across two charts.

Stress-tested with AI.

Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials NPV & IRR Calculator Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Essentials NPV & IRR Calculator Google Sheets template needs no conversion step and both charts survive the trip intact.

Is the FinancialAha Essentials NPV & IRR Calculator Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials NPV & IRR Calculator Excel template opens directly in Excel with no import step. Both charts are native Excel charts, and there are no macros or VBA.

Will the FinancialAha Essentials NPV & IRR Calculator spreadsheet Excel file open in older versions of Excel?

Yes. The Essentials NPV & IRR Calculator spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

What does the Essentials NPV & IRR Calculator spreadsheet add over the free build?

The internal rate of return, which the free build does not produce at all, plus the payback period and the profitability index - and ten years of cash flow rather than five, each shown discounted and cumulative.

What does the internal rate of return tell me in the Essentials NPV & IRR Calculator spreadsheet?

It is the discount rate at which the value would come out exactly zero. Read against the rate you actually used, it says how much room the assumptions have before the case stops working.

Why does the Essentials NPV & IRR Calculator spreadsheet read payback from the discounted flows?

Because the undiscounted version answers the wrong question. The year the raw cash covers the investment comes before the year the discounted cash does, and only the second reflects what the money is worth.

What is the profitability index for in the Essentials NPV & IRR Calculator spreadsheet?

Return per unit invested. It is what makes a small project and a large one comparable when the value figures alone are not.

Can I compare several projects in the Essentials NPV & IRR Calculator spreadsheet?

Not in this build - it covers one. Three projects side by side, ranked against each other on every metric, is what the Ultimate build does.

How do I open the Essentials NPV & IRR Calculator spreadsheet template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.

More Essentials Investing & Trading Templates

Investment Portfolio Tracker

A name beside every ticker and a percentage return on each position, so holdings of very different sizes can be compared. The Essentials Investment Portfolio Tracker spreadsheet template carries 20 holdings, works out market value and gain per position, and puts total portfolio value and total gain on a dashboard with a chart of how the value splits between holdings. Google Sheets and Excel, one file. No macros, no VBA.

$19

Stock Trading Journal

Each of the thirty rows is one side of a trade, so buys and sells are logged apart and the cash flow takes its direction from the side, its size from the quantity and price, and its fees netted in. The Essentials Stock Trading Journal spreadsheet template settles a realised figure on closing rows against what you paid for that ticker, and an open position stays visible as a buy with no sell against it. Two working sheets and a chart, Google Sheets or Excel. No macros, no VBA.

$19

Options Trading Journal

Pick the leg you traded and the money works itself out - direction, premium, contract count and fees all folded into one cash flow. The Essentials Options Trading Journal spreadsheet template handles opening and closing legs in both directions so the sign follows the action, nets fees into the result rather than reporting them separately, holds thirty trades on a single log, and shows the net total, the win rate and the number logged on a dashboard. Google Sheets and Excel. No macros, no VBA.

$19

Crypto Portfolio Tracker

Percentage return sits beside value and gain on every one of twenty holdings, so a small position that doubled is tellable from a large one that drifted. The Essentials Crypto Portfolio Tracker spreadsheet template takes coin, symbol, quantity, average cost and current price per row, with a Dashboard carrying total value, total gain, overall return, total cost basis and how many holdings are ahead. Two working sheets and an allocation chart. Google Sheets and Excel. No macros, no VBA.

$19
Essentials
Preview
See Investing Ultimate Pack 8 templates included • Save $123

Instant digital delivery · Terms & Conditions apply

Highlights:

Dashboard with charts and KPIs
Pre-filled categories and sample data
No sign-up, no subscription
Lifetime free updates
Works in
Excel Google Sheets

Looking for premium spreadsheet templates?

Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.

View Premium Templates Browse All Essentials Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →