Determining Optimal Portfolio in a Three-Asset Portfolio Mix in Nigeria

This study is aimed at determining the optimal portfolio in a three-asset portfolio mix in Nigeria. The research employed majorly two empirical methodologies which were Matrix algebra and Lagrangian method of optimization. Matrix algebra was used to compute the various portfolio weights. Lagrangian method of optimization was useful in obtaining the global minimum variance and the efficient frontier of the portfolio. In order to arrive at the best asset in the portfolio that is expected to yield maximum expected return, the study employed the utility function test. The data used for the study were daily stock prices for First Bank Nigeria Plc, Guinness Nigeria Plc and Cadbury Nigeria Plc obtained from the Nigerian Stock Exchange for the period of January 2010 to December 2013 The result obtained from the analysis indicated that among the three assets chosen in the study, Guinness has the highest utility value of 0.031 with lowest risk of 4.268 and the investment opportunity point ( ) , μ σ which is (0.169, 2.065) lies on the Capital Market Line. The assets of Guinness and First Bank are located above the Global Minimum at point ( ) , μ σ which is (0.10, 1.84) and are said to be efficient assets with high expected returns and low risk. The study therefore concluded that First Bank and Guinness were the only efficient optimal assets in the three asset-portfolio mix and therefore, the preferred choice for every investor since they yielded a high return with minimum variance.


Introduction
The world of investment is strikingly full of uncertainty as investors face the possibility How to cite this paper: Offiong, A.I., Riman, H.B. and Eyo, E.E.(2016) Determining Optimal Portfolio in a Three-Asset Portfolio of either making gain or losing a fraction or even sometimes their entire investment funds.Every investor is faced with the decision of either holding back his investible funds (particularly, if the magnitude of returns on his proposed investment in not known) or invest all the same assuming he is a risk taker.Most investors hold their baskets of investment in more than just one or two portfolio for the obvious reason of diversification which is intended to minimize risk on the investment.Accordingly, [1] was quick to posit that, the main goal of such investors constructing such portfolio was to basically in an attempt to "strike a balance" between mainly two conflicting objectives, namely, making a maximum return/profit at the most minimum risk possible given that a wise choice of constituent assets was made and the proper fraction of investment funds was allocated correspondingly.Harry Markowitz's mean-variance portfolio model, which is the foundation of modern portfolio theory, assumes that all available information and expectations on future prices are contained in the current prices of assets, and thus treat future payoffs and returns as random variable.In simple terms, it can be assumed that the returns of an asset (say asset i), follow a Gaussian distribution in which the expected mean value of the returns, r  and their variance δ 2 capture all the information concerning the expected outcome, likelihoods and range of deviations from it [1].However, the common feature of most investment is that the actual returns on investment sometimes vary significantly from their expected returns.The magnitude of such variances is often predicated on the level of information asymmetry that exists in the market.This is the risk that is mostly inherent in all financial assets and thus, necessitates a careful selection of investment portfolio by investors.
In choosing or combining assets in a portfolio, it is important for investors to know the degree of covariance that exists between the assets.Covariance reflects the degree to which the returns of two securities vary or change together.For instance, assets that have a positive upward co-movement will tend to reduced returns, while assets that have a downward and negative co-movement tend to yield increase returns.Thus, upward and downward deviations from the expected return will and can be reduced through diversification since diversification has the ability to reduce the variance of expected even when both have the same magnitude of expected return.As the number of securities included in a portfolio increases, the importance of the risk of each individual security decreases whereas the significance of the covariance relationship increases [2] Arguably, only very few investors have recognized the role of diversification in portfolio risk reduction, while others are ignorant about it.The idea of identifying the appropriate asset mix is the main role in determining the portfolio risk and return.For every portfolio investment strategy, overcoming the problems of selection and allocation of investment funds to the constituent assets are of major concern to many investors [3] [4].A potential portfolio investor should plan his investment objectives which should be stated in terms of return and risk tolerance.While stating his objectives, the investor should consider the constraints arising out of some factors like liquidity, which is the speed with which an asset can be sold.
Allocation of investment capital in a three-asset portfolio mix constitutes a problem to potential investors, institutions and corporate organizations.Several investors in Nigeria often face the difficulty of how to allocate their capital to companies quoted in the stock market in order to maximize returns while minimizing risk as ultimate goal.
Apart from investors facing the challenge of selecting the type of asset to invest in, they also lack technical knowledge on how to allocate their funds to the selected portfolio.
Most available literatures have enunciated portfolio selection given two assets while ignoring the case of multi-assets mix in a portfolio.This study intends to show how to determine the optimal portfolio in a three-asset portfolio mix through understanding 1) how to determine the fraction capital that should be allocated to the various assets 2) how to obtain a maximum expected return at the most minimum risk 3) how to determine the optimal portfolio among all possible efficient portfolios and 4) how to determine the best asset in a three-asset portfolio mix.The research utilizes daily stock prices for the period 2010 to 2013 from the Nigerian Stock Exchange for three institutional investors, viz, First Bank Nigeria Plc, Guinness Nigeria Plc and Cadbury Nigeria Plc.

