Security Analysis and Portfolio Management using Excel
- 2.9
-
![]()
![]()
![]()
Brief Introduction
Master the art of analyzing equity stocks and creating efficient portfolios of stocksDescription
Worldwide stock markets and their members create thousands of challenging employment opportunities to finance graduates. Securities dealers, investment advisors, Stock broking companies, research agencies, consulting companies are few to mention. They recruit candidates in the roles of Investment Advisor, Equity Analyst, Equity Advisor, Stock Analyst, Valuation Analyst, Portfolio Analyst etc. This course lays strong foundation to pursue these careers.
This is a 4hr 8min course with 45 lectures. This course is a step by step approach to master the art of investing and investment returns. Your learning starts with basic concepts of investments and ends with advanced understanding of security analysis and portfolio management. Lectures are supplemented with quizzes, practice tests, and assignments.
Requirements
- Requirements
- Interest in equity stocks investment, basic knowledge of stock markets, accounting, and finance
- Access to computer or laptop to practice using Excel
Knowledge
- Learn about equity stock's dollar return, capital gain, dividend yield, and total return
- Learn how to calculate equity stock's return in Excel
- Learn difference between ex-ante and ex-post return and how to calculate those manually and using Excel
- Learn the components of risk and how to calculate diversifiable risk and non-diversifiable risk
- Learn what is margin trading and when you receive margin call in long position and short sale
- Learn how to calculate covariance, correlation between financial assets both manually and using Excel
- Learn how to construct two security portfolio
- Learn calculation of portfolio return, variance, and risk
- Learn estimation of required rate of return using CAPM
- Learn estimation of portfolio beta, alpha, and security market line
- Learn how to source data from stock exchanges and process it
- Learn application of Pivot Table
- Excel Data Analysis toolpak
Rama Krishna Yelamanchili
2.9 Raiting
[2021] Data Science: A-Z Bootcamp + Real Cases (Version 8.1)
- 4.4
-
![]()
![]()
![]()
![]()
![]()
A-Z Data Science Training: Advanced Statistics & Machine Learning with R, Excel + Tableau, Power BI from Best Seller Do you want a rewarding career?...
The Complete Financial Analyst Training & Investing Course
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Succeed as a Financial Analyst &Investor by Award Winning MBA Prof who worked @Goldman, in Hedge Funds & Venture Capital ...
MS Office 2013: 10-in-1 Courses To Maximize Productivity
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Comprehensive, all-in-one training to get the most out of Microsoft Office 2013. 10-in-1 courses with 80 hours of video. Unlock the Power Of Microsoft Office and Watch Your Productivity Soar!...
Investments I: Fundamentals of Performance Evaluation
- 4.7
-
![]()
![]()
![]()
![]()
![]()
In this course, we will discuss fundamental principles of trading off risk and return, portfolio optimization, and security pricing. The course emphasizes real-world examples and applications in Excel throughout....
