Personal Finance

Unlock the secrets of Financial Leverage and discover how borrowed money can amplify your returns—or increase your risks. In this video, Ryan O’Connell, CFA, FRM, explains when financial leverage works, provides a simple financial leverage example, and demonstrates the formula to calculate leveraged returns. Perfect for students and professionals, this guide highlights the power of leveraging and its impact on investment strategies. Watch now to deepen your understanding of financial leverage and how to use it effectively!

🎓 *Get 25% Off CFA Courses (Featuring My Videos!) — Use code RYAN25 here:*
👉 https://ryano.finance/cfa

Chapters:
0:00 – When Financial Leverage Works
0:26 – Simple Financial Leverage Example
2:50 – Formula to Calculate Leveraged Returns

*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.

Learn whether you should realize capital gains now and pay taxes or hold your investment and defer taxes in this step-by-step Excel analysis. This video covers key concepts like understanding capital gains tax brackets, calculating starting values, capital appreciation, and taxes paid for both scenarios. You’ll also see a comparison of the final values and how much additional return the earlier realization scenario would need to break even. Perfect for investors looking to optimize their tax strategy, this tutorial simplifies a complex financial dilemma with clear examples in Excel.

📈 *See Why I Recommend This Broker:* https://ryano.finance/ibkr-overview

💾 *Download Free Excel File Here:* https://ryanoconnellfinance.com/product/capital-gains-tax-investment-value-calculator/

Chapters:
0:00 – Introduction: The Capital Gains Dilemma
1:03 – Understanding Capital Gains Tax Brackets
2:03 – Forming Assumptions Regarding Expected Returns
2:49 – Calculating Starting Values for Each Scenario
3:57 – Calculating Capital Appreciation Over Time
5:41 – Calculating Taxes Paid at the End
7:01 – Comparing Final Values of Both Scenarios
7:40 – How Much Extra Return Is Needed to Break Even?
9:17 – Conclusion: Key Takeaways and Final Thoughts

*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.

In this video, Ryan O’Connell, CFA, FRM walks you through The Ultimate Excel Spreadsheet for Self-Employed Entrepreneurs and Small Businesses, designed to help you track profits and estimate taxes with ease. Learn how to accurately manage your revenue, business and personal expenses, and understand crucial tax calculations like self-employment tax and federal income tax. Ryan also covers how to estimate quarterly taxes, calculate your net worth, and plan for retirement, all tailored for small businesses and entrepreneurs in the United States. Whether you’re new to small business finances or a seasoned entrepreneur, this video simplifies tax planning and financial tracking. Download the Excel template and take control of your small business finances today!

💾 *Purchase the file created in this video here:*
https://ryanoconnellfinance.com/product/the-ultimate-excel-spreadsheet-for-self-employed-entrepreneurs/

📈 *See Why I Recommend This Broker:* https://ryano.finance/ibkr-overview

Chapters
0:00 – Financial Model Overview | Track Your Earnings & Taxes
6:29 – Revenue Tracking Explained | Accurate Income Calculations
10:38 – Business and Personal Expenses | Maximizing Tax Deductions
12:22 – Self-Employment Tax | How to Calculate
15:24 – Federal Income Tax Calculation Simplified
27:38 – State Taxes | Estimate With Online Tool
29:32 – Calculate Your Personal Budget & Post Tax Monthly Savings
33:17 – Personal Balance Sheet | Calculate Your Net Worth
35:53 – Retirement Age & Net Worth Calculator | Plan Your Future
43:22 – Quarterly Taxes | How to Estimate
45:19 – Errors and Omissions | Ongoing Updates

*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.

In this comprehensive video, Ryan O’Connell, CFA, FRM, delves into the intricate differences between Traditional and Roth IRAs, focusing on the pivotal decision of whether to rollover from a Traditional IRA to a Roth IRA. The video, titled “Traditional vs Roth IRA Rollover: Excel Analysis,” offers a detailed, Excel-based breakdown of each IRA type, making complex financial concepts accessible and understandable. Beginning with an introduction to the basics of Traditional and Roth IRAs, Ryan expertly guides viewers through an Excel model, demonstrating how to calculate potential tax implications, the impact of rollovers, and the long-term value of each IRA option. The video is an invaluable resource for anyone looking to make informed decisions about their retirement planning, particularly those considering a rollover.

💾 Purchase the file created in this video here: https://ryanoconnellfinance.com/product/traditional-vs-roth-ira-rollover-excel-model/

👨‍💼 My Freelance Financial Modeling Services:
► Custom financial modeling solutions tailored for your needs: https://ryanoconnellfinance.com/freelance-finance-services/

