Get instant live expert help on how to calculate pmt
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
In cell B10, use the PMT function to calculate the equal monthly payment amount necessary to pay off the amount borrowed in cell B9, at the end of the term in cell B6, using the APR in cell B5. Be sure the result of the PMT function is positive.
Solved by A. F. in 29 mins
Hi I need help with PMT and Absolute PMT problems. There are 2 sheets I will send you.
Solved by M. D. in 15 mins
Did I calculate the beginning balance correctly?
Here is the question I'm referring to.
In cell E2 calculate the present value of an auto loan that has a $450.00 payment. 5.25% interest rate, and a four year repayment period. could you explain how to do this? Also we use pmt function and absolute references instead of mixed.
Solved by A. H. in 19 mins
how do i calculate the interest rate so that it is a positive number. Here is the question "Insert the PMT formula in J7 to calculate the first client's monthly payment; use appropriate relative and absolute references in your formula, do not use actual numbers. show the result as a positive number.
Solved by K. L. in 26 mins
Insert the PMT function in cell J5 to calculate the first client's monthly payment, using appropriate relative and using excel absolute value function. Copy the formula down the column.
Solved by I. E. in 16 mins