Loan Amortization

[Lalic]

I have a group of mortgage loans I want to amortize the first 5 payments listing the detail principal and interest payment separately. Is there an easy way to do this? Can you do this efficiently in a pivot table?

 

[Barrie Davidson]

On 2002-03-06 13:15, Lalic wrote:
I have a group of mortgage loans I want to amortize the first 5 payments listing the detail principal and interest payment separately. Is there an easy way to do this? Can you do this efficiently in a pivot table?

I believe this was answered for you by Paul B at:

http://www.mrexcel.com/board/viewtopic.php?topic=1454&forum=2&1

Was the response not sufficient?

 

[Guest]

I don't know about pivot tables, but if you use the PMT function to figure out the total payment, then figure the interest paid by (Current Balance*(Interest Rate/12)), the difference between those numbers will be your payment toward principal.

 

[Scott R]

See help on the CUMPRINC and CUMIPMT functions. That's exactly what you need.