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
Q42: When formated as a date, the results
Q43: The MONTH function would return 25 when
Q44: A NOT function reverses the truth of
Q45: The _ function calculates cumulative principal through
Q46: The YEAR function would return _ on
Q48: Which function would calculate a final value
Q49: The DCOUNTA function returns an error if
Q50: The _ function calculates the periodic interest
Q51: Which function calculates the total amount of
Q52: Which of the following is not an