Actuarial CM2 syllabus, CM2 excel practice workbook solutions-min

CM2 Excel Practice Workbooks with Solutions (CM2B)

Financial Engineering and Loss Reserving’(CM2) provides a grounding in the principles of actuarial modelling, focusing on stochastic asset-liability models and the valuation of financial derivatives. CM2B consist of a part of CM2 which is a practical exam to test your knowledge about how much you have learnt and has been introduced under new curriculum. We have received some messages on “Where CM2 Excel practice workbooks are available”?
CM2 equips the student with a knowledge of the theories of behaviour of financial markets, measures of risk, determining reserves for a non-life insurer and price options. The subject includes theory and application of the ideas to real data sets using excel.

CM2 excel practice workbooks

If you are wondering on how to practice for CM2B, the CM2 excel practice workbooks are now within your reach.
It is hard to find the data sets and you may be looking for one. Blessings to IFoA, they have provided the Excel workbooks and solutions to make you understand the concepts and the simulation of Actual pricing of Options using the theoritical solutions provided in CM2 material such as Binomial Tree, Risk Neutral Probabilities, Call Put Parity, Forward Pricing and more!
The CM2 Excel practice workbooks are more than helpful to understand the pricing of instruments in real life situation.

Workbook & Solution 1

The exercise contains calculation of Call Option, Put Option, Sensitivity of Strike Price on Ct and Pt Payoffs.

It is a stochastic Model with Utility and Expected utility calculation.

Workbook & Solution 2

This contains Binomial Tree, Risk Neutral Probabilities, Call Put Parity and more. The end result is the value of Options, which is also a Financial Instrument.

Workbook & Solution 3

This explains the calculation of Dividends with stock postions as Long and short and calculation of Forward Price (that is easy!)

We hope that you’d now learn and won’t be manipulated by people to attend something that is publicly available as CM2 Excel practice Workbooks!
About the Author

Mayank Goyal

Facebook Twitter

Redmond Lover(Microsoft), London Dreamer(Actuary), California Thinker(Entrepreneur). Actuarial Science, Blogger, Web Developing, Winphan India, App development, Social Media Managing, Event Managing & bla bla bla.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.