Investment Analysis Portfolio Management Core Finance

Financial Analysis Done Right – Rigorously Analyse Investments & Manage Portfolios using Excel® & Google Sheets
Investment Analysis Portfolio Management Core Finance
File Size :
3.51 GB
Total length :
8h 0m



Fervent #LearnWithDistinction


Last update




Investment Analysis Portfolio Management Core Finance

What you’ll 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)

Investment Analysis Portfolio Management Core Finance


No prior knowledge required. We start from the very basics. And build you to an Investment Analysis & Portfolio Management Guru.
It’s okay if math freaks you out. Seriously. Every single equation is explained one variable at a time. We rip it apart to its core, and show you how simple it really is.
Knowledge of basic statistical analysis is useful but NOT essential.
You’ll need a calculator, access to Microsoft Excel® OR a Google account (Google Sheets).


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 ReturnsUnderstanding 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 ReturnsEstimating 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 RelationshipsEstimating 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 ReturnEstimating 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 & OptimisationRisk reduction by diversification.Exploring Optimal Diversification – Number of Securities to HoldOptimising portfolio weights to achieve a target expected return.Minimising your portfolio risk (mathematically) using robust financial analysis techniques.Decomposing DiversificationInvestigate 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 DISTINCTIONWe’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 FoundationYou’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 WalkthroughsEvery 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 QuestionsApply what you learn immediately with 150+ practice questions, all with impeccably detailed solutions.Cheat Sheets & ResourcesMathematical 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.


Section 1: Before You Start…

Lecture 1 Welcome to the Course. Here’s What You’re Going To Master.

Lecture 2 Disclaimer

Lecture 3 Course FAQs

Lecture 4 Important: Course Pointers

Section 2: Understanding Price, Risk, and Return Relationships & Calculating Returns

Lecture 5 Price, Risk, and Return – Definitions & Relationships

Lecture 6 What is Shorting?

Lecture 7 Calculating Stock Returns

Lecture 8 Calculating Stock Returns II (Applied)

Lecture 9 Variable Notations & Descriptions Cheat Sheet

Lecture 10 Learning Experience Testing and Feedback

Lecture 11 Section Conclusion & Additional Insights

Lecture 12 Additional Resources

Section 3: Estimating Expected Returns

Lecture 13 Expected Returns using Average (Mean) Method

Lecture 14 Expected Returns using State Contingent Weighted Probabilities

Lecture 15 Expected Returns using Asset Pricing Models I

Lecture 16 Expected Returns using Asset Pricing Models I (Applied)

Lecture 17 Expected Returns using Asset Pricing Models II

Lecture 18 Additional Resources

Section 4: Understanding and Measuring Risk & Relationships

Lecture 19 Estimating The Total Risk of a Stock I

Lecture 20 Estimating The Total Risk of a Stock II – Applied

Lecture 21 Estimating The Market Risk of a Stock I

Lecture 22 Estimating The Market Risk of a Stock II – Applied

Lecture 23 Estimating Firm Specific Risk

Lecture 24 Additional Resources

Section 5: Measuring Investment Portfolio Returns and Risk

Lecture 25 IMPORTANT: Changes to Keyboard Shortcuts

Lecture 26 Estimating Portfolio Returns

Lecture 27 Estimating Portfolio Risk I (2 Assets)

Lecture 28 Estimating Portfolio Risk II (Multiple Assets)

Lecture 29 Estimating Portfolio Risk II (Multiple Assets) – Applied

Lecture 30 Additional Resources

Section 6: Mastery Check & Setup for the Next Phase

Lecture 31 Take a breather!

Lecture 32 Insights by Fervent [Special Feature]

Lecture 33 Test Guidelines [READ BEFORE YOU START THE TEST]

Lecture 34 Installing Solver

Lecture 35 Additional Resources

Section 7: Exploring The Effects of Diversification & Investment Portfolio Optimisation

Lecture 36 Reducing Portfolio Risk by Diversification

Lecture 37 Optimal Diversification – Number of Securities to Hold

Lecture 38 Optimising Weights To Achieve A Target Return I

Lecture 39 Optimising Weights To Achieve A Target Return II – Applied

Lecture 40 Minimising Portfolio Risk – 2 Assets

Lecture 41 Minimising Portfolio Risk – Multiple Assets, Applied

Lecture 42 Additional Resources

Section 8: Decomposing Diversification – Investigating Why It Works

Lecture 43 A Bit Puzzling?

Lecture 44 Correlation of Securities

Lecture 45 Estimating Correlation – Applied

Lecture 46 Correlation and Risk

Lecture 47 Correlation, Risk, and Returns

Lecture 48 Solving the “Puzzles”

Section 9: BONUS: Continue Your Journey On Mastering Finance

Lecture 49 Interesting Questions Asked (IQAs)

Lecture 50 Tell us what you’d like to learn next?

Lecture 51 Bonus: Explore Our Other Courses

ACA, ACCA, CFA®, other Professional students,Ivy League / Russell Group University students,Finance Managers keen on applying conceptual techniques including portfolio design.,Investors wanting to work with techniques that are rigorously grounded in academic and practitioner literature.,Analysts, and aspiring Investment Bankers wanting to gain a solid foundation in investment analysis.,Anyone who wants to learn investment analysis and portfolio management!

Course Information:

Udemy | English | 8h 0m | 3.51 GB
Created by: Fervent #LearnWithDistinction

You Can See More Courses in the Business >> Greetings from

New Courses

Scroll to Top