Question

Ellie wants to endow a college scholarship to honor her late grandmother. She wants to save...

Ellie wants to endow a college scholarship to honor her late grandmother. She wants to save enough money to support withdrawals of $15,000 per year (forever). Ellie will save to fund this scholarship for the next 20 years. The first scholarship withdrawal will be at the time of her last contribution to the endowment. While she saves money for the endowment, Ellie can earn 8% APR per year. Once she has funded the endowment, Ellie will move the money into a safe account that pays 3% per year. What yearly contribution must Ellie make to achieve her goal?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

А. B С 1 APR of safe account Annual withdrawal Value of withdrawal at Year-20 3% $15,000.00 $515,000.00 2 3 4 5 6 7 APR of En

Cell reference -

A B С 1 0.03 2 3 4 APR of safe account Annual withdrawal Value of withdrawal at Year-20 15000 |=C3/C2*(1+C2) 5 0.08 APR of En

Hope it will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.

Add a comment
Know the answer?
Add Answer to:
Ellie wants to endow a college scholarship to honor her late grandmother. She wants to save...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Imari wants to establish a charitable foundation that will make annual scholarship payments forever. Imari wants...

    Imari wants to establish a charitable foundation that will make annual scholarship payments forever. Imari wants the foundation to make the first annual scholarship payment in 4 years from today, she wants that first scholarship payment to be 22,410 dollars, and she wants annual scholarship payments to increase by 3.79 percent per year forever. To fund the foundation, Imari plans to make equal annual savings contributions for 3 years. How much does Imari need to save each year for 3...

  • Aloma, a university graduate who started a successful business, wants to start an endowment in her...

    Aloma, a university graduate who started a successful business, wants to start an endowment in her name that will provide scholarships to EE students. She wants the scholarship to provide $17.000 per year and expects the first one to be awarded on the day she fulfills the endowment obligation. If Aloma plans to donate $240.000 what rate of return must the university realize in order to award the annual scholarship forever? The rate of return that the university must realize...

  • Francis Fray is saving for her retirement fund. She wants to have $450,000 in 30 years...

    Francis Fray is saving for her retirement fund. She wants to have $450,000 in 30 years when she turns 75 . She expects the APR to be 6% compounded monthly a. How much should she deposit each month? b, She has decided to save even more each month to get to her goal and is planning to deposit $550 each month. How long will it take her to achieve her goal of $450,000? Thank you

  • Stefani German, a 40-year-old woman, plans to retire at age 65, and she wants to accumulate...

    Stefani German, a 40-year-old woman, plans to retire at age 65, and she wants to accumulate $420,000 over the next 25 years to supplement the retirement programs that are being funded by the federal government and her employer. She expects to earn an average annual return of about 6% by investing in a low-risk portfo containing about 20% short-term securities, 30% common stock, and 50% bonds Ste ani currently has $37.280 hat a an annual rate o return o 6%...

  • Lady Gaga is 30 and already worried about her future. She wants to make sure that...

    Lady Gaga is 30 and already worried about her future. She wants to make sure that she’ll be able to keep up with the life standard she got used to – at the end of the day, she was born this way and wants to die this way, too. She has couple of goals that she wants to achieve after she retires. First, she wants to be able to withdraw $150,000 each month to cover her clothing and make-up expenses...

  • Last 4 digits of CUNYFirst ID BUS 121 - - Name Time Value of Money: Problem...

    Last 4 digits of CUNYFirst ID BUS 121 - - Name Time Value of Money: Problem Set la Tips: • For now, ignore "payment" and "mode" in the TVM calculator app. Problems: 1. Shirin needs to borrow $3.000 and is considering her options. Her bank is offering to lend her the money for 2 van after which she will need to make a single payment to the bank in the amount of $3,500. Her cousin offered to lend her money,...

  • Jinhee Ju. 27. has an annual salary of $37,000. Jinhee wants to buy a new car in 3 years, and she wants to save e...

    Jinhee Ju. 27. has an annual salary of $37,000. Jinhee wants to buy a new car in 3 years, and she wants to save enough money to make a $7,000 down payment on the car and finance the balance. Also, in her plan is a wedding. Jinhee and her boyfriend, Paul, have set a wedding date 2 vears in the future, after he finishes medical school. Paul will have a $100,000 student loan to repay after graduation. But both Jinhee...

  • This is a classic retirement problem. A friend is celebrating her birthday and wants to start...

    This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She has the following years to retirement and retirement spending goals: Years until retirement 35 Amount to withdraw each year $85,000 Years to withdraw in retirement 25 Interest rate 7.5% Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make equal annual deposits into her account...

  • Question 6: This is a classic retirement problem. A friend is celebrating her birthday and wants...

    Question 6: This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She has the following years to retirement and retirement spending goals: Years until retirement 35 Amount to withdraw each year $85,000 Years to withdraw in retirement 25 Interest rate 7.5% Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make equal annual deposits into...

  • Use the following information to answer each question Allison wants to save for retirement. She is...

    Use the following information to answer each question Allison wants to save for retirement. She is 20 and wants to retire in 40 years. She is considering two options and expects to earn an 8% annual return under each option. Option 1: She is considering contributing $6,000 per year to an IRA for 10 years at which time she figures she will be tired of self-deprivation save no more. The invested funds, however, will continue to grow until she retires....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT