Need formula on MS Excel to make amortization calculator? - mortgage loan amortization calculator
I am an overview of the 36 payments (lines 1-36), so I have to pay for each column (column A), interest (column B), the first (column C) and the balance (column D). I just want to enter to the loan amount into a cell and get a good result for the interest paid to the principle of payment and the balance of 36 payments. If you do not understand is http://www.lenderhomepage.com/tools/mortgage-amortization-calculator.php visit, I try to do something in Excel
2 comments:
This happens:
http://web.tampabay.rr.com/temphomepage/ ...
It is indeed 360payments (30 x 12), not 36th If you are the 36 monthly installments, the payment amount increases to $ 4700.45
Why reinvent the wheel? There are a number of free loan amortization excel models. Here is a Microsoft Web site:
http://office.microsoft.com/en-us/excel/ ...
Post a Comment