Chapters:
0:00 – Intro to Traditional Vs Roth IRA Rollover
2:15 – Declaring Inputs for IRA Excel Model
6:55 – Modeling a Traditional IRA in Excel
22:00 – Taxes on Traditional IRA
32:42 – Saving Excess Distributions in a Brokerage Account
37:17 – Inheritance for Traditional IRA
44:00 – Rollover Traditional IRA Into Roth IRA
48:14 – Taxes on Rollover Into Roth IRA
57:32 – Roth IRA Value Over Time
1:05:47 – Roth IRA Inheritance Value

*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

Looking to master your stock portfolio management in Excel? In this easy-to-follow guide, “LIVE Stock Portfolio Dashboard in Excel in 30 Minutes!”, we cover everything you need to know to set up a real-time stock portfolio tracker. From creating a transaction log and calculating returns to breaking down sector and market cap allocations with beautiful pie charts, this tutorial is your go-to resource for all things investing and Excel. Whether you’re a novice or seasoned investor, this video will equip you with the tools to calculate gains, losses, dividends, and more, all in a live, up-to-date Excel dashboard.

💾 *Purchase the file created in this video here:* https://ryanoconnellfinance.com/product/investors-toolkit-live-stock-tracker-in-excel/
📈 Need help with a project? https://ryanoconnellfinance.com/hire-me/

