Dividend Stock Analysis Using Microsoft Excel

Dividend Stock Analysis Using Microsoft Excel, available at $44.99, with 55 lectures, and has 2 subscribers.

You will learn about Analyze dividend yield, payout ratio, and dividend growth using Excel Develop skills in visualizing and interpreting dividend stock data using charts and graphs in Excel. Understand how to calculate key financial ratios for dividend stock evaluation in Excel. Understand the importance of dividend stock analysis in investment decision-making. Create custom Excel templates for dividend stock analysis. Strategies for building and analyzing diversified dividend stock portfolio using Excel. This course is ideal for individuals who are Retail income investors looking for ways to improve their investing knowledge It is particularly useful for Retail income investors looking for ways to improve their investing knowledge.

Enroll now: Dividend Stock Analysis Using Microsoft Excel

Summary

Title: Dividend Stock Analysis Using Microsoft Excel

Price: $44.99

Number of Lectures: 55

Number of Published Lectures: 55

Number of Curriculum Items: 55

Number of Published Curriculum Objects: 55

Original Price: $84.99

Quality Status: approved

Status: Live

What You Will Learn

Analyze dividend yield, payout ratio, and dividend growth using Excel
Develop skills in visualizing and interpreting dividend stock data using charts and graphs in Excel.
Understand how to calculate key financial ratios for dividend stock evaluation in Excel.
Understand the importance of dividend stock analysis in investment decision-making.
Create custom Excel templates for dividend stock analysis.
Strategies for building and analyzing diversified dividend stock portfolio using Excel.

Who Should Attend

Retail income investors looking for ways to improve their investing knowledge

Target Audiences

Retail income investors looking for ways to improve their investing knowledge

Unlock the power of Microsoft Excel to revolutionize your dividend stock analysis. This course dives deep into the intricacies of dividend stock analysis using Excel, covering a range of crucial topics including individual stock analysis, portfolio analysis, DRIPs (Dividend Reinvestment Plans), sector analysis, Dividend Discount Models (DDM), and Weighted Average Cost of Capital (WACC).

We spent years examining dividend stocks not knowing it would eventually lead us to being able share our knowledge and experience here. Through step-by-step tutorials and real-world examples, you’ll learn how to leverage Excel’s powerful features to analyze dividend stocks with precision and confidence. From evaluating the financial health of individual companies to optimizing your dividend portfolio for maximum returns, this course provides you with the tools and techniques to succeed in the dynamic world of dividend investing. Get a copy of all the worksheets we will be using so you can always have them by your side to guide you through your dividend investing journey.

This course is designed to empower you with practical insights and actionable strategies. Once you complete this course we are sure you will be able to examine dividend stocks confidently. Join us today and take your dividend stock analysis to the next level with Microsoft Excel!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Quick Message

Chapter 2: Dividend Stocks Overview

Lecture 1: Intro to section

Lecture 2: Types of Dividend Stocks

Lecture 3: Understanding Important Dates

Lecture 4: Benefits of Dividend Investing

Lecture 5: Dividend Metrics

Lecture 6: Dividend Terms

Lecture 7: Dividend Kings & More

Lecture 8: Tax Considerations

Lecture 9: Risks in Dividend Investing

Lecture 10: Plan for Rest of Course

Chapter 3: Individual Dividend Stock Analysis

Lecture 1: Finding data for anaylsis

Lecture 2: Calculating Current Yield

Lecture 3: Calculating Average Dividend Growth Rate

Lecture 4: Using Charts for Visualizing Growth Rate

Lecture 5: Dividend Coverage Ratio

Lecture 6: Dividend Payout Ratio

Lecture 7: Historical Returns

Lecture 8: Calculating CAGR

Lecture 9: Calculating Standard Deviations

Lecture 10: Relationship between Standard Deviation & Yield

Chapter 4: Portfolio Analysis

Lecture 1: Portfolio Overview

Lecture 2: Calculating Correlations Manually

Lecture 3: Using Excels Correlation Function

Lecture 4: Tracking Annual Income

Lecture 5: Finding Portfolio Weights

Lecture 6: Finding Weighted Dividend Yields

Lecture 7: Standard Deviations of the Portfolio

Lecture 8: Weighted Standard Deviations of the Portfolio

Lecture 9: Weighting & Visualizing Sector & Industry Diversification

Lecture 10: Calculating Total Returns

Lecture 11: Adding a Preferred Stock to the Portfolio

Lecture 12: Adding a Closed End Fund to the Portfolio

Lecture 13: Adding a ETF to the Portfolio

Chapter 5: DRIPs

Lecture 1: DRIPs Overview

Lecture 2: DRIPs Spreadsheet Overview

Lecture 3: Cost Basis Overview

Lecture 4: Automated DRIP Example

Lecture 5: Self DRIP Scenario 1

Lecture 6: Self DRIP Scenario 2

Chapter 6: Sector Analysis & Scoring Systems

Lecture 1: Sector Analysis Overview

Lecture 2: Filling in the Sector Analysis Sheet

Lecture 3: Scoring System Overview

Lecture 4: Setting up Scoring System

Lecture 5: Quick Note

Lecture 6: Solution to the Errors in the Scoring Sheet

Lecture 7: Evaluating the Scores

Chapter 7: Advanced Analysis

Lecture 1: Dividend Discount Model Overview

Lecture 2: Weighted Average Cost of Capital (WACC) Overview

Lecture 3: WACC Walkthrough

Lecture 4: Calculating WACC

Lecture 5: Calculating Dividend Discount Model

Lecture 6: Problems with WACC & DDM

Chapter 8: Outro

Lecture 1: Conclusion

Instructors

Vincent David Resendiz
Passionate Excel, Finance Analysis, and Python Enthusiast

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu