Use the XNPV Function in Excel

Financial function that determine present value and future values are useful from understanding current values of an item to future values of the same. There's many Excel function that help you do analysis of value and this video will cover one of those functions - XNPV and how to use the XNPV function. Also view the video on how to use the NPV function at • How to Calculate NPV i...
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

Пікірлер: 6

  • @ExploringExcelAmey
    @ExploringExcelAmey10 жыл бұрын

    Thanks for the video

  • @happymm2008
    @happymm20084 жыл бұрын

    Thank you! This is very helpful!

  • @DougHExcel

    @DougHExcel

    4 жыл бұрын

    You’re welcome!

  • @Pablo-oh2hi
    @Pablo-oh2hi Жыл бұрын

    535

  • @sachinangural1877
    @sachinangural18774 жыл бұрын

    xnpv doesn't includes the first cash flow. So, you should have made the first CF to zero and added it after the computation.

  • @DougHExcel

    @DougHExcel

    4 жыл бұрын

    Hi Sachin Angural, thanks for adding to the thread!