How to know the outstanding balance amount of a loan?

Hi Pradeep,

Check out the attached workbook where you have the actual calculations in excel to derive to loan balance. I belive there is no straight forward function to help you get the loan balance amount. This one i have downloaded from web research, believing it might help you.

Thanks,