Cashflow Continued - Annuities
Article Index
Cashflow Continued - Annuities
Balance exhausted
Annuity calculator

Chapter Five

We move on to annuities in the second of three chapters devoted to exploring the way in which interest rate affects cashflow.

Banner

Chapter Five

Although a savings plan (see Chapter Four) is just a special case of an annuity it has become common practice to apply the term to a particular type of investment where a lump sum is exchanged for a cash flow (contrast with a savings plan where a cash flow is exchanged for a lump sum). In the case of an annuity the cash flow reduces the principal but interest still acts to increase it.

Annuities explored

If the amount deposited is PV and the amount periodically withdrawn is S (which is positive as it represents cash flowing to you) then at the end of the first time period the balance stands at:

  PV*(1+I)-S

and at the end of the second:

 (PV*(1+I)-S)*(1+I)-S=
PV*(1+I)*(1+I) - S*(1+I) -S

and so on.

Each month the balance earns I% interest and so increases by (1+I) but then S is removed from the account.

In general after n time periods the balance stands at:

PV*(1+I)^n - S*(1+I)^(n-1)-
S*(1+I)^(n-1) ...-S

If you compare this situation with the savings plan you should notice that it is the same but with the regular payment positive (i.e. a cash inflow) and the initial deposit negative (i.e. a cash outflow).

fig2

Figure 1: An annuity - the deposit decreases as cash is withdrawn but interest still acts to increase it.

 

We already have a formula that gives the future value, i.e. the balance at time n, and it is just the formula used for the savings plan when there is an initial deposit PV :

          (1+I)n - 1   
FV= S* ------------ + PV*(1+I)n
 I

and as long as we regard the cash flow as positive and the intial deposit as negative (i.e. money you paid out) then we don’t even have to change the sign of S in the formula.

That is, the function:

  =FV(I,nper,S,PV)

will calculate the Future Value FV of an annuity consisting of a regular payment of S, at I% for nper periods with a starting blance of PV. (Note that in Excel's terminology PMT is used for S and Rate for I.)

In the case of an annuity PV is usually negative and the payment S is positive. For example, suppose we set up an annuity with a PV of -$1000, then at an interest rate of 10% per annum if we withdraw $100 each year the FV or balance at the end of one year is:

 =FV(10%,1,200,-1000)

which gives $900. The reason is that the interest on $1000  is $100 making the balance at the end of the year $1100 and then we withdraw $200 reducing the balance to $ 900. The following year the balance will be:

 =FV(10%,2,200,-1000)

which works out to $790 - i.e. plus $90 of interest and minus the $200 withdrawal and so on.

<ASIN:0470178892>

<ASIN:0195301501>

 

 



 
 

   
RSS feed of all content
I Programmer - full contents
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.