Optimal Complete Portfolio Assignment

Part I: Optimal Complete Portfolio (30 pts)

James migrated in the 1980s to Germany and has been living in Berlin until his retirement last summer. He still earns a small amount of income from a part-time job as mechanical engineer with the Berliner Verkehrsbetriebe (BVG). James lives in his own home in Reinickendorf; his annual expenses are estimated to level out at 30,000. He receives social security payments and collects income from some investments as shown below:

• Assets: Equities: 300,000; Bonds: 250,000; Home: 473,500.
• Income: Assets: 8,000; part-time job: 25,000

The equities have an average return of 10% and a standard deviation of 22%. In contrast, the bonds yield a return of 6% against a standard deviation of 10%. The correlation between the equities and bonds is -0.30 and the risk-free rate is 2% p.a.

James envisions optimally readjusting his investment strategy as well as setting an adequate spending policy. Assumingly, Jamess utility function is of the form:

U =E(r) 1 A2 , where E(r) is the expected return on the risky portfolio, A measures his 2 degree of risk aversion, and 2 denotes the variance of the returns on the risky portfolio. Acting as a financial advisor, your group asked James to answer the risk tolerance questionnaire provided by FinaMetrica in attempts to establish his risk profile. Assume that James score varied with the group that administered the survey:

Group 5: He scored 20 points

• (5 pts) What is the risk-return profile of the current portfolio held by James as described in the previous lines?
• (15 pts) Construct Jamess optimal complete portfolio and compute the associated risk-return tradeoff! Hint: Use the specific A computed in question 1!
• (5 pts) Determine the certainty equivalent (CEQ) rate of return on the optimal risky portfolio, as perceived by James!

Part II: Portfolio Analysis (30 pts)

You are required to replicate the computer lab session completed in class based on the following new information relative to the investment signals to be used:

• Group 5: Nr_Analysts Nr_Analysts;

In addition, you are required to construct 4 portfolios (not three as we did in class). Once you alter the data this way, you should follow the three steps we used to construct your portfolios. Please, do provide a two-slide pitch for your analysis along your code and log- file.

The various files are provided on Blackboard. These are the same as the ones used in class! You get not only the Excel file but also the Stata code from our lab session, which you need to modify for you to solve your assignment.

Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back! Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects.

Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.

To connect with expert and ask your query click here Exam Question Bank