Question

In: Finance

Question 1 John made equal monthly (end-of-the-month) deposits into an account for 10 years (total of...

Question 1 John made equal monthly (end-of-the-month) deposits into an account for 10 years (total of 120 deposits). He then made equal monthly (end-of-month) withdrawals (the first withdrawal occurs one month after the last deposit) of $1,000 for the next 12 years (total of 144 withdrawals), reducing the balance to zero. The account pays 8.4 percent per year compounded monthly. What was the monthly deposit?

Solutions

Expert Solution

ANSWER DOWN BELOW. FEEL FREE TO ASK ANY DOUBTS. THUMBS UP PLEASE.

Using Financial calculator:

N= 144

I/Y = 8.4/12 = 0.7

PMT = -1000

CPT Press PV = 90,538.29

(Amount needed at t=10)

N= 120

I/Y= 0.7

FV = -90,538.29

CPT Press PMT = 483.94

The amount you need to contribute each month is = $483.94

(ANSWER)

Normal method:

Formula: The present value of an ordinary annuity (PV)

PV = C× [1-(1+r)^-n]/r

PV = Present value (The cummulative amount available at Present)

C= Periodic cash flow.

r =effective interest rate for the period.

n = number of periods.

PV = 1000× [1-(1+0.007)^144-]/0.007

PV = 90,538.29

Formula: The Future Value of an ordinary annuity (FV)

FV= C× {[(1+r)^n]-1}/r

FV = Future value (The cummulative amount available in Future)

C= Periodic cash out flow.

r =effective interest rate for the period.

n = number of periods.

90,538.29= C× {[(1+0.007)^120]-1}/0.007

C= $483.94

The amount you need to contribute each month is =$483.94 (ANSWER)


Related Solutions

John made equal monthly (end-of-the month) deposits into an account for 10 years (total of 120...
John made equal monthly (end-of-the month) deposits into an account for 10 years (total of 120 deposits). He then made equal monthly (end-of month) withdrawals (the first withdrawal occurs one month after the last deposit) of $1,000 for the next 12 years (total of 144 withdrawals), reducing the balance to zero. The account pays 8.4 percent per year compounded monthly. What was the monthly deposit?
brandon wishes to accumulate 100,000 by making level monthly end of month deposits for 30 years...
brandon wishes to accumulate 100,000 by making level monthly end of month deposits for 30 years into an account that earns 5.4% interest convertible monthly. after 10 years the interest rate increases to 6.6% convertible monthly. what should brandons new deposit amount be if he wishes to accumulate 100,000 at the end of 30 years?
$1,000 deposits are made into an investment account at the end of year 1, 2, and 3
$1,000 deposits are made into an investment account at the end of year 1, 2, and 3. No deposit was made in year 4. Interest accrues at 5.0% monthly. What is the balance in the account at the end of Year 5?$3,666$3,487$3,476$3,649
A payment of $110 was made at the end of each month for 4 years into a savings account. The interest rate on the account is 5.4% compounded monthly. What’s the interested earned on the account?
A payment of $110 was made at the end of each month for 4 years into a savings account. The interest rate on the account is 5.4% compounded monthly. What’s the interested earned on the account?
A series of 10 end-of-year deposits is made that begins with $9,000 at the end of...
A series of 10 end-of-year deposits is made that begins with $9,000 at the end of year 1 and decreases at the rate of $300 per year with 8% interest. What amount could be withdrawn at t = 10? Type your answer here Round entry to the nearest dollar. Tolerance is ±4. Do it by hand and show your work please.
A series of 10 end-of-year deposits is made that begins with$6,000 at the end of...
A series of 10 end-of-year deposits is made that begins with $6,000 at the end of year 1 and decreases at the rate of $300 per year with 11% interest.What amount could be withdrawn at t = 10? $
A series of 10 end-of-year deposits is made that begins with $6,500 at the end of...
A series of 10 end-of-year deposits is made that begins with $6,500 at the end of year 1 and decreases at the rate of $300 per year with 8% interest. a. What amount could be withdrawn at t = 10? b. What uniform annual series of deposits (n = 10) would result in the same accumulated balance at the end of year 10? I would like to be able to use excel functions to solve this rather than by hand....
You make deposits at the end of each month into an account earning interest at a...
You make deposits at the end of each month into an account earning interest at a rate of 6%/year compounded monthly. Your deposits will be $2000/month in the first year, $2200/month in the second year, $2420/month in the third year, $2662 in the fourth year, and so on. How much will be in your account at the end of 40 years? No Excel answers please.
A person deposits $60 at the end of each month in an account which earns 12.5%...
A person deposits $60 at the end of each month in an account which earns 12.5% compounded monthly for 17 years. The person then stops making the deposits, but allows the money to remain in the bank earning the same interest for 5 more years. a. Find the value of this account at the end of 22 years. $ b. State the total amount of interest earned on this account. $
3. Jose deposits $150 at the end of each month into an account that pays 6%...
3. Jose deposits $150 at the end of each month into an account that pays 6% interest compounded monthly . After 8 years of deposits, what is the account balance?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT