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中文
Free Download - Excel & Google Sheets

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

An initial investment, five years of expected cash flow, and a discount rate kept as its own visible input. Back comes total cash flow before discounting, simple ROI, and net present value once the rate is applied, so the difference the discounting makes is there on the page. The Free NPV & IRR Calculator spreadsheet template holds all of it on one working sheet with a How to Use tab. Google Sheets or Excel, one file. No macros, no VBA.

Essentials Get more value with Essentials Spreadsheet Template View Essentials $19 Ultimate Unlock all features with Ultimate Spreadsheet Template View Ultimate $29
Works in Excel and Google Sheets · CC BY 4.0
npv-irr-calculator.xlsx
Free NPV & IRR Calculator Spreadsheet Template for Google Sheets & Excel - dashboard preview

Get More with Essentials or Ultimate NPV & IRR Calculator Spreadsheet Templates

Free NPV & IRR Calculator

Spreadsheet Template
Works in Excel and Google Sheets · CC BY 4.0
Works in Excel and Google Sheets · CC BY 4.0
What's Included
  • One working sheet holding the whole calculation
  • An initial investment and five years of expected cash flow
  • A discount rate you set, kept as its own visible input
  • Net present value once that rate is applied
  • Total cash flow shown before discounting, so the difference is visible
Essentials NPV & IRR Calculator spreadsheet template - Google Sheets and Excel preview

Essentials NPV & IRR Calculator

Spreadsheet Template
  • Everything in Free
  • 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
View Essentials NPV & IRR Calculator Spreadsheet Template $19›
Most popular
Ultimate NPV & IRR Calculator spreadsheet template - Google Sheets and Excel preview

Ultimate NPV & IRR Calculator

Spreadsheet Template
  • Everything in Essentials
  • 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
View Ultimate NPV & IRR Calculator Spreadsheet Template $29›

The FinancialAha Free NPV & IRR Calculator Spreadsheet Template is a one-sheet workbook for Google Sheets and Excel, with a How to Use guide on a second tab. It works as a Free NPV & IRR Calculator Excel template and a Free NPV & IRR Calculator Google Sheets template from the same download. This Free NPV & IRR Calculator spreadsheet template discounts five years of cash flow back to today against a rate you set. Worth saying before anything else: this build produces net present value, not internal rate of return - the rate itself is on the larger builds. No macros, no VBA.

Inside the workbook

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

The FinancialAha Free NPV & IRR Calculator Spreadsheet Template runs on a single working sheet, with the instructions on a tab of their own. It works in both Microsoft Excel and Google Sheets and here is what the Free NPV & IRR Calculator spreadsheet holds.

  1. 01 of 01

    NPV and IRR

    An initial investment, five years of expected cash flow, and the discount rate you want them measured against. Back come the total of those flows, a simple return on the investment, the net present value once the rate has been applied, and a flag for whether that value came out above zero. The gap between the raw total and the present value is the whole lesson of the sheet: money arriving in year five is not worth what money arriving now is worth, and the discount rate is where you say by how much. One thing the name promises that this build does not deliver: there is no internal rate of return here. Nor is there a payback period or a profitability index. Those arrive with the Essentials build, along with five more years of cash flow.

    FinancialAha NPV & IRR Calculator spreadsheet template - NPV and IRR sheet

  2. Included guide

    How to Use

    A step-by-step guide on its own tab, covering how to replace the sample values and how to change the currency. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Free NPV & IRR Calculator Spreadsheet template for Google Sheets

Upload the Free NPV & IRR Calculator Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Free NPV & IRR Calculator Google Sheets template needs no conversion step and nothing gets rewritten on the way in - every figure recalculates exactly as it does in Excel. The currency dropdown beside the title relabels the money fields, and the whole Free NPV & IRR Calculator spreadsheet is small enough to open instantly.

Free NPV & IRR Calculator Google Sheets template setup

A shared copy of the Free NPV & IRR Calculator Google Sheets template works when a decision is being weighed by more than one person, since the discount rate is the part most open to argument and it sits in a single visible cell. Sheets version history covers a figure typed over.

Sharing the Free NPV & IRR Calculator Google Sheet

The Free NPV & IRR Calculator Google Sheet is built for a sitting rather than a routine: put the flows in, read the present value, then move the discount rate and read it again. Because the Free NPV & IRR Calculator spreadsheet has nothing to scroll, testing three rates takes under a minute.

