Use Excel to solve the following problem. Assume that you are 39 years old planning for your future retirement at age 65. You think that you will be comfortable living on the proceeds from a $1,000,000 401K Retirement Account.a. If your investments grow at an average rate of 6% annually how much must you invest monthly to achieve your projected retirement fund total by the time you retire in 26 years?b. Assuming that when you do retire, you will re-direct your $1,000,000 investment portfolio into less volatile and more secure mutual funds. You expect that, invested in these sources, your portfolio will securely earn 4.5% annually. Based on your assumptions and the normal life expectancy of an American male or female (I determined this to be 81 years old), without consuming any of your principal, how much money will you have on a monthly basis to support your life?(I have worked this problem out on my own, I just want to be sure I applied the formulas and concepts correctly.)

Q: You have discussed your retirement plans with your significant other and plan to move to a state…

A: Yield = 5% Return Annual Withdrawals = 85,000

Q: You are 20 years old today. You want to retire at age 50 and have $4 million at that time. Assume…

A: The present value of money refers to the concept that money available in the future is worth less…

Q: Suppose you are 30 years old and would like to retire at 60. Moreover, you would like to to have a…

A: Using the PMT function in excel

Q: Your client is 45 years old, and she wants to begin saving for retirement, with the first payment to…

A: Time = t = 65 - 45 = 20Payment = p = $6000Interest rate = r = 11%

Q: a. Luis is planning on retiring in 10 years. Luis has a mutual fund that is earning a return of 6%…

A: There are two methods of Interest: One is Simple Interest and second is Compound Interest. Simple…

Q: You have just turned 23 years of age and accepted your first job. However, you would like to retire…

A: Current Age is 23 years The retirement age is 58 years Therefore; the Time period of the deposit is…

Q: You would like to start saving for retirement. Assuming you are now 20 years old and you want to…

A: Future Value of Annuity = Amount * (((1 +Rate of Interest)N-1 )/Rate of Interest)Where,Amount =…

Q: 4. You want to have a retirement fund of $200,000 available when you retire. You invest in an IRA to…

A: The sum that remains after future cash amounts have been discounted to a later date is most likely…

Q: You have decided that you want to be a millionaire when you retire in 45 years.   a. If you can…

A: Present Value(PV) is value of a future amount at current point of time. It is done by discounting…

Q: If you wait until you're 45 to begin investing for retirement, you'll need to invest $2,153 per…

A: we will assume that retirement age is 60. to find the rate we will use the 'RATE' function in excel.…

Q: Your business finance course has motivated you to begin investing for retirement in your company's…

A: The FV of an investment refers to the cumulative worth of the investment's cash flows at a future…

Q: ou would like to start saving for retirement. Assuming you are now 20 years old and you want to…

A: The future value function or concept can be used to determine the future value of a present sum or…

Q: Assume you are currently 25 years old and just received an inheritance of $1,000,000 from a wealthy…

A: Money have time value that means more money would be required in the future for same amount and this…

Q: Because your salary should increase every year, the amount you invest for retirement should also…

A: Retirement savings is the clubbed amount of savings saved every year from salary of an individual.…

Q: You want to have $2million when you retire. You think you can earn 11% return on your retirement…

A: The question is based on the concept of present value calculation for future cash flow. Formula as,…

Q: bjective is to save $500,000 for preparing your retirement, assuming 30 years from now. If you…

A: Future value=$500000Period=n=30 yearsInterest rate=r=10%

Q: Having just started a nice job after graduation, you would like to be financially responsible and…

A: To determine which option will provide the highest retirement amount in 40 years, we need to compare…

Q: re trying to decide how much to say for retirement assume you plan to save 10,000 per year and will…

A: There is need of planning for retirement and if done properly on time can have good retirement life.

Q: 8) Special Retirement PlanYou set up a retirement plan where you will invest $20,000 per year in an…

A: Annuity is the payment series which are made at equal time intervals.

Q: You have heard about the impending retirement crisis facing the global community and you want to…

A: Monthly Deposits (PMT) is $380Time Period (n) in years is 40Interest Rate (r) is 7.74%Compounding…

Q: Linda would like to have a retirement account with $3,000,000 in it on the day she retires 40 years…

A: Solution:-When an equal amount is invested each periodat end of period, it is called ordinary…

Q: Second Best Insurance company is advertising a new product to retirees looking to invest their…

A: NPV refers to net present value. It is an important capital budgeting tool. Essentially NPV is the…

Q: You save $800 a year into a 401(k) account that you invest in a mutual fund earning 9% per year.…

A: Given, Amount saved every year is $800 Rate is 9% Number of years is 25.

Q: You want to save for retirement. Assuming you are now 25 years old and you want to retire at age 55,…

A: Definition: Future value: This is the amount of present value accumulated or compounded at a rate of…

Q: You are planning for your retirement. You expect to earn a monthly salary of $7,000 starting on the…

A: First thing you have to calculate retirement amount needed and total amount at retirement.

Q: In our prior example, you need to have about $4,000,000 in savings at the age of 60 to fund…

A: Present value is the concept in finance that suggests the worth of a future cash flow, assuming it…

Q: 1) In a few short years, you will graduate and enter the workforce. Let us suppose that you and a…

A:

Q: You just turned 23 years old and want to retire when you turn 65. You expect to withdraw $70,000 per…

A:

Q: You are planning to save for retirement over the next 20 years. To do this, you will invest $900 a…

A: We will apply the TVM (time value of money) concept here.Value or worth of money changes with…

Retirement Income

Retirement income is the income received by the retiring person after retirement. Income can either be paid every month or paid annually. The retiree would get a guaranteed income until their death. Retirement income payment differs from person to person based on their investment type and payment method. Some are paid on a lump-sum basis and some are paid in a regular series with fixed payment or variable cash flow. Retirement income can be created from retirement savings, investment, salary, bonus, and wages from employment. Every working individual should plan their retirement income according to their income goals for the future. The plan should be made by identifying suitable income sources, estimating future expenses, applying a savings plan, and managing risk and assets. The most common age for retirement is between 60-65 years.