Using Formula in the Excel Sheet
N = NPER(8%,50000,-500000,0,0)
We get the answer as follows
10. Your mother has $500,000 invested at 8.0%, and she now wants to retire. She wants...
Your Aunt Ruth has $450,000 invested at 6.5%, and she plans to retire. She wants to withdraw $40,000 at the beginning of each year, starting immediately. How many years will it take to exhaust her funds, i.e., run the account down to zero?
Your aunt has $440,000 invested at 5.5%, and she now wants to retire. She wants to withdraw $45,000 at the beginning of each year, beginningimmediately. She also wants to have $50,000 left to give you when she ceases to withdraw funds from the account. For how many years can she make the $45,000 withdrawals and still have $50,000 left in the end? a. 14.37 b. 16.38 c. 13.93 d. 12.50 e. 11.35
You have $375,000 invested at 7.5% and now you want to retire. You want to withdraw $35,000 at the end of each year, beginning at the end of this year. How many years will it take to exhaust your fund and run it down to $0?
Your aunt wants to retire and has $375,000. She expects to live for another 25 years, and she also expects to earn 7.5% on her invested funds. How much could she withdraw at the beginning of each of the next 25 years and end up with zero in the account? a. $29,729.70 b. $32,859.14 c. $34,502.10 d. $31,294.42 e. $28,243.21
Your uncle has $500,000 and wants to retire. He expects to live for another 20 years, and he also expects to earn 5% on his invested funds. How much could he withdraw at the beginning of each of the next 20 years and end up with zero in the account? $40,474.12 $39,617.22 $39,259.89 38,210.76 $37,759.46
Your father has $400000 invested at 7 percent, and he wants to retire. He plans to withdraw $55000 at the beginning of each year, starting now. How long will it take to exhaust his funds, i.e., run the account down to zero? Your Answer: Answer units Question 19 (4 points) You have just won a lottery that promises to pay you and your heirs $3500 per year forever, beginning in one year. Since you desperately need the cash today, for...
Jody wants to travel at the time when her bank account has $11,675, and she needs to withdraw from her account $2,085 at the end of each six months for the travel expenses while she travels until no fund remains in her account. Jody would like to know for how long (in years) she can withdraw $2,085 from her account at the end of every six months if interest is 4% compounded quarterly. Answer the following question: Which TVM variable...
Problem #8 (TVM): Tom's best friend, Joe, works for a company that was just acquired. He lost hi job. Joe was given a severance payment of $365,000, which he invested at a 7.5% annual rate. He now plans to retire, and he wants to withdraw $35,000 at the end of each year, starting at the end of this year. How many years will it take to exhaust his funds, i.e., run the account down to zero?
You have $3,200 invested at 7%. You want to withdraw $8,000 at the end of each year, starting at the end of this year. How many years will it take to exhaust your funds, i.e., run the account down to zero?
Jody wants to travel at the time when her bank account has $11,675, and she needs to withdraw from her account $2,085 at the end of each six months for the travel expenses while she travels until no fund remains in her account. Jody would like to know for how long (in years) she can withdraw $2,085 from her account at the end of every six months if interest is 4% compounded quarterly. Answer the following question: What variable does...