Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

201

202

203

204

205

206

207

208

209

210

Using Built-in Functio ns in Analytic Models Chapter 11

Syntax

PV(Rate, NPer, Pmt, FV, {Type})

Description

The PV function returns the Present Value of an investment with a future value of FV,wherePmt is received

for NPer periods and is discounted at the rate of Rate per period. If Type is omitted or zero, PV assumes that

the investment is an ordinary annuity. If Type is nonzero, PV 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 a machine that sells for 80,000 USD saves your company 11,000 USD a year for 10

years. Assuming that the money saved could be invested at 8 percent per year, you can calculate the

PRESENT_VALUE cube as follows:

PV(0.08, 10, 11000, 0) = -73811

The present value of the machine is 73,811 USD, indicating that you might be better off investing the 80,000

USD in another way. But suppose that you can sell the machine for 30,000 USD at the end of the 10 years.

You can calculate the PRESENT_VALUE cube as follows:

PV(0.08, 10, 11000, 30000) = -87707

In this case, the present value is higher than the cost of the machine, indicating a profitable investment.

QUARTILE

Syntax

QUARTILE(Dimension, Va l ue s , Quartile, {Type}, {Condition})

Description

The QUARTILE

function returns a quartile of Va l ue s.

The Quartile argument sets which q uartile (0, 1 ,2 , 3, or 4) is calculated. If Type is zero or omitted,

QUARTILE calculates a population quartile; otherwise, QUARTILE calculates a sample quartile. If Condition

is omitted, the function uses all Va l u es .IfCondition is included, the function uses only those Val u e s for

which Condition is true.

Returns

The QUARTILE function returns a quartile of Va l u e s . The Quartile argument sets the quartile (0, 1 ,2 , 3,

or 4) that is calculated. If Type is zero or omitted, QUARTILE calculates a population quartile; otherwise,

QUARTILE calculates a sample quartile. If Condition is omitted, the function uses all Val ue s .IfCondition is

included, the function uses only those Va l u e s for which Condition is true.

Example

For example

, s uppose that an analytic model contains a data cube called SCORES that uses dimensions

called STUD

ENTS and TESTS.