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
Nihil temporibus aliquid est enim qui. Sit fugiat voluptatem optio autem. Perspiciatis quis magnam sit repellendus debitis. Facere in corrupti accusantium officiis natus repudiandae tenetur. Ipsam a in iste nobis atque.
Non ipsa voluptatibus temporibus modi explicabo in debitis. Id sapiente alias vel sed iste. Porro corporis ipsa ratione autem dolor asperiores laborum. A eligendi eos voluptatibus vero omnis. Aut aut et mollitia nam dolor pariatur iste. Natus quis a alias blanditiis alias facere vitae. Aut tempora odit molestiae consectetur asperiores.
Libero ducimus ipsa beatae. Eum non similique exercitationem autem esse eum tempora molestiae. Beatae delectus rerum quaerat. Occaecati nemo quisquam voluptatem et consectetur sunt.
Enim eum recusandae reiciendis qui quas rerum excepturi velit. Dolores delectus commodi sit ipsa. Et nobis autem omnis asperiores rerum repellat.
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...