Review of Related Literature
Several studies have been conducted on Portfolio theory due to its vital importance in finance literature though pioneered by [5] and popularized by [6]- [11].
Introducing the model for Portfolio selection and stating the two stages of Portfolio selection, [5]  Estimating utility by a function of mean and variance of return of 149 mutual funds, [12] found that ordering portfolios by mean-variance rule was almost identical to the order obtained by using expected utility.The mean-variance formulation provides a very good local approximation to expected utility functions using both monthly and semi-annual return data [13].According to the study, investors can confidently rely on mean-variance optimization, with attitude towards local changes in portfolio value reflected by the local relative risk-aversion.
Investigating the optimal holding period (investment horizon) for the classical meanvariance portfolio model, [14] used the historical transaction record of Istanbul Stock Exchange ISE-100 index stocks data for empirical analysis.The results of the study showed that portfolio returns with varying holding period has a convex structure with an optimal holding period.While investigating optimal portfolio allocation in a world without treasury securities, Bomfim [15] examined the extent to which investors' portfolio allocation decisions are likely to be affected by the retirement of all federal government debt.He noted that, if current projections of future budget surpluses materialize, investing in Treasury se-curities-an asset class with which investors have long been familiar-could eventually become a thing of the past.Thus, under such circumstances, highly conservative investors-whose portfolios have risk-return characteristics akin to money market instruments-and very aggressive investors-that hold mostly equities-stand to be the least affected by the removal of Treasuries from the pool of investable assets.[16] sought to determine the relationship between portfolio risk and portfolio size, the optimal portfolio size in the Nairobi Securities Exchange and the extent of risk reduction achieved by diversification.The results of the study indicate that diversification results in risk reduction benefits.Portfolio risk decreased as the number of securities in the portfolio increased.Their result further observed that Risk reduction is initially rapid with risk reduction of 40% is achieved with a portfolio size of 8 securities.Adding 8 more securities achieves a further 5% reduction in portfolio risk while the next 14 additional securities achieves only a further 2% risk reduction.
[17] used linear programing model to determine optimal portfolio mix for Multigrow Insurance Company in Ghana who had obtained GH₵ 200,000 cash facility but were experiencing difficulties in determining how much to invest in each of five investment areas in order to maximize return.Based on the methodology used optimal portfolio mix was obtained for the Insurance Company.[18] explored which asset classes add value to a traditional portfolio of stocks, bonds and cash by using ten different investment categories simultaneously in a mean-variance analysis as well as a market portfolio approach.The study further sought to determine the optimal weights of all asset classes in the optimal portfolio.The mean-variance analysis suggested that real estate, commodities and high yield add most value to the traditional asset mix of stocks, bonds and cash.The authors further opined that adding these three asset classes comes close to an all asset portfolio.The portfolio with all assets showed a diversification benefit along the efficient frontier that varies between 0.40% and 0.93% in the volatility range of 7% to 20%.Based on their analysis the authors concluded that the proportion of non-traditional asset classes appearing in the market portfolio is relatively small, and thus, investors must determine their own individual constraints, while the market portfolio and the portfolio optimized by mean-variance are considered as the boundaries for the asset classes.
[19] examined and developed a sensitivity analysis for differential risk premiums in REIT stocks and the effect in determining an optimal port-folio mix by applying mean variance analysis in the US financial markets.Furthermore, the study used the meanvariance approach to illustrate ways to maximize the utility of the optimal portfolio with varying degrees of risk aversion.Two different risk premiums between stocks and bonds, such as 0.006% and 0.012% were applied to examine the portfolio choices.Their result showed that when the risk premium of REITs and stocks was 1.5%, investors with risk aversion equal to 1 to 6 were better off investing almost all capital in REITs.
The study suggested that this group of investors can short sell their bonds and put a very small weight in stocks.Furthermore, investors can also derive the same benefit even when the risk premium of REITs and stock is 2.0% with a risk aversion of 1 to 9.
However, when the risk premium of REITs and stock is 2.5%, the investor's risk aversion factor does not matter, and it suggests that investors can short sell bonds and invest in REITs having a larger weight in the optimal portfolio.

