dear all,
i would like to calculate the interest for a duration of days with compounded interest on quarterly basis.
Please help me. the data sheet is attached .thanks
dear all,
i would like to calculate the interest for a duration of days with compounded interest on quarterly basis.
Please help me. the data sheet is attached .thanks
Try with in "G2"
Formula:Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
sir, its not working.
Hello, what exactly should G2, G3, and G4 be?
By exactly, I mean the exact numbers that belong in those cells.
Once we know this, we can build a working formula for you in Excel.
sir, as you suggested i am attaching herewith the excel sheet where the results also being given.
NEED FORMULA IN FOR ARRIVING THE FIGURE IN COLUMN "interest"BASED ON THE PRINCIPLE OF ACCUMULATED COMPOUND INTEREST OF 90 DAYS.
FOR EVERY 90 DAYS, THE INTEREST WILL BE ADDED TO PRINCIPAL TO CALCULATE THE INTEREST.
The interest formula in a such way that I can calculate interest for any number of days
applying the principle of accumulated interest for a period of 90 days each.
Last edited by srinivastsc; 06-29-2017 at 10:00 PM. Reason: file attached
How much of this is an Excel question, and how much of this is a more generic business math question about how to calculate interest.
I am not knowledgeable about business math, but this seems like it should be a basic present value or future value type question. My first suggestion would be to look at the PV() or FV() functions and see if they are appropriate for your situation.
If those functions (or others listed in the help file) are not appropriate, then I would suggest you explain the formulas/equations you are using to obtain the results listed, and we should be able to help you program those formulas in Excel.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks