Match List-I and List-II.
| List-I | List-II |
|---|---|
| (A) This function calculates the periodic payment for an annuity, assuming equal payments and a constant rate of interest. | (I) IRR function |
| (B) It is the total number of payment periods in an annuity. | (II) PMT |
| (C) It is the number 0 or 1 and indicates when payments are due. | (III) Nper |
| (D) NPV is also related to the | (IV) Type |
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 3
The correct answer is Option (3) → (A) - (II), (B) - (III), (C) - (IV), (D) - (I)
The items are financial functions of a spreadsheet and the arguments they use.
(A) This function calculates the periodic payment for an annuity, assuming equal payments and a constant rate of interest. — this matches (II) PMT. PMT returns the payment for each period, such as the monthly instalment of a loan at a fixed rate of interest.
(B) It is the total number of payment periods in an annuity. — this matches (III) Nper. For a four-year loan repaid monthly, nper is 4 × 12 = 48.
(C) It is the number 0 or 1 and indicates when payments are due. — this matches (IV) Type. Type 0 means payments at the end of each period and type 1 at the beginning.
(D) NPV is also related to the — this matches (I) IRR function. The internal rate of return is the rate at which the net present value equals zero.
NCERT (2026-27 edition):
NCERT (2026-27 edition):
NCERT (2026-27 edition): |
