6.2 C
London
Thursday, December 19, 2024
HomeSoftware TutorialsGoogle SheetsHow to Calculate Compound Interest in Google Sheets (3 Examples)

How to Calculate Compound Interest in Google Sheets (3 Examples)

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

We can use the following compound interest formula to find the ending value of some investment after a certain amount of time:

A = P(1 + r/n)nt

where:

  • A: Final Amount
  • P: Initial Principal
  • r: Annual Interest Rate
  • n: Number of compounding periods per year
  • t: Number of years

The following examples show how to use this formula in Google Sheets to calculate the ending value of investments in different scenarios.

Example 1: Compound Interest Formula with Annual Compounding

Suppose we invest $5,000 into an investment that compounds at 6% annually.

The following screenshot shows how to use the compound interest formula in Google Sheets to calculate the ending value of this investment after 10 years:

This investment will be worth $8,954.24 after 10 years.

The following screenshot shows how to calculate the ending investment after each year during the 10-year period.

Note that Column F shows the formula we used in each corresponding cell in Column E:

Compound interest formula in Google Sheets

Example 2: Compound Interest Formula with Monthly Compounding

Suppose we invest $1,000 into an investment that compounds at 6% annually and is compounded on a monthly basis (12 times per year).

The following screenshot shows how to use the compound interest formula in Google Sheets to calculate the ending value of this investment after 5 years:

This investment will be worth $1,348.85 after 5 years.

Example 3: Compound Interest Formula with Daily Compounding

Suppose we invest $5,000 into an investment that compounds at 8% annually and is compounded on a daily basis (365 times per year).

The following screenshot shows how to use the compound interest formula in Google Sheets to calculate the ending value of this investment after 15 years:

This investment will be worth $16,598.39 after 15 years.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Sum Across Multiple Sheets in Google Sheets
How to Combine Columns in Google Sheets
How to Compare Two Columns in Google Sheets

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories