Welcome! This post is meant to accompany Chapter 4 “On Compound Interest” and the Appendix to Chapter 4, in my book The Financial Rules For New College Graduates: Invest Before Paying Off Debt and Other Tips Your Professors Didn’t Teach You (ABC-CLIO Praeger, 2018.)1
I highly recommend you open up a spreadsheet alongside this material.
For starters, we want to know how to set up a spreadsheet to calculate Future Value, if we already know Present Value, Yield, and Time.
This first video below can get you started on that journey.
COMPOUNDING MULTIPLE AMOUNTS OR WITH MULTIPLE YIELD ASSUMPTIONS
The next video adds a level of complexity. Let’s say we want to see multiple years’ worth of compounding returns. For example, we might want to contribute to a retirement account multiple years in a row, and see the results of that activity over time. Spreadsheets are ideally suited for this type of setup, as the next video shows:
The third compound interest video introduces the idea that in the real world, money can compound more frequently than annually. Bonds often compound semi-annually. Stock returns often compound quarterly (because dividends are paid quarterly.) Monthly-pay debts we owe to our mortgage company, credit card company, or auto-loan company compound 12 times a year. We need to add an additional step for compounding more frequently than once a year.
Please see related posts on Discounting Cashflows and Compound Interest:
And please see my earlier writing about compound interest and discounting cashflows.
Post read (253) times.
- Hey! Order it here: https://www.amazon.com/gp/product/1440861056?ie=UTF8&tag=bankeanony-20&camp=1789&linkCode=xm2&creativeASIN=1440861056 ↩