Investment Analysis & Portfolio Management - Core Finance

Financial Analysis Done Right - Rigorously Analyse Investments & Manage Portfolios using Excel® & Google Sheets

4.45 (3393 reviews)
Udemy
platform
English
language
Financial Modeling & Ana
category
Investment Analysis & Portfolio Management - Core Finance
19,337
students
8 hours
content
Mar 2024
last update
$109.99
regular price

What you will learn

Calculate stock returns manually as well as on Excel and Google Sheets, using real world data obtained from free sources.

Estimate the Expected Returns of Stocks using the Mean Method, State Contingent Weighted Probabilities, as well as Asset Pricing Models.

Calculate the total risk, market risk, and firm specific risk of stocks from scratch, and explore how the different risks interact.

Understand why the math works, and why equations work the way they do - even if your math is weak and if math freaks you out.

Witness the power of diversification and how the risk of your portfolio can be lower than the individual assets that make up the portfolio!

Measure your investment portfolio's performance by calculating portfolio returns and risks.

Optimise your investment portfolios by maximising your returns while minimising your risk.

Decompose Diversification so you understand why it actually works (hint: it's the mathematical "magic" of Rho)

Why take this course?

Say hello to Financial Analysis done right. You'll master sophisticated investment analysis and portfolio management techniques that are rigorously grounded in academic and practitioner literature.

Explore and master powerful relationships between stock prices, returns, and risk. Quantify and measure your investment risk, from scratch.

Discover what your financial advisor should be doing to manage your portfolio - to manage your investments.

Do all of this, and a whole lot more... manually, as well as on Excel® and Google Sheets, working with real world data.

There’s no prior knowledge required. We’ll start you from the very basics, and build you to a financial analysis PRO thanks to:

6 SECTIONS TO MASTERY (plus, all future updates included).

Introduction: Understanding Investment Security Relationships & Estimating Returns

  • Understanding powerful relationships between risk, return, and price.

  • Intuitively explore the baseline fundamental law of Financial Analysis - The Law of One Price.

  • Calculating stock returns for dividend and non-dividend paying stocks, manually.

  • Downloading and working with real world data, and estimating stock returns on Excel® / Google Sheets.

Estimating Expected Returns

  • Estimating expected returns using the average (mean) method.

  • Estimating expected returns using 'state contingent weighted probabilities'.

  • Estimating expected returns using Asset Pricing Models including the Capital Asset Pricing Model (CAPM).

  • You'll learn each approach theoretically AND practically, ensuring you fully understand why the formulas work the way they do, and that you're able to download relevant data and conduct the initial financial analysis by computing expected returns for any stock you want.

Understanding and Measuring Risk and Relationships

  • Estimating the total risk of a stock.

  • Estimating the market risk of a stock.

  • As a by-product of learning to measure the market risk, you'll also learn how to quantity the relationships between securities - something that will be a focal theme of portfolio management and investment / financial analysis.

  • As with the expected returns, you'll learn to measure risk manually as well as on Excel® / Google Sheets. Thanks to a solid understanding of why the equations work the way they do, you'll see how Google Sheets can get things wrong, and what you can do to make sure you conduct financial analysis without incorrect / inaccurate estimates.

Measuring Portfolio Risk and Return

  • Estimating the return of a 2 asset and multi-asset portfolio.

  • Measuring the risk of a 2 asset and multi-asset portfolio.

  • Discover the 3 factors that influence / impact portfolio risk - 1 of which is more important than the other two combined!

Exploring Diversification & Optimisation

  • Risk reduction by diversification.

  • Exploring Optimal Diversification - Number of Securities to Hold

  • Optimising portfolio weights to achieve a target expected return.

  • Minimising your portfolio risk (mathematically) using robust financial analysis techniques.

Decomposing Diversification

  • Investigate and explore why, fundamentally, diversification works for financial analysis / investment analysis.

  • Rethink the way you measure the relationships between securities for financial analysis by extending the current measure.

  • Explore precisely how and why the most important factor of risk influences / impacts portfolio risk.

DESIGNED FOR DISTINCTION

We've used the same tried and tested, proven to work teaching techniques that've helped our clients ace their exams and become chartered certified accountants, get hired by the most renowned investment banks in the world, and indeed, manage their own portfolios. Here's how we'll help you master financial analysis and turn you into an Investment Analysis & Portfolio Management PRO:

A Solid Foundation

You’ll gain a solid foundation of the core fundamentals that drive the entire investment analysis and portfolio management process. These fundamentals are the essence of financial analysis done right.

Example Walkthroughs

Every major concept is taught with example question walkthroughs, so you can literally see how we analyse investments and conduct rigorous financial analysis, one step at a time.

Loads of Practice Questions

Apply what you learn immediately with 150+ practice questions, all with impeccably detailed solutions.

Cheat Sheets & Resources

Mathematical proofs, one page cheat sheets, workable Excel® & Google Sheet spreadsheets – all included.


Say goodbye to information overload.

Engage with carefully thought out, clutter-free, and engaging study materials that focus on the 20% finance fundamentals that drive 80% of the results.

Easily follow through complex financial analysis concepts with great visuals that don’t overdo it.

Explore byte-sized lectures that don’t cut corners – so you receive the right amount of information which will hold you in good stead wherever you go, whatever you move on to do.


Watch your confidence grow.

Apply what you learn immediately in example question walkthroughs and progressively challenging quizzes with impeccably detailed solutions.

Engage with over 150 questions ranging from simple true and false ones to more complex problems that take you outside your comfort zone.

Questions are relevant for Ivy League / Russell Group University students studying any core Finance / Financial Analysis course, as well as professionals studying for the ICAEW CFAB, ACA, ACCA, and CFA qualifications.

All questions designed in-house, by Russell Group Distinction Tutors.


Finally understand why  the math works.

Learn why we divide some variables by something, and multiply other variables by something else. Get past the painful approach of memorising countless equations. Not only will we rip apart each equation one variable at a time, we’ll also give you mathematical proofs that show the equation’s logic one step at a time. Save yourself time and effort by understanding why the equation works the way it does. Then go out and create your own equations, and redefine the way you conduct your own financial analysis.


Rigorously Analyse Investments & Manage Portfolios using Excel® & Google Sheets.

Enroll now and conduct your own financial analysis in a robust manner, from scratch.

Our review

---- ### **Course Overview** The Global course rating stands at an impressive **4.45**, with all recent reviews painting a picture of a highly effective and engaging educational experience. The course covers the fundamental concepts of finance, specifically focusing on Markowitz Portfolio Theory, and is well-received by beginners as well as more seasoned professionals in the financial industry. ### **Pros** - **Detailed Lectures**: Students appreciate the comprehensive nature of the lectures, which are both rigorous and easy to follow. - **Practical Application**: The course is designed not only to teach but also to allow students to apply what they learn through practical exercises and quizzes after each subunit. - **Effective Learning Tools**: The system of quizzes post-subunit completion is highly effective, making the learning process worthwhile and enhancing retention. - **Simplicity in Teaching**: The teaching methodology is praised for its simplicity, making complex financial concepts understandable and enjoyable. - **Real-World Application**: The course content is practical and can be applied directly to real-world investment analysis and portfolio management. - **Engaging Content**: The course material is engaging and keeps learners interested throughout the course. - **Comprehensive Coverage**: It covers a wide array of basic concepts well, making it a good refresher for experienced individuals or a solid starting point for those new to finance. - **Rigorous yet Accessible**: The course is challenging enough to be rigorous but still accessible to beginners. - **Clear Explanations**: The examples given are clear and well-explained, which helps in grasping the concepts more easily. - **Strong Recommendation for Financial Professionals**: It's recommended by investment professionals as a valuable resource for their career. - **Ease of Understanding**: The explanations are praised for demystifying complex ideas. ### **Cons** - **Limited Excel Versus Python Utility**: There are mixed sentiments about the necessity of using Excel or Python, with some students wishing for deeper mathematical insights and others questioning the need to use Excel over Google Sheets. - **Math Depth**: Some users felt that certain mathematical aspects were not delved into deeply enough, which could make understanding more challenging. - **Practical Sum Clarification**: A couple of reviews mentioned a preference for more explicit instructions on calculations rather than just examples. - **Cost Consideration**: One student pointed out the additional cost of purchasing Excel alongside the course. - **Desire for More Practical Sheet Instruction**: There is a suggestion that the course could benefit from teaching students how to create their own calculation tools using sheets, which would be useful in future applications. - **Arbitrage Opportunities Clarification**: One student found the explanation of arbitrage opportunities to be lacking. - **Device Requirement**: One review noted the need for a laptop to complete certain assignments, which could be a limitation for some learners. ### **Additional Feedback** - **Comprehensive Quizzes**: The quizzes are seen as an excellent tool for recapitulation and application of the learned concepts. - **Realistic Examples**: The practical examples given in the course are appreciated for their relevance and clarity. - **High Expectations Met**: The course is generally seen as surpassing expectations, offering a solid foundation in portfolio management and investment analysis. - **Accessibility for Non-Financial Background Learners**: The course is considered suitable for learners with no prior financial background, providing them with the necessary tools to understand and engage with finance at a fundamental level. - **Room for Improvement in Excel Tools**: There is a call for improved integration of Excel tools tailored for retail users, making the application of concepts easier outside the classroom setting. ### **Conclusion** Overall, this course is highly regarded for its comprehensive approach to teaching fundamental finance concepts through engaging lectures, practical applications, and effective learning tools. While there are some areas that could be improved, such as providing more detailed mathematical explanations and integrating Excel tools for retail users, the course remains a strong educational asset for both beginners and seasoned professionals in the financial industry.

Charts

Price

Investment Analysis & Portfolio Management - Core Finance - Price chart

Rating

Investment Analysis & Portfolio Management - Core Finance - Ratings chart

Enrollment distribution

Investment Analysis & Portfolio Management - Core Finance - Distribution chart
1802334
udemy ID
7/16/2018
course created date
10/14/2019
course indexed date
Bot
course submited by