Description: The study of Employee Benefits has always been aided by using financial algorithms. During recent semesters, the Lotus 1-2-3 package Lotus has been introduced to students due to the explosion of its use in the business community. This paper will show how our students use Lotus to design a spreadsheet for computing minimum annual distributions from tax-sheltered plans.

Description: This paper establishes a framework to analyze the volatility of corporate profits as a result of variability in accounting for pension plans. It models a Canadian corporation that maintains a defined-benefit pension plan and that has adequate cash flow to fully fund the pension plan, should it wish. Volatility of corporate profits is important because many senior executives have some component of their compensation directly related to corporate profitability and consequently do not want any surprises with respect to actual profits compared to expected profits. The volatility management techniques considered are investment policies for the pension plan, funding the pension plan, and an alternative plan design. The analysis is timely since changes are proposed to the accounting standards to eliminate most smoothing techniques. The results suggest that, depending on the investment environment, reduced volatility may be accompanied by by enhanced return, which is a result that few would expect.

Description: This paper presents a multi-state stochastic model for analyzing continuing care retirement community CCRC populations. The model considers CCRCs with a number of independent living units and a skilled nursing facility. Residents may transfer temporarily or permanently to this facility. It is assumed that units vacated by deaths, withdrawals or permanent transfers are immediately occupied by new residents. Transfers are modeled using a time-homogeneous Markov process. The paper provides some probabilistic results and some numerical results obtained using this model. Some important generalizations of the model are also briefly discussed.

Description: This paper discusses the level of reserve funds that a pension plan should maintain to protect itself from a downturn in the financial markets. From Current Pension Actuarial Practice in Light of Financial Economics Symposium, M-RS04-1.