205
FINANCIAL FUNCTIONS
[02 slv_I%] : Calculates annual interest
Input method: slv_I%(N, PV, PMT, FV, P/Y, C/Y)
Here, we will calculate the interest to establish a monthly
payment of $1000 (TAB is set to 2).
¬
Ï
FINANCE
B02
(
360
,
200000
,
—
1000
,
0
,
12
,
12
) ®
Thus, monthly payments of $1000 are possible at interest rate of 4.39%
• It is possible to find out an unknown variable by inputting known variable for the
functions described below.
• However, the contents simulated on the home screen do not influence the variable
values of the TVM SOLVER.
[03 slv_PV] : Calculates the present value.
Input method: slv_PV(N, I%, PMT, FV, P/Y, C/Y)
[04 slv_N] : Calculates the number of payments.
Input method: slv_N(I%, PV, PMT, FV, P/Y, C/Y)
[05 slv_FV] : Calculates the future value.
Input method: slv_FV (N, I%, PV, PMT, P/Y, C/Y)
[06 Npv (] : Calculates the pure initial value and evaluates the validity of the
investment.
<Example 5>
There is a plan of raising the initial investment to
increase sales each year, as shown to the right. How
much would the initial investment have to be in order to
increase the annual revenue of 18%?
•“Npv(” is used in such a case to calculate investment.
• Input method: Npv(interest rate, initial investment, list
of following collected investment)
$?
$7000
$9000
$5000
$8000
$11000
12345
,, ,,
,
EL-9650-(08)EN (197-210) 8/1/00, 9:09 AM205