Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 398 Weeks Ago, 3 Days Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Management Posted 03 Feb 2018 My Price 10.00

FV function

You are now 50 years old and plan to retire at age 65. You currently have a stock portfolio worth $150,000, a 401(k) retirement plan worth $250,000 and a money market account worth $50,000. Your stock portfolio is expected to provide you annual returns of 12 percent, your 401(k) investment will earn you 9.5 percent annually, and the money market account earns 5.25 percent, compounded monthly.
                 
a. If you do not save another penny for the next 15 years, how much will you have from your current savings when you retire at age 65?
                 
Hint: Determine the future value of each account and then the grand total of all three.                                                                                    Use the future value of a lump sum equation as well as the FV function: FV(rate,nper,pmt,pv,type)
                 
  Current age:   Retirement age:      
                 
  Stock Portfolio            
  Current value of stock portfolio:            
  Expected return on portfolio:            
  Years to retirement:            
                 
Expected value of portfolio at age 65 (formula):            
Expected value of portfolio at age 65 (function):            
                 
  401k Plan            
  Current value of 401k portfolio:            
  Expected return on portfolio:            
  Years to retirement:            
                 
Expected value of portfolio at age 65 (formula):            
Expected value of portfolio at age 65 (function):            
                 
  Money Market Account            
  Current value of stock portfolio:            
  Expected return on portfolio:            
  Years to retirement:            
  Frequency of compounding:            
                 
Expected value of portfolio at age 65 (formula):            
Expected value of portfolio at age 65 (function):            
                 
  Total of all three investments:            
                 
b. Assume you plan to invest $12,000 every year in your 401K plan for the next 15 years starting next year. How much will you have in total at retirement?
                 
  Annual investment in 401k plan:            
  Expected return on portfolio:            
                 
Value of 401k plan investments (formula):            
Value of 401k plan investments (function):            
                 
Total investment amount at retirement:            
                 
c. Assume that you expect to live another 25 years after retirement (i.e., until age 90). You now take all of your investments (use scenario from part b), and invest it in an account paying 8 percent. If you plan to use all your savings starting a year from retirement, how much can you withdraw every year for the next 25 years and leave nothing in your account at age 90?
                 
Hint: Solve for the PMT using the present value of an annuity equation and then use the PMT function: PMT(rate,nper,pv,fv,type).
                 
  Amount available at retirement:            
Length of planned withdrawals (years):            
  Expected return on investments:            
                 
                 
Amount of each yearly withdrawal (formula):            
Amount of each yearly withdrawal (function):            
                 
d. If you wanted a perpetuity, how much will you be able to withdraw each year starting a year from now without touching your principal?
                 
  Type of payment:            
Present value of perpetuity:            
  Expected return on investment:            
                 
Amount of each yearly withdrawal:            
                 
           

 

Answers

Maurice Tutor
(5)
Status NEW Posted 03 Feb 2018 08:02 PM My Price 10.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on-----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------

Not Rated(0)