Matching
Match the following terms with the corresponding description.
Premises:
PV
NPV
RATE
FV
NPER
Responses:
Calculates the total present (i.e. ,current)value of a series of payments that will be made in the future
Calculates the periodic rate for an investment or loan given the number of payment periods,a fixed periodic payment,and present E,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 discount rate (rate of return)and a set of given cash inflows
Correct Answer:
Premises:
Responses:
PV
NPV
RATE
FV
NPER
Premises:
PV
NPV
RATE
FV
NPER
Responses:
Related Questions
Q1: The FV function is best suited for
Q2: PPMT should be used to calculate the
Q8: The _ function is best suited when
Q19: Which database function will return the largest
Q25: The _ should be used to calculate
Q29: Which of the following functions will calculate
Q54: Which of the following is not an
Q64: The IPMT function should be used to
Q66: The MATCH function will return a value
Q82: Which of the following functions should be