If I start with $30,000 in my 401K and am able to save into my 401K: $5,000 next year (2025) $10,000 a year for the next 5 years (2026-2031) $15,000 a year for the 5 years after that (2031 - 2036) $20,000 a year for the following 5 years (2036 -2041) $ 10,000 for the last 4 years (2041 - 2045) If my 401K can earn me an average 6% interest, what would my yearly totals be and the total amount saved at the end of 20 years? Please show all of your work including any Excel formulas. Thanks for your help!!!

Your grandparents would like to establish a trust fund that will pay you and your heirs $205,000 per year forever with the first payment 12 years from today. If the trust fund earns an annual return of 4 percent, how much must your grandparents deposit today?

Explain which information you would need to take into consideration when deciding whether to receive $5,000 today or $5,500 one year from today.

After completing your Bachelor of Business (Accounting) degree, suppose you secure a permanent position as an accountant. You drafted a financial plan to retire in 35 years from now andthinking about creating a fund that will allow you to receive $25,000 at the end of each year for 30years after your retirement. The interest rates areexpected to be 2.45% per annum during the 35- year pre-retirement period and 3.15% during retirement.   Required: a) To provide the 30-year, $ 25,000-a-year annuity, calculate how much should be in the fund account when you retire in 35 years.                                                                                                  b) How much will you need today as a single amount to provide the fund calculated in part (a) if you earn 2.75% per year during the 35-yearpre-retirement period?                                                                                                                                             c) (Using different…

You wish to retire after 22 years; at which time you want to have accumulated enough money to receive an annuity of $68,000 a year for 25 years of retirement. During the period before retirement, you can earn 6 percent annually, while after retirement you can earn 4 percent on your money.   What annual contribution to the retirement fund will allow you to receive the $68,000 annually?

Your grandparents would like to establish a trust fund that will pay you and your heirs $175,000 per year forever with the first payment one year from today. If the trust fund earns an annual return of 3.4 percent, how much must your grandparents deposit today?

Perpetuity: Your grandfather is retiring at the end of next year. He would like to ensure that his heirs receive payments of $10,000 a year forever, starting when he retires. If he can earn 6.5 percent annually, how much does your grandfather need to invest to produce the desired cash flow? Please use Excel to solve

As part of his 401(k) retirement plan at work, Ken Lowery invests 5.0 percent of his salary each month in the Capital Investments Lifecycle Fund. At the end of this year, Ken's 401(k) account has a dollar value of $210,800. If the fund charges a 12b-1 fee of 0.75 percent, what is the amount of the fee? (Round your answer to 2 decimal places.) 12b-1 fee

house's first contribution is made one year from today and his last is made the day he mo p00,000 per year. II Mil- retires, how much money must he contribute each year to his retirement fund? (Solving a comprehensive problem) Having just inherited a large sum of money, you are trying to determine how much you should save for retirement and how much you can spend now. For retirement, you will deposit today (January 1, 2016) a lump sum in a bank account paying 10 percent compounded annually: You don't plan on touching this deposit until you retire in five years (January 1, 2021), and you plan on living for 20 additional years. During your retirement, you would like to receive a payment of $50,000 on the first day of each year, with the first payment on Janu- ary 1, 2021, and the last payment on January 1, 2041(Complicating this objective is desire to have one final three-year fling during which time you'd like to track your down all the original cast members of Hey Dude and Saved by the…

June Stickney purchased an annuity on January 1, 2019, which, at a 12% annual rate, would yield $6,000 each June 30 and December 31 for the next 6 years. What was the cost of the annuity to Stickney? Round your answer to two decimal places. $ fill in the blank 4 Five equal annual contributions are to be made to a fund, with the first deposit on December 31, 2019. Determine the equal contributions that, if invested at 10% compounded annually, will produce a fund of $30,000 on December 31, 2024. Round your answer to two decimal places. $ fill in the blank 5 Beginning on December 31, 2020, 6 equal annual withdrawals are to be made. Determine the equal annual withdrawals if $11,000 is invested at 10% interest compounded annually on December 31, 2019. Round your answer to two decimal places. $ fill in the blank 6