Determining how much to save for retirement

Assignment Help Operation Management

Reference no: EM131118955

A recent MBA would like your assistance in determining how much to save for retirement. He is planning to invest $ 3,000 in a tax- sheltered retirement fund at the end of each year (i.e., appreciation of the fund is not taxed). The rate of return each year can be modeled as a normally distributed random variable with a mean of 12 percent and a standard deviation of 3 percent, and can vary from year to year. He is 30 years old now.

a) Design a base case spread sheet and show all calculations

b) In the base case, assuming the rate of return is deterministic at 12 percent each year, how much money should he expect to have in his retirement fund at the end of age 60? (Note: Please calculate the entire cash flow over the years and do not use any existing financial function in Excel to calculate the answer directly. This allows you to incorporate uncertain return rates in each year in the following parts.)

Reference no: EM131118955

Questions Cloud

Big and high profile e-business project to manage : Most people think of projects only in on ground or brick and mortar environments. Lately, there are lots of online or electronic projects everywhere around the world. As a senior Project Manager what other advice would you give to a new and young Pro..

Starting with income before depreciation expense : Starting with income before depreciation expense, prepare the remaining portion of the income statement for 2009 and 2010.

Open discussion-debate of affirmative and negative teams : Write a debate on the research on Affirmative Action. Remember, this is a professional debate where all opinions are to be respected.

Evaluate the method-conclusion-or reliability : An annotated bibliography takes your preliminary bibliography and adds annotation to each entry. Each annotation should contain the following information:

Determining how much to save for retirement : A recent MBA would like your assistance in determining how much to save for retirement. He is planning to invest $ 3,000 in a tax- sheltered retirement fund at the end of each year (i.e., appreciation of the fund is not taxed). In the base case, assu..

Prepare the entry to record depreciation for 2011 : In 2011, it is determined that the total estimated life should be 15 years with a salvage value of $4,000 at the end of that time.

Proactive efforts carried out by counseling professional : Proactive efforts carried out by counseling professional in response to institutional, systemic, and cultural impediments to their clients' well-being defines. A shift in thinking toward is slowly gaining recognition in the counseling profession. Not..

Compute depreciation expense on the equipment for 2010 : Prepare the journal entry(ies) necessary to record the depreciation expense on the building in 2010.

Which earnings number is more meaningful net income or gaap : Why do companies do this? Which earnings number is more meaningful, net income or this non-GAAP measure?

User Account

All Pages