excel project 3 | StudyDaddy.com

Hi Sir 

I have project that due on Sunday. 

1.                   The Work/Accumulation period

•                      The retirement spreadsheet should calculate on a year by year basis the accumulation of retirement savings. This means you will have a series of time value of money calculations. Each year will therefore be a future value calculation for the year. You must state for each year the proportion of your portfolio you want to invest in equities (with an expected return of xx%) vs. bonds (with an expected return of aa%)

•                      Assume annual contributions are split into equal monthly installments made at the end of each month, coincident with the receipt of your paycheck.

•                      For simplicity, assume your account compounds on a monthly basis.

•                      Repeat the calculation for each year you are working to determine your account balance at retirement.

2.                   The Retirement/Spending Period

•                      In your first year of retirement, there will be no further cash inflows into the retirement account. Since you are no longer working, you are only drawing from the principal you have accumulated and not earning a salary. Your job is to calculate how much money will be left in your account at the end of the year after drawing out your retirement income. Remember, your principal will still earn the risk-free rate of return of ww%. You aren’t pulling out all the money at once. The annual draw on your savings will  (a) be split into equal monthly withdrawals, (b) should be based on your budget and (c) be reported in the “withdrawal” column.

•                      Continue the calculation for future years. Increase your withdrawal each year by 2.1% so your retirement income keeps pace with inflation. Remember, your principal will still be earning the risk-free rate of interest.

3.                   Results

•                      Report how old you are when (or if) you run out of money. Were your savings sufficient to fund your retirement until your expected date of death?  Based on this analysis, would you change anything about either your pre-retirement contributions or your post-retirement withdrawal patterns?  Would you change your asset mix? 

•                      Make appropriate changes to your assumptions to ensure that your retirement income lasts to age 100. Once you have a retirement plan that you are comfortable with, we will use that for the third part of the assignment

Show more

Calculate Your Essay Price
(550 words)

Approximate price: $22

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