How to calculate NPV and IRR in Excel / Principles of finance / Episode 1

In this tutorial, we explain how net present value (NPV) and internal rate of return (IRR) can be used as capital budgeting tools and show how to calculate NPV and IRR in Excel.

0:00 NPV and IRR - capital budgeting
1:00 Cash flows and the discount rate
2:17 Finding NPV manually
4:19 NPV function
5:35 XNPV function
7:09 NPV schedule
10:20 Finding IRR by trial-and-error
12:36 IRR function
13:30 XIRR function

Enjoying our content?

Click the link below to subscribe to our channel:
   / @initialreturn  

You can also follow us on Twitter:
twitter.com/initial_return

And, visit our website for free courses, tutorials, and more:
www.initialreturn.com/

#exceltutorial #capitalbudgeting #finance