Advanced Portfolio Analysis. Fund Evaluation.
These calculations must be done in excel. Proper formulas must be used. I will leave the fund choice up to you. It must meet the criteria in the attached file. Choose a fund that an average college student would choose. The number of sheets used for calculations is at your discretion. The report needs to be in PDF format. 4 pages and double spaced. I attached a document of the assignment. Please be sure to follow all the instructions. I will need the PDF report and excel file. The excel calcuations must be also be put as exhibits in the PDF report. You will refer to the exhibits in the report. You will need the following information about the fund for the calculation and analysis: -The most recent fund prospectus -Daily price data of the fund from December 31, 2011 through June 30, 2022 (adjusted closing price on Yahoo Finance) -The Fama/French 5 Factors (2×3) [Daily] from December 31, 2011 through June 30, 2022 (Kenneth French Data Library) Please attach all the information used for the submission. Please include a titaqwle page for the report.