This course covers prescribed curriculum by IFoA and IAI for CM2 B including MS Excel and Modeling in MS Excel for Actuarial Science.
The paper covers topics like CAPM, MPT, APT, Multi-Factor and Single-Factor Models, EMH, Behavioral Finance, Stochastic dominance, Utility theory under uncertainty & certainty equivalent, interest rate models and credit risk models.
White Knight Ventures was the first in industry to start MS Excel & R For Actuarial Science in 2015 for training for insurance companies and students alike.
CM2B (MS Excel for CM2)
Updated as per latest guidelines by IFoA and IAI till 2021.
Addresss and Text Formulae
Shortcuts, Custom Formatting and Data Validation
Paste Special and VLookup
Vlookup, And, Or and If Functions
If, Lookup Functions, Index Match, Indirect
Datedif, Custom Formatting, Index Match
Sumif, Date Formulae, Sumproduct, PMT, PPMT, PV, Text to Column
Sumif, Countif, External Data, Formula Auditing, Offset, Loan Schedules, Errors
Advance Filter, VLookup with Match, Conditional Formatting
Pivot Table
Charts and What If Analysis
Portfolio Models and Efficient Frontier
Efficient Frontier and Monte Carlo
Binomial Model
Option Pricing_Dynamic Call Replication
Run-Off Triangles
Binomial Model Class
Option Pricing in MS Excel