Purchase Solution

Calculate Amount to Save for Retirement in Several Scenarios

Not what you're looking for?

Ask Custom Question

Assumptions:

1. Your required rate of return until retirement is 8%
2. Your retirement payout will be a fixed payment, and will be adjusted for a much more conservative return of 5%. This will be your return on the payout until you die.

Process:

Using the time value of money, you will need to calculate how much you will need to save up in a lump sum so you can retire at ages 62 and also at age 70, in order to receive annual payments for the rest of your expected life. Once you have calculated your answers, please outline how you plan to implement it. Please use the following information in your problem:

1. Target retirement age(s): 62 and 70 (please complete analysis for both)
2. Current age: 25
3. Total amount of money needed to live off for retirement: $37,500 ($3,125 a month)
4. Anticipated death age: 80
? Retirement at age 62: 18 years of retirement
? Retirement at age 70: 10 years of retirement
5. Do not factor in social security or spouses retirement.
6. $10,000 in retirement account right now at age 25.

Purchase this Solution
Solution Summary

The solution calculates the amount to save for retirement in several scenarios.

Solution Preview

Please find the solutions for how to calculate Time Value of Money in the attached file.

Running head: TIME VALUE OF MONEY

Time value of money

1. Retirement age = 62 years
Current age = 25 years
Expected time after retirement = 18 years
Remaining Time period of Service = 37 years (62-25 =37)
Present value = $37500
Time period after retirement = 18 years
Interest Rate before Retirement= 8%
Interest Rate after Retirement= 5%
PVA= A
A (Annuity) = $37500
i ( interest rate after retirement) = 5%
n (time period after retirement) = 18 yrs
Present value annuity = 37500
= 37500
= 37500
= 37500
= 37500 11.68959
= 438359.5
= $438359.5
This ...

Purchase this Solution
Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Operations Management

This quiz tests a student's knowledge about Operations Management

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

View More Free Quizzes
Related BrainMass Solutions

  • Retirement

    D: You really want to consume $30,00 a year in real dollars during retirement and wish to save an equal real amount each year until then. What is the real amount of saving that you need to accumulate by the time you retire?

  • Retirement Savings Problem

    This is the amount you need to save each year to get $500,000 at the end of 40 years. The solution explains how to calculate the annual savings needed for a given amount at retirement.

  • Develop a Retirement & Capital Needs Analysis

    Problems: Calculate how much Larry will need on the day he retires to meet his retirement goal. Calculate how much he needs to save regularly to meet his retirement goal.

  • Time value of money: retirement plans

    What equal amount must he save at the end of years 11 through 30 to meet this objective? The interest rate for the first 10 years will be 5 percent. After that time, the interest rate is expected to be 7 percent.

  • Retirement Account

    197393 Archie's Retirement account is short: calculate additional amount needed to retire Today is Archie's 50th birthday and his retirement account totals $237,000.

  • Time Value of Money Concepts

    for 21st year to 35 years Periodic amount=R=?

  • bonds, stocks, payments, PV needed, Retiring, time value $

    Your tutorial is attached in Excel. There is a separate tab for each problem and several scenarios at different interest rates so you can see how they change the discounted amounts.

  • Retirement Savings

    $3,230.81 $3,230.81 saved each year would become $500,000 in 40 years at 6% The solution explains how to calculate yearly savings so as to reach the goal of retirement amount.

  • Time Value of Money for present and future values

    Question: How much will you need on hand at 65 to cover the $75,000 annuity payment for 25 years? Calculate How much (pv) you need at 65 to pay 75k for 25 years? Figure what you have to save for 40 years to get to that balance (FV).

View More Related Solutions