banner

How Can Financial Information Systems Software Help Portfolio Managers in Selecting Optimal Investment Portfolio?

Abd El-Moneim Ahmed El-Tohamy[·]

Noha Mohamed Hamza[*]

 

Abstract

This paper aimed to providing and examining financial information system software that can help finance mangers in forming optimal investment portfolio. The ·paper investigates the portfolio formation of Misr Iran Development Bank III (Wafi) and National Bank of Egypt VII. The formation of. the portfolio based on 42 Egyptian mutual funds. The data covers 150 week for each Bank from January 2010 to December 2012. The paper found that a financial information system software can be used in supporting portfolio managers m forming and managing the optimal investment portfolio.

  1. Introduction

One of the problems in finance that is nowadays very difficult to solve without the help from intelligent techniques, is that of the selection of an optimal investment portfolio. Decision makers have partial information about the market and have to deal with high level of uncertainty. Portfolio management is a complex, subjective and generally unstructured process. Several intelligent system techniques have been developed for selecting an optimal portfolio. Neural networks ( Casas, 2001; Chapados & Bengio , 2001; Lowe, 1994; Zimmermann, Neuneier, & Grthmann, 2002; Zimmermann & Grthmann, 2005), genetic algorithms (Lai, Yu, Wang, & Zhou, 2006; Lin, Cao, Wang, & Zhang, 2004; Zhou, Yu, Huang, Wang, & Lai, 2006), rule-based expert systems including multi-agent systems (Cohen & Lieberman, 1990; Seo, Giampapa, & Sycara, 2004; Sycara, Decker, & Zeng, 1998), and support vector machines (Fan & Palaniswami, 2001) have all found applications in portfolio selection. However, they all face certain drawbacks. One of the main disadvantages of the mentioned intelligent system approaches is that they neglect dependencies among characteristics of assets such as return and risk. Therefore, these methods do not consider how changes in one criterion would influence changes in another criterion. Moreover, the mentioned methods assume that data are precise. However, the return and the risk of an asset are only predictions, and the reputation of a company is often subjectively defined. Therefore, the data available in reality are not as precise as assumed in the models. Thus, the proposed financial information system software is based on Markowitz (1952) Theory, Modern Portfolio Theory and Capital Asset Pricing Model.

The construction of the best combination of investment portfolio is an optimization problem: Select the best assets to form portfolio, (Ruben & Lozano , 2008) the portfolio optimization problem uses mathematical approaches to model the investment portfolio. It aims to find an optimal set of assets to invest on, as well as the optimal investments for each asset. Non-linear programming technique – used to solve portfolio selection problem – refers to mathematical programming with continuous & discrete variables and non-linearities in the objective function and constraints. Generalized Reduced Gradient (GRG) Method, (Etienne & Gauthier, 2006) is general and in principle applicable to any convex, non-linear programming problem with equality and inequality constraints, (Hong & Kang, 2004) many algorithms have been used to solve general non-linear problems. The algorithm developed is based on the concept of reduced gradient & is an effective and efficient approach. The generalized reduced gradient method has been proven to be a precise and accurate method for solving non-linear programming problems.

In summary, the main purpose of this paper is providing financial information system software that can help portfolio managers in forming optimal portfolio using the non linear programming based on generalized reduced gradient method in solving the optimization problem. In order to examine the introduced software, we choose the Egyptian fund of funds as our objective market.

Fund of funds is an investment strategy of holding a portfolio of other investment mutual funds rather than investing directly in shares, bonds or other securities. There are two fund of funds in Egypt, Misr Iran Development Bank III (Wafi) and National Bank of Egypt VII.

We used the Egyptian mutual fund in forming the portfolio of fund of funds.

2-Key Factors in Forming the Portfolio

  1. Expected rate of Return E(r)

The expected rate of return E(r) of investment is the statistical measure of return, which is the sum of all possible rates of returns for the same investment weighted by probabilities, (Reilly & Brown, 2011):

(1)

Where: Pi = probability of rate of return.

rj = rate of return.

2.2Fund Risk

