Greetings,
I'm having a problem with a sheet that is calculating payment and interest for a given loan. When I change the interest rate to 2%,4%,7%,9%,11%,14%,16% and 17%, I don't get a value in the last row which is B32,C32,D32,E32.
B32=IF(A32>$D$14;"";$D$13)
C32=IF(A32>$D$14;"";$D$8/12*E31)
D32=IF(A32>$D$14;"";B32-C32)
E32=IF(A32>$D$14;"";E31-D32)
I found the file on google when I searched for "amortization formulas" from a website called Vertex42, under "Example: Loan Amortization Formulas in Excel". The forum doesn't let me upload yet since im a new member. Or you can just view it online to get a picture of my problem.
Is it correct that the last amount shouldn't be included? Is the file right or wrong? If it is wrong, how shall I adjust for this?
Best regardsSkärmklipp1.JPG
Bookmarks