ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula to calculate compound interest on increasing principal (https://www.excelbanter.com/excel-discussion-misc-queries/263993-formula-calculate-compound-interest-increasing-principal.html)

Moreden

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

Bernie Deitrick

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





All times are GMT +1. The time now is 10:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com