MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.