Lesson Withdrawing a certain amount of money periodically from a compounded saving account

Algebra ->  Sequences-and-series -> Lesson Withdrawing a certain amount of money periodically from a compounded saving account      Log On


   


This Lesson (Withdrawing a certain amount of money periodically from a compounded saving account) was created by by ikleyn(52777) About Me : View Source, Show
About ikleyn:

Withdrawing a certain amount of money periodically from a compounded saving account


Problem 1

There is an annually compounded saving account with initial amount of  X  dollars.
A person withdraws certain constant amount  W = 24000  dollars at the beginning of each year.
The account is compounded annually at  r = 6% annual rate at the end of each year.
What the initial value  X  of the account should be in order for to feed the person for  20  years
in accordance with this scheme ?

Solution

Let  r = 6% = 0.06  and let  p = 1+%2B+r.  Let us move in time back from the 20-th year to the beginning.


20)  At the beginning of the 20-th year, before withdrawing, the account must have exactly W = 24000 dollars in order for the person 
     could withdraw it and complete/(zeroed) the account.

     It means that at the end of the 19-th year, after compounding, the account should have exactly W = 24000 dollars.
     In turn, it means that at the end of the 19-th year, before compounding, the account should be exactly  W%2Fp dollars.

     Hence, at the beginning of the 19-th year, after withdrawing of W = $24000, the account must be exactly  the same  W%2Fp dollars.


19)  It means that at the beginning of the 19-th year, before withdrawing, the account must be  W%2Fp+%2B+W dollars.

     Hence, at the end of the 18-th year, after compounding, the account should be the same %28W%2Fp%2BW%29 dollars.
     In turn, it means that at the end of the 18-th year, before compounding, the account shoud be exactly  %281%2Fp%29%2A%28W%2Fp+%2B+W%29 dollars.

     Hence, at the beginning of the 18-th year, after withdrawing of W = $24000, the account must be exactly the same  %281%2Fp%29%2A%28W%2Fp+%2B+W%29 dollars.


18)  It means that at the beginning of the 18-th year, before withdrawing, the account must be  %281%2Fp%29%2A%28W%2Fp+%2B+W%29+%2B+W dollars.

     Hence, at the end of the 17-th year, after compounding, the account should be the same  %281%2Fp%29%2A%28W%2Fp+%2B+W%29+%2B+W dollars.
     In turn, it means that at the end of the 17-th year, before compounding, the account should be exactly  %281%2Fp%29%2A%28%281%2Fp%29%2A%28W%2Fp+%2B+W%29+%2B+W%29 dollars.

     Hence, at the beginning of the 18-th year, after withdrawing of W = $24000, the account must be exactly the same  %281%2Fp%29%2A%28%281%2Fp%29%2A%28W%2Fp+%2B+W%29+%2B+W%29 dollars.


17) - 16) - 15) - . . . . . . . . - 2)


1)    It means that at the beginning of the 1-st year, before withdrawing, the account must be  W%2Fp%5E19 + W%2Fp%5E18 + . . .  + W%2Fp + W dollars,
      and it is exactly the starting amount X, which is under the problem question.


      Hence,  X = W%2Fp%5E19 + W%2Fp%5E18 + . . .  + W%2Fp + W,  which is equal, by applying the formula of the sum of geometric progression

              X = W*(((1/p^20)-1) / ((1/p)-1)) = W%2Ap%2A%28%281-p%5E%28-20%29%29%2F%28%28r%2F100%29%29%29.


ANSWER.  The initial value X of the account to feed the person with W dollars per year for 20 years should be  X = W%2Ap%2A%28%281-p%5E%28-20%29%29%2F%28%28r%2F100%29%29%29.

         The initial value X of the account to feed the person with W dollars per year for n years should be  X = W%2Ap%2A%28%281-p%5E%28-n%29%29%2F%28%28r%2F100%29%29%29.

         With the given data  W = 24000 dollars,  r = 6% = 0.06,  p = 1 + 0.06,  n = 20 years  the initial amount at the account should be  


                   X = 24000%2A1.06%2A%28%281-1.06%5E%28-20%29%29%2F0.06%29 = 291794.80 dollars.


Notice that the person get from the fund  $24000*20 = 480,000 dollars in all, in 20 years.


            In other problems the withdrawal period  (which is usually the same as the compounding period)  can be different from one year.
            It can be one quarter,  or one month,  or one week.  But the rate of the account is usually comes as the annual rate,  as you will see
            in problems that follow.  The scheme of deriving the final formulas is the same,  so I do not repeat deriving and give the final formulas
            and the way on how to use them in the problems that follow.


Problem 2

