You estimate you need to supplement your social security payments with monthly withdrawals of $3,420.00 per month from a private investment account during the first 24 years of your retirement.   Assuming you can earn annual returns of 6.9% in your investment account during your retirement years, how much money do you need to have accumulated in your investment account by the day you retire in order to fund the aforementioned monthly withdrawals?

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter5: The Time Value Of Money
Section: Chapter Questions
Problem 44P
icon
Related questions
Question

You estimate you need to supplement your social security payments with monthly withdrawals of $3,420.00 per month from a private investment account during the first 24 years of your retirement.   Assuming you can earn annual returns of 6.9% in your investment account during your retirement years, how much money do you need to have accumulated in your investment account by the day you retire in order to fund the aforementioned monthly withdrawals?

Expert Solution
Step 1: Calculating the amount required at beginning of retirement

Given:

Monthly withdrawal = $3,420

Interest rate = 6.9%

So, monthly interest rate = 0.069/12 = 0.58%

Time =24 years

Monthly period = 24*12 = 288

So, total amount at the beginning of retirement =  Using excel PV function

Syntax: PV(monthly rate, total period, monthly withdrawal, , 0)

 

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Types Of Securities Firms
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT