How Long Will Your Retirement Savings Last? (Excel Simulation)

📅 Published: August 15, 2025 📁 Financial Modeling, Personal Finance, Portfolio Management 🎥 YouTube Video

Wondering how long your retirement savings will last? In this video, we build a powerful Excel Monte Carlo simulation to forecast portfolio longevity and simulate annual returns across asset classes. You’ll learn how to input your personal data, project portfolio value over time, and calculate the average age your money runs out. Perfect for anyone doing retirement planning in Excel or testing different withdrawal strategies.

💾 *Download Free Excel File Here*: https://ryanoconnellfinance.com/product/retirement-savings-calculator/

*Need Ryan’s Help With Your Retirement Planning?*
Find my high net worth consulting service here: https://ryanoconnellfinance.com/financial-strategy/

Chapters:
0:00 – Intro: When Will Your Money Run Out in Retirement?
0:29 – Input Your Personal Details
2:36 – Calculate Future Age and Year
4:03 – Simulate Annual Returns by Asset Class
6:05 – Calculate Portfolio Value Year by Year
8:10 – Analyze Portfolio Value Over Your Lifetime
9:07 – Run a Monte Carlo Simulation on Your Portfolio
11:39 – Calculate the Average Age Your Money Runs Out
12:16 – Adjust Inputs and Re-Run the Simulation

*Disclosure: This is not financial advice and should not be taken as such. The information contained in this video is an opinion. Some of the information could be wrong. This channel is owned and operated by Portfolio Constructs LLC. Some of the links above are affiliate links, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase.

Explore Top Finance Certificates

Access official certificates from Wharton Online & Columbia Business School Executive Education, powered by Wall Street Prep. Save up to $500 with code RYAN.

Contact Me

Feel free to reach out to discuss your freelance project needs, and let’s collaborate on bringing your vision to life!

Contact Me

Have a question or want to work together? Fill out the form below and we’ll get back to you as soon as possible.

Contact Form Demo

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.