One of the best-known measures of risk is the variance, or standard deviation of expected returns. It is a statistical measure of the dispersion of returns around the expected value whereby a larger variance or standard deviation indicates greater dispersion. The idea is that the more disperse the expected returns, the greater the uncertainty of future returns, (Reilly & Brown, 2011).

The variance, or standard deviation of returns as the measure of risk is the variation of possible rates of return, R;, from the expected rate of return [E(Ri] as follows:

 (2)

where:

Pi is the probability of the possible rate of return, Ri

2.3Covariance of returns

Covariance is a measure of the degree to which two variables “move together” relative to their individual mean values over time. In portfolio analysis, are usually concerned the covariance of rates of return rather than prices or some other variable. A positive covariance means that the rates of return for two investments tend to move in the same direction relative to their individual means during the same time period. In contrast, a negative covariance indicates that the rates of return for two investments tend to move in different directions relative to their means during specified time intervals over time, (Reilly & Brown, 2011).

The magnitude of the covariance depends on the variances of the individual return series, as well as on the relationship between the series.

The covariance statistic provides an absolute measure of how they moved together over time.

For two funds, i and j, the covariance of rates of return is defined as:

  (3)

2.4Correlation coefficient of returns

Con-elation is the degree of relationship between two variables. The con-elation coefficient between two assets is closely related to their covariance. When the con-elation is – 1.0, the return are perfectly negative con-elated meaning that as one of the variables increase or decrease in value, so does the other in opposite proportions. The con-elation coefficient for assets without any con-elation at all is zero, (Reilly & Brown, 2011).

Where:

rij = the correlation coefficient of returns

σi = the standard deviation of Rit

σj = the standard deviation of Rit

Covij = the covariance between the rates of return for assets i and j.

2.5 Beta Coefficient

The beta coefficient, b, is a relative measure of non­ diversifiable risk, it is an index of the degree of movement of an asset’s retun1in response to a change in the market retun1. An asset’s historical returns are used in finding the asset’s beta coefficient. The market return is the return on the market portfolio of all traded securities, (Reilly & Brown, 2011).

Where:(5)

Covjm = covariance between returns of asset j and the market portfolio.

 = variance of returns on market portfolio.

3-Key Factors in determining the efficiency of the formed portfolio

  1. Portfolio Return

The expected rate of return for a portfolio of n funds is simply the weighted average of the expected rates of return for the fund in the portfolio Ri· This computation of the expected return for the portfolio [E(Rport)] can be generalized as follows, (Reilly & Brown, 2011):

Where:(6)

Wi= the percent of the portfolio in fund i

E(Ri) = the expected rate of retun1for fund i

  1. Portfolio Total Risk

The total portfolio risk can be viewed as consisting of two parts:

Diversifiable risk (unsystematic risk) represents the portion of a fund’s risk that is associated with random causes that can be eliminated through diversification and Non­ diversifiable risk (systematic 1isk) is· attributable to market factors that affect all funds; it cannot be eliminated through diversification, (Brigham & Ehrhardt, 2007).

The portfolio total risk can be expressed as follow:

Total Risk = Variance = Market risk + Diversifiable risk

Where:(7)

σ2port is the port f olio total variance

bi is the fund beta coefficient

 is the variance of the market

 is the varince of fund i

wi is the percent of the portfolio in fund i

  1.  Portfolio Beta

The beta of a portfolio can be easily estimated by using the betas of the individual fund it includes, (Brigham & Ehrhardt, 2007).

Where:(8)

bp is the portfolio beta.

wj represent the proportion of the portfolio’s total value represented by fund j.

bj equal the beta of fund j.

4- Financial information System

A financial information system is a type of business software used to input, accumulate, track and analyze financial data for optimal financial planning and forecasting decisions and outcomes. It produces reports such as fund performance reports, cash flow forecasts, what-if analysis reports and budgets. The output produced helps in making good financial management decisions thus helping the managers run the business effectively, (Elizabeth, 2011).

4.1 System and its parts

A system is an interrelated set of business procedures (or components) used within one business unit, working together for some purpose. A system has seven characteristics which are, (Joseph & Jeffery, 2012):

Inputs: the raw data collected to the system.

Outputs: processed data, the system results.

Constraint: a limit to what a system can accomplish.

Interface: point of contact where a system meets its environment, or where subsystems meet each other.

Environment: everything external to a system that interacts with the system.

Purpose: the overall goal or function of a system.

Boundary: the line that marks the inside and outside of a system, and that sets off the system from its environment.

Interrelated: dependence of one part of the system on one or more other system parts.

Component (subsystem): An irreducible part or aggregation of part s lhal makes up a sylcm; also called a subsytem.

4.2 Financial Information System Model

Figure (1) Financial Information System Software Model.

  1. The system Basic inputs is the lima return, tuna variance, fund size, Beta of the fund, the market variance, total equity of the portfolio that is required to invest, and fund of fund size. These inputs are sub-files that serve the main system as inputs.
  2. The system processes are based on Mathematical Models in forming the portfolio. We choose the Non-Linear Programming using Generalized Reduced Gradient method in forming the fund of funds portfolio.
  1. The system basic output is the portfolio formula (the invest weight in every fund) which maximize the return of the total fund of funds portfolio and minimize its total risk.
  2. Internal Environment is the fund of funds management policy.
  • Fund of funds invest in purchasing certificates issued by other Egyptian investment funds working at the Egyptian stock exchange authority under the supervision of capital market authority.
  • The fund of funds shall not invest in closed funds with more than “(20% in Wafi fund) (40% in NBE)” of its total assets with the condition to be restricted in the Egyptian stock exchange.
  • The fund of funds may invest up to 95% of its total net asset value in equity funds or balanced funds, and may invest up to 100% of the total net value of its assets in monetary funds.
  1. External Environment is the investment constraints powered by the executive regulation of capital market law no. 135 of 1993.
    1. The fund shall not invest in the investment certificates issued by other investment funds by more than 20% of its assets, nor to exceed 5% of the assets of each investment fund in which it is investing.
    2. The fund of funds shall invest in at least 5 funds.
  2. Purpose forming fund of funds portfolio.
  3. Components (subsystems) are the systems that calculate the mutual fund variance, return, beta, market variance that used as inputs to this system.

5- Methodology

5.1Research Approach

System analysis method used in forming the financial information system software.

5.2Research Hypothesis

There are significant differences between the proposed financial information system software and the other investment methods used in forming fund of funds portfolio.

5.3Variables definitions

  1. Independent variables:
    1. Investment percent
    2. Fund variance
    3. Fund return
    4. Beta of fund
    5. Market variance
    6. Fund size
    7. Fund of fund size
    8. Number of invested funds
  2. Dependent variables: System Efficiency and Effectiveness.

Null Hypothesis: There are no significant differences between the fund of funds return using the financial information system software, and the actual return of the fund of funds.

Alternative Hypothesis: There are significant differences between the fund of funds return using the financial information system software, and the actual return of the fund of funds

5.4 Research population

There are only two Fund of Funds found in Egypt, which are Misr Iran Development Bank III (Wafi) and National Bank Of Egypt VII. Therefore, the researcher targets the whole population from January 2010 to December 2012.

6- Data Analysis

  • For developing the software application.

We depending on the C-Sharp (C #) Programming Language, Microsoft Visual Studio 2010, .Net Framework 4.0 and Microsoft SQL Server 2008 in creating the database.

  • For Forming the Portfolio and solving the optimization problem.

The software application based on the Non Linear programming using the Generalized Reduced Gradient Model.

  • For Testing the Hypothesis

We depending on the Z-Test in testing the research hypothesis as the two samples are independent and the sample is greater than 30.

7- Statistical Results

There are two samples were used for testing . The first one is for National Bank of Egypt VII and the second is for Misr Iran Development Bank III (Wafi).

Table (1) Represent the Z-test results of the first sample of National Bank of Egypt VII, which shows that the Z value is (- 4.614) which fails in the rejected area, so we rejected the null hypothesis and accepted the alternative hypothesis.

Table (2) Represent the Z-test results of the second sample for Misr Iran Development Bank III (Wafi), which shows that the Z value is (-2.1179) which fails in the rejected area, so we rejected the null hypothesis and accepted the alternative hypothesis.

8-Findings

The financial information system software helps portfolio managers in forming and managing optimum fund of funds portfolio which cannot be done by human intuition alone. The process of financial analysis can be simplified and optimized by using such financial software, which helps finance managers assemble accurate and clear data with reports that pull real-time information.

9- Conclusion

Gathering and analyzing financial data are central to the success of a business. Financial information systems software analyzes financial data and help managers in making investment decisions. Financial information system software can use different mathematical models such as non-linear programming based on generalized reduced gradient method in forming optimum investment portfolio.

References

First: Books

  1. Elizabeth Hardcastle (2011), “Business Information System”, Elizabeth HardCastle & Ventus Publishing ApS.
  2. Eugene F. Brigham & Michael C. Ehrhardt.(2007). “Financial Management, Theory and Practice”, 11th edition, Thomson South­ Western press .
  3. F. Reilly & K. Brown (2011) “Investment Analysis and Portfolio Management”, Eighth Edition, Thomson South-Western press.
  4. Joseph S. Valacich, Joey F. George, Jeffery A.Hoffer, (2012), “Essentials of Systems Analysis And Desgin”, Pearson Hall, P.34

Second: Journals

  1. Casas, C. A. (2001), “Tactical asset allocation: An artificial neural network based model”. In proceedings of international joint conference on neural networks, Vol. 3 (pp. 1811-1816).
  2. Chapados, N., & Bengio, Y. (2001), “Cost functions and model combination for VaRbased allocation using neural networks”, IEEE Transactions on Neural Networks, (pp. 2-15).
  3. Cohen, C., & Lieberman, M. D. (1990). “A report on FOLIO: An expert assistant for portfolio managers. Investment Management: Decision Support and Expert Systems”, Elsevier Science, Expert Systems with Applications, (PP. 135-139).
  4. Etienne Jamoulle & Gauthier Dupont (2006), “A Reduced Gradient Method with Variable Base using Second Order Information, applied to the constrained and optimal powerflow”. System Europe Journal, (pp. 9-15), www.systemseurope.be.
  5. Fan, A., & Palaniswami, M. (2001), “Stock selection using support vector machines”. In Proceedings of international joint conference on neural networks, Vol. 3 (pp. 1793).
  6. Harry Markowitz (1952), “Portfolio Selection”, The Journal” of Finance , (Vol. 7, No. 1., pp. 77-91).
  7. Hong-Tau Lee, Sheu-Hua Chen & He-Yau Kang (2004), “A study of generalized reduced gradient method with different search directions”. Baidu research and development, (pp.10-20).
  8.  Lai, K. K., Yu, L., Wang, S., & Zhou, C. (2006). “A double-stage genetic optimization algorithm for portfolio selection”, Berlin Heidelberg: Springer-Verlag, part III. LNCS (Vol. 4234, pp. 928- 937).
  9. Lin, L., Cao, L., Wang, J., & Zhang, C. (2004). “The applications of genetic algorithms in stock market data mining optimization”, Data mining V. WIT Press, (pp. 175-196)
  10. Lowe, D. (1994). “Novel exploitation of neural network methods in financial markets”, IEEE International Conference on Neural Networks. Vol. 6 (pp. 3623-3628).
  11. Ruben Armananzas, Jose A. Lozano (2008), “A Multiobjective Approach to the portfolio optimization problem”. University of the Basque.
  12. Seo, Y., Giampapa, J., & Sycara, K. (2004). “Financial news analysis for intelligent portfolio management”, Robotics Institute, Carnegie Mellon University, Tech. report CMU-RI-TR-04-03.
  13. Sycara, K., Decker, K., & Zeng, D. (1998), “Intelligent agents in portfolio management”, Springer Press, (PP. 19-21).
  14. Zhou, C., Yu, L., Huang, T., Wang, S., & Lai, K. K. (2006). “Selecting valuable stocks using genetic algorithms”, LNCS Berlin Heidelberg: Springer-Verlag, (vol.4247, pp. 688-694).
  15. Zimmermann, H. G., & Grthmann, R. (2005), “Optimal asset allocation for a large number of investment opportunities”. Intelligent Systems in Accounting, Finance, and Management, (vol.12, P.33- 40).
  16. Zimmermann, H. G., Neuneier, R., & Grthmann, R. (2002),”Active portfolio management based on error correction neural networks”, Neural networks information processing systems. Canada: Vancouver, (pp.10-25)

Appendix 1

Table (1) National Bank of Egypt VII

Z-Test results between the actual fund of fluids return and the proposed model return
Mean -0.00077281 0.009746
Variance 0.00041141 0.000311
Observations 141 141
Hypothesized Mean Difference 0
Z -4.61360986
P(Z<=z) one-tail 1.9787E-06
z Critical one-tail 1.64485363
P(Z<=z) two-tail 3.9573E-06
z Critical two-tail 1.95996398

Table (2) Misr Iran Development Bank III (Wafi)

Z-Test results between the actual fund of funds return and the proposed model return
Mean -0.00037 0.010131
Variance 0.000536 0.000324
Observations 35 35
Hypothesized Mean Difference 0
z -2.11794
P(Z<=z) one-tail 0.020737
z Critical one-tail 1.644854
P(Z<=z) one-tail 0.020737
z Critical two-tail 1.95996398

Appendix 2

Data
National Bank of Egypt VII
Date Actual Return Return using software
25/02/2010 0.222% -0.218%
04/03/2010 -0.839% 0.727%
11-Mar-10 0.428% 0.761%
18-Mar-10 -0.194% 0.246%
25-Mar-10 -1.650% 2.646%
01-Apr-10 2.092% 2.711%
08-Apr-10 1.924% 2.624%
15-Apr-10 1.963% 1.934%
22-Apr-10 1.051% -0.367%
29-Apr-10 -0.736% 0.331%
06-May-10 0.000% -0.953%
13-May-10 -2.161% -0.817%
20-May-10 -1.507% -2.521%
27-May-10 -4.100% -0.583%
03-Jun-10 -1.084% 2.173%
10-Jun-10 0.801% -0.490%
17-Jun-10 -1.067% 2.063%
24-Jun-10 1.424% -0.056%
08-Jul-10 -0.602% -0.938%
15-Jul-10 -0.708% 2.294%
22-JuI-10 0.889% 0.161%
29-Jul-10 -0.256% 7.108%
05-Aug-10 2.065% 1.846%
12-Aug-10 1.057% 0.077%
19-Aug-10 -0.408% 0.657%
26-Aug-10 0.310% 0.533%
02-Sep-10 0.329% 0.818%
09-Sep-10 0.378% 0.241%
16-Sep-10 -0.089% 0.599%
23-Sep-10 0.287% 2.840%
30-Sep-10 2.154% 0.613%
07-0ct-10 -0.280% 2.237%
14-Oct-10 1.668% 1.032%
21-Oct-10 0.687% 0.233%
28-Oct-10 -0.114% -0.203%
04-Nov-10 -0.844% 0.342%
11-Nov-10 0.268% 0.448%
18-Nov-10 0.200% 1.052%
25-Nov-10 0.495% 0.505%
02-Dec-10 0.123% 0.015%
09-Dec-10 -0.956% 1.798%
16-Dec-10 1.882% 0.165%
23-Dec-10 -0.103% 0.940%
30-Dec-10 0.300% 1.494%
06-Jan-11 1.413% 1.745%
13-Jan-11 1.033% 1.211%
20-Jan-11 0.164% -1.317%
27-Jan-11 -3.201% -2.750%
03-Feb-11 0.000% 0.000%
10-Feb-11 0.000% 0.000%
24-Mar-11 -11.075% -0.775%
31-Mar-11 -11.973% 8.660%
07-Apr-11 4.169% 1.461%
14-Apr-11 0.609% -0.033%
21-Apr-11 -0.879% -0.590%
05-May-11 0.207% 0.411%
12-May-11 0.182% 1.012%
19-May-11 0.303% 5.394%
26-May-11 0.894% 2.183%
02-Jun-11 0.527% 0.465%
09-Jun-11 0.012% 2.189%
16-Jun-11 1.297% 1.129%
23-Jun-11 0.059% 0.080%
30-Jun-11 -0.998% -0.144%
07-Jul-11 -1.530% -0.219%
14-Jul-11 -1.530% -0.279%
21-Jul-11 -0.530% 0.597%
28-Jul-11 -0.037% -0.065%
04-Aug-11 -0.342% 0.648%
11-Aug-11 0.110% -0.466%
18-Aug-11 -3.110% 1.717%
25-Aug-11 0.872% -0.136%
01-Sep-11 -0.626% 0.146%
08-Sep-11 -0.113% 2.188%
15-Sep-11 0.732% 2.197%
22-Sep-11 -2.982% -0.067%
29-Sep-11 -0.865% -0.078%
06-Oct-11 -1.615% -0.017%
13-Oct-11 -0.702% 1.581%
20-Oct-11 0.853% 0.961%
27-Oct-11 0.542% 0.542%
03-Nov-11 0.237% 0.710%
10-Nov-11 0.367% 0.046%
17-Nov-11 -0.170% -0.186%
24-Nov-11 -1.152% -0.365%
01-Dec-11 -1.735% 3.111%
08-Dec-11 1.658% 0.378%
15-Dec-11 -0.358% 0.081%
22-Dec-11 -0.333% -0.355%
29-Dec-11 -2.790% 0.375%
Misr Iran Development Bank III
Date Actual Return Return using software
31-Mar-10 0.272% 2.605%
30-Jun-10 -0.514% -1.126%
30-Sep-10 0.018362283 0.004731111
30-Dec-10 0.003118301 0.015331225
31-Mar-11 -0.08256881 0.082985771
30-Jun-11 -0.009001 -0.002380288
29-Sep-11 -0.00855746 -0.000688181
29-Dec-11 -0.02749054 0.00308259
29-Mar-12 -0.00058011 -0.004752345
28-Jun-12 -0.01935946 0.023723336
05-Jul-12 0.033024616 0.033024616
12-Jul-12 0.017694939 -0.00299495
19-Jul-12 -0.01657587 0.004381157
26-Jul-12 0.00436115 0.000638415
02-Aug-12 -0.00891914 0.012770398
09-Aug-12 0.015630551 0.001751195
16-Aug-12 0.000582954 0.012201205
23-Aug-12 0.020974132 0.024029489
30-Aug-12 0.007989044 0.01767825
06-Sep-12 0.018229167 0.02208386
13-Sep-12 0.025080616 0.016561591
20-Sep-12 0.01899696 0.029266922
27-Sep-12 0.026099925 0.026099925
04-Oct-12 0.009551495 -0.012636453
ll-Oct-12 -0.02828054 0.008849114
18-Oct-12 0.001269976 0.011163531
25-Oct-12 0.009724131 0.009899997
Ol-Nov-12 0.00125615 -0.004801224
08-Nov-12 -0.01672765 0.004798622
15-Nov-12 -0.00425306 0.00314593
22-Nov-12 0.003203417 -0.007021026
29-Nov-12 -0.02032996 -0.020334335
06-Dec-12 -0.05215124 0.002838725
13-Dec-12 0.000687758 0.019466519
20-Dec-12 0.028751432 0.028751432
27-Dec-12 0.022380581 0.002188376

[·]Professor of Financial Management and Investment. Faculty of Commerce & Business Administration, Business Administratioi1Department, Helwan University

[*] Researcher. Faculty of Commerce & Business Administration, Business Administration Department, Helwan University.

https://powderencouraged.com/zht6b3bs66?key=8523542c4aaf6f083ce56f74bd271319
https://powderencouraged.com/w3m6c9b5?key=af8b4909c0965493e9682d74bb50a646
https://powderencouraged.com/ksq5rgwdmh?key=b5b47a0d83f8742dcf71d4de8ef00494
https://powderencouraged.com/bkcduddx?key=0252cc21d0f4e0ae5f53245940611301
×
error: Content is protected !!