Poradnik Excela

How to Calculate Compound Interest in Excel

Calculating compound interest is essential for financial planning. Excel's FV (Future Value) function makes this process quick and accurate.

Krok po kroku

1
Set up your data
Enter your principal amount, annual interest rate, and number of years into separate cells (e.g., A1, A2, and A3).
2
Select the target cell
Click on the cell where you want the final result to appear.
3
Enter the FV formula
Type '=FV(rate, nper, pmt, [pv])' using your cell references, ensuring the principal is entered as a negative value.

=FV(rate, nper, pmt, pv)

Always enter the present value (pv) as a negative number to ensure the result is returned as a positive value.

Why is my result negative?

Excel treats money flowing out as negative and money flowing in as positive; ensure your initial investment is entered as a negative number.