Technical data

Using Built-in Functio ns in Analytic Models Chapter 11
The initial values in the cash flow should be negative to represent a cash outflow. The remaining values may
be all positive (representing cash inflows) o r a combination of positive and negative.
Returns
The Internal R
ate of Return for Cash Flow. Guess can be omitted (or zero) in most cases. If IRR is unable
to find the Int
ernal Rate of Return, it returns an error value. In such cases, you can use a nonzero Guess to
nudge IRR towa
rd the correct answer.
Example
You can calculate the internal rate of return for a data cube called IRR_OF_CASH_FLOW with this formula:
IRR(MONTHS, CASH_FLOW)
You can calculate the internal rate of return for the first 12 months for a data cube called
RR_FOR_1ST_12_MONTHS with this formula:
RR(MONTHS, CASH_FLOW, 0, MEMBER(MONTHS) <= 12)
The Condition ensures that the IRR function uses only those values for which the month index is 12 or less.
LN
Syntax
LN(Data)
Description
The LN functi
on returns the natural logarithm of Data. The value of Data must be greater than zero; otherwise,
LN returns an
error value.
Example
These examples employ the LN built-in function:
• LN(7)returns 1.9459101491.
• LN(E()^5)returns 5.
• LN(25) / LN(5) returns 2.
• LN(-7)returns an error.
LEFT
Syntax
LEFT(Text, Count)
Description
The LEFT func
tion returns the first Count characters of Text.
Returns
The first Count characters of Tex t.
168 Copyright © 1988-2007, Oracl e. All rights reserved.