Matching
Match the following terms with the corresponding description.
Premises:
RATE
NPV
FV
PV
NPER
Responses:
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
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 total present (i.e. ,current)value of a series of payments that will be made in the future
Correct Answer:
Premises:
Responses:
RATE
NPV
FV
PV
NPER
Premises:
RATE
NPV
FV
PV
NPER
Responses:
Related Questions
Q12: In order for the AND function to
Q13: Which function will calculate the final value
Q14: In order for the NOT function to
Q15: The CUMPRINC function requires both starting and
Q16: If an IF statement has four outcomes,it
Q18: Which of the following calculates the net
Q19: Which database function will return the largest
Q20: When using Advanced Filtering < > is
Q21: Advanced filtering will not copy results to
Q22: What is the difference between advanced filtering