And then applied this formula to other cells in the column. After that, in cell C5 (under the column “New Deposit”), we have used this formula, C5=$H$7.Add more periods under this column if necessary and apply the formulas from the above row. Initially, we have taken only 9 months or periods (under the Period column).For this, you have to follow the steps below.
We can use an Excel formula for calculating compound interest with regular deposits. Calculate Compound Interest with Regular Deposits Using Manual Formula Read More: How to Calculate Future Value When CAGR Is Known in Excel (2 Methods)Ģ.
The syntax FV(C6,C8,C9,C10,C11) returns the future value by compound calculation.
0 kommentar(er)
