What is the amount of 20 equal annual deposits that can provide 40 annual withdrawals when...

What is the amount of 20 equal annual deposits that can provide 40 annual withdrawals when a first withdrawal of $2,000 is made at the end of year 21 and subsequent withdrawals increase at the rate of 3 % per year over the previous year’s withdrawal. Determine the deposit amounts based on the interest rate of 7 % compounded annually.

Expert Solution

Withdrawal per annum = $2,000

Rate of increase in withdrawal = 3%

Interest rate = 7%

Present Value of the withdrawals as at Year 21:

Year	Withdrawal	PVF (7%)	PV of Withdrawal
21	$2,000	0.934579439	$1,869.16
22	$2,060	0.873438728	$1,799.28
23	$2,122	0.816297877	$1,732.02
24	$2,185	0.762895212	$1,667.27
25	$2,251	0.712986179	$1,604.94
26	$2,319	0.666342224	$1,544.95
27	$2,388	0.622749742	$1,487.19
28	$2,460	0.582009105	$1,431.60
29	$2,534	0.543933743	$1,378.08
30	$2,610	0.508349292	$1,326.56
31	$2,688	0.475092796	$1,276.97
32	$2,768	0.444011959	$1,229.23
33	$2,852	0.414964448	$1,183.28
34	$2,937	0.387817241	$1,139.05
35	$3,025	0.36244602	$1,096.46
36	$3,116	0.338734598	$1,055.47
37	$3,209	0.31657439	$1,016.02
38	$3,306	0.295863916	$978.04
39	$3,405	0.276508333	$941.47
40	$3,507	0.258419003	$906.28
41	$3,612	0.241513087	$872.40
42	$3,721	0.225713165	$839.79
43	$3,832	0.210946883	$808.39
44	$3,947	0.19714662	$778.17
45	$4,066	0.184249178	$749.08
46	$4,188	0.172195493	$721.08
47	$4,313	0.160930367	$694.12
48	$4,443	0.150402212	$668.17
49	$4,576	0.140562815	$643.20
50	$4,713	0.131367117	$619.15
51	$4,855	0.122773007	$596.00
52	$5,000	0.114741128	$573.72
53	$5,150	0.107234699	$552.28
54	$5,305	0.100219345	$531.63
55	$5,464	0.093662939	$511.76
56	$5,628	0.087535457	$492.63
57	$5,797	0.081808838	$474.21
58	$5,970	0.076456858	$456.48
59	$6,150	0.071455008	$439.42
60	$6,334	0.066780381	$422.99
			$39,107.99

Future value of Deposits = Present Value of withdrawals

Annual Deposit * FVAD(7%, 20) = $39,107.99

Annual Deposit * 43.86517678 = $39,107.99

Annual Deposit = $39,107.99 / 43.86517678

Annual Deposit = $891.5498

ekkarill92 answered 3 years ago

What is the amount of six equal annual deposits that can provide ten annual withdrawals, where...

What is the amount of six equal annual deposits that can provide ten annual withdrawals, where a first withdrawal of $22332 is made at the end of year seven and subsequent withdrawals increase at $2092 over the previous year, at an interest rate of 5% compounded annually?

What equal annual amount must be deposited for 10 years in order to provide withdrawals of...

What equal annual amount must be deposited for 10 years in order to provide withdrawals of $200 at the end of the second year and increasing by 25% per year until the end of tenth year? The interest rate is 10% compounded annually.

You will retire in 40 years. At that time you will begin making annual withdrawals and...

You will retire in 40 years. At that time you will begin making annual withdrawals and the first withdrawal will need to have the purchasing power that $127,849 has today. You will withdraw the same amount of money each year of retirement (and you recognize that its purchasing power will fall as inflation continues). You plan to live for 24 years during retirement, necessitating 24 withdrawals. Inflation equals 6% per year. Obviously, you will need to save (and invest) money...

A bank’s daily withdrawals and deposits over the last 12 months is indicated a. What net...

A bank’s daily withdrawals and deposits over the last 12 months is indicated a. What net deposit drain has a probability of 1.5%? b. What net deposit drain has a probability of 2%? c. What is probability of a one-day net deposit drain in excess of $30.00? deposits (000) withdrawals (000) 356 180 320 277 356 336 237 316 178 174 101 324 325 337 335 309 92 42 392 286 336 181 272 361 72 351 261 239 333...

(1)If the Fed wishes to increase the amount of deposits that banks hold, it can A ...

(1)If the Fed wishes to increase the amount of deposits that banks hold, it can A force banks by decree to do so. B buy government bonds in an open market operation. C sell domestic deposits to foreign investors. D sell government bonds in an open market operation. (2)According to the quantity equation of money, in the long run, an increase in the growth of the money supply will A increase inflation by the larger amount if velocity decreases. B ...

What amount of money should be set aside today to provide 40 payments of $10,000 every...

What amount of money should be set aside today to provide 40 payments of $10,000 every six months if the first payment is to be made in 20 years from now and money is invested at 9% compounded semiannually? Cannot use Excel

Two particles with equal de Broglie wavelength can have equal speed, equal kinetic energy, equal amount...

Two particles with equal de Broglie wavelength can have equal speed, equal kinetic energy, equal amount of movement and equal frequency?

Anne Simpson wants to have $1,400,000 in 50 years by making equal annual end-of-the-year deposits into...

Anne Simpson wants to have $1,400,000 in 50 years by making equal annual end-of-the-year deposits into a tax-deferred account paying 11.75 percent annually. What must Anne's annual deposit be? The amount of Anne's annual deposit must be $__ Round to the nearest cent

Lisa Simpson wants to have $1,400,000 in 30 years by making equal annual end-of-the-year deposits into...

Lisa Simpson wants to have $1,400,000 in 30 years by making equal annual end-of-the-year deposits into a tax-deferred account paying 11.75 percent annually. What must Lisa's annual deposit be?

You take out a loan in the amount of $260,000 with annual equal repayments over the...

You take out a loan in the amount of $260,000 with annual equal repayments over the next 20years. What is the balance of the loan after the 5th payment? i = 6%

Question