Determination of Optimal Portfolio
Following [20], the rule for selecting the best asset is known as utility function test of the portfolio.Utility refers to the expected return of the portfolio minus risk penalty.
The risk penalty is given by: Risk squared is the variance of the portfolio and risk tolerance is a number from 0 through 100.It is difficult to define the concept of risk tolerance precisely because the level is set by financial situation or financial disposition and preference of an investor.
The concept of risk tolerance depends on the behavioral pattern of investors.For instance, if an investor experiences an increase in wealth, he/she will choose to increase (or keep unchanged, or decrease) the fraction of the portfolio held in the risky asset if relative risk aversion is decreasing (constant, or increasing).Thus, the capacity to bear the risk of losses without being upset depends on financial ability and personal temperament.Thus, the best asset for investment would be the one from the efficient frontier that maximizes the utility.

Mathematical Modeling of Two Risky Assets
Consider a portfolio containing two financial assets, the investor's decision may be based on the expected returns and variances which are the two sufficient parameters in which normal distribution may be defined [21].Therefore, the expected value or return represents the weighted average rates of return while the variance represents the level of risk.
Assume that there is a utility function of the type ( ) Any rational investors would seek to maximize or minimize the utility.That is, maximum expected return at a given level of risk or minimum risk at a given level of return.If we assume that there are only two risky assets, A and B, available for consideration in an investment portfolio.Since the portfolio contains two assets of different proportions, x and ( ) − , the functional relationship between risk and return can be easily determined [22].
In this case, we have where P R is the portfolio return, A x and B x are the portfolio weights.
The portfolio weights sum to one by taking expectation of equation ( 6) the mean portfolio return is found to be Consequently the portfolio variance is and the portfolio standard deviation is

Mathematical Formulation of Minimum Risk Two-Asset Portfolio Mix
Let ( ) ( ) The minimum Risk Portfolio is obtained by minimizing the portfolio standard deviation.Taking the first derivative of Equation ( 11) with respect to A x , we obtain To minimize P σ , set the first order derivative to zero; The sufficient condition for p σ to have a global minimum value at A x is that The degree of correlation between two assets A and B is used to determine the shape of the frontier within the portfolio.There are three assumptions about the correlation between two assets A and B.
1) Perfect positive correlation, We simplify Equation ( 7) as: When the correlation coefficient assumes the value +1 it means that all the points in the scattered diagram lie on the same straight line.Thus, the slope is positive which means that while the value of asset A is increasing, the value of B is also increasing or the value of A decreases as B decreases [23].
2) Perfect negative correlation, We simplify Equation (10) as: When the correlation coefficient assumes the value −1 it means that the slope is negative that is while one of the assets is increasing the other is decreasing [23].
3) Non-perfect correlation, 0 ρ = When the correlation coefficient takes the value zero, it means that there is no linear relationship between the assets A and B or that assets A and B are linearly uncorrelated [23].Therefore, we simplify Equation (10) as: ( ) Consider the mean and standard deviation in the relationship derived from the equations ( 9) and ( 16) respectively.We can write the slope of the frontier as:  17) depends on the denominator.Notice that the slope is vertical at some point and portfolio which produce this point is known as minimum variance portfolio [18].

Research Methodology
The study utilized daily stock prices for First Bank Nigeria Plc, Guinness Nigeria Plc and Cadbury Nigeria Plc from January 2010-December 2013.The choice of assets was determined by their high level of stock returns among other stocks in their sub-sectors.Stock returns was calculated as thus, Average rate of return R expressed as: [ ] where: R = rate of return.n = number of returns.The stock return in any time period is given as ( ) where: t P is the price at current time.
1 t P − is the price at previous time.

