icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 0 / 100

icon
Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a excel course? Or looking for more detail on Michael McDonald's Excel for Investment Professionals? Feel free to chat below.
Join CourseDuck's Online Learning Discord Community

icon
Course Description

Do you manage a portfolio of stocks or securities? Microsoft Excel offers professionals in the investment industry with a bevy of tools that they can use to make sound investments. In this course, learn how to leverage these tools and perform key investment-related activities in Excel, including investment evaluation and analysis on a stock or portfolio. Professor Michael McDonald provides an overview of the major tasks in the investment industry, and then digs into how to do single stock investment analysis. He also goes over how to compute expected returns on a stock and a portfolio, value a bond in Excel, compute performance evaluation metrics, and more.Topics include:Determine the variable required to compute the P/E ratio of a stock.Identify two factors that drive expected returns on a stock.Apply the appropriate formula to determine portfolio returns.Recall the type of mean that should be used to determine future returns based on buying an investment and holding it for an extended period of time.Define the formula for information ratios.Recognize the measure that describes worst case expected loss under normal circumstances.

icon
Instructor Details

Michael McDonald is a researcher and professor of finance at Fairfield University.He has extensive programming skills in SAS, Stata, Python, R, and SQL, among other programming languages. His past work experience includes using these programming languages to analyze big data sets in finance and economics and develop trading strategies based on data mining. He has done extensive work in investment banking, at tech startups, hedge funds, and on a wide variety of consulting projects. He has a track record of authoring creative and practical course materials for a variety of subject areas across business disciplines.

icon
Reviews

0.0

0 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete