By Admin on Nov 29, 2009 in Other - Business & Finance
daisy s asked:
How do you make an amortization schedule if you don’t know the monthly payments.
only information given is the amount of said loan and annual interest rate. i don’t know how to use excel if any one can tell me how to do it with equations. Can someone help me Please! I need it desperately. Thanx
Please dont send me to a website can i please just get some concrete information on how to do an amortization of loans.
How do you make an amortization schedule if you don’t know the monthly payments.
only information given is the amount of said loan and annual interest rate. i don’t know how to use excel if any one can tell me how to do it with equations. Can someone help me Please! I need it desperately. Thanx
Please dont send me to a website can i please just get some concrete information on how to do an amortization of loans.
You can set up the formula such as R = A[i / (1 - (1 + i))^-n] to find the monthly payments.
R = Monthly payment amount
A = Amount borrowed
i = annual interest rate
n = # of payments
Bleaksky | Dec 1, 2009 | Reply