
Udemy course Security Analysis and Portfolio Management using Excel by Rama Krishna Yelamanchili
Security Analysis and Portfolio Management using Excel is the best Udemy course on the market. With this offer they will be able to greatly improve their knowledge and become more competitive within the Finance & Accounting category. Therefore, if you are looking to improve your Finance & Accounting skills we recommend that you download Security Analysis and Portfolio Management using Excel udemy course.
Here you can see Udemy courses linked to: Finance & Accounting.
Course data:
- Author: Rama Krishna Yelamanchili
- Course rating: 3.5
- Category: Finance & Accounting
- Modality: Online
- Status: Available
- Idiom: English
Abouth Rama Krishna Yelamanchili
Currently I am working as Professor of Finance at ICFAI Business School, Hyderabad (IBS-Hyderabad). IBS-Hyderabad one of the India’s leading business school and accredited by AACSB, a constituent of IFHE University a NAAC A+ Grade Private University located in Hyderabad, Telangana, India. I teach courses like Security Analysis and Portfolio Management, Investments, Financial Management, Corporate Finance, Accounting, and Financial Statement Analysis.

What the udemy Security Analysis and Portfolio Management using Excel course teaches?
What you’ll learn 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 Show more Show less
Master the art of analyzing equity stocks and creating efficient portfolios of stocks
More information about the course Security Analysis and Portfolio Management using Excel
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.