Matching
Match each of the following functions to its best description:
Premises:
NPER
FV
RATE
NPV
PV
Responses:
Calculates the periodic rate for an investment or loan given the number of payment periods, a fixed periodic payment, and present value.
Calculates the net present value of an investment, given a fixed rate (rate of return)and futurepayments that may be identical or different.
Calculates the future value of an investment, given a fixed interest rate, term, and periodic payment
Calculates the total present (current)value of an investment with a fixed rate, specified number of payment periods, and a series of identical payments that will be made in the future.
Calculates the number of payment periods for an investment or loan given a fixed interest rate, periodic payment, and present value.
Correct Answer:
Premises:
Responses:
NPER
FV
RATE
NPV
PV
Premises:
NPER
FV
RATE
NPV
PV
Responses:
Related Questions
Q87: The PPMT function calculates the monthly principal
Q88: The NPV function is used mostly to
Q89: DSTDEV calculates the standard deviation of a
Q90: The database argument of a database function
Q91: Match each of the following terms to
Q93: Match each of the following terms to
Q94: Match each of the following nested
Q95: Match each of the following terms with
Q96: Match each of the following functions to
Q97: Match each of the following terms to
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents