Respuesta :
The word used to denote the loan's interest rate in the Excel PMT function is called rate.
The recurring payment for a debt is returned by the Excel PMT function, which is a financial function. Given the loan amount, number of repayment periods, and interest rate, you can use the NPER function to calculate the loan's installments.
The PMT Function computes a loan's payment using fixed instalments and a fixed interest rate.
The essential parameters are part of the PMT method syntax:
Rate is required. the loan's interest rate.
Nper Essential The no of of loan payments.
Pv is required. The principle is also known as the present value, or the entire amount that a series of future payments would be worth today.
Fv optional. The targeted cash balance following the final payment or the value in the future. If fv is absent, it is considered to be zero, meaning that the loan's future value is zero.
For more such question on excel PMT function.
https://brainly.com/question/14206205
#SPJ4
