By Admin on Jun 25, 2009 in Corporations
Sarah asked:
I have made an amortization table, and I now need to figure out how to add 100 dollars to the payment of the loan. It is for a 200,000 loan over 15 years with an interest rate of 4.59%. Right now the payments are at 1539.20 and the formula for that is =0.0459/12. Any help would be greatly appreciated. Thanks in advance.
I have made an amortization table, and I now need to figure out how to add 100 dollars to the payment of the loan. It is for a 200,000 loan over 15 years with an interest rate of 4.59%. Right now the payments are at 1539.20 and the formula for that is =0.0459/12. Any help would be greatly appreciated. Thanks in advance.
Here is a free Excel Loan Amortization Schedule worksheet. Maybe you can use the formulas from it to do what you want.
Loan Amortization Schedule
Cozmosis | Jun 27, 2009 | Reply