Manuals/calci/XNPV

XNPV (Rate,CashFlowValues,Dates)

• $Rate$ is the discount rate to apply to the cash flows
• Failed to parse (Conversion error. Server ("https://wikimedia.org/api/rest_") reported: "Cannot get mml. Server problem."): {\displaystyle CashFlowValues} is a series of cash flows that corresponds to a schedule of payments in dates
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Dates} is a schedule of payment dates.
  • XNPV(), returns the net present value for a schedule of cash flows that is not necessarily periodic.

Description

• This function computes the net present value for a schedule of cash flows that is not essentially periodic.
• The arguments should be numeric's.
• XNPV shows the error value whenever any number in dates precedes the starting date or values and dates contain a different number of values.
• XNPV is calculated as follows:

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \sum_{i=1}^N\dfrac{P_i}{(1+rate)^\tfrac{(date_i-date_0)}{365}}=0} where:

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle d_i} = the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle i^{th}} payment date,
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle d_0} = the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 0^{th}} payment date
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle P_i} = the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle i^{th}} payment.

Examples

	A	B
1	-12000	02-01-2009
2	3000	04-01-2009
3	4300	11-30-2009
4	3250	03-15-2010
5	2200	5-1-2010

=XNPV(0.95,A1:A5,B1:B5)= -4330.389965454265

Related Videos

XNPV

See Also

• NPV
• PPMT
• PV

References

• Xnpv

• List of Main Z Functions

• Z3 home