There is a quarterly compounded saving account with initial amount of  X  dollars.
A person withdraws certain constant amount  W = 6000  dollars at the beginning of each quarter.
The account is compounded quarterly at  r = 6%  annual rate at the end of each quarter.
What the initial value  X  of the account should be in order for to feed the person for  20  years
in accordance with this scheme ?

Solution
Use the general formula  X = W%2Ap%2A%28%281-p%5E%28-n%29%29%2F%28%28r%2F100%29%29%29.

In this case  W = $6000,  the quarterly rate is  r = 0.06/4 = 0.015,  p = 1 + 0.015 = 1.015, the number of payment periods (= the number of quarters) 
is n = 20*4 = 80, so


          X = 6000%2A1.015%2A%28%281-1.015%5E%28-80%29%29%2F0.015%29 = 282620.60 dollars.     ANSWER


Notice that the person get from the fund  $6000*20*4 = 480,000 dollars in all, in 20 years.

Problem 3

There is a monthly compounded saving account with initial amount of  X  dollars.
A person withdraws certain constant amount  W= 2000  dollars at the beginning of each month.
The account is compounded monthly at  r = 6%  annual rate at the end of each month.
What the initial value  X  of the account should be in order for to feed the person for  20  years
in accordance with this scheme ?

Solution
Use the general formula  X = W%2Ap%2A%28%281-p%5E%28-n%29%29%2F%28%28r%2F100%29%29%29.

In this case  W = $2000,  the monthly rate is  r = 0.06/12 = 0.005,  p = 1 + 0.005 = 1.005, the number of payment periods (= the number of months) 
is n = 20*12 = 240, so


          X = 2000%2A1.005%2A%28%281-1.005%5E%28-240%29%29%2F0.005%29 = 280557.40 dollars.     ANSWER


Notice that the person get from the fund  $2000*20*12 = 480,000 dollars in all, in 20 years.

Problem 4

You have $300,000 saved for retirement. Your account earns 10% interest.
How much will you be able to pull out at the beginning of each month, if you want to be able to take withdrawals for 25 years?

Solution

Use the general formula  A = W%2Ap%2A%28%281-p%5E%28-n%29%29%2Fr%29.


Here A is the initial amount at the account; W is the monthly withdrawn value; r is the nominal monthly percentage r = 0.1/12; 
presented as a decimal;  p = 1 + r  and n is the number of withdrawing periods (months, in this case).


In this problem,  W is the unknown;  the monthly rate is  r = 0.10/12 = 0.00833,  p = 1 + 0.00833 = 1.00833, the number of payment 
periods (= the number of months) is n = 25*12 = 300.  So


          300000 = W%2A1.00833%2A%28%281-1.00833%5E%28-300%29%29%2F0.00833%29.


The factor  1.00833%2A%28%281-1.00833%5E%28-300%29%29%2F0.00833%29 is equal to 110;  therefore


           W = 300000%2F110 = 2727 dollars  (rounded to the closest lesser dollar).


Thus you will be able to withdraw about $2727 every month during 25 years.    ANSWER


        The conclusion and the lesson to learn


If you are given a problem like this

    There is a saving account with initial amount of  X  dollars, compounded periodically (yearly, or quarterly, or monthly).
    A person withdraws certain constant amount  W  from the account at the beginning of each period.
    The account is compounded at the end of each period at the annual rate  r.  
    What the initial value  X  of the account should be in order for to feed the person for  n  years 
    in accordance with this scheme ? 

then the solution is as follows:

    a)  Use the decimal rate for the withdrawal (compounding) period  r (for the yearly period ),  or  r/4 (for the quarterly period)  or  r/12 (for the monthly period).  

        Then compute p = 1+r  and the number of the withdrawal periods m = n, or m = 4n  or  m = 12n, correspondingly;


    b)  then use the formula  X = W%2Ap%2A%28%281-p%5E%28-m%29%29%2Fr%29  to determine the initial amount  X  at the account.


My other lessons in this site associated with annuity saving plans and retirement plans are

    - Geometric progressions
    - The proofs of the formulas for geometric progressions

    - Ordinary Annuity saving plans and geometric progressions
    - Annuity Due saving plans and geometric progressions
    - Solved problems on Ordinary Annuity saving plans
    - Finding present value of an annuity, or an equivalent amount in today's dollars
    - Miscellaneous problems on retirement plans

OVERVIEW of my lessons on geometric progressions with short annotations is in the lesson  OVERVIEW of lessons on geometric progressions.

Use this file/link  ALGEBRA-II - YOUR ONLINE TEXTBOOK  to navigate over all topics and lessons of the online textbook  ALGEBRA-II.


This lesson has been accessed 2263 times.