SS - Investing Money Annuities
What is an Annuity?
An annuity is an investment that requires the investor to invest the a given amount at the beginning of each year (time period) for a specific number of years (time periods). Interest is paid at the end of each year (time period) and remain part of the investment.
Annuity Example
$1,000 is invested each year for 4 years and an interest rate of 4% is paid annually.
Exercise: The power of Time
Create a spreadsheet file to contain each of these Scenarios on different sheets.
The shaded cells are formulas.
Scenario #1: Invest Now
assume you are 15 years old and decide to invest $1,000 at 4% for each of the next 15 years.
After 15 years you stop investing money, but just let the investment grow until you are 65.
Scenario #2: Invest Later
assume you are 35 years old and decide to invest $1,000 at 4% until you are 65.
How did that Happen?
Which scenario has a higher value at age 65? By how much?
How much would need to invest each year in the other scenario to have the same value at age 65?
Scenario #3: Invest Always
assume you are 15 years old and decide to invest $1,000 at 4% until you are 65.
Think about how to create this sheet with re-doing everything!
How much would need to be invested each year in the other two scenario to have the same value at age 65?
For each scenario, how much would need to be invested each year to have $1 000 000 at age 65?
how does the interest rate affect the ending value? increase the interest rate by 2%, what happens?
Scenario #4:Â TFSA
The TFSA (Tax Free Savings Account) can be opened when you are 18
a maximum of $5,500 can be invested each year
how much could you have saved if you start at 18? 25? 35?
assume your return on investment is 6%