Create and solve your own complex financial model in Excel, based on your professional and/or personal interests. Here are some potential topics:

(1) Create a retirement savings plan. Show the effect of changing certain parameters, like savings rate and retirement age, on wealth.

(2) Model a actual or potential merger between firms. Show whether the merger would increase the total value of the two firms.

(3) Model different portfolio hedging strategies. For example, start with an equity index such as the S&P 500. Try two different hedging strategies: (a) add a position in Treasury bills (b) add a position in S&P 500 index puts. See which strategy is more effective.

USE EXCEL