Question

In: Finance

Derek wants to withdraw $11,575.00 from his account 3.00 years from today and $13,908.00 from his...

Derek wants to withdraw $11,575.00 from his account 3.00 years from today and $13,908.00 from his account 12.00 years from today. He currently has $2,838.00 in the account. How much must he deposit each year for the next 12.0 years? Assume a 6.69% interest rate. His account must equal zero by year 12.0 but may be negative prior to that. Currency: Round to: 2 decimal places.

Solutions

Expert Solution

rate = 6.69%

nper = 3

PMT = 0

FV = $11575

Using Excel :

PV = pv(rate,nper,pmt,pv,fv)

      = pv(6.69%,3,0,-11575)

      = $9531.25

rate = 6.69%

nper= 12

PMT = 0

FV = $13908

PV = pv(rate,nper,pmt,pv,fv)

      = pv(6.69%,12,0,-13908)

      = $6394.11

Rate = 6.69%

Nper = 12

PV = $9531.25+$6394.11-$2838 = $18763.36

FV = 0

PMT = pmt(rate,nper,pv,fv)

         = pmt(6.69%,12,-18763.36,0)

         = $2323.47

He must deposit $2323.47 each for the next 12 years


Related Solutions

Derek wants to withdraw $11,886.00 from his account 3.00 years from today and $12,955.00 from his...
Derek wants to withdraw $11,886.00 from his account 3.00 years from today and $12,955.00 from his account 14.00 years from today. He currently has $2,195.00 in the account. How much must he deposit each year for the next 14.0 years? Assume a 5.19% interest rate. His account must equal zero by year 14.0 but may be negative prior to that. Please use a financial calculator and show steps please
Derek wants to withdraw $13,890.00 from his account 3.00 years from today and $12,808.00 from his...
Derek wants to withdraw $13,890.00 from his account 3.00 years from today and $12,808.00 from his account 15.00 years from today. He currently has $2,268.00 in the account. How much must he deposit each year for the next 15.0 years? Assume a 5.06% interest rate. His account must equal zero by year 15.0 but may be negative prior to that. Answer format: Currency: Round to: 2 decimal places. Derek currently has $13,029.00 in an account that pays 4.00%. He will...
Derek wants to withdraw $11,575.00 from his account 3.00 yearsfrom today and $13,908.00 from his...
Derek wants to withdraw $11,575.00 from his account 3.00 years from today and $13,908.00 from his account 12.00 years from today. He currently has $2,838.00 in the account. How much must he deposit each year for the next 12.0 years? Assume a 6.69% interest rate. His account must equal zero by year 12.0 but may be negative prior to that. Currency: Round to: 2 decimal places.
Derek wants to withdraw $13,242.00 from his account 4.00 years from today and $13,962.00 from his...
Derek wants to withdraw $13,242.00 from his account 4.00 years from today and $13,962.00 from his account 14.00 years from today. He currently has $3,676.00 in the account. How much must he deposit each year for the next 14.0 years? Assume a 5.93% interest rate. His account must equal zero by year 14.0 but may be negative prior to that. round answer 2 decimal places
Derek wants to withdraw $11,935.00 from his account 4.00 years from today and $13,226.00 from his...
Derek wants to withdraw $11,935.00 from his account 4.00 years from today and $13,226.00 from his account 14.00 years from today. He currently has $2,428.00 in the account. How much must he deposit each year for the next 14.0 years? Assume a 5.06% interest rate. His account must equal zero by year 14.0 but may be negative prior to that.
Derek wants to withdraw $13,149.00 from his account 7.00 years from today and $12,556.00 from his...
Derek wants to withdraw $13,149.00 from his account 7.00 years from today and $12,556.00 from his account 15.00 years from today. He currently has $2,480.00 in the account. How much must he deposit each year for the next 15.0 years? Assume a 5.42% interest rate. His account must equal zero by year 15.0 but may be negative prior to that.
1. Derek wants to withdraw $12,424.00 from his account 5.00 years from today and $12,469.00 from...
1. Derek wants to withdraw $12,424.00 from his account 5.00 years from today and $12,469.00 from his account 11.00 years from today. He currently has $3,967.00 in the account. How much must he deposit each year for the next 11.0 years? Assume a 6.98% interest rate. His account must equal zero by year 11.0 but may be negative prior to that. Answer Format: Currency: Round to: 2 decimal places. 2. Derek currently has $13,919.00 in an account that pays 6.00%....
1. Derek wants to withdraw $13,105.00 from his account 6.00 years from today and $12,140.00 from...
1. Derek wants to withdraw $13,105.00 from his account 6.00 years from today and $12,140.00 from his account 14.00 years from today. He currently has $3,215.00 in the account. How much must he deposit each year for the next 14.0 years? Assume a 6.63% interest rate. His account must equal zero by year 14.0 but may be negative prior to that. Answer Format: Currency: Round to: 2 decimal places. 2. Derek currently has $14,133.00 in an account that pays 5.00%....
August Street, Inc. wants to have $7,500,000 in an account exactly 16 years from today. They...
August Street, Inc. wants to have $7,500,000 in an account exactly 16 years from today. They will make equal quarterly payments of $50,000 beginning next quarter and ending in 16 years. The account earns 8.00% p.a., compounded quarterly. August Street must have $_______ in its account today.
Derek currently has $10,365.00 in an account that pays 6.00%. Hewill withdraw $5,192.00 every other...
Derek currently has $10,365.00 in an account that pays 6.00%. He will withdraw $5,192.00 every other year beginning next year until he has taken 7.00 withdrawals. He will deposit $10365.0 every other year beginning two years from today until he has made 7.0 deposits. How much will be in the account 22.00 years from today?Currency: Round to: 2 decimal places.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT