Match List-I with List-II
| List-I Excel Function | List-II Use |
|---|---|
| (A) CUMIPMT | (I) This function returns the present value of an investment. |
| (B) PV | (II) This function calculates the periodic payment for an annuity, assuming equal payments and a constant rate of interest |
| (C) PMT | (III) This function returns the cumulative interest paid between two periods |
| (D) NPV | (IV) This function calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values). |
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 4
The correct answer is Option (4) →
(A) - (III), (B) - (I), (C) - (II), (D) - (IV)