Modeling a Three-Asset Portfolio Mix
Previously, we had model a two-asset mix, this model is common in most literatures and books.However, it is not common to find a model for a three-asset mix portfolio.If we consider a portfolio containing three financial assets (A, B and C), recourse is taken to matrix algebra which can represent a lot of data by putting them into groups which are called rectangular arrays.It is assumed that investors may invest in a total of three risky assets.
Suppose i R (

, , i A B C =
) indicate the return on asset i with an assumption that the constant expected return (CER) model holds: Suppose x represents the fraction of capital in asset i ( ) and assume that all capital is invested in the three assets so that 1 The return for the portfolio Taking expectations of both sides of the above equation we obtain This may be re-written as where Variance of the portfolio is written as ( ) It is observed that the variance of the portfolio return is dependent on three variance terms and six covariance terms.Therefore, the covariance terms are twice of the variance terms which contribute to the variance of the portfolio.Matrix notation can be used to simplify the portfolio algebra for easy calculation [22].

( )
, , m m m m ′ = be global minimum variance portfolio for three assets which is obtained by solving the constrained minimization problem.Following [4], the constrained minimization problem is given by: s.t 1 The lagrangian for this problem is and the first order conditions (FOCs) for a minimum are

A A B AB C AC A B B A AB C BC B C C A AC B BC C
The above conditions are made up of four linear equations in four unknowns.It can be solved to obtain the weights of global minimum.The four linear equations describing the first order conditions have the matrix representation.
or, more concisely, where ∑ is the covariance matrix.I is the identity matrix.I ′ is the transpose of I. m is the global minimum variance portfolio weights.λ is the Lagrange multiplier.
The system (25) is of the form Then the solution for z m is

Finding Efficient Portfolios
There are two methods of finding efficient portfolios [4].First, investors seek to maximize the portfolio expected return for a given level of risk.Let The investor in practice prefers to embrace the target expected returns rather to target risk levels.Thus, the second problem in Equation ( 28) is most often solved.
To solve the constrained minimization problem (11), first form the Lagrangian function.
The lagrangian for this problem is The first order conditions for a minimum are the linear equations.

A A B AB C AC
The above conditions are made up of five linear equations in five unknowns, , , , , x x λ λ In matrix algebra, it is represented as: The system above is of the form where 1 0 ,0 2 2 1 0 0 0 , and 1 0 0 1 Then the solution for z x is consist of the first three elements of x z for minimum variance portfolio with expected return ,0 p µ is greater than or equal to the expected return on the global minimum variance portfolio then x is an efficient portfolio [4].

Plotting Efficient Frontier
Analytical expression for a minimum variance portfolio can be used to show that any minimum variance portfolio can be created as a convex combination of any two minimum variance portfolios with different target expected returns.If the expected return on the resulting portfolio is greater than the expected return on the global minimum variance portfolio, then the portfolio is an efficient frontier portfolio.Otherwise, the portfolio is an inefficient frontier portfolio.Thus, to compute the portfolio frontier in ( ) space, we only need to find two efficient portfolios.The remaining frontier portfolios can then be expressed as convex combinations of these two portfolios.
Proposition I: Formulation of a frontier portfolio using two efficient portfolios [4].

Suppose ( )
, , and portfolio y solves Suppose α is any constant and define the portfolio z as a linear combination of portfolios, x and y: Then 1) The portfolio z is a minimum variance portfolio with expected return and variance given by ( ) , where , p m µ is the expected return on the global minimum variance portfolio, then portfolio z is an efficient portfolio.Otherwise, z is an inefficient frontier portfolio.This particular derivation of portfolio frontier was carried out by another Nobel Laureate [24].

