writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + +
no edit summary
<div style="font-size:30px">'''XNPV(Rate,V,Dates)'''</div><br/>
<div style="font-size:30px">'''XNPV (Rate,CashFlowValues,Dates) '''</div><br/>
*<math>Rate</math> is the discount rate to apply to the cash flows
*<math>Rate</math> is the discount rate to apply to the cash flows
*<math>V</math> is a series of cash flows that corresponds to a schedule of payments in dates
*<math>CashFlowValues</math> is a series of cash flows that corresponds to a schedule of payments in dates
*<math>Dates</math> is a schedule of payment dates.
*<math>Dates</math> is a schedule of payment dates.
**XNPV(), returns the net present value for a schedule of cash flows that is not necessarily periodic.
==Description==
==Description==