Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Manuals/calci/XNPV
(view source)
Revision as of 22:05, 27 July 2018
131 bytes added
,
22:05, 27 July 2018
no edit summary
Line 1:
Line 1:
−
<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==
Devika
writer
6,694
edits