✓ Board-verified
Accountancy · 2023 · 6 marks
CBSE 2023 · Region 1 · Set 1 · Q34
What is meant by 'Present Value' of an investment ? Explain the financial function which helps in its calculation.
Marking-scheme solution
Present value is the total amount that a series of future payments is worth now.
The financial function which helps in its calculation is known as PV.
Its syntax is
PV (rate, nper, pmt, fv, type)
Where
Rate : Interest rate per period.
Nper : Total number of payment periods in an annuity.
Pmt : The payment made each period and connot be changed over the life of
annuity : Typically pmt includes principal and interest but no other fees and
taxes.
FV : The future value, or a cash balance to attain after the last payment is
made.
Type : is the number $\displaystyle 0$ or $\displaystyle 1$ and indicates when payments are due. The fv and type
arguments are optional.
*
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 2023board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.