The discussion revolves around the formulation of compounding interest calculations for varying annual deposits and interest rates. Participants explore different scenarios involving initial deposits, annual contributions, and the application of these formulas in Excel.
Participants appear to share similar views on the approach to setting up the compounding interest calculations in Excel, but there are variations in the specific scenarios being discussed. No consensus is reached on a single formula applicable to all proposed situations.
Limitations include the lack of clarity on the specific interest rates and the exact formulas being proposed, as well as the dependence on the definitions of compounding and deposit frequency.
Individuals interested in personal finance, investment strategies, or those looking to understand compounding interest calculations in practical applications, particularly using Excel.
Eph said:I think I found a simple formula if I was putting in the same amount of money each year, but what if I wanted to start with 1000$, add 10k$ for 10 years, and then watch it compound at X interest; how would i set that up?
Eph said:What about if you want to just put in a deposit of say 10k per annum for 10 years but have it still compound at the same yearly rate?