What is Next Step

Congratulations for completing all 19 lessons in Design Cash Flow Projection Templates course! To recap, you have learned how to setup a cash flow projection model that you can use to perform projections on:

  • Movement of policies
  • Premium income, benefit outgo, commission, expenses
  • Reserves calculated using gross premium valuation (“GPV”) method & actuarial present values (“APV”)
  • Net profit

However, the journey of learning does not end here. Since you have started learning basic knowledge and skill in spreadsheet modeling, it is recommended for you to continue to learn more advanced techniques in modelling:

  • Model products with more complex features – Include participating products with bonus scales & investment-linked products with account balances (unit funds) and attaching riders (that are required to project together with basic plans, both premium paying riders and unit deducting riders).
  • Incorporate automation – Automatically generate results for multiple model points, such as for profit testing.

If you are setting up spreadsheet models that are used to perform reconciliations against actuarial models that are setup using other applications, such as Prophet, you may need to adjust your spreadsheet models in accordance to the conventions used in those applications.