Version

UltraCalcFunctionNPV Class

Calculates an investment's Net Present Value given it's expected rate or return and the cash flow represented as positive numeric values (income) and negative numeric values (payments).
Syntax
'Declaration
 
Public Class UltraCalcFunctionNPV 
   Inherits BuiltInFunctionBase
public class UltraCalcFunctionNPV : BuiltInFunctionBase 
Remarks

NPV(discountRate, value1, value2, ..., valueN)

DiscountRate is the investment's expected rate of return over the life of the investment, expressed as a percentage growth (or decline) per payment period. In some applications this may be the fixed interest rate. This numeric value is used to discount cash flows paid into or received from the investment.

Value1, value2, ... valueN are any number of numeric values representing cash inflows (as positive numbers) or cash outflows (as negative numbers). These cash flows must occur at a fixed period (the same period at which the discountRate is expressed), although some cash flows may be zero. The order of the sequence is important, as value1 is assumed to occur (N-1) periods before valueN and will have been able to accrue that much more interest at the assumed discountRate.

By convention, the NPV() assumes cash flows occur at the end of each period. Consequently, the NPV() represents the present value as of the date one period's length before the first cash flow, value1, has been made. If you require flexibility in when cash flows occur (the beginning or end of each period), consider using the PV() function. However, it differs from NPV() in that NPV() allows cash flows of different amounts.

Only numeric values or text values convertible to numeric values may be passed to this function. If a column or range reference is passed as a value argument, only numeric values or text values convertible to numeric values are used.

IRR()
Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also