# Get instant live expert help on ppmt function excel

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Need help for an excel problem regarding payment calculations. Also need a double check for my work. Specifically need help In PPMT and IPMT
Solved by B. D. in 12 mins
=-PPMT(B4,A19,20,B4) IS NOT WORKING AS IT DID IN THE OTHER 14 CELLS
Solved by S. A. in 18 mins
Using cell references, create a PMT formula in cell D8 to calculate the monthly loan from NewVentures CapitalInc. Bote: the PMT function uses the same arguments as the PPMT function with the exception that there is no PER criterion. Remeber to divide the rate by 12 and multiply the NPER by 12 to use the monthly units. Using cell refrences create PPMT formulas to find theprincipal portion of the loan payment for the first loan payment in cell D10 and the last loan payment in cell D11. In cell D13, create a formula to calculate the total cost of the loan by multiplying the monthly loan payment times the authorization period in years times 12.
Solved by D. J. in 13 mins
I need help on how to use indirect function along with sumifs function in excel.
Solved by Z. W. in 15 mins
In EXCEL 2016 HOUR Function in SQL fails with "Hour is not a recognized function
Solved by M. J. in 15 mins