Difference between revisions of "XNpv"

(Examples)
(XNpv(rate, values, dates, I))
 
(One intermediate revision by one other user not shown)
Line 2: Line 2:
 
[[Category:Doc Status D]] <!-- For Lumina use, do not change -->
 
[[Category:Doc Status D]] <!-- For Lumina use, do not change -->
  
= [[XNpv]](rate, values,dates,I) =
+
== XNpv(rate, values, dates, I) ==
  
Computes the net present value ([[NPV]]) of a non-periodic cash flow with constant discount rate.  The ''rate'' parameter is the annual discount rate for a 365 day year.  The ''values'' parameter is indexed by ''I'' and contains the cash flow amounts, with positive values indicating inflows (payments received) and negative values indicating outflows (payments made).  The ''dates'' parameter must also be indexed by ''I'' and contains the date in which each payment is made.  The date is expressed as the number of days since the date origin (e.g., Jan 4, 1904).
+
Computes the net present value ([[NPV]]) of a non-periodic cash flow with constant discount rate.   
 +
 
 +
=== Parameters ===
 +
* «rate»: the annual discount rate for a 365 day year.   
 +
* «values»: indexed by «I» and contains the cash flow amounts, with positive values indicating inflows (payments received) and negative values indicating outflows (payments made).   
 +
* «dates»: also be indexed by «I» and contains the date in which each payment is made.  The date is expressed as the number of days since the date origin (e.g., Jan 4, 1904). The first date is the reference date, which received no discounting.
 +
* «I»: The index shared by «values» and «dates».
  
 
For periodic cash flows, the [[Npv]] function can be used without having to specify the actual dates of each payment.  The page on [[Npv]] discusses the concept of net present value in some detail.
 
For periodic cash flows, the [[Npv]] function can be used without having to specify the actual dates of each payment.  The page on [[Npv]] discusses the concept of net present value in some detail.
  
= Examples =
+
== See Also ==
 
+
= See Also =
+
 
+
 
* [[Npv]]
 
* [[Npv]]
* [[XIrr]], [[Irr]]
+
* [[XIrr]]
 +
* [[Irr]]
 +
* [[Financial functions]]

Latest revision as of 16:54, 13 March 2018


XNpv(rate, values, dates, I)

Computes the net present value (NPV) of a non-periodic cash flow with constant discount rate.

Parameters

  • «rate»: the annual discount rate for a 365 day year.
  • «values»: indexed by «I» and contains the cash flow amounts, with positive values indicating inflows (payments received) and negative values indicating outflows (payments made).
  • «dates»: also be indexed by «I» and contains the date in which each payment is made. The date is expressed as the number of days since the date origin (e.g., Jan 4, 1904). The first date is the reference date, which received no discounting.
  • «I»: The index shared by «values» and «dates».

For periodic cash flows, the Npv function can be used without having to specify the actual dates of each payment. The page on Npv discusses the concept of net present value in some detail.

See Also

Comments


You are not allowed to post comments.