Please provide any assistance towards solving each part of the problem (i.e. what equations or numbers to use, further explanation of the questions being asked, etc.) Thank you.
In recent years, there has been a lot of media coverage about the funding status of pension plans for state employees. In many states, the amount of money invested in employee pension plans is far less than the amount estimated to be needed to pay them the retirement benefits they have been promised. Basically, pension plans work by investing enough money while employees are working so that the money invested, plus the investment income it earns over the years, will be sufficient to pay the workers their retirement incomes once they have retired.
There are many complicated assumptions, estimates, and calculations needed to determine how much money a state should invest in its pension fund each year. One of the most important assumptions is the rate of return the plan's investments will earn in the future. As you have seen in this chapter, the higher the rate of return used to calculate the present value of future cash flows, the lower the present value will be. To determine a pension plan's funded status, actuaries (1) estimate the future cash payments expected to be made to employees, (2) calculate the present value of those cash flows using an assumed rate of return (this present value is the gross liability of the fund), and (3) subtract the amount of money that has been invested from the gross liability calculated in step 2 (this amount is the funded status of the pension plan). Essentially, this is the same as calculating the net present value of an investment. If the plan has less money in its investments than the present value of its estimated future cash flows, it has a net liability and is considered to be underfunded by that amount.
Many states' pension plans have assumed they will earn 8 percent or more on their investments, even though many experts think a more appropriate assumption would be 6.5 percent. As an example, the state of Virginia used an assumed rate of return of 7.5 percent in 2009 but reduced the rate to 7.0 percent in 2011. In 2011, Virginia paid out approximately $3.3 billion in benefits to retirees.
a.) Assume Virginia's annual payments will continue to be $3.3 billion, and that retirees will receive benefits for 20 years on average. Using an assumed rate of return of 8 percent, calculate the liability of the state's pension plan. The liability is the present value of the future cash payments. (Be aware that the real-world calculation for a state's pension plan liability involves many more assumptions than just these two.)
b.) Assume the annual payments will continue to be $3.3 billion, and that retirees will receive benefits for 20 years on average. Using an assumed rate of return of 6 percent, calculate the liability of the state's pension plan.
c.) Reviewing your answers from Requirements a and b, provide an explanation as to why states may wish to assume a higher rate of return on their pension plan's investments than actuaries might recommend.
Attached are 2 pdf documents and an Excel file.
I will show you two ways to calculate the Present Value of the future cash payments. The first method is the long way, done in Excel, to help you understand what is happening. The second method is a shortcut. If you prefer, you may skip to the second method.
The expert calculates the present value in two ways--a step-by-step way for each time period, and by using a shortcut formula