Also available as:

Free NPV & IRR Calculator Spreadsheet template for Excel

The Free NPV & IRR Calculator spreadsheet Excel download is a plain .xlsx. Excel opens this Free NPV & IRR Calculator Excel template directly, with no import step and no compatibility prompt, and every figure updates the moment an input changes. There are no macros and no VBA in the file, so it opens without a security warning.

Free NPV & IRR Calculator Excel template setup

The same Free 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 Free NPV & IRR Calculator spreadsheet download to choose between.

Free NPV & IRR Calculator spreadsheet Excel notes

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

Opening the Free NPV & IRR Calculator spreadsheet Excel file

Nothing in the Free NPV & IRR Calculator Excel template is version-specific, so this Free 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 Free NPV & IRR Calculator spreadsheet template tracks

Seven inputs on the left, four figures back on the right. The Free NPV & IRR Calculator Spreadsheet Template works from these:

Initial investment
what goes out at the start
Year 1 cash flow
what comes back in the first year, and one row for each of the next four
Discount rate
the rate future money is measured back against
Total cash flow auto
derived, the five years added up before any discounting
Simple ROI auto
derived, the return without regard to when it arrives
NPV auto
derived, the same flows once the discount rate has been applied
NPV above zero? auto
derived, a plain Yes or No on the figure above it

Compare builds

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

Feature Free This page Essentials View Spreadsheet Template 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 Free NPV & IRR Calculator Spreadsheet Template discounts five years of cash flow for one project and returns net present value, a simple return and a plain Yes or No on whether that value is above zero. It does not produce an internal rate of return, a payback period or a profitability index. The Essentials NPV & IRR Calculator Spreadsheet Template for Google Sheets and Excel adds all three across ten years, with each year's discounted and cumulative figures laid out and two charts. The Ultimate NPV & IRR Calculator Spreadsheet Template runs three projects of fifteen years each, ranks them against one another on every metric, and shows what happens to the value as the discount rate moves across a range.

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

Good to know

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

  • Five years is the horizon, with a cash flow row for each and the initial investment on its own input.
  • The NPV discounts each year's flow by the rate you set and takes the initial investment off the front.
  • The flag reads yes or no on whether that value cleared zero.
  • This build does not calculate an internal rate of return, despite the name. That figure arrives with the Essentials build.
  • The dropdown beside the title relabels the money fields. It changes the label and nothing else.

How the NPV & IRR Calculator template works

The Free NPV & IRR Calculator Spreadsheet Template takes an initial investment, five years of expected cash flow and a discount rate, then returns the total of those flows, a simple return, the net present value once the rate has been applied, and a flag for whether that value cleared zero. The gap between the raw total and the present value is the whole lesson: money arriving in year five is not worth what money arriving today is worth, and the discount rate is where you say by how much. Worth knowing before you download it - despite the name, this build does not calculate an internal rate of return.

When this template helps

01

You are weighing one investment and want its value in today money rather than a raw total.

02

You want to see how sensitive a case is to the rate you discount it at.

03

Someone quoted you a return and you want to check it against the timing of the cash.

04

You want a calculation you can keep and revisit rather than a web form.

Tips to get the most out of it

  • The gap between total cash flow and net present value is what the discount rate costs future money.
  • The discount rate is the most contested input, which is why it sits in a visible cell rather than inside a formula.
  • The simple return ignores when money arrives, which is the difference the discounted figure exists to show.

Common mistakes to avoid

  • Expecting an IRR figure. There is none in this build - it returns present value, a simple return and a threshold flag.
  • Entering the initial investment as a cash flow row. It has its own input, and doubling it there distorts every result.
  • Reading the simple return as comparable to the discounted one. It ignores when the money arrives, which is the whole point of the exercise.
  • Treating a positive value as a decision. It is one input to a judgement, not the judgement.

How to Use the Free NPV & IRR Calculator Spreadsheet Template

1
Enter the investment
What goes out at the start, before any return.
2
Enter five years of cash flow
What you expect each year to produce.
3
Set the discount rate
The rate future money is measured back against.
4
Read the present value
Compare it with the undiscounted total to see what the rate costs.
Ultimate
NPV & IRR Calculator
Ultimate ($29) gives each part its own sheet, with deeper reporting on top.
View Ultimate $29

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.

