DATABASE FUNDAMENTALS
BASICS OF BIG DATA
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
PV
|
|
PMT
|
|
Payment
|
|
RATE
|
Detailed explanation-1: -=PMT(17%/12, 2*12, 5400) For example, in this formula the 17% annual interest rate is divided by 12, the number of months in a year. The NPER argument of 2*12 is the total number of payment periods for the loan.
Detailed explanation-2: -PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate.
Detailed explanation-3: -The NPER Function[1] is categorized under Excel Financial functions. The function helps calculate the number of periods that are required to pay off a loan or reach an investment goal through regular periodic payments and at a fixed interest rate.
Detailed explanation-4: -The NPER function calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.