help on loan amortization

Joined
Aug 1, 2013
Messages
2
Reaction score
0
Points
0
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 prepayent must remain the same Please reply
Manav
 

Hercules1946

New member
Joined
Mar 22, 2013
Messages
794
Reaction score
0
Points
0
Location
York, England
Excel Version(s)
2010
Hello
Im a bit confused by what your saying. It sounds like you have a total amount to repay that needs to include interest, and you also know what the repayment period is. If this is correct, then you need to calculate the following:
Principal (P) = Gross Borrowing - Prepayment or Deposit.
Interest Rate = i
No of payments = n

Then, the payment amount is:


P (i + ( i )
((1 + i)^n) - 1 )

Hope that makes sense with the limited fonts available.
 
Top