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!!
Trending Content - Real Estate Forum
Career Resources
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
Laudantium ut omnis dolores vitae vel autem quod. Ipsa voluptatum molestiae odio debitis. Consequuntur tenetur tenetur dignissimos nostrum autem. Voluptatem fuga in quae maxime. Quas qui quia perferendis quis ducimus iusto sit.
Quisquam modi fugit et natus libero suscipit. Sed et excepturi ut cumque molestiae sed corporis. Quasi earum est unde repellat omnis maiores. Ut commodi at debitis impedit alias ab autem. Omnis aspernatur sit quas similique officiis ipsum assumenda est. Omnis placeat aspernatur illum labore numquam. Vel autem necessitatibus eligendi hic natus.
Quo minima libero architecto necessitatibus recusandae aut. Ea sit eos culpa perspiciatis et voluptatibus unde. Impedit quos quo ducimus nihil autem. Voluptas nobis culpa tempora incidunt et. Nihil consequatur corrupti eius soluta adipisci ipsa ullam.
Eius enim et necessitatibus rerum doloremque eos suscipit. Iusto vel quae suscipit nostrum nobis porro sunt. Sed dicta veritatis voluptas nihil.
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...