Excel - calculating NPV of varying cash outflows

  • Thread starter Thread starter deadmoney
  • Start date Start date
D

deadmoney

I seem to have a problem with discounting a series of uneven cas
outflows. I know the principles, however I think that my formula i
what is hampering my results.

ex.

rate = 1.5% annual

month 1 = 500
month 2 = 200
month 3 = 200
month 4 = 400

what is the formula for calculating this (excel formula
 
Use the XNPv() function. If it is not available: Tools>Add-Ins, check
Analysis Toolpak

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top