Can anyone help me with my microsoft excel project ?

 

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.

 

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 15% with the discount code GRADUATE