Question

Jimmy has $255,906 accumulated in a 401k plan. The fund is caring a low, but safe, 3% per year. The withdrawals will take pla

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

Use the following excel function to calculate the number of years in which fund will be exhausted A1 NPER(3%,30000,-255906,0,

Add a comment
Know the answer?
Add Answer to:
Jimmy has $255,906 accumulated in a 401k plan. The fund is caring a low, but safe,...
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
  • Present and future value tables of $1 at 3% are presented below: FVAD $1 N 1...

    Present and future value tables of $1 at 3% are presented below: FVAD $1 N 1 2 3 4 5 6 7 FV $1 1.03000 1.06090 1.09273 1.12551 1.15927 1.19405 1.22987 1.26677 1.30477 1.34392 1.38423 PV $1 0.97087 0.94260 0.91514 0.88849 0.86261 0.83748 0.81309 0.78941 0.76642 0.74409 0.72242 FVA $1 1.0000 2.0300 3.0909 4.1836 5.3091 6.4684 7.6625 8.8923 10.1591 11.4639 12.8078 PVA $1 0.97087 1.91347 2.82861 3.71710 4.57971 5.41719 6.23028 7.01969 7.78611 8.53020 9.25262 1.0300 2.0909 3.1836 4.3091 5.4684 6.6625...

  • Present and future value tables of $1 at 3% are presented below: N 1 2 3...

    Present and future value tables of $1 at 3% are presented below: N 1 2 3 4 5 6 7 8 9 10 11 12 13 FV $1 1.03000 1.06090 1.09273 1.12551 1.15927 1.19405 1.22987 1.26677 1.30477 1.34392 1.38423 1.42576 1.46853 1.51259 1.55797 1.60471 PV $1 0.97087 0.94260 0.91514 0.88849 0.86261 0.83748 0.81309 0.78941 0.76642 0.74409 0.72242 0.70138 0.68095 0.66112 0.64186 0.62317 FVA $1 1.0000 2.0300 3.0909 4.1836 5.3091 6.4684 7.6625 8.8923 10.1591 11.4639 12.8078 14.1920 15,6178 17.0863 18.5989 20.1569...

  • 1. Suppose you accumulated $500,000, perhaps from many years of saving. You put the money in...

    1. Suppose you accumulated $500,000, perhaps from many years of saving. You put the money in a savings plan earning 6% compounded monthly. If you want to withdraw $4,000 at the beginning of each month, how long before the savings plan is exhausted? 2. Suppose you accumulated $500,000, perhaps from many years of saving. You put the money in a savings plan earning 6% compounded monthly. If you want the plan to last 40 years, how much can you withdraw...

  • Jimmy and Jane Have Goals Jimmy Johnson is 25 years old. He and his wife Jane...

    Jimmy and Jane Have Goals Jimmy Johnson is 25 years old. He and his wife Jane have two children, Emmitt and Patricia, ages 2 and 4 respectively. Jimmy wants to retire in 40 years and build boats. He would like a nice retirement home with some land on a peaceful lake in the mountains of Georgia. Jimmy believes that to purchase a home and lot in 40 years would cost $300,000 in today’s prices. In forty years Jimmy also believes...

  • Jimmy and Jane Have Goals Jimmy Johnson is 25 years old. He and his wife Jane...

    Jimmy and Jane Have Goals Jimmy Johnson is 25 years old. He and his wife Jane have two children, Emmitt and Patricia, ages 2 and 4 respectively. Jimmy wants to retire in 40 years and build boats. He would like a nice retirement home with some land on a peaceful lake in the mountains of Georgia. Jimmy believes that to purchase a home and lot in 40 years would cost $300,000 in today’s prices. In forty years Jimmy also believes...

  • cation fund for your child. The current cost for college 7 You plan to establish a...

    cation fund for your child. The current cost for college 7 You plan to establish a college education fund for your child. The 000 per vear and you expect this cost to increase by $600 per year. You plan to deposit money into an account earning 10% yearly nominal interest, compounde monthly, at the end of each year for the next 17 years. You will withdraw the ar required for college in the end of years 18 to 21 to...

  • 7. You plan to establish a college education fund for your child. The current cost for...

    7. You plan to establish a college education fund for your child. The current cost for college is $12,000 per year and you expect this cost to increase by $600 per year. You plan to deposit money into an account earning 10% yearly nominal interest, compounded monthly, at the end of each year for the next 17 years. You will withdraw the amount required for college in the end of years 18 to 21 to pay for college for years...

  • Chapter 3 - Nonlevel annuities - Geometric A trust fund has 7000 dollars on January 1,...

    Chapter 3 - Nonlevel annuities - Geometric A trust fund has 7000 dollars on January 1, 2020. It pays interest once a year starting on January 1, 2021 at an annual effective rate of 5%. (a) If the beneficiary makes no withdrawals from the fund, the balance at the end of 10 years will be (b) Now assume that the beneficiary will be allowed to withdraw the interest payment and an additional 10% of the balance on each January 1...

  • John met his insurance agent to discuss the purchase of an insurance plan to fund his...

    John met his insurance agent to discuss the purchase of an insurance plan to fund his 8- year-old daughter’s university education in 11 years’ time. The payout from the insurance company is as follows: • Receive $30,000 at the beginning of each year for 4 years with the first receipt starting 11 years from today. The insurance company had 3 payment proposals: Proposal 1: • Pay $35,000 today. Proposal 2: • Beginning 2 years from today, pay $8,000 each year...

  • You have just turned 30 years? old, have just received your? MBA, and have accepted your...

    You have just turned 30 years? old, have just received your? MBA, and have accepted your first job. Now you must decide how much money to put into your retirement plan. The plan works as? follows: Every dollar in the plan earns 7% per year. You cannot make withdrawals until you retire on your 65th birthday. After that? point, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until...

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