Which function would you use to find the periodic payment needed to pay off a loan in a specific number of periods?  A. RATE  B. NPR  C. PV  D. PMT

In Excel, the function to calculate the payment for a loan based on constant payments and a constant interest rate is:  A. PV  B. FV  C. PMT  D. NPV

A man takes out a loan of P45,000.00 that pays 4% interest compounded semi-annually. He intends to pay off the loan plus periodic interest by amortization in 3 years.11. Compute his rate of interest every 6 months (i) and the total number of interest periods (n).Group of answer choices4%; 32%; 61%; 61%; 12

A MAN MADE A LOAN OF PHP 60,000 PAYABLE IN 3 YEARS AT 8% COMPOUNDED QUARTERLY WHAT IS THE PERIODIC INTEREST RATE?A. 2% B.4% C. 1.33% D. 8%

Payments of 800, 500 and 700 are made at the ends of years 2, 4, and 6 respectively. Giventhat the effective interest rate is 13%, find the time point at which single payment of 2100would be equivalent

Mr. Joseph borrowed $18900 at 13.5% per annum and repaid $12 757.50 simple interest.Calculate the period of the loan