Bozo Retires

EXERCISE 1

BOZO RETIRES

This exercise has two purposes. First, it will give you practice with some key financial functions in Excel. The functions you will need to use are PMT and NPV. These are two of the three most commonly used functions in the course. The other is IRR. Second, the exercise gives you a sense for what it will take in terms of savings and investment returns to achieve a retirement goal in terms of timing and standard of living. Once it is set up, you can change assumptions regarding date of retirement, income level during retirement, rate of saving, etc., and analyze your options. I keep my plan on my computer at all times. It helps me to abide.

To start, you need several parameters:

1. Income per year during retirement. You may assume an amount, or you may develop a detailed budget, based on the standard of living you desire to maintain. If you want to be more realistic, you can subtract social security cash payments and any defined benefits retirement income you expect. The difference will be the living expenses you need to cover by this retirement plan;

2. Number of years you expect to be in retirement mode. This number depends on two ages, your age at time of retirement and your age at time of demise;

3. The amount of money you have saved for retirement now. This amount may of course be zero. It may even be negative for those of you with substantial debt. Icky-poo;

4. The rate of return you expect to earn on your retirement investments during your working years. This rate depends on your investment options and strategy, and especially your tolerance for risk;

5. The rate of return on your retirement investments during your retirement years. This rate will generally be lower than that during years, as you will likely want to put your funds into assets of lower risk;

6. An inflation rate that is applied to current dollars to calculate nominal (inflation-inclusive) dollars.

Think about how you will put the...