How to Track Passive Income Using a Spreadsheet

TL;DR

To track passive income effectively, create a spreadsheet to log your investments, dividends, and market values. For instance, use the provided spreadsheet template to input stock purchases, such as Leggett and Platt, detailing share amounts and prices. This structured approach allows you to visualize progress and maintain control over your financial growth.

Transcript

hey what's up guys andre jake here and in today's video we're gonna learn how to track our passive income with a spreadsheet so we can be the HBIC the head boss in charge without coming down alright guys so we track everything we track how many miles we were on how many calories we need how many likes we get in each video but for some reason we nev... Read More

Key Insights

• 👣 Passive income tracking is neglected by many individuals who diligently track other aspects of their lives.
• 🧍 Leggett and Platt is a reliable company for investing in dividend income due to its long-standing reputation and consistent dividend growth.
• 👤 The provided spreadsheet template simplifies the process of tracking passive income, helping users visualize their progress over time.
• 🤩 Diversifying investments and considering factors such as payout ratio and dividend growth are key to building a stable passive income stream.
• 🤯 Tracking and managing passive income can contribute to a sense of control and peace of mind, particularly in volatile market conditions.
• 🥅 The video emphasizes that while it may not be advisable to copy someone else's portfolio entirely, learning from their strategies and adjusting them according to personal circumstances and goals can be beneficial.
• 🌱 Having a clear understanding of past and projected passive income can help individuals plan for future financial needs and make informed decisions.

Questions & Answers

Q: Why is it important to track and manage passive income?

Tracking and managing passive income allows you to have a clear understanding of your finances, ensure that the money is being utilized effectively, and track your progress towards financial goals.

Q: What is the significance of the Leggett and Platt stock mentioned in the video?

Leggett and Platt is a stable company that has been around since 1883, primarily manufacturing parts for houses and cars. It is considered a safe investment due to its consistent dividend growth for 47 consecutive years.

Q: Does the video provide suggestions on how to create a personalized spreadsheet?

Yes, the video offers a spreadsheet template that viewers can access on the creator's Patreon page. The template includes sections for company names, shares owned, buy price, market price, cost basis, market value, gain/loss, annual dividend, dividend yield, yield on cost, and annual income.

Q: How does tracking and managing passive income contribute to financial freedom?

By actively monitoring and tracking your passive income, you can make informed decisions on how to reinvest the earnings and rely less on a traditional job. This can help you achieve financial freedom and live life on your own terms.

Summary & Key Takeaways

• The video teaches viewers how to track their passive income using a spreadsheet, emphasizing the importance of keeping tabs on where their money goes.

• The content focuses on tracking dividend income, specifically using the Robinhood app and WeBull.

• The video showcases a spreadsheet template that the creator has been using for years, and explains the process of buying a stock and keeping track of progress.