Tangency Portfolio

 

Investment and Portfolio Management
In this assignment, students are expected to create a complete portfolio made up of two risky
assets in the forms of two Saudi shares trading at Tadawul, and one risk-free asset in the form
of 4-week SAMA bill. This assignment is individual based and should submitted on
blackboard on 18-April-2022.
Using excel, students should:
1) Find the expected return, variance, standard deviation for each stock using historical
data from 2010-2019.
2) Determine the correlation and covariance between the two stocks.
3) Find the beta of each stock in relation to the market index TASI.
o β=
Cov(s,m)
Var(m)
4) Find the portfolio’s expected return, variance, standard deviations, and sharp ratio by
varying weights between stock1 and stock2.
5) Using the Solver tool in excel, find the minimum-variance portfolio and optimal
portfolio.
6) Find the complete portfolio assuming risk-free rate of 4-week SAMA bill average:
o http://www.sama.gov.sa/en-US/GovtSecurity/pages/SAMABills.aspx
7) Graph the above results.
Summary Report: students should provide a report detailing the reasons for choosing the
two risky assets and covering the above graph and end-results.

 

Sample Solution

Investors are mostly looking at various financial assets in order to increase their profits. However, expected earnings are not independent of risk, which is assessed by return volatility. Individuals, in this sense, build a portfolio that includes a variety of investing tools with varying weights. Diversification is the term for this method. To build a portfolio, minimal variance assets are typically picked. This traditional strategy, on the other hand, did not take into account the relationship between the assets in the portfolio. It is not enough to choose assets with low variance to reduce portfolio risk completely, because stocks may move in lockstep if we don’t know their covariance values.

Decision-making is an act as old as humankind and the ancestors of modern humans made daily decisions based on interpretations of dreams, smokes, divinations and oracles (Buchanan and O’Connell, 2018). According to Gigerenzer (2011), modern decision-making dates back to the seventeen century; when Descartes and Pointcarre invented the first calculus of decision-making. Buchanan and O’Connell (2018) attributes the popularity of modern decision- making to Chester Barnard in the middle of the twentieth century; for importing the terminology “ decision-making” which was mainly a public administration concept to the business sector to substitute restrictive narratives like policy making and resource allocation. William Starbuck, a professor in Oregon University acknowledges the positive impact of Chester Barnard’s introduction of decision- making on managers by explaining that policy-making and resource allocation are never ending acts, while decision denotes the conclusion of a discussion and start of an action plan (Buchanan and O’Connell, 2018). In addition, Gigerenzer (2011) suggests that the contemporary view of decision-making involves the use of heuristics and human information processing; which is the revolutionary work of Herbert Simon. Heuristics are mental short cuts, cognitive tools and rules of thumb developed through experiences, to enable individuals make judgements and arrive at decisions quickly (Gigerenzer and Gaissmaier, 2011).

2.6 Decision theory

Decision theory is a divergent field because of the different perceptions held by researchers about decisions (Hansson 2005). Decision theory also known as the theory of choice is the study of the rationale behind the choices made by an agent (Stanford Encyclopaedia of Philosophy, 2015). Decision theory deals with goal oriented behaviour in the presence of alternatives (Hansson, 2005). Decision theory can be broken into three branches namely; normative, descriptive and prescriptive branch (Vareman, 2008). Normative theory deals with how to make accurate decisions in a scenario of uncertainty and values, descriptive theory, examines the possibility of imperfect individuals making decision and prescriptive theory is a combination of descriptive and normative theories to achieve the best decision at any given situation (Vareman, 2008). However, there is no universal agreement on a standardized classification on the theories and therefore many researchers have classified the theories as either rational or non-rational (Gigerenezer, 2001; Hansson, 2005; Oliveira, 2007). In differentiating the rational from non-rational theory, Gigerenezer (2001) id

This question has been answered.

Get Answer