Thread: How to know the outstanding balance amount of a Loan?
View Single Post
 
Old 01-07-2012, 02:39 AM
PRADEEPB270's Avatar
PRADEEPB270 PRADEEPB270 is offline Windows Vista Office 2007
Novice
  
Join Date: Aug 2011
Location: Gurgaon-INDIA
Posts: 17
PRADEEPB270 is on a distinguished road
Default How to know the outstanding balance amount of a Loan?
Suppose,my current EMI ( equated monthly instalment ) is Rs.15000,Rate of Interest is-12% p.a. and Loan term ( Balance ) in months are-68 Months.
Can I know the outstanding balance through an excel formula? Is it possible?The answer should be come Rs.737504.


Regards

Pradeep
Reply With Quote