How to Calculate Compound Interest in Google Sheets

[@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: kzbin.info/www/bejne/fnO0opKNm6lpbKM

[@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.