variable interest rate calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

[Excel 2003]
I want to calculate compound, variable interest on an account consisting of
multiple deposits of irregular amounts and and irregular deposit dates.
It would be best if it could calculate on actual calendar dates, not just
30-day months/360 days. Also, it would be best if interest could be
compounded daily, rather than any larger period.
Does anyone happen to know a way to program this or a site that I might
purchase it from?
Thanks.
 
Great Product by the name of EXCEL

Look at XNPV or XIRR

The X means that the payment stream is not smooth. Inputs are actual dates
and amounts.

pretty sure it uses 365 day compounding and the XNPV of a future date should
give coumpounded interest for amounts deposited.

start with some simple inputs to get a handle on it, but this can be made to
do what you are asking
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I calculate interest? 1
Mtge calculation (Dly compound interest and multiple interest rate 2
Please Help in this Compound Interest UDF 2
Help understan this percentage 4
Help to create amortization schedule 0
calculation of future value between two dates 2
Calculate interest & withdrawals 0
Calculating interest due on late loan payments 1

Back
Top