Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
282 views
in Use of Spread Sheet in Business Application by (25.6k points)
closed by

List down the Parameters of the function PMT

1 Answer

+1 vote
by (27.3k points)
selected by
 
Best answer

LOAN REPAYMENT SCHEDULE: Loan is a sum of borrowed money for a specied period at a pre-specied rate of interest. The loan is repaid through a number of periodic repayment instalments over the loan repayment period. LibreOffice Calc function PMT is used to calculate the loan repayment schedule. The parameters of the function PMT are as follows.

Parameter – Explanation 

  • Rate – Interest rate Nper – Total Number of payments for the loan 
  • PV – Present value(Loan amount) 
  • FV – Future value, which is taken a zero, 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.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...