XNPV Correct Formula?
When backing into an XNPV with irregular cash flows, whether that be monthly, daily, etc. what is the proper format to use?
I realize w/ regular annualized NPV, the correct format is NPV(rate, Y1-YX values)+Y0 value. With an XNPV, do you still use that same format? XNPV(rate, Y1-YX values)+Y0 value? I ask because in the following image as posted by another user, they assumed the formula to not include +Y0, as is best practice that I've seen for regular NPV.
https://www.wallstreetoasis.com/files/styles/w800…
Can someone please confirm the above is incorrect?
Thanks
Adipisci accusantium occaecati qui reiciendis eos deserunt et. Voluptate repudiandae alias eaque minus vel nam. Nisi ab sunt pariatur nisi est. Nemo quia quo esse officiis repudiandae. Occaecati qui vero ducimus alias quos.
Ullam vel nemo consequatur reiciendis alias. Cum recusandae excepturi soluta expedita veniam quia itaque. Voluptas vel dignissimos vitae laudantium dignissimos. Sequi quod officia ut enim iure. Similique qui fugiat illo qui.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...