NPV and IRR Calculator Excel Template

4.62 (13 reviews)

Professional Excel spreadsheet to calculate NPV & IRR. Estimate monthly cashflows & feasibility. Ready for presentations. Dashboard with dynamic charts.

NPV-IRR-Calculator-Someka-Excel-Template-SS1
NPV-IRR-Calculator-Someka-Excel-Template-SS2
NPV-IRR-Calculator-Someka-Excel-Template-SS3
NPV-IRR-Calculator-Someka-Excel-Template-SS4
NPV-IRR-Calculator-Someka-Excel-Template-SS5
NPV-IRR-Calculator-Someka-Excel-Template-SS6

Download Free Demo!

Enter your email to download
NPV and IRR Calculator Excel Template - Demo version

Updates and news will be sent to this email address

GET THIS TEMPLATE

Additional Services

OR

BECOME MEMBER
Get this template, plus 400+ more with Someka Membership
Multi-User and Technical Support included. Learn more

TEMPLATE DESCRIPTION

One of the methods of doing a feasibility study is to check the NPV and IRR values of the project. Once you input your estimated cash flows, the NPV and IRR Calculator Excel Template displays you the Net Present Value and the Internal Rate of Return of the project, and much more.

Net Present Value is an important indicator to determine the current value after all your revenue and cost assumptions. Your cash flow’s Rate of Return and Net Present Value might be hard to estimate. But they shape the company you are planning to establish. As well as the value of your business and the capital of your projects.

NPV & IRR Calculator Features

Net Present Value Calculator template is a tool to identify the difference between the present value of cash inflows and the present value of cash outflows over a while.

This Excel spreadsheet with NPV and IRR Calculator gathers the data of the estimated cash flows in the future by dividing them into discount rates to find the Present Value of each cash flow. The sum of all the Present Value of the Cash flows forms Net Present Value formula.

It is constructed in 2 parts:

NPV-Calculator-Template-Someka-S01-1

Dashboard:

Firstly, the Dashboard of NPV and IRR Calculator template is where you should type in your data into the cash flow and input part. Input your estimated cash inflows into the white cells only. Once you change the ‘Period‘ on Dashboard the ratios will change accordingly.

If you choose Period Term as yearly, the template will calculate the ROI as net profit/initial investment for that period.

In the monthly period term, ROI is calculated as net profit (particular month) / initial investment (zero period).

Once the correctly estimated values are input it displays a line graph of the cash inflows and outflows, Net Present Value and Internal Rate of Return.

In addition, you may just input your estimated cash flows to the Dashboard or may use the Income Statement to calculate a well-estimated cash flow.

Feel free to take a look at our Cash Flow Statement Template for help with finding out accurate cash flow calculations.

Income Statement:

Secondly, your Revenue, Gross Profit, Total Income, Total Expenses, EBIT and Net Profit will show up on the Dashboard section. In this NPV and IRR  Calculator Excel sheet, please only input your data only in the white cells. Finally, the gray and colored cells will show you the results automatically once you input the necessary cells.

NPV-Calculator-Template-Someka-S02

NPV & IRR Calculator Excel Template Features Summary:

  • Yearly or monthly time period options
  • Visual presentation of your cashflow
  • Income statement for well-estimated results
  • Informational notes included
  • No installation needed, ready-to-use
  • Works both on Mac and Windows
  • Compatible with Excel 2007 and later versions
  • Does not include any VBA macros

NPV and IRR Calculator is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

Download Now!

PRODUCT VIDEO

Watch the video below to see the template in action! Presentation also includes usage notes, explanations and tips & tricks about the template.

NPV & IRR Calculator - Someka Excel Template Video

USER REVIEWS & COMMENTS