👉 CORRECTION: I made one mistake @15:03. C4 in the denominator (# of shares purchased), should actually be E4 (# of shares sold). You should also remove the double quotes ,””) at the end of the IF statement from that same formula.

👨‍💼 My Freelance Financial Modeling Services:
► Custom financial modeling solutions tailored for your needs: https://ryanoconnellfinance.com/freelance-finance-services/

*Seeking Alpha deals to help manage your portfolio:*
💰 *Get $50 OFF Alpha Picks:* https://ryano.finance/alpha-picks
📈 *Get $159 OFF Seeking Alpha Premium and Alpha Picks Bundle:* https://ryano.finance/seeking-alpha-bundle
🔥 *Get $30 OFF Seeking Alpha Premium:* https://ryano.finance/seeking-alpha

*Get 10% Off Snowball Analytics to help manage your portfolio with code RYAN here:*
https://snowball-analytics.com/register/ryan

Chapters:
0:00 – Overview of the Live Stock Dashboard in Excel
0:39 – Create a Transaction Log
2:47 – Begin Constructing Portfolio Dashboard
4:11 – Retrieve the Sector of Each Stock in the Portfolio
4:46 – Find the Market Cap Size of Each Company
6:22 – Calculate the Percentage Allocated to Each Share
8:22 – Retrieve the Beta of Each Stock
9:13 – Calculate Today’s Return on Each Share
10:31 – Calculate Average Purchase Price Per Share
14:22 – Calculate Average Sale Price Per Share
15:24 – Calculate Total Dividends Received
16:45 – Calculate Realized Gain or Loss on Each Stock
17:37 – Calculate Total Gain or Loss on Each Stock
18:30 – Calculate Unrealized Gain or Loss on Each Stock
19:52 – Calculate Total Portfolio Gains and Losses
22:45 – Conditionally Format Gains & Losses
23:44 – Create Market Cap Size Pie Chart
26:33 – Create Sector Allocation Pie Chart
27:29 – Create Individual Securities Holdings Pie Chart

*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

Ryan O’Connell, CFA, FRM presents “Dividend Discount Model: A Thorough Introduction”. First we walk through the dividend discount model on pen & pad, then we explore how to perform a DDM analysis in Excel to find out how to value dividend stocks.

🎓 *Get 25% Off CFA Courses (Featuring My Videos!) — Use code RYAN25 here:*
👉 https://ryano.finance/cfa

💾 *Download Free Excel File Here:* https://ryanoconnellfinance.com/product/dividend-discount-model-ddm-excel-template/

Chapters:
0:00 – Dividend Discount Model Definition
1:25 – Dividend Discount Model Formula
2:55 – DDM Example Calculation
3:49 – Download Stock Dividend Data from Yahoo Finance
4:22 – Calculate Dividend Growth Rate
5:08 – Calculate Stock Price Using Dividend Discount Model
6:26 – Is the Stock Overvalued or Undervalued?
7:01 – Calculating Required Return Using Excel Solver

*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

Ryan O’Connell, CFA, FRM shows how to build a stock dashboard in Google Sheets with live updating data using Google Finance.

💾 *Purchase the files created in this video here:* https://ryanoconnellfinance.com/product/google-sheets-stock-dashboard/

📈 *See Why I Recommend This Broker:* https://ryano.finance/ibkr-overview

Chapters:
0:00 – Introduction
0:10 – Create a New Google Sheet
1:11 – Setup Column Headers and Format Dashboard
2:12 – Manually Input Your Stock Portfolio Info
3:28 – Color Code Spreadsheet
4:13 – Calculate Company Market Capitalization
6:24 – Calculate the Amount Paid for the Portfolio
7:06 – Get Live Stock Prices In Google Sheets
8:07 – Calculate Allocation of Portfolio
8:43 – Calculate Stock Portfolio Returns
12:03 – Conditional Formatting Based On Gains & Losses
13:47 – Add Individual Stock Allocation Pie Chart
15:17 – Add Pie Charts Based on Market Cap & Sector
19:13 – Stock Portfolio Dashboard in Google Sheets Conclusion

*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

ALTERNATIVE TITLES
“Create a Custom Stock Tracker in Google Sheets”
“DIY Stock Dashboard: How to Build Your Own”
“Track Your Portfolio: A Step-by-Step Guide to a Google Sheets Stock Dashboard”
“Maximize Your Investments with a Google Sheets Stock Tracker”
“Building a Stock Dashboard in Google Sheets | Live Updating Data”
“Build a Stock Dashboard in Google Sheets: The Ultimate Guide”
“Effortlessly Monitor Stocks with this Google Sheets Dashboard Tutorial”
“Get a Bird’s Eye View of Your Investments with a Google Sheets Stock Dashboard”

Ryan O’Connell, CFA, FRM shows how to create a live updating stock portfolio tracker (dashboard) that DOES NOT require an Office 365 subscription or a Microsoft 365 subscription!

💾 *Purchase the files created in this video here:* https://ryanoconnellfinance.com/product/excel-stock-tracker/

📈 *See Why I Recommend This Broker:* https://ryano.finance/ibkr-overview

CHAPTERS:
0:00 – Introduction
0:21 – Create a new Google Sheet document
0:45 – Use the Google Finance function to retrieve stock prices
2:26 – Connect Microsoft Excel to Google Sheets
4:10 – Input stock portfolio information
5:30 – Calculate stock market capitalization size
7:30 – Format to distinguish between manual inputs and formulas
7:57 – Calculate amount paid and current portfolio value
9:48 – Calculate portfolio allocations
10:15 – Calculate gains and losses on portfolio
12:00 – Conditionally format gains and losses
12:59 – Format the stock portfolio dashboard (tracker)
13:40 – Create stock position allocation pie chart
15:10 – Create sector and market cap pie charts
20:07 – Conclusion

*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

Title: Create a Live Stock Portfolio Tracker in Excel | No Microsoft 365 Required

Alternative Titles:
Create a Stock Portfolio Tracker in Excel With Live Prices | No Microsoft 365 Required
Create a Stock Portfolio Dashboard in Excel With Live Prices | No Microsoft 365 Required
Pull Live Stock Prices Into Excel
Pull Live Stock Prices Into Excel Without Microsoft 365
Pull Live Stock Prices Into Excel Without Office 365

If You Invested $100 In Every S&P 500 Stock 20 Years Ago, This is What You’d Have Today.

🔑 Join this channel to get access to perks & support my work: https://www.youtube.com/channel/UCAkyj2N9kd0HtKhCrejsYWQ/join

This video shows the top 10 stocks in the S&P 500 index from 1/2/2003 to 12/13/2022. Data is based on the adjusted close price. Assumes each stock was purchased on 1/2/2003. Made by Ryan O’Connell, CFA, FRM.

Data Sources: Yahoo Finance, Kaggle
Music: Morning Song, Four Seasons: Winter, and William Tell Gallop

*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

Top 10 Stocks Over 20 Years | $100 Invested In Every Stock

If You Invested $100 In Every S&P 500 Stock 11 Years Ago, This is What You’d Have Today

This video shows the top 10 stocks in the S&P 500 index from 1/3/2012 to 12/13/2022. Data is based on the adjusted close price. Assumes each stock was purchased on 1/3/2012. Made by Ryan O’Connell, CFA, FRM.

*This video represents all stocks in the S&P 500 in December 2022 that were public companies at the start of 2012

🔑 Join this channel to get access to perks & support my work: https://www.youtube.com/channel/UCAkyj2N9kd0HtKhCrejsYWQ/join

Data Sources: Yahoo Finance, Kaggle
Music: Morning Song, Four Seasons: Winter, and William Tell Gallop

*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

Top 10 Stocks Over 11 Years | $100 Invested In Every Stock