Your uncle has $320,000 invested at 7.5%, and he now wants to retire. He wants...

Your uncle has $320,000 invested at 7.5%, and he now wants to retire. He wants to withdraw $35,000 at the end of each year, starting at the end of this year. He also wants to have $25,000 left to give you when he ceases to withdraw funds from the account. For how many years can he make the $35,000 withdrawals and still have $25,000 left in the end?

a.	12 years
b.	16 years
c.	15 years
d.	17 years
e.	19 years

Solutions

Expert Solution

Present Value of amount Invested = $320,000

Periodic Withdrawal at the end of each year = $35,000

Future Value to left to give you when he ceases to withdraw funds = $25,000

Calculating the number of years he can make the withdrawal and still have future left using Excel "NPER" function:-

So, the number of years he can make the withdrawal and still have future left is 16.73 years

Option D. 17 years(rounding off the decimal to nearest year)

If you need any clarification, you can ask in comments.

If you like my answer, then please up-vote as it will be motivating

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

1) Your uncle has $300,000 invested at 7.5%, per annum and he now wants to retire....

1) Your uncle has $300,000 invested at 7.5%, per annum and he now wants to retire. He wants to withdraw $35,000 at the beginning of each year, starting immediately. He also wants to have $25,000 left to give Katya when he ceases to withdraw funds from the account. For how many years can he make the $35,000 withdrawals and still have $25,000 left in the end? a. 15 b. 13.5 c. 13.5 d.11.9 2. Which statements is TRUE? a, firms...

Your uncle has 431,000 invested at 6.8% and he now wants to retire. He plans to...

Your uncle has 431,000 invested at 6.8% and he now wants to retire. He plans to withdraw $40,000 at the end of each year, beginning this year. How many years will it take to exhaust his funds, i.e., run the account down to zero?

Your aunt has $780,000 invested at 5.5%, and she now wants to retire. She wants to...

Your aunt has $780,000 invested at 5.5%, and she now wants to retire. She wants to withdraw $45,000 at the beginning of each year, beginning immediately. 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?

Your uncle has $300,000 today. Assume he can earn 9.18% on his investments. He now wants...

Your uncle has $300,000 today. Assume he can earn 9.18% on his investments. He now wants to retire in 10 years. Here is his situation: a. He wants to withdraw $35,000 every two years, beginning 12 years from today for 10 equal, every two-year (i.e. every other year) withdrawals. b. He has to pay for his daughter’s college beginning in 5 years at $20,000 for four years (i.e. he has to make a payment in year 5, 6, 7, and...

Uncle Bob is about to retire and he wants to buy an annuity that will provide...

Uncle Bob is about to retire and he wants to buy an annuity that will provide him with $8400 of income a year for 30 years with the first payment coming immediately the going rate on such annuities is 15.25% how much would it cost him too buy the annuity today

Your uncle calls and asks for your investment advice. Currently, he has $100,000 invested in a...

Your uncle calls and asks for your investment advice. Currently, he has $100,000 invested in a risky portfolio. This portfolio has an expected return of 10.5% and a volatility of 8%. Suppose the risk-free rate is 5% and the market portfolio has an expected return of 18.5% and a volatility of 13%. To maximize your uncle’s expected return without increasing his volatility, what investment strategy would you recommend? If your uncle prefers to keep his expected return the same, but...

Your Aunt Ruth has $340,000 invested at 7%, and she plans to retire. She wants to...

Your Aunt Ruth has $340,000 invested at 7%, 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? 15 13 12 16 14

1. Your uncle is planning for retirement, and he wants to buy an annuity that will...

1. Your uncle is planning for retirement, and he wants to buy an annuity that will provide him with $96,000 of income a year for 20 years, with the first payment coming immediately. The market rate on this annuity is 5.25%. How much would the cost be today? Answer just the dollar amount without the + or - sign. Round to the nearest dollar. 2. What's the value today of $1,950 to be received in 5 years if the appropriate...

For the purpose of this assignment, your uncle has decided to retire and has asked you...

For the purpose of this assignment, your uncle has decided to retire and has asked you to take over his Bed and Breakfast Inn (B&B). It is currently organized as a sole proprietorship and has fairly regular annual repeat customers (mostly families on vacation). Review and answer the following questions: What changes do you think you might implement to make the B&B more successful? Would you stay with a sole proprietorship? Why? If you are going to change the type...

Suppose your uncle invested $121,000 in an investment 4 years ago. The investment is worth now...

Suppose your uncle invested $121,000 in an investment 4 years ago. The investment is worth now $237,500. The annual interest rate (rate of return) on the investment during this period must be ______% per year. (Do not include the percent signs (%). Round your answers to 2 decimal places. (e.g., 32.16))

Subjects