Lesson 14: Intermediate Spreadsheets Part II

February 26, 2020

Review:

• Coronavirus
• Quiz 06 results
• Stock Market Simulation automation
• Retirement Savings Probability Calculator (RSPC) Project:
  • Instructions under Assignment section

Presentation/Activity:

• DataCamp.com
  • Continue Intermediate Spreadsheets
    • Chapter 3: Logic & Errors – due today, Wed Feb 26
    • Chapter 4: Positional Matching – due Fri Feb 28

Assignment:

• Study for Quiz 08 covering Intermediate Spreadsheets
• Retirement Savings Probability Calculator (RSPC) Project:
  • Build a Google Sheets file capable of simulating annual stock+bond returns to generate estimates of retirement savings.
  • Use a 40-year time horizon
  • Simulation count , n >= 100
  • Features:
    • Ability to modify initial balance and annual contribution.
    • Ability to modify stock/bond allocation, e.g., 60%/40%.
    • Ability to set financial target, e.g., $1,000,000.
    • Menu item or start button to launch simulation
    • At end of simulation, probability of reaching financial target is displayed.
    • At end of simulation, distribution of end balances is displayed on a histogram.
  • Due no later than last day of class before Spring Break. Sooner is better for grading purposes.
  • Teams (of 2 or 3 but no larger) allowed to work together.
  • Each individual will present their RSPC in-class/in-person with Instructor and be prepared to answer questions.