Withdrawing balances from accounts

[Ray92]

Hi,

Below are two banks, Bank A and Bank B where i am intending to withdraw based on the annual increase in withdrawal of 3% starting at age 70. Everthing works ok for me and and I provided the formula below that i am working on. However, I could not get the formula out for withdrawal. Given that the withdrawal amount is not present here, how can I know how much I can withdraw till the balances in account depletes to $0 at age 80? Note that I wish to withdraw from Bank A first till it depletes to $0, then continue with Bank B.

Current age	60
Bank A balance	$180,000
Interest for Bank A	3%
Bank B balance	$150,000
Interest for Bank B	2.50%
First withdrawal age	70
Last withdrawal age	80
Annual increase in withdrawal	3%
Year	Age	Beginning balance of Bank A (1)	Draw-down from Bank A (2)	Interest credited to Bank A (3)	Beginning balance of Bank B (4)	Draw-down from Bank B (5)	Interest credited to Bank B (6)	Total draw-down 7 = (2+5)
1	60	$180,000	0	(1)-(2)*(B3)	$150,000	0	(4)-(5)*B5	0
2	61	(1)-(2)+(3)	0		(4)-(5)+(6)	0		0
3	62		0			0		0
4	63		0			0		0
5	64		0			0		0
6	65		0			0		0
7	66		0			0		0
8	67		0			0		0
9	68		0			0		0
10	69		0			0		0
11	70		-60000			0		-60000
12	71		-60000			0		-60000
13	72	$30,000	-30000			-30000		-60000
14	73		0			-60000		-60000
15	74		0			-60000		-60000
16	75		0			-60000		-60000
17	76		0			-60000		-60000
18	77		0			-60000		-60000
19	78		0			-60000		-60000
20	79		0			-60000		-60000
21	80		0			-60000		-60000

<colgroup><col><col span="8"></colgroup><tbody>
</tbody>

 

[Fluff]

Cross posted

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

This not the first time you have been caught. Please provide all relevant links.