The assignment is intended to help you develop skills of implementing financial models in Excel. The assignment provides you with an opportunity to produce spreadsheet applications that solve and analyse corporate finance problems
2) Obtain from Bloomberg (or Datastream, or Thomson ONE Banker, or
Yahoo!Finance) the beginning of month values for the period 2001-2015 of both
the Dow Jones Utility Average Index and the PHLX Gold/Silver Sector Index.
Assume that you are a risk-averse investor.
For each of the two assets represented by the in... More