Search
Generic filters

Compound Interest Calculator Excel Template

Compound Interest refers to earning or paying multiple interest on interest. Although it can apply to both savings and loans, it is easiest to understand when you are thinking about savings. After each compound period, the interest earned over the period is added to the principal so the next calculation of interest includes the original principal plus the previously earned interest.

This page includes a basic compound interest calculator that you can use for simple future value problems. You can download the compound interest calculator spreadsheet to understand how compounding works from month to month.

Compound Interest

This spreadsheet is designed as an educational tool – to help you show how compound interest works for both savings and loans. The table is based on the payment frequency and shows the amount of interest adds in each period. The graph compares the total principal and payments to the balance over time.

Compound Interest Formula

Basic Compound Interest Formula

The basic compound interest formula for calculating a future value is F = P*(1+rate)^nper where

  • F = future accumulated value
  • P = principal (starting) amount
  • rate  interest rate per compounding period
  • nper =total number of compounding periods

Formula for Compounding Yearly, Monthly, Weekly

Compound Interest Formula for Annual Rate

  • P = the principal amount
  • r = the nominal annual interest rate in decimal form.
  • n = the number of compound periods per year
  • t = the time in years

Compound Interest formula Calculator

This is the basic formula where rate = r/n and nper = n*t. Although the math can handle a decimal value for nper, it should usually be a whole number. Traditional amortize loans use the same formulas as define for savings, except that the loan amount represents as a negative value for the starting principal, P. Payment amounts (A) are the positive values. In Excel we can use the FV function again. The formulas show how the FV function relates to the standard formula. Note that for now we aren’t including a principal amount.

Download Compound Interest Calculator Excel Template
Share on facebook
Share on linkedin
Share on email
Share on whatsapp

Download Guide

Compatible with : Microsoft Office Excel, Libra Office, WPS Office, Google WorkSheet
  • Download The Template XLSX File Format
  • Use the Template

Download Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Recently Uploaded Excel Templates: