Posted on May 11, 2011.
I'm making a chart of 36 payments (rows 1-36) so i need to make payment for EACH column (column A), interest (column B), principle (column C) and balance (column D). I just want to input The loan Amount in one cell and get a result for The Interest Paid, Paid and balances principle "for all 36 payments. Understand if you dont visit http://www.lenderhomepage.com/tools/mortgage-amortization-calculator.phpThis Is What I'm Trying to make it excel
