Required information [The following information applies to the questions displayed below.] "I only get one shot at this?" you wonder aloud. Martina, human resources manager at Covington State University, has just explained that newly hired assistant professors must choose between two retirement plan options. "Yes, I'm afraid so," Martina concedes. "But you do have a week to decide." Martina's explanation was that your two alternatives are (1) the state's defined benefit plan and (2) a defined contribution plan under which the university will contribute each year an amount equal to 8% of your salary. The defined benefit plan will provide annual retirement benefits determined by the following formula: 1.5 % x years of service x salary at retirement. "It's a good thing I studied pensions in my accounting program," you tell Martina. "Now let's see. You say the state is currently assuming our salaries will rise about 3% a year, and the interest rate they use in their calculations is 6%? And, for someone my age, you say they assume I'll retire after 40 years and draw retirement pay for 20 years. I'll do some research and get back to you." Note: Use tables, Excel, or a financial calculator. (FV of $1, PV of $1. FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) Hint: The calculations are greatly simplified using an electronic spreadsheet such as Excel. There are many ways to set up the spreadsheet. One relatively easy way is to set up the first few rows with the formulas as shown below, then use the "fill down" function to fill in the remaining 38 rows, and use the Insert: Name: Define: function to name column B "n". Since contributions are assumed made at the end of each year, there are 39 years remaining to maturity at the end of 2024. Note that multiplying each contribution by (1.06)", where n equals the remaining number of years to retirement, calculates the future value of each contribution invested at 6% until retirement. End of Year 2024 =A3+1 Years to Retirement 39 = 83-1 Salary 100,000 = C3x1.03 Contribution = C3×0.08 = C4x0.08 Future Value at Retirement = D3x1.06^n = D4x1.06^n Required: 1. You were hired at the beginning of 2024 at a salary of $100,000. If you choose the state's defined benefit plan and projections hold true, what will be your annual retirement pay? What is the present value of your retirement annuity as of the anticipated retirement date (end of 2063)? 2. Suppose instead that you choose the defined contribution plan. Assuming that the rate of increase in salary is the same as the state assumes and that the rate of return on your retirement plan assets will be 6% compounded annually, what will be the future value of your plan assets as of the anticipated retirement date (end of 2063)? What will be your annual retirement pay (assuming continuing investment of remaining assets at 6%)?

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)
7th Edition
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Chapter9: Insuring Your Health
Section: Chapter Questions
Problem 2FPE
icon
Related questions
Question

Hanshaben 

Required information
[The following information applies to the questions displayed below.]
"I only get one shot at this?" you wonder aloud. Martina, human resources manager at Covington State University, has just
explained that newly hired assistant professors must choose between two retirement plan options. "Yes, I'm afraid so,"
Martina concedes. "But you do have a week to decide."
Martina's explanation was that your two alternatives are (1) the state's defined benefit plan and (2) a defined contribution
plan under which the university will contribute each year an amount equal to 8% of your salary. The defined benefit plan
will provide annual retirement benefits determined by the following formula: 1.5% x years of service x salary at retirement.
"It's a good thing I studied pensions in my accounting program," you tell Martina. "Now let's see. You say the state is
currently assuming our salaries will rise about 3% a year, and the interest rate they use in their calculations is 6%? And, for
someone my age, you say they assume I'll retire after 40 years and draw retirement pay for 20 years. I'll do some research
and get back to you."
Note: Use tables, Excel, or a financial calculator. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1)
Hint: The calculations are greatly simplified using an electronic spreadsheet such as Excel. There are many ways to set up
the spreadsheet. One relatively easy way is to set up the first few rows with the formulas as shown below, then use the "fill
down" function to fill in the remaining 38 rows, and use the Insert: Name: Define: function to name column B "n". Since
contributions are assumed made at the end of each year, there are 39 years remaining to maturity at the end of 2024.
Note that multiplying each contribution by (1.06)", where n equals the remaining number of years to retirement, calculates
the future value of each contribution invested at 6% until retirement.
End of Year
2024
=A3+1
Years to
Retirement
39
Salary
100,000
Contribution
Future Value at
Retirement
= C3×0.08
= D3x1.06^n
= B3-1
= C3x1.03
= C4x0.08
=
D4x1.06^n
Required:
1. You were hired at the beginning of 2024 at a salary of $100,000. If you choose the state's defined benefit plan and projections hold
true, what will be your annual retirement pay? What is the present value of your retirement annuity as of the anticipated retirement
date (end of 2063)?
2. Suppose instead that you choose the defined contribution plan. Assuming that the rate of increase in salary is the same as the state
assumes and that the rate of return on your retirement plan assets will be 6% compounded annually, what will be the future value of
your plan assets as of the anticipated retirement date (end of 2063)? What will be your annual retirement pay (assuming continuing
investment of remaining assets at 6%)?
Transcribed Image Text:Required information [The following information applies to the questions displayed below.] "I only get one shot at this?" you wonder aloud. Martina, human resources manager at Covington State University, has just explained that newly hired assistant professors must choose between two retirement plan options. "Yes, I'm afraid so," Martina concedes. "But you do have a week to decide." Martina's explanation was that your two alternatives are (1) the state's defined benefit plan and (2) a defined contribution plan under which the university will contribute each year an amount equal to 8% of your salary. The defined benefit plan will provide annual retirement benefits determined by the following formula: 1.5% x years of service x salary at retirement. "It's a good thing I studied pensions in my accounting program," you tell Martina. "Now let's see. You say the state is currently assuming our salaries will rise about 3% a year, and the interest rate they use in their calculations is 6%? And, for someone my age, you say they assume I'll retire after 40 years and draw retirement pay for 20 years. I'll do some research and get back to you." Note: Use tables, Excel, or a financial calculator. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) Hint: The calculations are greatly simplified using an electronic spreadsheet such as Excel. There are many ways to set up the spreadsheet. One relatively easy way is to set up the first few rows with the formulas as shown below, then use the "fill down" function to fill in the remaining 38 rows, and use the Insert: Name: Define: function to name column B "n". Since contributions are assumed made at the end of each year, there are 39 years remaining to maturity at the end of 2024. Note that multiplying each contribution by (1.06)", where n equals the remaining number of years to retirement, calculates the future value of each contribution invested at 6% until retirement. End of Year 2024 =A3+1 Years to Retirement 39 Salary 100,000 Contribution Future Value at Retirement = C3×0.08 = D3x1.06^n = B3-1 = C3x1.03 = C4x0.08 = D4x1.06^n Required: 1. You were hired at the beginning of 2024 at a salary of $100,000. If you choose the state's defined benefit plan and projections hold true, what will be your annual retirement pay? What is the present value of your retirement annuity as of the anticipated retirement date (end of 2063)? 2. Suppose instead that you choose the defined contribution plan. Assuming that the rate of increase in salary is the same as the state assumes and that the rate of return on your retirement plan assets will be 6% compounded annually, what will be the future value of your plan assets as of the anticipated retirement date (end of 2063)? What will be your annual retirement pay (assuming continuing investment of remaining assets at 6%)?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Employee Retirement Income Security Act (ERISA)
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
Personal Finance
Personal Finance
Finance
ISBN:
9781337669214
Author:
GARMAN
Publisher:
Cengage
Individual Income Taxes
Individual Income Taxes
Accounting
ISBN:
9780357109731
Author:
Hoffman
Publisher:
CENGAGE LEARNING - CONSIGNMENT
SWFT Individual Income Taxes
SWFT Individual Income Taxes
Accounting
ISBN:
9780357391365
Author:
YOUNG
Publisher:
Cengage