Skip to content

The PMT function in MS… (Class 12 Accountancy 2026, Q29)

questionbuddy.in/q/cbse-12-accountancy-2026-67-5-1-q29-pmt-function-excel-used

AccountancyCBSE Class 12 · Board exam 2026, set 67/5/1 · 1 mark · MCQ

CBSE Class 12 Accountancy 2026: question 29

Set in the CBSE Class 12 board exam of 2026, paper 67/5/1, section B-II, question 29, for 1 mark. Try it first; the hints and our step-by-step solution are below.

Q29 · 1 mark · MCQUse of Spreadsheet in Business Applications

The PMT function in MS Excel is used to :

  1. (A)Calculate the total interest on a loan.
  2. (B)Calculate the periodic payment for a loan or investment.
  3. (C)Calculate the future value of an investment.
  4. (D)Calculate the present value of a series of payments.

Source: official question paper from cbse.gov.in (PDF). See it in the full 2026 board paper, set 67/5/1.

Hints

Open one hint at a time and try again before the next.

Hint 1

PMT stands for "payment".

Hint 2

FV and PV are separate functions.

Step-by-step solution

Each step shows the marks it earns, as an examiner would award them. Checked by an independent re-solve from the question paper.

  1. PMT(rate, nper, pv, [fv], [type]) returns the equal periodic payment (instalment) for a loan or investment at a constant rate.

  2. Total interest, future value (FV) and present value (PV) have their own functions. Option (B).

    1 mark

Answer: (B) Calculate the periodic payment for a loan or investment

Where the marks are

  • Periodic payment (1 mark)

Revise the chapter

Practise this chapterBoard-style questions from Use of Spreadsheet in Business Applications, one at a time, marked against the answer key and marking points.Back to the full paper2026 board paper, set 67/5/1: every question, by section.

The question is transcribed from the official paper; figures are described in words. The solution, hints and chapter tag are ours. Spotted an error? Write tosupport@questionbuddy.in.