How to Calculate Compound Interest in Google Sheets

In this video, I show how to calculate compound interest in Google Sheets. I show a couple different ways to do this: using the compound interest formula to do the calculation or using the FV function for the calculation.
Read through the full tutorial here:
www.modernschoolbus.com/calcu...
Timestamps:
00:00 Intro
1:38 Compound Interest Formula
2:10 Calculating Compound Interest with a Formula
3:44 Using the FV Function to Calculate Compound Interest

[@queenkai9522]

Very informative. Thank you. How would you add additional monthly or annual contributions?

[@Crayola-sb8ov]

Is it the same thing with continuous compound interest ?

[@devoutmordexfollower5289]

Quick question tho, how do you implement monthly deposits into the regular compound interest equation?

[@ModernSchoolBus]

For that you can use the FV function, though this assumes each monthly deposit is the same amount: ruclips.net/video/HBQq_WfD66A/видео.html

[@tomnewman2999]

if you compound every six months would you put 0.5?

[@ModernSchoolBus]

If you compound every 6 months, then there are 2 compounding periods each year, so you would put 2.