Attached are a word doc that describes the project and an excel spreadsheet that

Attached are a word doc that describes the project and an excel spreadsheet that is the guts of the project. Submit your write up in pdf form.
some notes from the class:
Since there are a lot of similar confusions about this project, I decided to point out and clarify a few things that I think a lot of people are still struggling with:
1. The “Median”, “5th percentile”, and “95th percentile” on your chart will come from the bottom table with orange background. Your “Median Portfolio Value” will come from the “Ending Value Median” of the upper table.
2. Growth rate: Do not worry too much about this. If you want to be accurate, you can do your own research and calculate it. Try to keep the rate between 2%-3%. If you don’t want to calculate it, just pick 2%. It’s not that important.
3. 10yr/20yr delay: For this, you go back in time and make yourself 10/20 years older. So, take your birth year and subtract 10 and 20. For example: if you’re born in 2000, take 2000 – 10 = 1990 -> that will be your 10 year delay. For most people, your 10-year/20-year delay income levels are supposed to be significantly lower than your “best-fit allocation” result because you’ll have less time to invest.
4. Starting salary: Make sure you change your starting salary when calculating 10yr/20yr delay.
5. You do not need to have 3/3 or 2/3 income levels being “sunny”. You don’t even need to have 1/3 being “sunny” as long as you can explain it. None of my income levels throughout all 5 runs was “sunny”.
6. If you don’t care about reality and just want your results to look pretty with “sunny” levels then applying these adjustments:
a. Lower growth rate
b. Higher saving rate
c. Higher company contribution
d. Higher retirement age
e. Lower Desired Retirement Income percenta
This video might help: https://uofsc.hosted.panopto.com/Panopto/Pages/Vie…
———————————————–
Info you will need to complete the tabels and write the report:
assume it is a spring semester and i am a senior born in 1998. And the major is geology
————————————————
What you hand in. A completed excel work sheet and the report