Difference between revisions of "Manuals/calci/XNPV"
Jump to navigation
Jump to search
| (3 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''XNPV(Rate, | + | <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> | + | *<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== | ||
| Line 38: | Line 39: | ||
|} | |} | ||
=XNPV(0.95,A1:A5,B1:B5)= -4330.389965454265 | =XNPV(0.95,A1:A5,B1:B5)= -4330.389965454265 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|CVgWvOFyGew|280|center|XNPV}} | ||
==See Also== | ==See Also== | ||
| Line 45: | Line 50: | ||
==References== | ==References== | ||
| + | *[https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_XNPV_function Xnpv] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 16:05, 27 July 2018
XNPV (Rate,CashFlowValues,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 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
See Also
References