[dba-SQLServer] SQL Equivalents of PV and NPer

On 22 Aug 2006 at 16:44, David Emerson wrote:

> Does anyone know what the equivalent SQL functions are for the VB PV 
> and NPer functions?
> 

AFAIK, SQL doesn't have any such functions, you'd have to roll your own UDFs from first 
principles.


PV = FV [ 1 / (1 + i)n ]
Where:

    PV = Present Value
    FV = Future Value
    i = Interest Rate Per Period
    n = Number of Compounding Periods

 

number of periods = natural log  [(FV * i) / (PV * i)] / natural log (1 + i)
where:
    PV = present value, the amount you invested
    FV = future value, the amount your investment will grow to
    i = interest per period


You can find these and other financial formulae at:
http://www.getobjects.com/Components/Finance/TVM/concepts.html




-- 
Stuart McLachlan