MQP 2010-Analysis of Fund Mapping Techniques for Variable Annuities

Our project tested the accuracy of projected mutual fund returns (via fund mappings) relative to the actual performance of the mutual fund. To achieve this, we performed Monte-Carlo simulations using geometric Brownian motion. Utilizing Excel’s VBA, we generated many scenarios to draw conclusions about fund mapping reliability. We modified parameters within the simulation in order to isolate factors that affected the fund mapping’s accuracy, and analyzed the specific effects of these variables to provide our sponsor, Towers Perrin, with recommendations.