Manuals/calci/XNPV

XNPV(Rate,V,Dates)

• $Rate$ is the discount rate to apply to the cash flows
• 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 V} is a series of cash flows that corresponds to a schedule of payments in dates
• $Dates$ is a schedule of payment dates.

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:

• $d_{i}$ = the $i^{th}$ payment date,
• $d_{0}$ = the $0^{th}$ payment date
• $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

See Also

• NPV
• PPMT
• PV

References

• Xnpv