Lesson Find a value of regular deposits for an Ordinary Annuity saving plan

Algebra ->  Finance -> Lesson Find a value of regular deposits for an Ordinary Annuity saving plan      Log On


   


This Lesson (Find a value of regular deposits for an Ordinary Annuity saving plan) was created by by ikleyn(52803) About Me : View Source, Show
About ikleyn:

Find a value of regular deposits for an Ordinary Annuity saving plan


Problem 1

You want to have  $600,000  for retirement in  20  years.
Your account earns  5%  interest compounded monthly.
    a)   how much would you need to deposit in the account at the end of each month ?
    b)   how much interest will you earn?

Solution

It is a classic Ordinary Annuity saving plan. The general formula is 


    FV = P%2A%28%28%281%2Br%29%5En-1%29%2Fr%29,    


where  FV is the future value of the account;  P is the monthly payment (deposit); 
r is the monthly percentage yield presented as a decimal; 
n is the number of deposits (= the number of years multiplied by 12, in this case).


From this formula, you get for the monthly payment 


    P = FV%2A%28r%2F%28%281%2Br%29%5En-1%29%29.     (1)


Under the given conditions, FV = $600,000;  r = 0.05/12;  n = 20*12.  
So, according to the formula (1), you get for the monthly payment value


    P = 600000%2A%28%28%280.05%2F12%29%29%2F%28%281%2B0.05%2F12%29%5E%2820%2A12%29-1%29%29 = 1459.74  (rounded to closest greater cent).


Answer.  The necessary monthly deposit value is $1459.74.


Note that of projected $600,000 the total of deposits you will be only  20*12 times $1459.74, 
i.e. 20*12*1459.74 = 350337.60 dollars. The rest 600000 - 350337.60 = 249662.40 is the interest,
which the account will earn/accumulate in 20 years.

Problem 2

A company needs  $7,700,000  in  14  years in order to expand their factory.
How much should the company invest each quarter if the investment earns a rate of  6%  compounded quarterly?

Solution

This problem is about a quarterly payment for Ordinary Annuity saving plan.


The formula for the Ordinary Annuity saving plan is


f = p+%2A+%28%28%281+%2B+r%29%5En-1%29%2Fr%29,


f is a future value
p is a monthly payment
r is an effective interest rate per time period
n is a number of time periods.


In your problem:


time periods are quarters.


f = 7700000
p = the quarterly deposit amount, which you want to find
r = 0.06/4
n = 14 years * 4 quarters = 56 payment periods


Formula becomes 7700000 = p%2A%28%281+%2B+0.06%2F4%29%5E56-1%29%2F%28%280.06%2F4%29%29


Express p from it to get:


    p = %287700000%2A%280.06%2F4%29%29+%2F+%28%281+%2B+0.06%2F4%29%5E56-1%29%29 = 88712.19  dollars.


The company should deposit $88712.19 quarterly in order to have $7,700,000 in 14 years at 6% per year compounded quarterly.


Interesting, that the company's total direct deposit will be only  $88712.19*4*14 = 4,967,883  dollars.

The rest is the interest which the account will earn.

Problem 3

Angela recently opened saving account at the bank which is compounded monthly at  4%  annual percent yield.
Angela is going to deposit certain constant amount of the money at the end of each month into the account during  30  years
to accumulate  $280,000  for her retirement.  Find the necessary monthly payment for Angela to get her goal.

Solution

It is a classic Ordinary Annuity saving plan. The general formula is 


    FV = P%2A%28%28%281%2Br%29%5En-1%29%2Fr%29,    


where  FV is the future value of the account;  P is the monthly payment (deposit); 
r is the monthly percentage yield presented as a decimal; 
n is the number of deposits (= the number of years multiplied by 12, in this case).


From this formula, you get for the monthly payment 


    P = FV%2A%28r%2F%28%281%2Br%29%5En-1%29%29.     (1)


Under the given conditions, FV = $280,000;  r = 0.04/12;  n = 30*12.  
So, according to the formula (1), you get for the monthly payment 


    P = 280000%2A%28%28%280.04%2F12%29%29%2F%28%281%2B0.04%2F12%29%5E%2830%2A12%29-1%29%29 = $403.43.


Answer.  The necessary monthly deposit value is $403.43.


\\\\\\\\\\\\\\\\\\\\\\\\


To make such complicated calculations as they are in this problem,
you should have/use an appropriate calculator for such long formulas.

Ideal choice is MS Excel, if you have it in your computer.

Then you write a formula in a text editor, copy-paste it
into an Excel work-sheet cell and click "Enter" - the result is ready
in the next second.

If you have no MS Excel in your computer, you may find similar
free of charge calculators in the Internet. One such calculator is

www.desmos.com/calculator

It allows you to do the same thing: you write a formula in a text editor,
copy-paste it into this calculator and click "Enter" - the result is ready
in the next instance.


////////////////////////


On Ordinary Annuity saving plans,  see the lessons
    - Ordinary Annuity saving plans and geometric progressions
    - Solved problems on Ordinary Annuity saving plans
in this site.

These lessons contain  EVERYTHING  you need to know about this subject,  in clear and compact form.
When you learn from these lessons,  you will be able to solve similar problems and to perform similar calculations
in semi-automatic mode.


My other lessons on Finance problems in this site are
    - Problems on simple interest accounts
    - Problems on discretely compounded accounts
    - Problems on continuously compounded accounts
    - Find future value of an Ordinary Annuity
    - How long will it take for an ordinary annuity to get an assigned value?
    - Find future value for an Annuity Due saving plan
    - Regular withdrawals from an annuity account
    - Ordinary annuity account with non-zero initial deposit as a combined total of two accounts
    - Annual depositing and semi-annual compounding in ordinary annuity saving plan
    - Variable withdrawals from a compounded account (sinking fund)
    - Present value of an ordinary annuity cumulative saving plan
    - Problems on sinking funds
    - Find the compounding rate of an ordinary annuity
    - Accumulate money using ordinary annuity; then spend money via sinking fund
    - Calculating a retirement plan
    - Accumulating money via ordinary annuity and spending simultaneously via sinking fund
    - Loan problems
    - Mortgage problems
    - Amortizing a debt on a credit card
    - One level more complicated non-standard problems on ordinary annuity plans
    - One level more complicated problems on sinking funds
    - One level more complicated non-standard problems on loans
    - Using Excel to find the principal part of a certain loan payment
    - Using Excel to find the interest part of a certain loan payment
    - Tricky problems on present values of annuities
    - OVERVIEW of my lessons on Finance section in this site

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

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 976 times.