Here are some problems that our users have asked and received explanations on
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
I need a pv formula which I'm sure has an IF function:
Rate=B5/12
nper= subtract cell b10 from b6 and multiply by 12
pmt= negative B7
My answers should be 255,022.95 284,573.82 185,040.73
43,562.09
Solved by F. F. in 26 mins
In cell B5, insert the PMT function using the data from the range B2:B4—be sure to divide the interest rate by 12, multiply the years by 12, and display the payment as a positive number.
Solved by X. J. in 11 mins
enter a formula in cell c9 using the PMT function excel to calulate the monthly payment on a loan using the assumptions list in the status Quo scenario in the pmt formula use c6 as the monthly interest rate c8 as the num of payments and c4 as the loan amount enter the formula in cell c9