I have below cash flow with Date and Amount,what method should i use for this for net Present value, NPV or XNPV.
and how i can calcuate the PV.
PV=XNPV?
<TABLE style="WIDTH: 161pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=215 border=0><COLGROUP><COL style="WIDTH: 51pt...