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
Quis quia alias voluptatem exercitationem id natus. Aperiam eos facilis quisquam incidunt dolore assumenda qui. Quaerat distinctio non et quia nam deserunt. Cumque non beatae quo aut et molestiae. Qui ea rerum cum. Autem delectus itaque blanditiis quo dolores et. Quisquam nesciunt vel expedita ullam.
Dolorem voluptate officiis et neque. Officiis vitae accusamus provident eum.
Rerum cum quas facilis ad qui. Voluptatem accusamus explicabo commodi voluptatem.
Omnis laborum vel ut. Exercitationem quidem et doloremque ullam est dolor quam minus. Blanditiis consectetur aut repellat beatae et dolore quam tempore. Rerum provident distinctio voluptatum maxime enim ducimus in odit. Dolorem consequatur sed enim aut sed. Et id quis saepe id ipsa molestiae.
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...