Show all work

Q15. You are planning your retirement in 30 years. You currently have $0 in a savings account and $0 in a stock account. You plan to add $40,000 per year to your savings account and also add $10,000 to your stock account at the end of each of the next 30 years. The stock account will earn a return of 6 percent and the savings account will earn a return of 1.5 percent. When you retire, you plan to withdraw an equal amount for each of the next 25 years at the end of each year and have nothing left. Additionally, when you retire you will transfer your money to an account that earns 5 percent. How much can you withdraw each year? 0 30 55 Withdrawal of ??? @ 5% (1) Savings: 40,000 @ 1.5% (2) Stock: 10.000 @ 6% Step 1. FV of savings and stock account (1) Savings: 30 N; 1.5I/Y; -40,000 PMT CPT FV: 1,505,547.25 (2) Stock: 30 N; 6I/Y; -10,000 PMT CPT FV: 790,581.86 (1) + (2) = $1,505,547.25 + $790,581.86= $2,292,129.12 Step 2. Post-retirement withdrawal (CPT PMT) 25 N; 5 I/Y;-2292129.12 PV CPT PMT: 162,632.19