Review the MBA’s retirement planning situation described in Chapter 9 ( Figure 9

Review the MBA’s retirement planning situation described in Chapter 9 ( Figure 9.16 ). Modify the spreadsheet to include the assumptions that the annual raise each year is triangular with a minimum of 1%, a most likely value of 3%, and a maximum value of 5%, and that the investment return each year is triangular with a minimum of -8%, a most likely value of 5%, and a maximum value of 9%. Use Crystal Ball to find the distribution of the ending retirement fund balance under these assumptions. How do the results compare with the base case?

You may also like