Table 5-1. TVM Menu Labels

Menu Label

Description

First Level

Stores (or calculates) the total number of payments or compounding periods.*† (For a 30-year loan with monthly payments, N＝12 x 30＝360.)

@

Shortcut for N: Multiplies the number in the display by

 

 

P/YR, and stores the result in N. (If P/YR were 12, then

30 @ would set N＝360.)

Storesas a percentage.(or calculates) the nominal annual interest rate

Stores (or calculates) the present value—an initial cash flow or a discounted value of a series of future cash flows (PMTs + FV). To a lender or borrower, PV is the amount of the loan; to an investor, PV is the initial investment. If PV paid out, it is negative. PV always occurs at the beginning of the first period.

Stores (or calculates) the dollar amount of each periodic payment. All payments are equal, and no payments are skipped. (If the payments are unequal, use CFLO, not TVM.) Payments can occur at the beginning or end of each period. If PMT represents money paid out, it is negative.

Stores (or calculates) the future value—a final cash flow or a compounded value of a series of previous cash flows (PV + PMTs). FV always occurs at the end of the last period. If FV is paid out, it is negative.

e

Second Level

Specifies the number of payments or compounding periods per year.† (it must be an integer, 1 through 999.)

*When a non-integer N (an “odd period”) is calculated, the answer must be interpreted carefully. See the savings account example on page 71. Calculations using a stored, non-integer N produce a mathematically correct result, but this result has no simple interpretation. The example on page 172 uses the Solver to do a partial-period (non-integer) calculation in which interest begins to accrue prior to the beginning of the first regular payment period.

†The number of payment periods must equal the number of compounding periods. If this is not true, see page 87. For Canadian mortgages, see page 197.

5: Time Value of Money 63

File name : English-M02-1-040308(Print).doc Print data : 2004/3/9