How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
rate
How to Calculate Compound Interest in Excel.
rate

How to Calculate Compound Interest in Excel.

Rosemary Njeri

Prior to discussing how to calculate compound interest in excel, lets define it. Compound interest is as a result of reinvesting interest, rather than paying it out, so that interest in the next period is then earned on the principal sum plus previously accumulated interest.

Simply, compound interest is interest you earn on interest.

Formula to Calculate Compound Interest in Excel.

To calculate compound interest, we can use the FV function which can be found in excel.

Example:

Suppose $1000 was invested for 10 years at an annual interest rate of 5%, compounded semi-annually. Calculate your compound interest.

First, we begin by transferring the data to an excel spreadsheet.

Compound Interest in Excel.

Then insert the FV function and something like this should appear.

To get the rate, we use the annual rate / periods, B2/B4.

To get the number of periods we use term * periods, B3*B4.

There is no periodic payment, so we use zero.

By convention, the present value (pv) is input as a negative value, since the $1000 “leaves your wallet” and goes to the bank during the term.

Compound Interest in Excel.

Fill in the table as directed by excel, click OK and you should have your answer.

Compound Interest in Excel.

Therefore, your compound interest is $1,280.08.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How to Calculate Average Collection Period.
What is Average Collection Period? In order to calculate average …

How to Calculate Average Collection Period.

How to Calculate AC for a Room.
When we speak of size in reference to air conditions, …

How to Calculate AC for a Room.

Popular Posts

    Categories

    learntocalculate.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

    How To Calculate

    Learn how to calculate anything

    Pages

    • About Us
    • Contact Us
    • Privacy Policy
    Copyright © 2025 How To Calculate

    Ad Blocker Detected

    Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

    Refresh