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

John Rider wants to accumulate $100,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, FVA 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. If 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?

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…

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?

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…

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