You may have enough funds for retirement

Assignment Help Financial Management

Reference no: EM131958295

WORK MUST BE DONE ON EXCEL AND SHOW WORK:

Suppose you wish to retire 38 years from today. You determined that you will need $220,000 per year after you retire, with the first retirement funds withdrawn one year from the day you retire and that you will need to make 30 such withdrawals. Assuming that you can earn 5% per year on your retirement funds.

a) How much must you deposit in an account today (lump sum), so that you may have enough funds for retirement?

b) If you cannot afford to make a single lump sum deposit, today, to support your retirement. How much must you deposit at the end of each year for the next 38 years so that you have enough funds for your desire retirement? Assuming the last deposit will be made on the day you retire.

Reference no: EM131958295

Questions Cloud

Should the company make the investment : Your company is looking at a new project in Mexico. The project will cost 5,345,000 pesos. The cash flows are expected to be 2,442,000 pesos per year.

Determine what annual payment will need to be invested : Determine what annual payment will need to be invested if you have $10,000 today and want it to grow to $100,000 over 20 years at 4.5%.

Coast of louisiana with the gulf horizon : Shortcomings and difficulties with the FEMA grant process following the incident of the coast of Louisiana with the Gulf Horizon drilling platform.

What is the taxable income in year 3 : JameisCrabLegs Inc., a seafood distributor in the State of Florida, with a 34% combined income tax rate is considering an investment of $10,000.

You may have enough funds for retirement : How much must you deposit in an account today (lump sum), so that you may have enough funds for retirement?

Determine the external rate of return : A company makes a product for an engineering distributor. If tooling and setup costs were $400,000 in year 0 and an additional $190,000 in year 3.

Write a paper about sense making : Write a paper about Sense Making. When you write reference put the references link below the references and use Harvard style.

Implementing greenleaf ideas for servant leadership : What do you consider as obstacles to implementing Greenleaf's ideas for servant leadership?

How much must jackie invest today : Jackie wants to put the money aside now. Jackie's bank offers 8% interest compounded semiannually.

User Account

All Pages