Derek currently has $11,872.00 in an account that pays 4.00%. He will withdraw $5,149.00 every other...

Derek currently has $11,872.00 in an account that pays 4.00%. He will withdraw $5,149.00 every other year beginning next year until he has taken 8.00 withdrawals. He will deposit $11872.0 every other year beginning two years from today until he has made 8.0 deposits. How much will be in the account 30.00 years from today?

Answer format: Currency: Round to: 2 decimal places.

Expert Solution

The excel sheet below gives the account balance after 30 years.

All the working has been shown in the formula sheet. If you still have any query kindly ask in the comment section.

The account balance would be $159,240.26

The formula used are:

Note: Give it a thumbs up if it helps! Thanks in advance!

jeff jeffy answered 1 year ago

Derek currently has $10,109.00 in an account that pays 4.00%. He will withdraw $5,509.00 every other...

Derek currently has $10,109.00 in an account that pays 4.00%. He will withdraw $5,509.00 every other year beginning next year until he has taken 7.00 withdrawals. He will deposit $10109.0 every other year beginning two years from today until he has made 7.0 deposits. How much will be in the account 29.00 years from today?

Derek currently has $11,546.00 in an account that pays 4.00%. He will withdraw $5,196.00 every other...

Derek currently has $11,546.00 in an account that pays 4.00%. He will withdraw $5,196.00 every other year beginning next year until he has taken 7.00 withdrawals. He will deposit $11546.0 every other year beginning two years from today until he has made 7.0 deposits. How much will be in the account 23.00 years from today? PLEASE SHOW THE STEP HOW TO SOLVE THE QUESTION

Derek currently has $14,368.00 in an account that pays 4.00%. He will withdraw $5,867.00 every other...

Derek currently has $14,368.00 in an account that pays 4.00%. He will withdraw $5,867.00 every other year beginning next year until he has taken 6.00 withdrawals. He will deposit $14368.0 every other year beginning two years from today until he has made 6.0 deposits. How much will be in the account 24.00 years from today? round to 2 decimals

Derek currently has $10,486.00 in an account that pays 4.00%. He will withdraw $5,749.00 every other...

Derek currently has $10,486.00 in an account that pays 4.00%. He will withdraw $5,749.00 every other year beginning next year until he has taken 6.00 withdrawals. He will deposit $10486.0 every other year beginning two years from today until he has made 6.0 deposits. How much will be in the account 28.00 years from today?

Derek currently has $11,132.00 in an account that pays 4.00%. He will withdraw $5,347.00 every other...

Derek currently has $11,132.00 in an account that pays 4.00%. He will withdraw $5,347.00 every other year beginning next year until he has taken 4.00 withdrawals. He will deposit $11132.0 every other year beginning two years from today until he has made 4.0 deposits. How much will be in the account 23.00 years from today?

Derek currently has $12,527.00 in an account that pays 4.00%. He will withdraw $5,639.00 every other...

Derek currently has $12,527.00 in an account that pays 4.00%. He will withdraw $5,639.00 every other year beginning next year until he has taken 5.00 withdrawals. He will deposit $12527.0 every other year beginning two years from today until he has made 5.0 deposits. How much will be in the account 27.00 years from today? *PLEASE SHOW ON FINANCE CALCULATOR IF POSSIBLE*

1.Derek currently has $11,020.00 in an account that pays 4.00%. He will withdraw $5,597.00 every other...

1.Derek currently has $11,020.00 in an account that pays 4.00%. He will withdraw $5,597.00 every other year beginning next year until he has taken 4.00 withdrawals. He will deposit $11020.0 every other year beginning two years from today until he has made 4.0 deposits. How much will be in the account 24.00 years from today? 2. Derek currently has $12,878.00 in an account that pays 6.00%. He will withdraw $5,256.00 every other year beginning next year until he has taken...

Derek currently has $10,761.00 in an account that pays 5.00%. He will withdraw $5,643.00 every other...

Derek currently has $10,761.00 in an account that pays 5.00%. He will withdraw $5,643.00 every other year beginning next year until he has taken 6.00 withdrawals. He will deposit $10761.0 every other year beginning two years from today until he has made 6.0 deposits. How much will be in the account 28.00 years from today?

Derek currently has $12,018.00 in an account that pays 5.00%. He will withdraw $5,543.00 every other...

Derek currently has $12,018.00 in an account that pays 5.00%. He will withdraw $5,543.00 every other year beginning next year until he has taken 8.00 withdrawals. He will deposit $12018.0 every other year beginning two years from today until he has made 8.0 deposits. How much will be in the account 28.00 years from today?

Derek currently has $11,916.00 in an account that pays 6.00%. He will withdraw $5,627.00 every other...

Derek currently has $11,916.00 in an account that pays 6.00%. He will withdraw $5,627.00 every other year beginning next year until he has taken 4.00 withdrawals. He will deposit $11916.0 every other year beginning two years from today until he has made 4.0 deposits. How much will be in the account 28.00 years from today?

Question