finance excel project | StudyDaddy.com

Demographics and justifications:

  • Assume you are beginning full time work this year.
  • State the age at which you plan on retiring. How many years do you have to accumulate the dollars necessary to commence retirement? 
  • Report the age at which you expect to die and how much money (if any) you want to have upon death to leave to someone or some organization. How many years will you be spending money in retirement? 
  • Show these assumptions and their justifications on your spreadsheet.

Expected Retirement Spending: (Use a spreadsheet to make this easier)

  • Create an annual expense budget for your needs in your first year of retirement using today’s dollars. For example, you may have no mortgage payment due in retirement. Note that if you retire prior to being eligible for Medicare (age 65 under current law), you will also need to budget for medical insurance. There are sources online available to help you find an estimate of this. Recognize that this figure could vary widely based on your future health.
  • Note that it is not necessary to establish a budget that varies from month to month. The focus of this assignment is your annual needs rather than your expected monthly cash flows.
  • Using your estimate of expenses in today’s dollars, the number of years before retirement and a rate of inflation assumption of 2.1%, report how much money you expect to spend in your each year of retirement in future dollars. Remember to continue to adjust for inflation to account for the impact of inflation during retirement.

Earnings and Savings Behavior:

Create an estimate of your future annual earnings in a spreadsheet, reporting the following assumptions:

  • Your actual current retirement savings
  • Average annual salary growth rate
  • The percentage of salary you expect to contribute each year between now and retirement toward work-sponsored retirement accounts (e.g., 401(k)), including the assumed employer contribution percentage. This can vary from year to year if you wish, either increasing or decreasing over time.

If you do not use a linear salary growth rate, please bold the figures that use a different assumption. For example, if you give yourself a flat $10,000 raise at age 30 because you predict a promotion that year, bold the salary of the year in which the $10,000 raise applies. If you see yourself leaving the workforce to return to school, bold the reduced student salary you expect during those years.

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