Excel
Sheets
Privacy by default
Your numbers stay in your own file
Formula-driven
All calculations update automatically
Dual compatible
Works in Excel and Google Sheets
Sample data included
See the template in action right away

Frequently Asked Questions

What is the difference between the free, Essentials, and Ultimate Free NPV & IRR Calculator spreadsheet template?

Free is a single-sheet starter template with sample data and a How to Use guide. Essentials ($19) is the fuller build, with more worked out for you rather than typed. Ultimate ($29) goes further again, splitting the template across more working sheets and adding deeper reporting on top. What each tier holds differs by template - the comparison table on every template page lists it exactly.

Which Free NPV & IRR Calculator spreadsheet template should I download?

Essentials is the fuller build of this template for ongoing use, and the comparison table on this page lists exactly what it adds. The Free version is a good fit for one-off planning or trying out the layout.

Can I upgrade the Free NPV & IRR Calculator spreadsheet template later?

Yes. Essentials is a one-time $19 purchase with no subscription. What it adds depends on the template: some builds gain capacity and a dashboard, others richer detail in the same layout. The comparison table on this page lists the differences exactly.

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

Yes. Upload the file to Drive and choose "Open with Google Sheets". Nothing needs rewriting in the Free NPV & IRR Calculator Google Sheets template, and the currency dropdown still relabels the money fields.

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

Yes. The download is a plain .xlsx, so the Free NPV & IRR Calculator Excel template opens directly in Excel with no import step. There are no macros and no VBA, so it opens without a security warning.

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

Yes. The Free 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.

Does the FinancialAha Free NPV & IRR Calculator Spreadsheet Template calculate IRR?

No, and that is worth knowing before you download it. This build produces net present value, a simple return and a threshold flag - there is no internal rate of return in it. That figure, along with the payback period and profitability index, is on the Essentials build.

How many years of cash flow does the Free NPV & IRR Calculator spreadsheet take?

Five. The Essentials build takes ten, and the Ultimate build gives each of three projects fifteen.

Why does net present value differ from the total cash flow in the Free NPV & IRR Calculator spreadsheet?

Because money arriving in year five is not worth what money arriving today is worth. The discount rate is where you say by how much, and the gap between the two figures is what it costs.

Is the Free NPV & IRR Calculator spreadsheet template safe to download?

Yes. No macros, no tracking. The file is a plain .xlsx that opens directly in Excel or Google Sheets.

How do I open the Free 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.

Can I use the Free NPV & IRR Calculator spreadsheet template for commercial work?

All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.

More Free Investing & Trading Templates

Investment Portfolio Tracker

A row per position with ticker, shares and average cost, plus a current price column you keep up to date yourself, and market value and gain or loss against cost fall out of it. The Free Investment Portfolio Tracker spreadsheet template holds 16 positions on one working sheet, with How to Use on a second tab. Google Sheets or Excel, one file. No macros, no VBA.

Free

Stock Trading Journal

Sixteen rows, one per finished trade, each with the date, the ticker, the side, the size and both prices side by side, and a result you record yourself. The Free Stock Trading Journal spreadsheet template carries the net figure across every row in a strip above, counts how many trades are logged, and takes its currency from a dropdown. Quick enough to fill in as a trade closes. One working sheet, Google Sheets or Excel. No macros, no VBA.

Free

Options Trading Journal

Date, ticker, strategy, strike, expiry and contract count on every entry, with the result recorded alongside in a column you fill yourself. The Free Options Trading Journal spreadsheet template gives you fourteen rows on one working sheet, leaves the strategy label as free text so any structure can be recorded, and carries the net figure across all trades and the number logged in a strip above. Google Sheets or Excel, one file. No macros, no VBA.

Free

Crypto Portfolio Tracker

Sixteen rows, one holding each: the units you hold, what you paid per unit, what one is worth today. The Free Crypto Portfolio Tracker spreadsheet template derives market value and gain or loss from those three and totals the portfolio in a strip at the top. Fractional quantities need no rounding, currency switches from a dropdown, and the How to Use guide sits on a second tab. Google Sheets or Excel, one file. No macros, no VBA.

Free
NPV & IRR Calculator
Free · $19 · $29
View Essentials $19