Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

191

192

193

194

195

196

197

198

199

200

Using Built-in Functio ns in Analytic Models Chapter 11

The condition of the IF statement ensures that the month being calculated is after the first six months and

before the last six months of the analytic model. If the condition is true, the IF function returns the centered

moving average calculated by the second argument; otherwise, the IF function returns zero.

See Also

Chapter 11, “U

sing Built-in Functions in Analytic Mo dels,” DAVG, page 148,Chapter 11, “Using Built-in

Functions in A

nalytic Models,” MEMBER, page 172 and Chapter 11, “Using Built-in Functions in Analytic

Models,” NUMM

EMBERS, page 177.

NPER

Syntax

NPER(Rate, P

mt, PV, FV, {Type})

Description

The NPER function returns the number of payment periods required to accumulate a future value of FV when

the present value is PV, the payment is Pmt,andtherateisRate.IfType is omitted or zero, NPER assumes that

the investment is an ordinary annuity. If Type is nonzero, NPER assumes that the investment is an annuity due.

Note. Enter negative amounts for money out of your pocket, or positive amounts for money coming to you.

Example

Suppose that

you deposit 1,000 USD at the end of each year in a savings account that earns 6 percent per

year. To dete

rmine how many years it takes before the account is worth 20,000 USD , use the following

formula for t

he YEA RS_REQUIRED cube:

NPER(0.06, -

1000, 0, 20000) = 13.53

Note. The decimal part of the answer is not particularly meaningful; you cannot be sure of getting the 20,000

USD until the end of the 14th year.

If you deposit the 1,000 USD at the start of each year, use the following formula. The 1 for the Type argument

indicates an annuity due:

NPER(0.06, -1000, 0, 20000, 1) = 12.99

If the account already has 5,000 USD in it at the start, use the following formula:

NPER(0.06, -1000, -5000, 20000, 1) = 8.72

NPV

Syntax

NPV(Dimension, Rate, Cash Flow, {Type}, {Condition})

Description

The NPV function returns the Net Present Value for Cash Flow, where Rate is the rate p er period. If Type is

zero or omitted, NPV treats the investment as an ordinary annuity; otherwise, NPV treats the investment as an

annuity due. If Condition is omitted, the function uses all values of Cash Flow. If Condition is included, the

function uses only those values of Cash Flow for which Condition is true.