amortization tables
Posted by AxisFin on October 15, 2001 5:24 PM
I am trying to create a self size adjusting amortizatin table, unsucessfully so far. I have figured out how to do the calculation in order to get the P&I payments but am having trouble developing the amortization table. I would like it to be self adjusting in length depending on the paramiters I enter into the payment areas. Any advice?
Posted by Dan on October 16, 2001 4:15 AM
I have a Loan template workbook that I can send you if you want. This is part of my Excel 97 package - I don't know if this is in everyone's installation package or just our company's. It may help you out. Let me know.
Posted by Don C on October 16, 2001 5:28 AM
An IF statement will work.
Let's say that the Balance Due is in column E, the each formula in row 15 would start with
=IF(E14>0,statement,"") where statement is that column's formula. When the balance due reaches zero, the cell goes to blank.
