Тёмный

The 4% Retirement Rule Using Microsoft Excel 

Chris Menard
Подписаться 72 тыс.
Просмотров 1,9 тыс.
50% 1

In this video, I use Microsoft Excel to explore the 4% retirement or withdrawal rule, a method suggested by Bill Bengen in 1994. I delve into the background of the rule, its assumptions, and implications and further demonstrate how to manipulate numbers according to various scenarios.
I consider variables such as stock market performance, spending habits, and inflation. I also address adjustments to the 4% rule recently suggested by Bengen himself.
Download the file used in this video here:
chrismenardtraining.com/Files...
The Long View Podcast Episode with Bill Bengen:
• The Long View: Bill Be...
Chapters:
00:00 Introduction
00:28 The Origin of the 4% Rule
01:17 Breaking Down the 4% Rule with Excel
02:08 Observations and Assumptions in the 4% Rule
03:34 Mathematical Illustration of the 4% Rule
04:33 Tweaking the Numbers in the 4% Rule
05:34 Impact of Market Fluctuations on the 4% Rule
06:15 Conclusion and Additional Resources
Check out my Excel Courses here:
courses.chrismenardtraining.com
Blog Post on the 4% rule
chrismenardtraining.com/post/...
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ RU-vid keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
#excel #4percentrule #chrismenard

Хобби

Опубликовано:

 

3 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 5   
@willlsmith8063
@willlsmith8063 10 дней назад
That spreadsheet is different class!.....thanks much appreciated......now subscribed.........all the best from Scotland
@ChrisMenardTraining
@ChrisMenardTraining 7 дней назад
Welcome aboard!
@m444ss
@m444ss 4 месяца назад
Just a datapoint: I put the gains & inflation (S&P 500 total return by year, CPI-U by year) for 1994-2023 into the spreadsheet. Using actuals still results in a positive balance after 30 years, but $226,074 less than in the model (as downloaded, no edits to inputs).
@melojansan
@melojansan 4 месяца назад
Great worksheet. Thank you.
@ChrisMenardTraining
@ChrisMenardTraining 4 месяца назад
Welcome 😊
Далее
Your Ultimate Financial Plan in 10 minutes
12:41
Просмотров 149 тыс.
КТО ЭТО БЫЛ?
25:31
Просмотров 427 тыс.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
How to SORT Data in Excel | 7 Tips
16:51
Просмотров 78 тыс.
Are You Making This Excel Mistake? Fix It in Minutes!
10:18
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
You Won't Believe These Crazy PIVOT TABLE Hacks!
11:30
Просмотров 672 тыс.
10 Awesome Time Saving Hacks in Excel
13:35
Просмотров 41 тыс.
#shoot
1:00
Просмотров 5 млн
Самая старая пивная в Праге
0:11