help on loan amortization

[parmarmanav@yahoo.co.in]

Hi
For a while now i am just stuck on preparing my loan amortization table with prepayment option.Need some help.I want my "PMT" to change with every prepayment amount I enter for the balance loan period ,and the loan PMT before the prepayment must remain the same Please reply

Manav

[jsuarezg]

Hello,

In this video, I think, you can learn how to do it.

http://www.youtube.com/watch?v=vjqJq_gkV2U

Is very clear,