Can someone please advise me how to solve for a monthly loan payment amount? I want to provide the Present value, the # of payments, and the annual interest rate, and have the formula return the correct monthly payment.
Thanks.
Can someone please advise me how to solve for a monthly loan payment amount? I want to provide the Present value, the # of payments, and the annual interest rate, and have the formula return the correct monthly payment.
Thanks.
Here's a start:
http://www.meadinkent.co.uk/excel-loan-repayments.htm
Best regards,
Ray
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks