Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-07-2012, 02:39 AM
PRADEEPB270's Avatar
PRADEEPB270 PRADEEPB270 is offline How to know the outstanding balance amount of a Loan? Windows Vista How to know the outstanding balance amount of a Loan? Office 2007
Novice
How to know the outstanding balance amount of a Loan?
 
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
  #2  
Old 01-07-2012, 04:45 AM
Catalin.B Catalin.B is offline How to know the outstanding balance amount of a Loan? Windows Vista How to know the outstanding balance amount of a Loan? Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

have you tried http://support.microsoft.com/kb/214091
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Balance from different sheets andre Excel 0 11-29-2011 02:36 PM
How to know the outstanding balance amount of a Loan? Large amount of text as a form field. JustK Word 2 11-15-2011 11:17 AM
Sum required without consider the negative amount PRADEEPB270 Excel 2 08-22-2011 04:23 AM
Analysis of Amount based on following criterion. aligahk06 Excel 1 04-24-2010 10:34 AM
Convert Dollar amount to text GeorgeLawshe Word 0 03-07-2010 10:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft