Ask Question
23 January, 10:33

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

+4
Answers (1)
  1. 23 January, 12:22
    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 and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers