# Can anyone help me with my microsoft excel project ?

### Calculate the price of your order:

275 words
+
Approximate price
\$ 0.00

## Retirement Saving Project

Project’s instructions:

Purpose:        To gain an understanding of the affect of start date, rate of return, inflation and taxes on what it will take you to save a set amount of money by the time you retire at age 65.

1.     Prepare an Excel table (template available on Pilot) showing your expected income at the following ages: 25, 35, 45, and 55 (if you are older than any of these ages start with your current age, then use the remaining ages above). If you are realistic with your income expectations the exercise will be more meaningful.  Start with your salary expectation at graduation and inflate that amount each year to determine your salary at each age level.

2.     Assume you need to save an additional \$1,000,000 (in today’s dollars) to supplement your retirement at age 65.

3.     Let’s explore the affect of start date and investment rate of return on your retirement savings and lifestyle.  Determine what dollar amount you have to save and what percentage of your pay would have to be saved if you earned either 8% or 10% return on your investments.  (E.g., if you started saving at age 25 how much would you need to invest each year earning 8% annually to accumulate \$1,000,000 at age 65?)  Repeat this same calculation assuming you delayed starting your savings until age 35, 45, and 55. Note: The goal is to accumulate \$1,000,000 at age 65.  What changes is the number of years you have to save… 40, then 30, 20 and finally 10.

4.     Now let’s explore the affect of taxes on your retirement income.  Assume you are age 65 today and you have achieved your goal of \$1,000,000 in retirement savings.  Further assume that you will live in retirement for 30 years until age 95.  Also assume that your retirement savings portfolio earns 6% annually and that your average tax rate is 20%.  How much can you withdraw annually from your investment savings and still have it last 30 years? Now take this annual amount and subtract federal income tax from it to establish the actual cash available to buy your retirement lifestyle.  Could you live comfortably in retirement on this amount of income?  What factors might affect your ability to live comfortably on the calculated amount?  Comment and show your calculations.

5.     Now let’s explore the affects of inflation on your savings goal! In step 4 above, we determined how much annual income could be derived from our \$1,000,000 retirement savings assuming we were age 65 TODAY.  But how much would you have to save annually to have an amount of retirement saving that has the same purchasing power at your age 65 as \$1,000,000 today?  If inflation averages 3% each year during the time before you retire at age 65, how much would you need to save to achieve the equivalent of \$1,000,000 today? In step 2 your goal was \$1,000,000 in today’s dollars.  To maintain the purchasing power of \$1,000,000 today how much would you need at retirement at age 65? Repeat the table in 3 above, savings for an inflation adjusted \$1,000,000.  Show your calculation for the inflation adjusted savings goal.

6.     What conclusions would you make regarding when you should begin investing for your retirement, the affect of different investment rates of return, and the affects of inflation on retirement saving plans.  Has this project has helped you understand the importance of having goals and having a plan to achieve those goals?

Note: I have also attached an Excel example how should the final work looks like.

### Basic features

• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee

### On-demand options

• Writer's samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources

### Paper format

• 275 words per page
• 12pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, CHicago/Turabian, Havard)

### Guaranteed originality

We guarantee 0% plagiarism! Our orders are custom made from scratch. Our team is dedicated to providing you academic papers with zero traces of plagiarism.

### Affordable prices

We know how hard it is to pay the bills while being in college, which is why our rates are extremely affordable and within your budget. You will not find any other company that provides the same quality of work for such affordable prices.

### Best experts

Our writer are the crème de la crème of the essay writing industry. They are highly qualified in their field of expertise and have extensive experience when it comes to research papers, term essays or any other academic assignment that you may be given!

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00

### Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Hello 👋