✓ Board-verified
Accountancy · 2024 · 3 marks
CBSE 2024 · Region 3 · Set 2 · Q31
State the parameters 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
period.
= $\displaystyle 0$) of the
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 f2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- QQ Cut.11 v Wrap Text iCaliba'i I. Copy v Paste I u~ v -v A Merge 81 Center v v 1) format Painter E Clipboard…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct…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…2025
- iCalibfi 11 'A A' I ® ' Wrap Text % Copy v Paste I Ll v; E Merge 8z Center v 'X Format Painter Clipboard Font…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2024board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.