Description: This actually is a copy of an appendix of a research paper sponsored by the SOA Committee on Finance Research. You can read the entire research paper: “Lapse Modeling for the Post-Level Period—a Practical Application of Predictive Modeling” at the SOA site https://www.soa.org/Research/Research-Projects/Finance-Investment/lapse-2015-modeling-post-level/#sthash.W9lERSls.dpbs, but you can read this valuable appendix copied here in this issue to see how to build a PM step-by-step using your data and the R programming language. We thank Richard Xu, Dihui Lai, Minyu Cao, Scott Rushing, and Tim Rozar for their excellent paper and the Society of Actuaries, for the permission to reprint this portion of the paper.

Description: This article discusses using Excel to calculate internal rate of return IRR and the potential complications associated with the task.