Matching
Match each of the following functions to its best description:
Premises:
NPV
RATE
PV
FV
NPER
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 number of payment periods for an investment or loan given a fixed interest Rate,periodic payment,and present value.
Calculates the future value of an investment,given a fixed interest rate,term,and periodic payment
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 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.
Correct Answer:
Premises:
Responses:
NPV
RATE
PV
FV
NPER
Premises:
NPV
RATE
PV
FV
NPER
Responses:
Related Questions
Q82: The RATE function returns the periodic rate
Q83: A loan amortization table is a schedule
Q85: Database functions do not require a Criteria
Q89: DSTDEV calculates the standard deviation of a
Q91: Match each of the following terms to
Q93: Match each of the following terms to
Q94: Match each of the following nested functions
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