Videos and spreadsheets for in the Insurance Revenue Account & Profit Modelling (Batch 1), starting from 02 December 2021. IMPORTANT! Please do not mark the last lesson as “completed”.
Insurance Revenue Account & Profit Modelling
Insurance Revenue Account & Profit Modelling is the intermediate level course for “Cash Flow Modelling on Spreadsheet” series, which aims to provide more in-depth understanding on how we can model insurance cash flows on spreadsheets – particularly commission, expenses, reserves, taxation and profits. This course also introduces techniques used to setup a cash flow model that can be used for sensitivity and stress testing, by…
Introduction to Cash Flow Modelling
Introduction to Cash Flow Modelling aims to introduce underlying concepts of modelling insurance cash flows on spreadsheets, which helps to establish good foundations before exploring to more complex cash flow modelling, either on spreadsheets or actuarial software (such as Prophet). This course is organized using “building-block” approach, starting with introducing overall concepts of cash flow modelling for life insurance products, including insurance cash flow components…