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

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.

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 Convert Time to Hours and Minutes.
An hour is a period of time equal to a …

How to Convert Time to Hours and Minutes.

How to Calculate Payroll Taxes.
Payroll taxes are taxes that employees and employers must pay …

How to Calculate Payroll Taxes.

Leave a Reply Cancel Reply

Popular Posts

  • 5 Best AI Apps for Solving Complex …
    March 22, 2023 0

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 © 2023 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