Need and exact value for IRR or NPV for uneven cash flows?

Standard Excel IRR (Internal of Rate Return) and NPV (Net Present Value) formulas assume a smooth receipt of cash flows at the end of every year. In order to calculate exact returns for cash flows received throughout the year or at any point in time over several years, Excel formula xIRR and xNPV must be used.

Our Excel template has done the hard work for you, and created a fill in the blank template for you use. Simply input your cash flows and dates and the spreadsheet does the rest. There are two tabs, one for xIRR calculation and one for xNPV.

It doesn’t get any easier, don’t waste another minute trying to figure out the formula specifics, simply download our sheet and your analysis will be complete within minutes.

No locked cells or macros allow for easy customizations.

For only $9.95, it’s the smartest time saving investment you can make. And if you’re not satisfied for any reason, simply email us and we will refund your money. No questions asked. With our no-risk, 30-day money-back guarantee you’ve got nothing to lose!

6 Reasons to Choose the xIRR / xNPV Template

1. You don’t have to reinvent the wheel. Preparing ROI spreadsheets from scratch takes hours or days, even if you’ve done it before. But why bother? Our no-hassle Marketing Return on Investment template saves you the time and effort.

2. You can customize the templates with ease. Because there are no locked cells, our xIRR and xNPV template can be easily customized and adapted to your situation. Insert, delete or rearrange rows and data as you see fit. The result is a relevant analysis that speaks to your specific business.

3. You don’t need a finance degree to use them. We’ve taken the drudgery out of Return on Investment analysis. You simply input your numbers and the spreadsheet does the rest! Even non-finance managers can easily create and understand the report.

4. You’ll look like a professional. This spreadsheet delivers a solid analysis that’s pleasing to the eye. What’s more, we’ve formatted the worksheet for easy reading and clear interpretation.

5. You can’t make a smarter investment in your Maketing efforts. At only $9.95, the Template pays for itself in minutes. And if you’re not satisfied, we offer a no-risk, 30 day money-back guarantee.

6. No-risk, 30-day money back guarantee If you’re not satisfied for any reason, just email us and we’ll refund your money. No questions asked.

xIRR / xNPV Uneven Cash Flows


    The Business Case Team is made up of a small group of professionals, each from different business backgrounds, but with one thing in common: a passion for analyzing business decisions. 



    Copyright © 2020 All rights reserved.