13 reviews for NPV and IRR Calculator Excel Template

  1. Rosa Hasan –

    I need more data about the process of this template, is there anything more available?

    • Someka –

      We have two solutions for you. To begin, we suggest you view our tutorial video on YouTube. If further assistance is required, please consider investing in our customer service.

  2. Melissa Hindle –

    Adding yellow notes was really smart and usefull, thank you team.

  3. Vishal Kumer –

    Is that possible to see the cashflow chart Yearly?!

    • Someka –

      Yes, you can accomplish this. Open the Dashboard page, and look for the input section. Here, you can change the Period Term and modify the timeline of the chart analysis. Hopefully this helps!

  4. Thaddis K. –

    Why I can not change anything in blue columns or rows??

    • Someka –

      Greetings! To prevent customers from making accidental alterations to the blue columns, we need to ensure they remain locked.
      Therefore, kindly refrain from modifying the blue areas and you will get a pleasant output from your inputs.

  5. Linda Pringle –

    Thanks for making free versions, I downloaded it at first step, check the usability of it and then I purchase the primum version.

  6. Sam Peters –

    I had some problems to understand the template and support service is very good and fast. Now I am done with this app. Thx

  7. Jenny –

    Loved it made it simple to calculate NPV in just a few minutes i recommend it

  8. Meg –

    thx to this product, we can work on different scenarios by changing a few numbers quickly. expense contents are very comprehensive and cover all our needs.

  9. Daren C –

    hello someka thank you for everything. small question. I want to see montly cahsflow but there is only yearly??

    • Someka –

      Hi Daren,

      You can change the ‘Period‘ on the Dashboard.
      Please see the image below.

      npv-irr-calculator_monthly-selection

      Hope this helps.

  10. Usman –

    Helpful for npv

  11. Florian –

    Very helpful. You made this confusing topic easy to understand.

  12. Josh Riepe –

    good thanks

  13. grant ellis –

    THANKING YOU IN advance for sending me template excel irr and npv I appreciate it so much…will get back to you after I use it

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED TEMPLATES

  • Mobile App Financial Model Excel TemplateMobile App Financial Model Excel Template - Someka S02

    Mobile App Financial Model Excel Template

     $0.00 – $199.95

    Easy-to-use Mobile App Financial Model tool. Feasibility study and budget for tech startups. Financial projections & cost breakdown. All in Excel!

    Select options
    This product has multiple variants. The options may be chosen on the product page
  • Grocery Store Financial Model Excel TemplateGrocery-Store-Financial-Model-Excel-Template-Someka-SS5

    Grocery Store Financial Model Excel Template

     $0.00 – $199.95

    Easy-to-use financial model for grocery shops. Printable & clean financial statements. Dashboard with charts. No installation needed. All in Excel.

    Select options
    This product has multiple variants. The options may be chosen on the product page
  • Stock Price Calculator Excel TemplateStock-Prices-Template-Excel-Someka-SS4-u

    Stock Price Calculator Excel Template

     $0.00 – $69.95

    Stock price tracker in Excel. Fetches real time stock quotes and calculates profit/loss on your portfolio! No installation, no monthly fees.

    Select options
    This product has multiple variants. The options may be chosen on the product page
  • Finance KPI Dashboard Excel TemplateFinance-KPI-Dashboard-Someka-Excel-Template-SS10

    Finance KPI Dashboard Excel Template

     $0.00 – $79.95

    Excel spreadsheet for finance KPIs. Most common metrics for finance & accounting departments. Printable dashboard with trend charts. Ready for use.

    Select options
    This product has multiple variants. The options may be chosen on the product page
  • Bakery Financial Model Excel TemplateBakery-Financial-Model-Excel-Template-Someka-SS2

    Bakery Financial Model Excel Template

     $0.00 – $199.95

    Financial planning spreadsheet for bakeries. Feasibility study & printable financial statements. Dashboard with charts. Ready for use. All in Excel.

    Select options
    This product has multiple variants. The options may be chosen on the product page
  • Ecommerce Financial Model Excel TemplateECommerce-Financial-Model-Excel-Template-SS2

    Ecommerce Financial Model Excel Template

     $0.00 – $199.95

    All-in-one financial planning tool in Excel. Feasibility study & budget for SaaS startups. Ready to present financial projections. No installation needed.

    Select options
    This product has multiple variants. The options may be chosen on the product page
Search