“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Solved by B. E. in 24 mins

Hi I have an Absolute PMT table I need help on.

Solved by A. J. in 26 mins