Analysis and Discussion of Result
The study begins by examining the descriptive results from the three selected companies.The result presented in Table 1 revealed that First Bank had a mean expected return of 18.29 percent followed by which had a mean expected returns of 17.73 per cent.
The result observed that Cadbury had a mean expected return of 1.68 percent.
The result for standard deviation (which is the measure for the riskiness of the asset) revealed that First bank Nigeria, Guinness and Cadbury Nigeria Plc had standard deviation of 3.11, 2.73 and 3.26 respectively.Thus, Cadbury Nigeria Plc had the least return on asset but with the highest standard deviation.Table 2 shows the collision of the mean, variance and covariance values for all the descriptive statistics on First Bank, Guinness and Cadbury.These values are used as aid in the optimization of the three assets portfolio.indicates Global Minimum, First Bank, Guinness, Cadbury and Capital Market Line (CML) drawn from the expected return of the efficient frontier.From the graph, Guinness lies on the capital market line with higher expected returns and lower risk at the point ( ) , µ σ which is (0.16, 2.06).First Bank is slightly away from the capital market line with higher returns and lower risk at ( ) , µ σ which is (0.18, 2.18).Cadbury is far away from the capital market line with lowest expected returns and highest risk at the  point ( ) , µ σ which is (0.01, 3.39).Therefore, among the three assets, Guinness Nige- ria is the most efficient asset as indicated in the graph of efficient frontier.

Summary
The study has shown that among the three assets in the portfolio, two assets Guinness and First Bank are efficient optimal assets and Cadbury is the only inefficient asset in the portfolio.Guinness was observed to have the lowest risk of 4.268 while Cadbury had the highest risk of 11.538.The study affirmed that the Global Minimum Variance Portfolio provided a suitable and recommended aid in selecting optimal portfolio with expected return of 0.131 and variance of 3.397.The utility function test revealed that Guinness is an efficient optimal asset and the best company for investment since it has the highest utility value of 0.031.In period of recession or deep economic doldrums, the asset of Guinness Nigeria Plc will still have the ability to provide some protection from an extreme loss even when other assets vale depreciates.A careful note of caution needs to be explained here that the research is not intended to lure investors to invest in Guinness Nigeria Plc, but rather to examine and explain how investors can select an optimal asset given a three-asset portfolio mix.
stated that the first stage starts from examination and ended the principle with the opinion about the potential performance of available securities.The second stage of this principle begins from the relevant views on the potential performance of securities and ended with the selection of Portfolio.Focus of Markowitz study was the second stage of Portfolio selection.The model developed by Markowitz works on the mechanism of expected rate of return and expected risk of Portfolio.
sign of the slope in Equation ( m ′ = consist of the first three elements of m z for the global minimum variance portfolio with expected return , level of risk.The constrained maximization problem is defined as: the risk of portfolio for a given level of return.Let ,0 p µ denote a target expected return level.

µ
is the target rate of return with val- ue of 0.016.The variance has value of 11.53 and the standard deviation has value of 3.39.The value 11.53 for variance of asset C indicates that asset C has the highest risk.The expected returns and variances are used to aid the selection of optimal portfolio.

Figure 1
Figure 1 represents the efficient frontier for three assets where the expected return is plotted against the risk.All efficient assets are above the Global Minimum which means that the frontier portfolio is efficient.All assets located above the Global Minimum at point ( ) , µ σ which is (0.10, 1.84) are efficient assets with high expected returns and low risk.These assets are preferred choice for every investor.

Figure 2
Figure2shows the risk and return trade-off for three asset portfolio.In this graph, the y-axis shows the expected returns and the x-axis shows the risk.It clearly

Figure 1 .
Figure 1.Efficient frontier for three assets.

Table 1 .
Descriptive analysis for the first bank, Guinness Plc and Cadbury Nigeria Plc.

Table 3
shows the Global Minimum result obtained from the returns.The portfolio x =The expected return of the portfolio is 0.13.The variance is 3.39 and the standard deviation is 1.84.This table represents the minimum risk portfolio for the three assets A, B and C.

Table 4
The variance has value of 4.76 and the standard deviation has value of 2.18.The variance has value of 4.26 and the standard deviation has value of 2.06.The value 4.26 for variance of asset B indicates that asset B has the lowest risk TableTable 6shows efficient portfolio result for Cadbury Nigeria.The portfolio weights Bµ is the target rate of return with value of 0.16.

Table 3 .
Global minimum variance portfolio.

Table 4 .
Efficient portfolio result for first bank Nigeria.

Table 5 .
Efficient portfolio result for Guinness Nigeria.

Table 6 .
Efficient portfolio result for Cadbury Nigeria.