By Admin on Nov 18, 2009 in Software
Aces asked:
i’m making a chart of 36 payments (rows 1-36) so i need to make each column for payment (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, principle paid and balance for all 36 payments. If you dont understand visit http://www.lenderhomepage.com/tools/mortgage-amortization-calculator.php This is what i’m trying to make on excel
i’m making a chart of 36 payments (rows 1-36) so i need to make each column for payment (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, principle paid and balance for all 36 payments. If you dont understand visit http://www.lenderhomepage.com/tools/mortgage-amortization-calculator.php This is what i’m trying to make on excel
Why reinvent the wheel? There are a number of free EXCEL loan amortization templates available. Here is one from Microsoft:
HandyDan | Nov 20, 2009 | Reply
This will do it:
By the way, it’s 360payments (30 x 12), not 36. If you use 36 monthly payments, the payment amount jumps to $4,700.45
nospamcwt | Nov 21, 2009 | Reply