代做Assignment 3调试Haskell程序

日期：2024-03-26 03:53

Instructions:

1. This is a group assignment. Each group submits one copy of answers only.

2. Write down your answers on a separate Word file. Write down your group list and submit your answers (Word file and Excel file) via the link provided in Moodle before the deadline.

Case 1

John Jackson is a 50-year-old engineer who works in Hong Kong and plans to retire on his 60th birthday. Jackson meets with your, his financial advisor, to discuss his financial goals during his retirement. One of his financial goals is to purchase an apartment in the U.K., his home country, for his retirement. After a long discussion with him, you have decided to use the goals-based approach to construct a portfolio for his financial goal.

You have asked Simon Sun, your colleague, to develop capital market expectations for the asset classes you selected for Jackson’s portfolio. The capital market expectations are given in the worksheet “By Solver” in the Excel file <03a-Portfolio Optimization.xlsx>. Your next step is to identify the optimal portfolio for Jackson’s financial goal.

1. Suppose you believe one of the portfolios, A, B, C, and D with an expected return of 7%, 8%, 9%, and 10%, respectively would be optimal. Calculate the standard deviation of returns (in 2 decimal places) of each of the portfolios using the Solver function and fill in the following table:

Portfolio	A	B	C	D
Expected return	7%	8%	9%	10%
Std dev.

2. Suppose Jackson requires an 85% chance of purchasing the apartment. Which of the above portfolios can minimize the savings today? Write down your arguments and steps for your answer. (Hint: modify and use the worksheet “Goals Based” for your work.)