Register
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?
70.3k views
3 votes
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?

User Adam Templeton
by
6.3k points

1 Answer

3 votes

Answer: The function Stella can use to calculate the periodic payments of a loan is:

The Excel PMT function or NPER function.

Explanation: 1. The Excel PMT function is a financial function that returns the periodic payment for a loan.

2. The NPER function to figure out payments for a loan, given the loan amount, number of periods, and interest rate.

User Slammaster
by
6.1k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

6.4m questions

8.4m answers

Other Questions

10 points Wireframing and storyboarding are helpful in which step of web development? Advertising Planning Printing Publishing
If a website ends with .gov does it mean that its written by the government or?
To group option buttons so that selecting one deselects all of the others, you must make the ____ attribute the same.
Harrison worked on a spreadsheet to show market trends of various mobile devices. The size of the file has increased because Harrison used a lot of graphs and charts. Which file extension should he use
In which job role would a course in 3D modeling help with professional career prospects? Computer Programmer Multimedia Artist Technical Support Specialist Web Developer
Link Copied!