Solved

Match Each of the Following Functions to Its Best Description

Question 69

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:

NPV
RATE
PV
FV
NPER
Related Questions

Q13: The _ function calculates the total number

Q24: The _ function calculates the total future

Q28: An INDEX function returns the position of

Q48: Which function would calculate a final value

Q68: IF you use the function,=MATCH(66,A1:<br>A4,0),on the table

Q69: The formula = _ (10/15/2018,2)would return 12/15/2018.

Q70: 4)If there are 5 possible outcomes, how

Q72: What is the first argument of an

Q75: Which of these is not a capability

Q87: The RATE function returns the periodic rate