Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
[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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 "Mac" wrote: [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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Amortization w/ variable interest rate | Excel Worksheet Functions | |||
APY and Interest rate calculation | Excel Worksheet Functions | |||
Variable interest rate | Excel Worksheet Functions | |||
Cash investment tracking when receiving variable interest rate | Excel Discussion (Misc queries) | |||
calculate interest on an increasing balance with variable rate | Excel Discussion (Misc queries) |