Stella is a bank executive. She is preparing a spreadsheet on the loan repayment schedules of customers. Which function can she

Question

White raven [17]

4 years ago

9

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

Computers and Technology

1 answer:

Tresset [83] · Answer 1 · 2021-11-20T08:35:31+03:00

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])