192
Chapter 9: Financial Features
06 Npv ( Npv (Interest rate, initial investment, list of following collected
investment [, frequency list])
Calculatesthenetpresentvalueandevaluatesthevalidityofthe
investment.Youcanenterunequalcashowsinthelistoffollowing
collected investment.
Example
The initial investment is $25,000
planning to achieve the profits
each year as shown on the
right, Evaluate whether annual
revenueof18%isachieved.
*Youcanexecutethecalculation
by using a list or a frequency
list calculation.
07 Irr ( Irr (initial investment, list of following collected investment [,
frequency list] [, assumed revenue rate])
Calculatestheinvestmentrevenueratewherethenetpresent
value is 0.
Example
If the investment for the sales
plan in the previous example
is $28,000, how much is the
investment revenue rate?
• 12.42isobtainedasthe
answer, thus, the investment revenue rate for the above condition
is12.42%.
* In the previous example, revenues following the investment value
(inputusingminussign)wereassumedtobepositive.However,
when the assumed revenue is set to minus (in other words, more
than two inverse symbols), the assumed revenue rate must be
entered at the end. Otherwise an error may occur.