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!!!

You wish to retire in 11 years, at which time you want to have accumulated enough money to receive an annual annulty of $26,000 for 16 years after retirement. During the period before retirement you can earn 12 percent annually, while after retirement you can earn 14 percent on your money. What annual contributions to the retirement fund will allow you to receive the $26,000 annuity? Use Appendix C and Appendix D for an approximate answer, but calculate your final answer using the formula and financial calculator methods. Note: Do not round Intermediate calculations. Round your final answer to 2 decimal places. Annual contribution

John Rider wants to accumulate $90,000 to be used for his daughter's college education. He would like to have the amount available on December 31, 2026. Assume that the funds will accumulate in a certificate of deposit paying 8% interest compounded annually. (FV of $1. PV of $1. EVA of $1, PVA of $1. FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Answer each of the following independent questions. Required: 1. If John were to deposit a single amount, how much would he have to invest on December 31, 2021? 2. IH John were to make five equal deposits on each December 31, beginning a year later, on December 31, 2022, what is the required amount of each deposit? 3. If John were to make five equal deposits on each December 31, beginning now, on December 31, 2021, what is the required amount of each deposit? (For all requirements, Round your final answers to nearest whole dollar amount.) 1. Amount Annuity amount Annuity amount 2.

Munabhai

Al Ferris has $70,000 that he wishes to invest now in order to use the accumulation for purchasing a retirement annuity in five years. After consulting with his financial advisor, he has been offered four types of fixed-income investments, which we will label as investments A, B, C, and D. Investments A and B are available at the beginning of each of the next five years (call them years 1 to 5). Each dollar invested in A at the beginning of a year returns $1.40 (a profit of $0.40) two years later (in time for immediate reinvestment). Each dollar invested in B at the beginning of a year returns $1.70 three years later. Investments C and D will each be available at one time in the future. Each dollar invested in C at the beginning of year 2 returns $1.90 at the end of year 5. Each dollar invested in D at the beginning of year 5 returns $1.30 at the end of year 5. Click here for the Excel Data File Formulate and solve a linear programming model for this problem on a spreadsheet. a. Which…

? You would like to have enough money saved to receive a $53,000 per year perpetuity after retirement. How much would you need to have saved in your retirement fund to achieve this goal? Assume that the perpetuity payments start on the day of your retirement. The annual interest rate is 8 percent. O -00 Multiple Choice $715,500 $1,060,000 $530,000

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?

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