In that case, divide the year by a quarter or a half.
Now, this rate can be used for as many quarters or half years as are given.
----- Original Message -----
From: "Rohit Trivedi" <rohi...@msn.com>
To: "'Vedprakash'" <vedprakash.sha...@gmail.com>;
<accessindia@accessindia.org.in>
Sent: Wednesday, June 26, 2013 1:27 AM
Subject: Re: [AI] How to calculate compounded interest using excel?
And if the interest is compounded quarterly or at 6 monthly basis?
-----Original Message-----
From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On
Behalf
Of Vedprakash
Sent: 25 June 2013 09:41
To: accessindia@accessindia.org.in
Subject: Re: [AI] How to calculate compounded interest using excel?
The formula for excel is:
=100*(110/100)^10
----- Original Message -----
From: "Rajesh H Mehta" <rajeshme...@in.ibm.com>
To: <accessindia@accessindia.org.in>
Cc: <accessindia@accessindia.org.in>; "AccessIndia"
<accessindia-boun...@accessindia.org.in>
Sent: Tuesday, June 25, 2013 8:53 AM
Subject: [AI] How to calculate compounded interest using excel?
Dear all,
Good morning!
Can any 1 tell me the formula to calculate any thing with compound
interest using excel?
Example: Lets say what should I type on excel incase if I wish to
calculate %10 for lets say 100 rupees for 10 year?
Regards
Register at the dedicated AccessIndia list for discussing accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessind
ia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the
mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessind
ia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the
person sending the mail and AI in no way relates itself to its veracity;
2. AI cannot be held liable for any commission/omission based on the mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of the
person sending the mail and AI in no way relates itself to its veracity;
2. AI cannot be held liable for any commission/omission based on the mails sent
through this mailing list..