Ask Question

Stella is a bank executive. She is preparing a spreadsheet on the loan repayment schedules of customers. Which function can she use to calculate the periodic payments?

A. What-If analysis

B. PMT

C. Regression Analysis

D. Min

+3
Answers (1)
  1. 15 April, 16:39
    0
    The answer is B: PMT

    Stella will use the PMT function to calculate the payment for a loan that has constant interest rate and payments. This function is a financial function that can be used to calculate the monthly payment due on a personal loan. The syntax for PMT is = PMT (rate, nper, pv, [fv], [type])
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Stella is a bank executive. She is preparing a spreadsheet on the loan repayment schedules of customers. Which function can she use to ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers