HDTutorial
EN
How to Calculate NPV, IRR & ROI in Excel || Net Present Value || Internal Rate of Return

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Calculate NPV, IRR & ROI in Excel || Net Present Value || Internal Rate of Return

374,571 views October 25, 2018 8:31

Watch on YouTube
ChannelMatt Macarty

Description from the creator

#npv #irr #excel
Please SUBSCRIBE:
youtube.com/subscription_center?add_user=mjmaca…
Try my Hands-on Python for Finance course on Udemy: udemy.com/hands-on-python-for-finance/

alphabench.com/data/excel-npv-irr-tutorial.html
Watch: youtu.be/b4eV7vo1vJM to calculate payback/breakeven

Tutorial demonstrating how to calculate NPV, IRR, and ROI for an investment. Demonstrates manual calculation of present values as well as the use of NPV and IRR functions in Excel. The spreadsheet used can be downloaded at:
alphabench.com/data/NPV-IRR_STR.xlsx

Capital Budgeting includes the analysis of various projects with financial measurements such as Net Present Value (NPV), Internal Rate of Return (IRR) and Return on Investment (ROI). This video discusses all of these concepts briefly while demonstrating the calculation of them using Excel.


Excel Functions:
NPV
IRR

About this tutorial

Matt Macarty published this 8:31 video tutorial on October 25, 2018. It has been watched 374,571 times on YouTube.

Duration
8:31
Published
October 25, 2018
Views
374,571
Likes
2,146

Share

Further reading

  • Calculating Net Present Value (NPV) and Internal Rate of ... financetrain.com

    Internal Rate of Return (IRR) Function. IRR is based on NPV. It as a special case of NPV, where the rate of return calculated is the interest rate corresponding to a 0 (zero) net present value. IRR function is represent…

  • NPV IRR Calculator | IQ Calculators iqcalculators.com

    This NPV IRR Calculator calculates the net present value and internal rate of return from a capital investment. See if your npv and irr calculations meet your capital budgeting requirements.

  • Learn How to Calculate NPV and IRR in Excel | Excelchat got-it.ai

    Learn How to Calculate NPV and IRR in Excel Excel allows a user to get an internal rate of return and a net present value of an investment using the NPV and IRR functions. This step by step tutorial will assist all leve…

This tutorial in other languages