1 answer

Please solve in word format instead of excel Answer the question. $100,000 was deposited in a...

Question:

please solve in word format instead of excel
Answer the question. $100,000 was deposited in a savings account 8 years ago, and the account earned interest at the rate of
Answer the question. $100,000 was deposited in a savings account 8 years ago, and the account earned interest at the rate of 10% per year. Assuming the end-of-the-year convention, what is the amount of equal annual withdrawals that can be made to completely deplete the fund 15 years from now if the first withdrawal will be made one year from today? I B Fi Initial Deposit $100,000,00 (P)

Answers

Amount Deposited 8 Years ago = X = $100000

Interest Rate = r = 10%

Number of Years = m = 8

Value of Investment now = PV = X(1+r)m = 100000(1+0.10)8 = $214358.881

Let the amount withdrawn each year be P

Number of withdrawals = n = 15

Present Value of the amount = PV = $214358.881

Interest Rate = r = 10%

The present value of all the future withdrawals should be equal to the present value of the amount

=> PV = P/(1+r) + P/(1+r)2 +....+ P/(1+r)n = P[1- (1+r)-n]/r

=> 214358.881 = P[1- (1+0.10)-15]/0.10

=> P = 214358.881*0.10/[1- (1+0.10)-15] = $28182.57

Hence $28,182.57 can be withdrawn each year

.

Similar Solved Questions

1 answer
Fill in all the blanks responsible for most of the high level mental functions. 4. The...
Fill in all the blanks responsible for most of the high level mental functions. 4. The is a long narrow cable of nervous tissue within the __ pairs of spinal nerves originate fron the _ Spinal nreves are nerves that provide communication between the and the 5. The chronic metabolic disorder of i...
1 answer
16. (10 points) Bipolar pulse signals, s(t) (i -1,2), of amplitude +1 V are received in...
16. (10 points) Bipolar pulse signals, s(t) (i -1,2), of amplitude +1 V are received in the presence of AWGN that has a variance of 0.1V2. Determine the optimum (minimum probability of error) detection threshold, yo, for matched filter detection if the a priori probabilities are: a) P(si) 0.5 b) P(s...
1 answer
Preadsheet/output. · Portfolio Separation a. What is two-fund portfolio separation and why is it important? b. What are...
preadsheet/output. · Portfolio Separation a. What is two-fund portfolio separation and why is it important? b. What are the assumptions that need to hold in order for two-fund separation to apply...
1 answer
Please try to answer every question. Question 5: Complete the energy range values for the 3...
please try to answer every question. Question 5: Complete the energy range values for the 3 orbital (2 excited state of Hydrogen. The electron can be placed in the 3 orbital by manually dragging the electron or firing an photon once when the electron is in the ground state. Note also that the electr...
1 answer
Tional Park Tours during May 2019, its first month of operations, are indicated in Trial Balance...
tional Park Tours during May 2019, its first month of operations, are indicated in Trial Balance National Park Tours Co. is a travel agency. The nine transactions the following T accounts: Cash Equipment (1) 27,300(2) 1,900 (3) 19,700 (7) 10,900|(3) 3,550 (4) 3,000 (6) 8,200 (9) 2,700 Beth Worley, D...
1 answer
Q4. Draw the shear bending moment diagram of the beam shown. 100 kN 100 kN/m 60...
Q4. Draw the shear bending moment diagram of the beam shown. 100 kN 100 kN/m 60 KN/m 40 kN/m 2m 85 kN 275 KN...
1 answer
The equilibrium constant for the chemical equation N2(g) 3 H2(g)2NH3 (g) is Kp = 0.0146 at...
The equilibrium constant for the chemical equation N2(g) 3 H2(g)2NH3 (g) is Kp = 0.0146 at 183 oC. Calculate the value of Kc for the reaction at 183 °C....
1 answer
- -- - --10--- The region R is bounded by the curves y = 3.x, y...
- -- - --10--- The region R is bounded by the curves y = 3.x, y = 9 - 22, and the y-axis, and its density is 8(x, y) = sy. To find the center of gravity of the pd (3) pdf92) pd 9() region you would compute 8(2,y)dA=1 62, y)dydx, 28(2,y)dydx, and 1 y(x,y)dyd. where Jc Jp(x) Je Jp(2) Jp(2) c= d= p(2) ...
1 answer
Question 1 (1 point) What is the sum of the coefficients when the following is balanced:...
Question 1 (1 point) What is the sum of the coefficients when the following is balanced: Al + Fe2O3 --> Al2O3 + Fe 04 O 12 09 08 Question 2 (1 point) A (9.45x10^1).00 g sample of lithium reacts with an excess of chlorine to form lithium chloride. What mass of lithium chloride forms? Note: Your an...
1 answer
21 0 Required information A new advertising campaign by a company that manufactures products that apply biometric, surveillance, and satellite technologies resulted in the cash flows shown. Part...
21 0 Required information A new advertising campaign by a company that manufactures products that apply biometric, surveillance, and satellite technologies resulted in the cash flows shown. Part 3 of 3 Year Cash Flow, $1000 2000 10 points 0 -4000 3000 2000 eBook Print Calculate the unique external r...
1 answer
Bare Trees United issued 20-year bonds 3 years ago at a coupon rate of 8.5 percent....
Bare Trees United issued 20-year bonds 3 years ago at a coupon rate of 8.5 percent. The bonds make semiannual payments. If these bonds currently sell for 91.4 percent of par value, what is the YTM? Multiple Choice 8.98 percent 9.53 percent 9.13 percent 9.27 percent 8.42 percent...
1 answer
Need help. please explain Mixture FeSCN Absorbance O-149 O-250 O-314 O.432 O.521 1 3 Caloudations xperiment...
need help. please explain Mixture FeSCN Absorbance O-149 O-250 O-314 O.432 O.521 1 3 Caloudations xperiment 23. z046 Lab Complete the tables below for each of the five mixtures you prepared. You may use this page to replace the data pages for Expt. # 23 that appear in your lab manual. Mixture #...
1 answer
Home / study / business / economics / economics questions and answers / 4. indicate what...
home / study / business / economics / economics questions and answers / 4. indicate what would happen to both m1 and m2 (increase, decrease, no change) due to each ... Question: 4. Indicate what would happen to both M1 and M2 (increase, decrease, no change) due to each of th... 4. Indicate what woul...
1 answer
Assume that the differences are normally distributed. Complete parts (a) through (d) below. 1 4 5...
Assume that the differences are normally distributed. Complete parts (a) through (d) below. 1 4 5 7 8 Observation X 2 49.1 3 44.6 6 50.8 46.0 49.8 48.8 46.7 50.0 Y 49.4 47.6 46.8 54.6 50.4 50.4 46.8 52.7 (a) Determine d =X-Y for each pair of data. 1 3 4 5 6 7 8 Observation 2 d; (Type integers or dec...
1 answer
What is the degree of #16x^4yz + 12x^2y^3z - 24x^3y^2z - 18xy^4z#?
What is the degree of #16x^4yz + 12x^2y^3z - 24x^3y^2z - 18xy^4z#?...