Difference between revisions of "Manuals/calci/XNPV"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | '''XNPV | + | <div style="font-size:30px">'''XNPV(Rate,V,Dates)'''</div><br/> |
| + | |||
| + | *<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>Dates</math> is a schedule of payment dates. | ||
| − | |||
| − | |||
| − | |||
==Description== | ==Description== | ||
*This function computes the net present value for a schedule of cash flows that is not essentially periodic. | *This function computes the net present value for a schedule of cash flows that is not essentially periodic. | ||
Revision as of 06:27, 27 February 2014
XNPV(Rate,V,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 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
- 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.
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.
Equation:
XNPV
Lets see an example,
XNPV(R, V, dates)
B C
-10000 02-01-2009
3000 04-01-2009
4300 11-30-2009
3250 03-15-2010
2200 05-01-2010
?UNIQ4279e6deca12de8c-nowiki-00000002-QINU? is 2069.5268 '
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | -10000 | 02-01-2009 | 2069.5268 | |
| Row2 | 3000 | 04-01-2009 | ||
| Row3 | 4300 | 11-30-2009 | ||
| Row4 | 3250 | 03-15-2010 | ||
| Row5 | 2200 | 05-01-2010 | ||
| Row6 | ||||
| Row7 |
