Ask Question
26 June, 21:53

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. 26 June, 23:06
    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?
Get 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 there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers