Spreadsheet problem-compute value of the retirement plan

Assignment Help Financial Management
Reference no: EM131518775

Spreadsheet Problem 

Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65. For the first ten years, she contributes $2,400 per year. She increases the contribution rate to $4,400 per year in years 11 through 20. This is followed by increases to $9,400 per year in years 21 through 30 and to $14,400 per year for the last ten years. This money earns a 10 percent return.

First compute the value of the retirement plan when she turns age 65. (Round your answer to 2 decimal places.)

Value       $

Compute the annual payment she would receive over the next 40 years if the wealth was converted to an annuity payment at 9 percent. (Round your answer to 2 decimal places.)

Annual payment      $

Reference no: EM131518775

Questions Cloud

Evaluating proposed acquisition of new production machine : Riverview Company is evaluating the proposed acquisition of a new production machine.
Present value and annuity payments : A local furniture store is advertising a deal in which you buy a $5,600 living room set with three years before you need to make any payments.
The implied exchange rate : The “implied” exchange rate between USD and Japan based on “Big MacCurrency” is
Estimate the total cash flows and find out the NPV-IRR : Estimate the total cash flows and find out the NPV, IRR, and PI of this project.
Spreadsheet problem-compute value of the retirement plan : First compute the value of the retirement plan when she turns age 65.
What is amount of after-tax salvage value of the equipment : What is the amount of the after-tax salvage value of the equipment? What is the value of the depreciation tax shield in year 2 of the project?
House appreciation and mortgage payments : Say that you purchase a house for $302,000 by getting a mortgage for $265,000 and paying a $37,000 down payment. what are the monthly payments?
Find the values assuming a regular or ordinary-annuity : Find the following values assuming a regular, or ordinary, annuity: -
Would shareholders want management to make this change : Would shareholders want management to make this change?

Reviews

Write a Review

Financial Management Questions & Answers

  Which currency appreciated

A U.S. Investor wants to invest 1,000 USD (U.S. Dollar) in Hong Kong, where the interest rate is .5%. Which currency appreciated?

  Calculate NPV and IRR for the investment

Calculate NPV and IRR for the following investment. Initial investment = $1,000,000 machine, the project term is 6 years, sales for year 1 are estimated to be $1,000,000, and will grow by 7.5% per year through year 5, sales for year 6 = $500,000, var..

  How would you explain this ex post return

Suppose that in the next period security Ri has earned only 5% over the preceding period. How would you explain this ex post return?

  Absolute deviation and the mean square error

Discuss the mean absolute deviation (MAD) and the mean square error (MSE). Which do you think is a better indicator of the accuracy of a forecasting method and why?

  Break-even is how the firm evaluates its projects

EpicSept is about to introduce a new employee monitoring tool and has determined that it will charge $100 per unit. The firm must decide whether or not to purchase a high-capacity manufacturing machine. If EBIT Break-even is how the firm evaluates it..

  What is this project equivalent annual cost or EAC

what is this project’s equivalent annual cost, or EAC?

  What is the certainty-equivalent price

On the London Metals Exchange the price for copper to be delivered in one year is $3,530 a ton. (Note: Payment is made when the copper is delivered.) The risk-free interest rate is 0.58% and the expected market return is 8%. What is the certainty-equ..

  What is the stock expected capital gains yield

If D1 = $2.50, g (which is constant) = 7%, and P0 = $45, what is the stock's expected capital gains yield for the coming year?

  Calculate the market price for the bonds

Calculate the market price for the bonds and long-run earnings growth rate.

  Operating earnings per share are estimated

The S&P 500 operating earnings per share are estimated to be ~ $107 for 2015. You expect earnings to increase 20% next year. What price range would you expect for the S&P 500 index at the end of next year, and what point estimate would you have for i..

  Financed by a combination of common stock

Suppose that it is financed by a combination of common stock and $1.08 million of debt. The interest rate on the debt is 9%, and the corporate tax rate is 35%. How much profit is available for common stockholders after payment of interest and corpora..

  What must the coupon rate of maturity

DMA Corporation has bonds on the market with 16.5 years to maturity, a YTM of 6.3 percent, and a current price of $1,036. The bonds make semiannual payments and have a par value of $1,000. What must the coupon rate be on these bonds?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd