Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mac Mac is offline
external usenet poster
 
Posts: 213
Default variable interest rate calculation

[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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 279
Default variable interest rate calculation

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Amortization w/ variable interest rate Betty K Excel Worksheet Functions 1 November 21st 09 04:53 PM
APY and Interest rate calculation boba[_2_] Excel Worksheet Functions 1 December 11th 08 05:29 PM
Variable interest rate Williap Excel Worksheet Functions 0 January 8th 07 06:38 PM
Cash investment tracking when receiving variable interest rate Jeannz Excel Discussion (Misc queries) 0 September 13th 05 03:35 AM
calculate interest on an increasing balance with variable rate LPMastro Excel Discussion (Misc queries) 0 February 16th 05 08:13 PM


All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"