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 incorporating shocks on assumptions used.
This course is organized using “building-block” approach, starting with recapping concepts and techniques from beginning level course Introduction to Cash Flow Modelling and setup calculations for commission and expenses that are not covered previously. Course Participants then learn the techniques used to manage assumptions, by incorporating sensitivity factors in both projection and valuation cash flows. Furthermore, they continue to learn to calculate reserves under different reserving basis, before setting up a projected revenue account used to calculate profits and respective actuarial present values.
Through this solving-based course, the Course Participants will learn techniques that are useful and relevant to their daily work, as the problems presented during this course are simulated from the real-life actuarial works of an insurance company.
This course is suitable to Course Participants who have attended beginning level course Introduction to Cash Flow Modelling or equipped with equivalent skills & knowledge.