Expected return on your investments

Assignment Help Financial Management

Reference no: EM131020509

You are 30 years old today and planning to retire at age 62. You want to plan your finances for living 35 years past age 62 and die dead broke. You determine you will need $3000 per month from age 62 for the 35 years.

Your plan is to go live in the tropics, on the beach, and live on coconuts and fishing. Also, you need to conclude your retirement savings at age 55 because all your spare money then will be going to your children’s education.

The question is how much money you will need to save each month between now and 55 so that you can quit contributing. The expected return on your investments over the whole period is 10% per year. Please ignore inflation.

Please answer questions in excel and attach excel document.

Reference no: EM131020509

Questions Cloud

What is the present value of the annuity : A 10-year annuity pays $2,900 per month, and payments are made at the end of each month. The interest rate is 8 percent compounded monthly for the first six years, and 6 percent compounded monthly thereafter. What is the present value of the annuity?

What are your monthly payment and your current loan balance : You bought a house 8 years ago with a $250,000 mortgage. It was a 15 year loan with monthly payments which will pay off the loan when you make the last payment. The interest rate was 6%. What are your monthly payment and your current loan balance? Ho..

If the returns are capital appreciation : You are investing in a stock that will deliver 6% per year, for 6 years. Assume you invest $10,000 initially. The tax on both capital gains and dividends is 28%. If the returns are capital appreciation, you hold for 6 years and do not sell, what is t..

Ow much interest will you pay over the twenty years : You take out a $200,000 mortgage for 20 years at 6%. What is your monthly payment? What is the principle and interest on the first payment? What is the principle and interest on the twelfth payment? How much interest will you pay over the 20 years?

Expected return on your investments : You are 30 years old today and planning to retire at age 62. You want to plan your finances for living 35 years past age 62 and die dead broke. You determine you will need $3000 per month from age 62 for the 35 years. Your plan is to go live in the t..

Identify the direction of change in modified duration : Calculate modified duration using the information above. If the yield to maturity increases to 8.5%, what will be the change (in dollar amount) in bond price? Identify the direction of change in modified duration if: i. the coupon of the bond is 4%, ..

Consider including capital gains tax rules : Describe the after tax effects on the client's cash flow based on the sale of the land. Consider including capital gains tax rules.

What is net income : Archware Systems has total assets of $35.594 billion, total debt of $9.678 billion, and net sales of $23.690 billion. Their net profit margin for the year was 0.24, while the operating profit margin was 30 percent. What is Archware’s net income?

Write an equation in slope-intercept form for the ppf : On two separate graphs draw the PPF for Amazonia and Noblia. Measure zippers on the vertical axis and hats on the horizontal axis. Write an equation in slope-intercept form for the PPF for Amazonia

User Account

All Pages