Excel Tips and Tricks: Present Value of Multiple Uneven Cash Flows - Excel Tutorial

[@TheMystrafanx]

Everything is as you say, however I just wanted to point out that NPV refers to the NET PRESENT VALUE, not the PV. The difference between the NPV and the PV is quite huge. The NPV is your investment PLUS the PV of the future cash flows, and in real life our first number (the investment) will be negative of course. Thus the NPV and the PV are quite different things. Im just clarifying for the viewers :). However, great video :).

[@esjaybee2161]

Helped with my Masters homework in 2018. Thank you!!

[@adanmartinezmjc]

you just saved my life. Thank you

[@asmaakter8607]

It's really a very helpful video and content is exactly according to this formula. Many Many Thanks

[@Shaylee_W]

Seriously thank you so much. I needed this so badly.

[@minthos4045]

Dude whats the point of the 1st method which is a bit time consuming. Glad you showed the NPV function afterwards.

[@leejoohui1191]

Hi there! Would it make much difference whether we add up all the cash flows (by dragging across the row) as shown in your video from 6:01 - 6:05 leading to a formula of NPV(rate, value1:value7) compared to following the formula given in excel ie. NPV(rate, value1, [value2], [value3], ... , [value7])? Theoretically, does both notation symbols : and , imply similar function of summing up values? I noticed that they both produce the same result anyway.

[@nst9427]

Thanks for showing this! I was wondering how to enter an initial cash flow.

[@Surfwtw]

I also did it the long way to show that it was correct. I got the same answer using both methods which confirms the accuracy. I am not sure why Excel only have NPV but to use NPV in Excel if there is an initial investment (Cash outflow) then you would enter it as a negative number before the NPV formula." =- initial investment+NPV(rate, value1...)"

[@cindylove7529]

Thanks for sharing, I didn't know the NPV function before.

[@IksMidwinter]

this just saved me. thank you for this.

[@leejoohui1191]

Sry if this seems to be a very basic question but thanks for being patient in answering. Cheers!

[@kristyli7268]

how would you find it quickly it's for beginning of the year instead of OA?

[@hyacinth411]

Awesome thanks....this helped me bunches Financial mgt 3331: uneven cash flow for present value

[@athirahfirdaus]

THANK YOU!

[@Surfwtw]

In Excel you can use NPV to find the PV and just assume the initial investment is 0. Then you will have the same result.

[@za3team388]

تستاهل احلى بوسة

[@jacobstromburg5803]

skip to 5:23

[@sweettooth6966]

What can i do if i have 110000000000000000000000000000 year to calculate :)

[@y.r.7618]

or if you have $100 today and save it in your piggy bank and 20 years later you find that piggy bank in your closet, those $100 will probably not buy you much because everything will be more expensive than 20 years ago.