Compound interest is defined as "the interest on savings calculated on both the initial principal and the accumulated interest from previous periods." Classically, known as "interest on interest", this is the most common type of interest used in everyday finance situations.
To calculate compound interest in Excel,
on principal amount P
at the rate of interest R
for the number of years N
and compounded T times per year
we can use the formula = P*(1+R/T)^(N*T)
In this video, understand how to calculate various kinds of compound interest values using Excel formulas.
⏱ Video Topics:
==============
0:00 Compound Interest Calculations in Excel
0:40 Compound Interest Formula
1:50 Using the FV function to calculate compounded value
2:22 Pop Quiz ⁉
2:40 Compounding every quarter (or other durations)
4:52 Understanding compounding effect (simple vs. compound interest over time)
6:34 Effect of interest rates on the compounded value
7:57 Compounding with regular payments (monthly for example)
10:26 Reverse of compounding (using goal seek)
Sample Workbook:
==================
Download the sample file and learn more about compound interest in Excel using this page
https://chandoo.org/wp/compoundinter...
Finance Concepts: Videos
========================
Want to learn financial concepts and how to do the calculations with Excel or power bi? Watch below videos:
Top 10 Finance Formulas in Excel • If you work in finance, here are the ...
Payroll workbook & calculations • How to make payroll & pay slip calcul...
Waterfall Charts (one of the most important finance charts) • How to make an AWESOME Waterfall Char...
Variance Analysis with Excel • Make a BEAUTIFUL Budget vs. Actual ch...
Mortgage with Extra Payment Scenario Excel Calculator • How to calculate Mortage with Extra P...
Stock Portfolio Tracker with Excel • I made a LIVE portfolio tracker in Ex...
~
#finance #excel