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 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.