Target Exam

CUET

Subject

-- Accountancy Part C

Chapter

Use of Spreadsheet in Business Applications

Question:

Which of the following financial function indicates the loan amount?

Options:

PV

FV

Nper

Rate

Correct Answer:

PV

Explanation:

The correct answer is option 1- PV.

PV is the financial function that indicates the loan amount.

 

Parameter Explanation
Rate Interest rate per period for the loan
Nper Total number of payments for the loan. Its unit (e.g. year)
should match with the unit of the interest rate.
Pv Present value, i.e. the loan amount
Fv Future value, which is taken as 0, is the balance at the
end of the loan period
Type Whether payment is made at the beginning (value=1) or
at the end (value=0) of the period