✓ Board-verified
Accountancy · 2024 · 3 marks
CBSE 2024 · Region 3 · Set 1 · Q32
State the pa rameters of Excel's PMT function. What is the use of this function?
State the pa rameters of Excel's PMT function. What is the use of this function ?
Marking-scheme solution
The parameters of the PMT function are as follows.
1. Rate: Interest rate per period of loan.
2. Nper: Total number of payments for the loan. Its units should match with the
unit of interest rate.
3. PV: Present value i.e. loan amount.
4. FV: Future value, which is taken as zero, is the balance at the end of the loan period.
5. Type: Whether payment is made at the beginning (value =$\displaystyle 1$) or at the end (value
= $\displaystyle 0$) of the period.
USE : This function calculates the periodic payment for an annuity assuming equal
payment and a constant rate of interest.
More from Spreadsheet
- Explain the two syntax forms of 'Lookup' function.2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- Using the worksheet find out the error and its reason for the given 'VLOOKUP' syntax. (i) = VLOOKUP (B1, B2: E8, 2, 0) (ii) = SQRT (VLOOKUP (B5, B8:…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.2025
- What is a 'Pivot table'? State any three of its advantages. OR List eight uses of Accounting Software.2023
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.2025
- From the given 'VLOOKUP' syntax find out the error and its reason using the worksheet. (i) = VLOOKUP (B5, C3: F10, 2, 0) (ii) = SQRT (VLOOKUP (B3,…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2024 board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.