Dear FRM Candidate, hope your preparation so far has been smooth! With D-Day just around the corner, many students tend to start cramming just about now!
That’s why we thought we would extend a helping hand. We at EduPristine have demystified a few tough topics through our new series "Xcel FRM Series".
This series would be especially helpful if you:
- Learn Better Hands-On
- Are trying to get through tough topics quickly
- Wonder how the concepts taught in FRM are applicable in real life
- Want to learn a thing or two in MS Excel.
The Xcel FRM Series is a 3 day series where you will receive MS Excel Sheets absolutely FREE!
Today, let’s focus on the areas of Foundations of Risk Management and Quantitative Analysis. We have included 4 Workbooks that cover the following topics:
- Effect of Correlation on Portfolio Risk and Return – using form control: Here, you will learn visually how correlation impacts the performance of a two asset portfolio. Check out how the shape of the portfolio possibilities curve is formed. After the exam, you can learn how to use form controls.
- Efficient Frontier>: You can see how the efficient frontier is actually constructed. After the exam, learn how the array function "MMULT" is used.
- Regression Analysis: Find the Beta of a stock by regressing the Stock return’s against a benchmark’s. See how regression analysis is performed using the OLS tool in Excel.
- Two Asset Correlation: Learn how to calculate correlation using a Step by Step Approach.
Feel free to share these sheets with your friends!
Stay tuned for Day 2 of Financial Markets and Products.
Till then, happy studying!
Comments