Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Formula to calculate compound interest on increasing principal

Hi folks,
Would appreciate some help in locating a formula to calculate compound
interest on an increasing principal.
Many thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,441
Default Formula to calculate compound interest on increasing principal

Moreden,

If you add to the principal at a constant rate, and the interest rate
doesn't change, then simple use the FV function. Otherwise, you need to use
a stepwise method, using a table of variable inputs to FV at every change in
rate or principal addition.

HTH,
Bernie
MS Excel MVP


"Moreden" wrote in message
...
Hi folks,
Would appreciate some help in locating a formula to calculate compound
interest on an increasing principal.
Many 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
How to calculate Compound Interest Nikhil Excel Worksheet Functions 3 September 19th 07 03:52 PM
Template to calculate Compound Interest on Savings Graham Excel Discussion (Misc queries) 1 October 18th 06 01:26 PM
how do you calculate compound interest with multiple payments? Wahine15 Excel Worksheet Functions 8 October 6th 06 06:30 PM
how do I calculate the annual interest when I know the compound dawn2511 Excel Worksheet Functions 4 July 20th 05 06:42 PM
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 02:51 AM.

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"