Retirement Planning and Investment Strategies

The video tutorial explains how to use Excel to calculate future values of retirement savings plans, specifically focusing on a 401k and a 403b. It covers the calculation of future values over 20 and 40 years for Richard's 401k, highlighting the impact of compounding interest. The tutorial also explores Maria's 403b plan, including employer matching and tax savings, and calculates her total investment and returns over 30 years.

What is the monthly contribution Richard makes to his 401k plan?

• $250

• $200

• $300

• $350

How many years is Richard planning to invest in his 401k?

• 10 years

• 15 years

• 20 years

• 25 years

What Excel function is used to calculate the future value of Richard's 401k?

• IRR

• NPV

• FV

• PV

What is the annual interest rate for Richard's 401k plan?

• 3.5%

• 2.5%

• 4.0%

• 3.0%

How much will Richard have in his 401k after 20 years?

• $106,000

• $96,000

• $86,717.32

• $76,000

What is the future value of Richard's 401k after 40 years?

• $200,000

• $261,166.72

• $300,000

• $350,000

How does the 40-year balance compare to the 20-year balance?

• Triple

• More than double

• Exactly double

• Less than double

What percentage of the 40-year balance is the 20-year balance?

• 33%

• 50%

• 25%

• 66%

What is the main reason for the significant growth in Richard's 401k over time?

• Lower taxes

• Higher contributions

• Employer match

• Compounding interest

What is the significance of the 33% calculation in Richard's plan?

• It shows the tax rate

• It indicates the employer match

• It represents the growth factor

• It compares the 20-year and 40-year balances