I have $500,000 in the bank now. I plan to withdraw $30,000 at the end of...

I have $500,000 in the bank now. I plan to withdraw $30,000 at the end of this year. Each subsequent end of year withdrawal will increase by 7%. If I earn 8% per year on my investments in the first 4 years, then 6% per year in the next 3 years, and 5% per year in the following 4 years,
1. Determine how much money I will have at the end of 11 years.
2. Determine the initial withdrawal amount at the end of this year that will leave me with no money at the end of 11 years using either Solver or Goal Seek.

Expert Solution

A.

Years	Total Amt.	Incremental Factor for Investment = 1+Rate of Interest	Amt. @ end of the year	Incremental Factor for Withdrawl = 1+Rate of Increase	Withdrawl @ end of the year	Net Amt. @ end of the year
1	500,000	1.08	540,000	1.00	30,000	510,000
2	510,000	1.08	550,800	1.07	32,100	518,700
3	518,700	1.08	560,196	1.07	34,347	525,849
4	525,849	1.08	567,917	1.07	36,751	531,166
5	531,166	1.06	563,036	1.07	39,324	523,712
6	523,712	1.06	555,134	1.07	42,077	513,058
7	513,058	1.06	543,841	1.07	45,022	498,819
8	498,819	1.05	523,760	1.07	48,173	475,587
9	475,587	1.05	499,366	1.07	51,546	447,821
10	447,821	1.05	470,212	1.07	55,154	415,058
11	415,058	1.05	435,811	1.07	59,015	376,796

B.

Using goal seek function as per below screenshot the answer will be $48,592

Years	Total Amt.	Incremental Factor for Investment = 1+Rate of Interest	Amt. @ end of the year	Incremental Factor for Withdrawl = 1+Rate of Increase	Withdrawl @ end of the year	Net Amt. @ end of the year
1	500,000	1.08	540,000	1.00	48,592	491,408
2	491,408	1.08	530,720	1.07	51,994	478,726
3	478,726	1.08	517,024	1.07	55,633	461,391
4	461,391	1.08	498,302	1.07	59,528	438,775
5	438,775	1.06	465,101	1.07	63,695	401,406
6	401,406	1.06	425,491	1.07	68,153	357,337
7	357,337	1.06	378,778	1.07	72,924	305,854
8	305,854	1.05	321,146	1.07	78,029	243,118
9	243,118	1.05	255,273	1.07	83,491	171,783
10	171,783	1.05	180,372	1.07	89,335	91,037
11	91,037	1.05	95,589	1.07	95,589	(0)

jeff jeffy answered 1 year ago

I have $400,000 in the bank now. I plan to withdraw $20,000 at the end of...

I have $400,000 in the bank now. I plan to withdraw $20,000 at the end of this year. Each subsequent end of year withdrawal will increase by 8%. If I earn 10% per year on my investments in the first 3 years, then 5% per year in the next 2 years, and 4% per year in the following 3 years, Determine how much money I will have at the end of 8 years. Determine the initial withdrawal amount at the...

You want to withdraw $19883 two years from now. Calculate the amount of end-of-period bi-weekly payments...

You want to withdraw $19883 two years from now. Calculate the amount of end-of-period bi-weekly payments that you need to make, if the (nominal) interest rate is 1.5% per year. Assume bi-weekly compounding.

How much money will I need to have at retirement so I can withdraw $60,000 a...

How much money will I need to have at retirement so I can withdraw $60,000 a year for 20 years from an account earning 8% compounded annually? a. How much do you need in your account at the beginning? b. How much total money will you pull out of the account? c. How much of that money is interest?

You want to be able to withdraw $30,000 from youraccount each year for 25 years...

You want to be able to withdraw $30,000 from your account each year for 25 years after you retire. If you expect to retire in 20 years and your account earns 6.1% interest while saving for retirement and 5% interest while retired:Round your answers to the nearest cent as needed.a) How much will you need to have when you retire? $ b) How much will you need to deposit each month until retirement to achieve your retirement goals?$ c) How much did you...

Suppose you have $800,000 in your savings account when you retire. Your plan is to withdraw...

Suppose you have $800,000 in your savings account when you retire. Your plan is to withdraw $6,000 a month as retirement income from this account. You expect to earn annual interest of 6 percent, compounded monthly, on your money during your retirement. How many months can you be retired until you run out of money? a. 285.14 b. 210.83 c. 262.59 d. 220.27 The dividends paid by a corporation a. are tax-deductible, i.e., reduce the taxable income of the corporation...

5. You plan to deposit $500 into a bank account now (year 0), $300 in year...

5. You plan to deposit $500 into a bank account now (year 0), $300 in year 2, and $1000 in year 4. How much money will be in your account in year 7, if the annual interest rate is 5%? a. 2,345 b. 2,244 c. 2,175 d. 2,500 6. If the interest rate is 6.5%, calculate the present value of $5000 paid annually over the next 25 years a. 69,899 b. 65,798 c. 60,898 d. 60,989

You want to be able to withdraw $30,000 each year for 20 years. Your account earns...

You want to be able to withdraw $30,000 each year for 20 years. Your account earns 8% interest. a) How much do you need in your account at the beginning? $ b) How much total money will you pull out of the account? $ c) How much of that money is interest? $

You want to be able to withdraw $30,000 from your account each year for 20 years...

You want to be able to withdraw $30,000 from your account each year for 20 years after you retire. If you expect to retire in 30 years and your account earns 4.8% interest while saving for retirement and 4.7% interest while retired: Round your answers to the nearest cent as needed. a) How much will you need to have when you retire? $ b) How much will you need to deposit each month until retirement to achieve your retirement goals?...

You plan to open a bank account by depositing $500 today and end of each year...

You plan to open a bank account by depositing $500 today and end of each year for the next nine years (year 1, year 2, ……. year 9). If the interest rate is 2%, what will be your balance in ten years? show workings in excel file

An investment pays $20,000 at the end of year 2, $30,000 at the end of year...

An investment pays $20,000 at the end of year 2, $30,000 at the end of year 4 and $X at the end of year 8. At an annual effective rate of 8.5%, the modified duration of this cash flow is 5.51704. Calculate X (round your answer to integer). Ans should be one of these: Numerical answers (in random order) 6.955, 0.062, 4.5228, 6538.49, 0.04317, 2660.67, 50000, 400.36, 202.1, 3671.29, 1951.62, 4.4621. please show all work and do not use excel...

Question