This Exam is an assessment of the following course CLOs:
Use spreadsheet software to analyze financial data and compute return and risk measures of financial securities in a complex environment.
Download the historical daily closing price of Ford Company (F) from Yahoo Finance website for the period 1/1/2010-31/12/2014, download the data to excel, Use Excel formulas to compute the following:
-Holding period return
-Average holding period return
-Variance