MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Loan formulas


Posted by Twomntns on September 22, 2001 6:22 AM

Here's my problem. I am trying to create a record of my debt, payments to that debt, etc.. I am wondering if Excel has any formula's wherein I could enter an amount owed, interest rate, monthly payment and keep an acurate track of the debt still owed.

Thanks! Any help will be greatly appreciated!


Posted by Aladin Akyurek on September 22, 2001 6:50 AM

See the PMT function. (NT)