Hello Everyone!
I have the below sample loan payment schedule in an excel doc. It automatically calculates monthly payment, interest, principal and loan balance.
Screen Shot 2013-06-19 at 11.38.04 PM.jpg
I'd like to calculate average interest rate in a way that allows me to manipulate the monthly payment. So, for example, the borrower would be able to pay back more in the beginning months, and less in the end months, but still pay back the same amount cumulatively. Does anyone know any formulas I can use or have any ideas?
Thanks!
Bookmarks