NPV in Excel
Can someone please advise me on whether I should use the NPV or XNPV function in Excel to calculate the FMV of cash flows that are not annual (i.e. monthly, quarterly, semi-annual)? All cash flows are expected on the month-end date for each respective period. Thank you in advance!!
XNPV. Remember to include the initial cash outlay at time 0 within the calculation, as opposed to a NPV calculation in Excel.
Always XNPV, as it takes into account the different timing of cash flows.
Thank you both. For a quarterly cash flow example when using XNPV, should i divide the discount rate by 4 or does the XNPV formula already account for this adjustment?
Thank you!
Not sure if you saw what Kurtis said, but no. As stated XNPV takes into account the different timing of cash flows, so again, no
Ea neque sed aut quas. Commodi ullam nihil natus impedit dolorem qui deserunt. Omnis rerum recusandae inventore rerum numquam iusto architecto. Exercitationem repellat quia et ut fuga repudiandae.
Culpa sequi consequuntur vel aut. Blanditiis ut voluptas qui vitae. Mollitia ratione sed quae aspernatur aut. Perferendis officiis porro qui ipsam incidunt. Laboriosam modi provident quia quos.
Voluptate omnis repellat itaque sed ex. Aliquam incidunt dicta voluptatem soluta assumenda possimus sequi. Consequatur et minima cum. Ullam iste blanditiis consectetur vero modi doloremque.
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...