REAL ESTATE PORTFOLIO DIVERSIFICATION BY TODD H. KURTIN B.S., The University of Wisconsin, Madison 1979 A THESIS SUBMITTED IN PARTIAL FULFILLMENT OF THE REQUIREMENTS FOR THE DEGREE OF MASTERS OF SCIENCE in Business Administration in THE FACULTY OF GRADUATE STUDIES Commerce and Business Administration We accept this thesis as conforming to the required standard THE UNIVERSITY OF BRITISH COLUMBIA May 1984 (Cc)TODD H. KURTIN, 1984 In presenting this thesis in partial fulfilment of the requirements for an advanced degree at the University of British Columbia, I agree that the Library shall make it freely available for reference and study. I further agree that permission for extensive copying of this thesis for scholarly purposes may be granted by the head of my department or by his or her representatives. It is understood that copying or publication of this thesis for financial gain shall not be allowed without my written permission. Department of The University of British Columbia 1956 Main Mall Vancouver, Canada V6T 1Y3 II ABSTRACT This thesis examines the potential benefits of diversification in real estate. By calculating a set of returns for apartment blocks in Vancouver, British Columbia, two issues of diversification are dealt with: the potential of diversifying within real estate, and the benefits of including real estate in mixed-asset portfolios. To examine the potential of diversifying within real estate, the study looks at the relative proportions of systematic and unsystematic risk of real estate. Also, the paper investigates the rate at which variations of returns for randomly selected portfolios are reduced as a function of the number of properties in a portfolio. To investigate the benefits of including real estate in mixed-asset portfolios, two types of efficient portfolios are constructed: one that hedges against inflation, and the other that is mean-variance efficient. By selecting these two types of efficient portfolios, the paper considers two major investment objectives of investors: (1) that their portfolio provides a return to combat inflation; (2) that their portfolio have minimum risk for a given expected rate of return. The findings of the study show that portfolios consisting solely of real estate(of one property type in one local market) are not well diversified. The investigation found that only 29 percent of total risk is unsystematic(diversifiable). However, a large portion of the unsystematic risk can be diversified away Ill by holding a portfolio which contains only a few properties. The findings also illustrate that real estate is a useful addition in mixed-asset portfolios. Real estate contributes to the effectiveness of both the inflation-hedged portfolio and the mean-variance efficient portfolio. In the inflation-hedged portfolio, real estate does not contribute as strongly as expected, but the results still demonstrate that real estate should be included in portfolios that are designed to hedge inflation. In the mean-variance efficient portfolio, real estate is found to have a low or negative correlation with other assets, making the potential to diversify very high. IV TABLE OF CONTENTS Abstract II Table of Contents IV List of Tables VList of Figures VII Acknowledgement VIIChapter 1 Introduct ion 1.1 Constraints of the Study 4 1.2 Importance of Study 6 Chapter 2 Literature Review 2.1 The Efficient Principles and the Basic Models of Portfolio Theory 9 2.2 Empirical Research in the Stock Market 13 2.3 Portfolio Analysis with Real Estate 9 Chapter 3 Data Base 3.1 The Apartment Market in Vancouver 35 3.2 Apartment Block.Sample 39 3.3 Other Investment Assets and their Rate of Returns 46 V Chapter 4 Procedures 4.1 Return and Risk 49 4.2 Procedures to Test Diversification within Real Estate .55 4.3 Procedures to Calculate Efficient Portfolios 57 Chapter 5 Valuation Model 5.1 Theoretical Specification 61 5.2 Development and Analysis of the Regression Model 67 Chapter 6 Results 6.1 Return and Risk Measures of Apartment Blpcks 79 6.2 Answer and Analysis of Question One 80 6.3 Answer and Analysis of Question Two 8 Chapter 7 Piscussion 7.1 Implication of Findings to Investors 101 Bibliography 108 Appendix A 113 Appendix B 5 Appendix C 18VI LIST OF TABLES Table Page 2.1 Summary Statistics for Properties with 20 Quarters of Data 31 2.2 Description of Portfolio Size and Reduction in Return Variation by Property Type 32 2.3 Non-Diversifiable Return as a Proportion of Total Risk...33 3.1 Vancouver Apartment Data 37 3.2 Summary Statistics for the Apartment Block Sample 41 3.3 An Average Rent Index for Vancouver by Area 43 3.4 Apartment Operating Expense Ratio Equation 45 5.1 Number of Sales Transactions/Year 69 5.2 The Average Predictive Error for the GIM and the Market Value Model 73 5.3 The Annual Valuation Equations 4 6.1 The Return and Risk Measures for the Set of Apartment Blocks 81 6.2 The Return and Risk Measures for the Sub-Sample of Apartment Blocks 3 6.3 Descripion of Portfolio Size and Reduction in Return Variation 85 6.4 The Inflation Rate, the Mean Returns and Standard Deviations for the Investment Assets 90 6.5 Correlation Matrix of Inflation and the Investment Assets 91 6.6 The Weighted Proportions for Each Asset in an Inflation-Hedged Portfolio 93 6.7 A Set of Portfolios along the Efficient Frontier (by decreasing rate of return) 97 6.8 Comparisons of the Risk (Variance) of the Individual Assets to Efficient Portfolios with the Same Mean Return.98 VII LIST OF FIGURES Figure Page 5.1 The Long Run Supply and Demand Schedule of Apartment Blocks in Vancouver 62 5.2 The Short Run Supply and Demand Schedule of Apartment Blocks in Vancouver 62 6.1 Graph of the Efficient Frontier 96 VIII ACKNOWLEDGEMENTS I would like to thank the committee members, Dr. Dominique Anchor, Dr. Lawrence Jones, and Dr. Michael Tretheway, for their cooperation in helping me to complete this thesis project. I am particularly grateful to Mollie Creery, Dennis Jackson, and Esther Lee for their assistancer, without which, this study would never have been completed. 1 INTRODUCTION 1 .0 The discussion of portfolio selection has occupied the pages of financial journals for over thirty years. The breadth of the discusssion has extended from the efficiency principles of Markowitz[40] and the simplifying model of Sharpe[55] to issues of portfolio size, strategy, and to the degree of diversification both in domestic and international markets. Nevertheless, research on portfolio selection has been limited to the investigation of only a few investment instruments, with the major emphasis'on securities. Real estate as an investment has been ignored. Why? Researchers have been reluctant to assess real estate because information on returns is not readily ava ilable. This paper extends the research of portfolio selection by considering real estate in investment portfolios. The paper examines real estate as an investment through a sample of apartment properties in Vancouver, British Columbia. With these properties, quarterly realized returns are generated over a 10-year period ending in 1979 for the purpose of conducting an empirical analysis. The analysis concentrates on two questions of relevance to investors: (1) Can investors diversify their portfolios solely within a real estate market? (2) Can the inclusion of real estate result in more efficient mixed-asset portfolios? To answer the first question, the paper investigates the 2 rate at which variations of returns, for randomly selected portfolios, are reduced as a function of the number of properties in a portfolio. We will test the hypothesis that investors can diversify their portfolios within a real estate market--i. e. that the risk of real estate for the most part is diversifiable risk and that investors can benefit from diversification. Previous research has shown that investors can diversify within investment markets. Using the stock market to test diversification, Evans and Archer[l7], Latane and Young[36], Elton and Gruber[l6], and Brealy[7] have found that the relationship between the number of securities included in a portfolio and the level of variation takes the form of a decreasing asymtotic function. In the only study using the real estate market, Miles and McCue[44] have come to similar conclusions. They considered the relationship between portfolio size and the return variation to follow the 1/n rule of McEnally and Boardman [43]. 1 An hypothesis directed to question 2 postulates that the inclusion of real estate can improve the efficiency of investors' portfolios. Efficiency in this context includes portfolios that hedge against inflation as well as mean-variance efficient portfolios --i. e. those portfolios which offers the highest expected return for a given nominal variance, or which minimizes nominal variance for a given expected return. Support for this hypothesis stems from prior academic works. Results from Friedman[22] and Hoag[28] have illustrated that because a 3 low or negative correlation exists between real estate and other investment assets, the inclusion of real estate improves the performance of mean-variance efficient portfolios. Fama and Schwert[l9] and Hallegren[27] have concluded that real estate is a good hedge against inflation. In approaching the investigation of the paper's two questions, we first review the literature associated with portfolio selection. In Chapter 2, works which reinforce the hypotheses or are relevant to the issues raised in this paper are discussed. Next, in Chapter 3 the data used in the study is described. The process of selecting the final property sample and the assumptions necessary to complete the information for the sample are dealt with here in some detail. After the description of the data, the methodology used to answer the two questions is presented in Chapter 4. Included in this section are the procedures used to measure the diversification capabilities within real estate and the techniques used to compute efficient portfolios. Chapter 5 introduces the valuation function needed to determine quarterly market values for the apartment properties. Since real estate does not have the continuous market transactions of most equities, a valuation model must be developed to estimate quarterly values for the properties. Empirical testing and analysis is discussed in Chapter 6; here also the validity of the hypotheses is assessed. Lastly, in Chapter 7 the paper reviews the implications of the findings with respect to real estate investors. 4 1.1 CONSTRAINTS OF THE STUDY This paper like most studies examining real estate suffers from less than adequate information. Ideally, the data base should consist of a time-series of returns for the national real estate market; a market that includes properties of all types from across Canada. With such a data base, the potential for diversification within real estate could be fully tested, and an appropriate real estate return index constructed to compute efficient mixed-asset portfolios. However, since real estate lacks observable market transactions and related investment return information, i. e. cash flows from properties, reseachers investigating real estate have often either to narrow the scope of their analysis, or to place less weight on their findings. This paper chooses to narrow the scope of the analysis. Although the sample used is as complete as - possible, certain aspects of the data base impede a fully adequate analysis of the two questions. First, the sample is confined to one local real estate market. Obviously, having data for only one local market inhibits the investigation of geographical diversification, thus reducing the possiblity of creating an efficient portfolio of real estate properties. If, however, we find that diversification is obtainable even within a local market, we would have strong evidence in support of our first hypothesis. Secondly, the sample was intended to contain commercial as well as apartment properties, thereby increasing the possibility 5 for diversification. However, sufficient information to provide reliable rates of return for the commercial properties was not available, and so these properties were dropped from the study. Thirdly, the data base is also constrained by the number of assumptions and estimating procedures needed to complete it. Because real estate properties are traded infrequently, quarterly prices must be estimated by means of a fundamental valuation function. This function is critical to the results of the paper since the capital gain(loss) on the properties is the major factor determining the rate of return. In addition, estimations are necessary for cash flows and debt. Thus all factors contributing to the return of the properties are in some way estimated. As a result of these constraints, the paper will test a limited version of its hypothesis that investors can diversify solely within a real estate portfolio. The problems stated above have forestalled an investigation of geographic and property-type diversification, two of the ways in which investors spread their risk within real estate. As a result, the hypothesis should be restated that investors can diversify their portfolios within a local real estate market. If there is either geographic diversification within the city or the existence of high property specific risk, then this hypothesis will be accepted. The problems mentioned above do not affect to any serious degree the analysis of question two. The issue as to whether 6 real estate can improve the efficiency of , investors' portfolios deals with the covariance of real estate returns to the returns of other investment assets. The returns generated from the study of apartment blocks in Vancouver should reflect the movement of the national real estate market, if we agree with Sharpe's argument that stocks, or in this case properties, move together because of macroeconomic events. 2 The variance of these apartment returns may be greater than they would be elsewhere since the Vancouver real estate market is considered quite volatile, but the pattern still reflects the action of the national real estate market. As a result, the measure of covariance between real estate and the the other investment assets should be reasonable. 1.2 IMPORTANCE OF STUDY Even though data problems affect the analysis, the paper provides valuable information to researchers and to investors. First, in view of the dearth of empirical studies involving real estate returns, this paper provides much-needed evidence on the performance of real estate. Second, the study can be of value to individual or small corporate investors on the subject of how to structure their portfolios more effectively. In real estate, it is not uncommon to find limited capital investors restricting their portfolios to one local market or even to one property type. These investors confine their portfolios to a limited 7 number of holdings due to high transaction costs, and because real estate is a lumpy and indivisible asset, making it difficult for them to own just a small percentage of the asset. The results of the study will indicate to these small capital investors whether they can diversify while holding a narrow portfolio based on a local market, or whether they should consider the cost/benefits of further diversifying their portfolios into other real estate markets or into a mixed asset portfolio. Third, the study gives all investors, large or small, information on how real estate covaries with other investment assets. Because the study is intended for use by members of the lay public, we will frequently explain some terms at length and reiterat aspects of investment procedures for the purposes of additional clarity and understanding. 8 FOOTNOTES The 1/n rule of McEnally and Boardman is expressed in equation form as: Vp = Vs + !/n(Vu) where Vp is the expected average variance of a portfolio, Vs is systematic risk and Vu is unsystematic risk. Sharpe, William F., "A Simplified Model for Portfolio Analysis", Management Science, Vol.9, January 1963, pp. 277-293 9 2.0 LITERATURE REVIEW This chapter reviews a selection of academic studies concerning portfolio theory and diversification, beginning with a discussion of the efficiency principles of Markowitz and the basic models of portfolio theory as developed by Markowitz and Sharpe. The chapter then presents a number of empirical studies which use securities to examine the question of diversification. Although the articles that are examined consider the question of diversification in the context of the stock market, they have been included because of their relevance to the analysis of the paper. The final section deals with work that has been done on portfolio theory and diversification within the context of real estate. In addition, the theory underlying the valuation models used in the paper is reviewed. 2.1 THE EFFICIENT PRINCIPLES AND THE BASIC MODELS OF PORTFOLIO THEORY Harry Markowitz proposed the efficiency principles of portfolio theory over thirty years ago.1 In 1952, he introduced the efficiency principles as part of a new hypothesis on investment behavior. The new hypothesis stated that "the investor does(or should) consider expected return a desirable thing and variance of return an undesirable thing."2 Before Markowitz proposed this hypothesis, theories and models 10 interpreted investment behavior as that behavior of an investor to maximize the discounted value of future returns. In his initial article on portfolio selection Markowitz considered the hypothesis of maximizing the discounted value of future returns, but rejected it: If we ignore market imperfections the foregoing rule never implies that there is a diversified portfolio which is preferrable to all non-diversified portfolios. Diversification is both observed and sensible; a rule of behavior which does not imply the superiority of diversification must be rejected as both a hypothesis and as a maxim.3 In place of the maximum return hypothesis, Markowitz presented what he termed as his mean-variance rule. The hypothesis stated that an investor does(or should) select portfolios that have a maximum expected return for a given variance of return or that an investor does(or should) select portfolios that have a minimum variance for a given expected return.4 Portfolios that fit the description elaborated by his hypothesis, Markowitz called efficient; such portfolios make up the efficient frontier. Investors would choose from among this set of efficient portfolios according to their utility preference. In his article, Markowitz did not illustrate the techniques necessary to calculate the set of efficient portfolios, but he described the components which made up the model: the measurements of expected return and variance(risk) of a portfolio. The measurement of the expected return of a 11 portfolio is fairly straightforward and is calculated as follows: N E = Z X.M-11 i = i where X^ is the percentage of the investor's assets allocated to the ith security, and is the expected value of the ith security. The measurement of the variance of a portfolio is more complex as it includes the variance of the individual assets as well as the covariance between the assets. The calculation of the variance of a portfolio is as follows: N N V = Z Z X.X.o- â€¢ i=1 j=1 where X^, Xj are the percentage of the investor's assets allocated to the ith and jth security and a. â€¢ is the covariance between asset i and j. It is the covariance between the assets which enables investors to diversify their portfolios. If investors select assets in their portfolio which have a low or negative covariance, then the overall variance of the portfolio is reduced. Markowitz's mean-variance rule differed from previous hypotheses in that it considered the interrelationship of returns. Markowitz's findings and investment model alter the concept of portfolio theory. However investors and researchers soon 1 2 realized that the model was not practical; it needed too much information to be useful. The next step in portfolio analysis had to be the development of a more simplified model. William Sharpe provided this simplified model in 1963.5 In considering his model, referred to as the Diagonal Model, Sharpe had two objectives: to make it practical so that investors could perform portfolio analysis at a very small cost, and to construct a model that would not assume away the existence of the interrelationship among securities. Sharpe achieved his objectives by proposing a model that allowed for two important assumptions. The first of these considered the returns of various securities to be related only through a common relationship with some basic underlying factor. Sharpe incorporated this assumption directly in his model: R. = A . + j3 â€¢ I + C. l l Fi l where: R^ is the return on the ith security; A^ and are parameters; is a random variable with an expected value of zero; and I is the level of some index for the underlying factor. The second assumption that Sharpe made, which must hold true for the first assumption to be true, is that the covariance between the random variables of any two securities is zero. With these two assumptions, the return for any security is determined by the relationship of the security to the underlying factor and by 1 3 random factors. Through his model, Sharpe decomposed the risk of a portfolio into systematic(non-diversifiable) and unsystematic(diversifiable) risk. Systematic risk is associated with the underlying factor and affects all securities; unsystematic risk relates to the individual securities, and is represented by the random factors in the model. The unsystematic risk can and should be diversified away. 2.2 EMPIRICAL RESEARCH IN THE STOCK MARKET The initial question of this paper asks whether investors can diversify solely within a real estate market. To answer this question, we examine the relationship between the risk of a portfolio and the number of properties it contains. Most of the literature investigating the effect of portfolio size and the reduction of return variation has focused on securities. Empirical studies by Evans and Archer[l7], Latane and Young[36], Elton and Gruber[l6], and Brealy [7] have examined exhaustively the effect of portfolio size on the reduction of return variation with respect to securities. Since all of these studies have reached similar conclusions, we will only discuss one of the articles here: the article examined is the Evans and Archer paper. Evans and Archer argue that if portfolio size has an effect on the reduction of return variation, the result must be a function of the reduction of the unsystematic portion of the 1 4 total â€¢ variance. They also argue that as the number of securities in a portfolio approaches the number of securities in the market, the variation of the portfolio return will approach the level of systematic variation, suggesting a relationship that behaves as a decreasing asymptotic function.6 To prove their point, they constructed randomly selected portfolios of sizes 2 to 40. The portfolios were then regressed by the equation: Y = A + B(1/X) where Y is the computed mean portfolio standard deviation(the measure of risk), and X is the portfolio size. The results of the regression analysis were quite positive: the coefficient of determination(another term for R2) for the equation was .9863. When the average standard deviation of return was plotted against the number of securities in the portfolio, the plotted graph formed a decreasing asymptotic function. Evans and Archer then conducted one more experiment. This one involved t-tests on successive mean portfolio standard deviations to determine at what point significant reduction of variation(at the .05 level) took place. The results of the test indicated that the addition of one security to a portfolio of size 2 caused significant reduction in the mean portfolio standard deviation. For portfolio of size 8, the necessary increase was 5 securities; for a portfolio of size 16, the necessary increase was 19 securities. Evans and Archer concluded that there was probably little economic justification for increasing portfolio size beyond 10 or so securities, and 1 5 suggested that investors include some form of marginal analysis in their portfolio selection models. Moving from the investigation of diversification, we now review studies that examine efficient portfolios. The paper uses two definitions for efficiency: Markowitz's mean-variance definition and inflation-hedged portfolios. To illustrate the potential advantages of diversification under the definition of mean-variance efficiency, Robichek, Cohn and Pringler[50] presented a study on returns of alternative investment instruments. The paper computed ex post rates of return and correlation coefficients for twelve alternative investment media for the period 1949-1969. The authors' aim was to identify the degree to which investment alternatives, other than common stock and riskless one-period bonds, influenced the construction of efficient portfolios. The investment media included common stocks from the United States, Canada and Japan; U.S. government and corporate bonds; real estate; and commodity futures. The data used to compute returns on real estate was the U.S. Department of Agriculture index of value per acre of farm real estate. Though farm land returns are a dubious indicator of the returns on real estate, the authors were not able to discover a better one. The paper found that the correlation coefficients among the various assets were generally low, and that the signs of the coefficients were almost equally divided between positive and negative. Of the 66 correlation coefficients between all pairs 1 6 of assets, only 4 indicated positive correlation significant at the .05 level. For real estate, all the correlations with the other assets were negative except for the positive correlation with U.S. Treasury Bills and with Japanese stocks, which was significant. The implication of the findings is that diversification among the twelve investment media leads to improved portfolio efficiency in the mean-variance context. To demonstrate which assets are effective hedges against inflation and therefore useful in a inflation-hedged portfolio, we review a paper written by Fama and Schwert[l9], "Asset Returns and Inflation". Fama and Schwert developed a model to test the effectiveness of such assets based on the work of Irving Fisher, 7 who had hypothesized that the nominal interest rate can be expressed as the sum of an expected real return and an expected inflation rate. From Fisher's proposition, Fama and Schwert designed their model so that the expected nominal return on an asset from t-1 to t is the sum of the expected real return and the best possible assessment of the expected and unexpected inflation rate from t-1 to t. Fama and Schwert's model, which they tested by regression analysis, appeared as: Rjt = a + fljEU^W + VVE(V*t-1)] + Njt where: R.. is the nominal return on asset j from t-1 to t; E(At/$t_1) is the best possible assessment of the expected value of the inflation rate A., that can be made on the 17 basis of the set of information *t_1 available at t-1; [Afc -E(At/$t_1)] is unanticipated inflation(inflation at time t minus expected inflation made on the base of $t_1; Njt is the random term for asset j at time t; 0_j and 5j are the linear coefficients to be estimated; and the tildes denote random variables. If /3j = 1.0, in the model, the asset is a complete hedge against expected inflation, and the expected real return on the asset is uncorrelated with expected inflation. If 5^=1.0, the asset is a complete hedge against unexpected inflation and when /3 j = 6 j= 1 .0 then the asset is a complete hedge against both aspects of inflation. The regression model was tested using a number of assets: (1) T-Bills with one-to six-month maturity (2) common stocks from the New York Stock Exchange (3) U.S. government bonds (4) human capital (the rate of change of labor income per capita) (5) privately held residential real estate(the rate of inflation of the Home Purchase Price component of the CPI). 18 Fama and Schwert first analyzed how well the selection of assets hedged against expected inflation during three time horizons: monthly, quarterly, and semi-annually. The estimates of Bj(the coefficient for the expected inflation), were close to one for treasury bills, government bonds and real estate for all three periods. Human capital was positively related to the monthly and quarterly expected inflation rate but was negatively related to the semiannual expected inflation rate. Common stock returns showed a negative relationship for all time horizons, with the coefficient increasing in magnitude with time. The results from the test of unexpected inflation showed only real estate to be a complete hedge against unexpected inflation for all time horizons. The coefficient for human capital was moderately positive with monthly unexpected inflation, but turned negative for quarterly and semiannual unexpected inflation. Government bonds and common stock had increasingly negative coefficients as the time horizon increased. The study of Fama and Schwert implies that real estate is the only asset which acts as a complete hedge against both expected and unexpected inflation. Real estate returns move in high correspondence with both components of the inflation rate. If their findings hold up, then real estate should prove a hedge against inflation and contribute to the inflation-hedged portfolio developed in this study. In Fama and Schwert's study, the regression equation that 19 included real estate had an R2 of roughly 60 percent, implying that the inflation adjusted return of real estate is not certain and that real estate has a considerable amount of real return variation.8 2.3 PORTFOLIO ANALYSIS WITH REAL ESTATE The examination of portfolio selection did not extend to real estate until 1970, when Harris Friedman applied portfolio theory to equity investment in real estate.9 Friedman's initial work investigated the concept of selecting real estate portfolios, through the application of mathematical models used to select and evaluate common stock portfolios. In addition, he evaluated the relationship of real estate to common stock by comparing real estate portfolios to common stock portfolios and by constructing a portfolio containing both real estate and common stock. To build the individual real estate and common stock portfolios in the study, Friedman employed Sharpe's diagonal model; 10 when he combined the two investment assets into one portfolio, he used the Cohen-Pogue multi-index model.11 In writing this first paper, Friedman initiated the procedures to resolve data problems associated with real estate returns. To construct his real estate portfolios, he needed the holding period returns for each property in the portfolio. Using five one-year holding periods for the study, he had information on the yearly cash flow from the properties, but knew the market values for only the beginning and ending years 20 of the study. Friedman estimated the intermediate values by assuming that the properties appreciated at the compound growth rate. Thus, Friedman understated the riskiness of real estate, and provided real estate with an added advantage in its comparison to common stock. Friedman encountered another difficulty when he tried to select an appropriate index to use in Sharpe's diagonal model for his real estate portfolios. He employed an average of the Boeckh construction cost indexes for hotels, residences, apartments, commercial properties, and factories with the American Appraisal Index.12 This "hodgepodge" of an index would be expected to have a low association with the returns of the properties in the sample; hence most real estate risk would appear to be diversifiable.13 Again the risk associated with real estate was understated, making real estate appear undeservedly attractive. The last major difficulty Friedman faced was the choice of a super-index to use in the Cohen-Pogue model when combining real estate and common stock into one portfolio. Friedman used the GNP index - an index really not adequate to explain the variation of returns for real estate and common stock.14 Despite its problems, Friedman's paper presented some notable findings. First, both on a before-and after-tax basis, efficient real estate portfolios dominated common stock portfolios except in the range of unusually 4 high returns. Friedman qualified this finding by pointing out that the sample 21 used in the study was not representative of the universe of real estate assets. Second, taxes had more impact on common stock returns than they did on real estate. The reason for this was that tax shelter benefits of real estate help lessen the effect of taxes on the returns of real estate as compared to common stock. Third, real estate appeared as the dominant asset in the mixed asset portfolio, especially on an after-tax basis. Lastly, the covariance between real estate and common stock was negative, which greatly reduced the total mixed asset portfolio risk. In conclusion, Friedman stated that models developed to select common stock portfolios can be adapted to the selection of real estate portfolios, and that real estate dominates common stock as an investment asset. A more recent paper by Hoag[28] attempted to correct some of the problems that Friedman encountered. Hoag's objective was not to improve on Friedman's work, but to provide information on risk and return of real estate investments in order that current investment management technology could be applied to real estate. Hoag tried to accomplish this objective by constructing an index of real estate value and return for non owner- occupied industrial property. The importance of the Hoag paper to this study is in the method he uses to determine property value. Because capital gain(loss) is the major factor for the return on real estate, the valuation model plays a critical role on the estimate of the 22 return on real estate. Hoag employed a property valuation function based on fundamental characteristics of the properties: property type, size, age, economic and demographic factors, cash flows and transaction prices. Hoag argued that this valuation model was equivalent to income capitalization appraisal, except that as appraisal is subjective the valuation model makes an objective judgement. Hoag further argued that this type of fundamental analysis is accomplished by security analysts in the stock market where macroeconomic variables and firm-specific data are used to assess a firm's value.15 Hoag estimated his valuation function by using actual transaction prices from the sample of industrial properties. In his model, a value for each nontransacting property, at any given time, is estimated from the valuation function applied to the fundamental characteristics at that time. The macroeconomic characteristics of the model try to capture the supply and demand functions of the industrial property market through time, while the microeconomic and physical characteristics of the properties describe the building, surroundings and location. Hoag considered the results of the model to be quite reasonable, with an adjusted R2=.89. However, the standard error was unacceptably high, being $352, 000 or 30 percent of the mean sales price. From the valuation function, Hoag calculated the individual properties rate of returns and the overall market rate of return.This overall market rate of return represented his return 23 index for real estate. The return on the index was high(.0338/quarter) as was the the risk(a standard deviation of .0861/quarter). Hoag concluded that the two measures were comparable to those obtainable on stocks and bonds. When Hoag calculated the cross correlation of real estate to other assets and inflation, the results illustrated that real estate could help investors diversify their portfolios and in addition allow them to use real estate as a hedge against inflation. These results support the hypothesis of question two in this paper that real estate can improve the efficiency of investors' portfolios. In his implementation of a fundamental valuation function Hoag did not fully detail the theory underlying his model. Hoag argued that since stock analysts use fundamental techniques to value stocks, it would be reasonable to develop a fundamental valuation function for real estate. Since a valuation function plays a major role in this paper in determining the rate of return on the sample of properties, reference to two papers which discuss the theory behind fundamental valuation functions is in order. Both papers consider the valuation of properties from the point of view an appraiser. "The Valuation of Multiple Family Dwellings by Statistical Inference, " by William Shenkel[59] is the foundation for the valuation model developed for this paper. Shenkel initiated his paper with the proposition that income properties are bought and sold on the basis of anticpated net income. 24 However, he argued that, in practice, appraisers deviate from the proposition that value is determined by net income since it is difficult to estimate net income. Instead they often use gross income as a proxy for net income, and thus assume a relationship between gross income and value. This relationship is illustrated by the gross income multiplier: V = f(GIM). To find the gross income for a property, appraisers often calculate the average or median GIM from a sample of recently sold properties. Shenkel contended that the statistical technique of simple regression can serve as a substitute for the standard GIM and that regression can be a more precise tool in estimating value: " The regression derived multiplier is produced with statistical measures of reliability and an estimate of the expected error."16 Shenkel admitted that the error from simple regression is often too great to determine value; he argued rather that to value property accurately, reliance must be placed on multiple regression. In advocating multiple regression, he presented a second proposition which stated that if it could be shown that net income and, therefore, value were related to a set of common property characteristics, then property characteristics could predict value. Shenkel wanted to demonstrate that market value could be estimated directly from value-significant property characteristics, and that appraisers could dispense with the capitalization process.17 25 Shenkel, to confirm his proposition, ran a stepwise multiple regression analysis on a sample of 47 apartment houses over a five-year period. The sample of apartment houses were located in a single metropolitan area. He selected 69 property characteristics through which to explain value. These characteristics could be associated with three groups: those associated with area or size; those associated with locational attributes; and those covering amenities and services of a given apartment house. In Shenkel's initial run, the coefficient of determination was .9719 with 20 significant variables. The average predictive error was 6.85 percent. Shenkel reran the regression analysis eliminating gross income as a variable. The results from this run were very similar (a coefficient of determination of .9776 and a predictive error of 7.20 percent). Shenkel suggested from this second model, that reasonable accuracy might be obtained without reference to gross income, net income, capitalization rates or the usual capitalization procedures. He further pointed out that the model could have been even more accurate if the time period had been shorter: "Ideally, sales should be confined to the shortest possible time period...the shorter the time interval the less the influence of time on the sales price." He suggested a one year time frame. From the results of the test, Shenkel confirmed that market value could be determined by a set of property characteristics. He also declared that multiple regression analysis is more objective than conventional capitalization, that multiple 26 regession deals directly with those factors important to net income and to value. A second article that provides a theoretical argument for using statistical regression models is Albert Church's, " An Econometric Model for Appraisers".18 Church opened the discussion of his model by deriving the structural supply and demand function for individual properties. The quantity demanded is a function of price, P, and a set of characteristics, X, that possess value to the buyer: Qd^ = f (P^, X^) i=1...n the number of properties The quantity supplied is a function of price, P, and a set of characteristics, Y, that are valued by the seller: QSi = g (p., y.) After having derived the supply and demand function, Church presented the methodology for determining market value. He considered the supply and demand function to be discontinuous, since a property is either sold or not sold and since the price may not be uniquely determined by the supply and demand function. He says there is a range of coincidence between the supply and demand functions where the buyer and seller bargain on price. Because of the coincidence of the supply and demand functions when a property is sold, the model can only determine the expected value of the selling "price [E(Pj, ,X^ , Y^ ) ] ,given a set of characteristics for the buyer and seller. The actual price for the property is a function of the 27 expected selling price and a random variable, N ^ . The random variable denotes the bargaining range of the buyer and seller. The "most probable selling price" for a property not sold can be inferred from a property which is sold during the time interval and which possesses identical characteristics and identical supply and demand functions. Therefore Church assumed that sales data could be used to determine the expected or probable sales price for all properties classified by type of character i st ic. From this assumption that the supply and demand function holds for all properties, Church simplified the model. The new equation reduced to its simplest form is: P. = e(X.,Y.,N.) 1 1' 1' 1 where price equals the function, e ,which contains the characteristics important to the buyer and seller and the random variable. It is this function, e ,which should be employed in regression analysis. In the regression analysis the value of Ni is assumed to be equal to zero. Church concluded his article by pointing out a number of problems that arise when applying the model in regression analysis. The first problem is that linear least-squares regression requires the specified equation to be linear in coefficient. To accomplish this the function, e ,is linearized for m observable characteristics: 28 P. a + + m im + A m+1 + N. 1 o 1 i=l i â€¢'â€¢ n for properties m for the characteristics is a constant . â€¢ â€¢ â€¢ where: Aj is the linear coefficient to be estimated from data on property sales; Z^j is the specific characteristics or combination of characteristics for properties(derived from the X^,Y^); and is the random term. The second problem is the selection of characteristics derived from X^, to be included in the equation. Church reasoned that attributes which varied from property to property and which explained sales price differences should be included. Characteristics which were similar between properties need not be included. He categorized the variables that should be in the equation: physical, locational, market, and prior knowledge. The last problem Church mentioned is the interaction effect of the characteristics. Interaction occurs when a joint occurrence of two or more variables(characteristics) produces an effect which is different from the individual occurrences of two separate events. For example a den adds X dollars to a house and a fireplace adds Y dollars; together their worth is greater than or less than X and Y. 29 A final article, which has been of great benefit to this work, is an empirical study of question one: Can an investor diversify within a real estate market? Only one study has examined diversification with regard to real estate portfolios; it was performed in 1980 by Miles and McCue[44]. Miles and McCue conducted their study on a large commingled real estate fund with over 300 properties, dispersed across the United States and containing five different property types. The majority of properties were office buildings, and industrial properties. The objective of the study was to test real estate portfolios against the 1/n rule of McEnally and Boardman, where the expected average variance of the portfolio equals the systematic risk plus 1/n unsystematic risk: V = V + l/n(V ) p s ' u Miles and McCue began their study by calculating quarterly returns on the sample of properties over a five-year period. Just as we have done in the present study, the authors had to estimate value. To do this, Miles and McCue accepted the annual appraised value of the properties as market value.19 To determine the quarterly value of the properties, they selected two methods: the first geometrically smoothed the changes in value over the intermediate quarters; the second assumed that price did not change from quarter to quarter, but only on an annual basis. Since the authors utilized two methods to estimate value, they needed two return measures(both were on a 30 before tax basis). Summaries of the returns and variances for the sample are shown in Tables 2.1 and 2.2.20 The results from Table 2.2 show that portfolio size does have an effect on the reduction of return variation. These results are consistent for each property type. When Miles and McCue divided the sample into four geographic regions, the results were still the same. Return variation decreased substantially with portfolio size. Miles and McCue conducted one more experiment. They compared the average total variance to the market related variance. Table 2.3 presents the results. Except in one case(unsmoothed returns in the West),the ratio of market related variance to average total variance is below 15 percent. Thus the non-market risk of real estate is quite high, demonstrating that potential gains from diversification in real estate are quite large. It is of particular interest to this study that Miles and McCue repeated this experiment for one property type, over each of the regions. The highest ratio of market variance to average total variance in any region was 16 percent. This result suggests that the present study,though restricted in its final analysis to one property type in one local market, can still show the possibility of diversification. 31 TABLE 2.1 SUMMARY STATISTICS FOR PROPERTIES WITH 20 QUARTERS OF DATA BREAKDOWN BY TYPE -Total Sample Industr ial Office Other N 166 1 18 29 19 Unsmoothed Returns .0386 .0393 .0402 .0319 Smoothed Returns .0364 .0370 .0382 .0303 Variance Unsmoothed Returns .0048 .0048 .0067 .0021 Varaince Smoothed Returns .0013 .0012 .0023 .001 1 Mean Beta 1 .0 .973 1 . 1 38 .938 - BREAKDOWN BY Region -Total Sample East Midwest South West 166 1 3 78 42 33 Unsmoothed Returns .0386 .0449 0340 .0335 .0535 Smoothed Returns .0364 .0422 0326 .0321 .0488 Variance Unsmoother Returns .0048 .0063 0034 .0034 .0092 Variance Smoothed Returns .001 3 .0032 0010 .001 3 .001 6 Mean Beta 1 .0 1.713 91 83 .61 76 1 .399 Source: Miles and McCue[44] 32 TABLE 2.2 DESCRIPTION OF PORTFOLIO SIZE AND REDUCTION IN RETURN VARIANCE BY PROPERTY TYPE (MEAN OF VARIANCE x 10 ) - Smoothed Returns -Total Sample - Unsmoothed Returns Total Sample All Properties Individually 12.739 Random Portfolios of Properties: 2 Properties 8.647 4 Properties 3.942 6 Properties 2.713 8 Properties 1.900 10 Properties 1.999 12 Properties 1.659 14 Properties 1.432 16 Properties 1.332 18 Properties 1.297 20 Properties 1.182 30 Properties 1.042 All Properties .627 48.670 23.359 15.433 12.084 .10.529 7.985 7.690 7.051 6.400 6.398 6.815 5.771 4. 1 77 Source: Miles and McCue[44] 33 TABLE 2.3 Vpl Vpall Ratio NON-DIVERSIFIABLE RETURN AS A PROPORTION OF TOTAL RISK By Type Smoothed Returns Total Industrial Office 12.739 11.098 21.596 .627 .674 2.571 .049 .061 .119 Other 10.953 1 . 1 94 .109 Vpl Vpall Rat io Unsmoothed Returns 48.760 49.211 63.594 4.166 5.945 6.708 .086 .121 .105 22.532 2.171 .096 Vp1 Vpall Rat io Total Sample 12.739 .627 .049 By Region Smoothed Returns East Midwest South West 31.849 9.096 12.193 14.516 3.494 .764 .677 -1.815 .110 .084 .056 .125 Vp1 Vpall Rat io Unsmoothed Returns 48.670 64.209 35.015 4.177 9.223 8.057 .086 .144 .230 33.921 2.312 .068 93.593 25.419 .271 Source: Miles and McCue[44] 34 ENDNOTES 1. Markowitz, Harry M., "Portfolio Selection", Journal of Finance, Vol.12, March 1952, pp.77-91 2. ibid 3. ibid 4. ibid 5. Sharpe, William F., "A Simplified Model for Portfolio Analysis", Management Science, Vol.9, January 1963, pp.277-293 6. Evans, John L. and Archer, Stephen N., "Diversification and the Reduction of Dispersion:An Empirical Analysis", Journal of Finance, December 1968, pp.761-767 7. Fisher, Irving, The Theory of Interest, MacMillian Publishers, New York, 1930 8. Fama, Eugene F., and Schwert, William G., "Asset Returns and Inflation", Journal of Financial Economics, June 1977, pp.115-146 9. Friedman, Harris C, "Real Estate Investment and Portfolio Theory", Journal of Financial and Quantitative Analysis, April 1970 10. Sharpe, William F., "A Simplified Model for Portfolio Analysis", Management Science, Vol.9, January 1963,pp.277-293 11. Cohen,K.J., and Pogue,J.A., "An Empirical Evaluation of Alternative Portfolio Selection Models", Journal of Business, Vol.40, April 1967, pp.166-196 12. Friedman, Harris C., "Real Estate Investment and Portfolio Theory", Journal of Financial and Quantitative Analysis, April 1970 13. Findlay III , Chapman M., Hamilton, Carl W., Messner Stephen, D., and Yormark, Jonathan S., "Optimal Real Estate Portfolios", Journal of American Real Estate and Urban Economics Association, Vol.7, No.3, Fall 1979, pp.298-317 14. ibid 15. Hoag ,James W., "Towards Indices of Real Estate Value and Return", Journal of Finance, May 1980 16. Shenkel, William M., "The Valuation of Multiple Family Dwellings by Statistical Inference", The Real Estate Appraiser, January-Febuary 1975, pp.25-36 17. ibid 18. Church, Albert M., "An Econometric Model for Appraising", American Real Estate and Urban Economics Association Journal, Vol.3, No.1, Spring 1975, pp.17-29 19. Miles, Mike and McCue, Tom, "Considerations in Real Estate Portfolio Diversification", Working Paper, University of North Carolina, 1980 20. The unsmooth returns and variations assume no price change during a year. The smooth returns are geometrically compounded on a quarterly basis.The total sample is 166 properties,since the authors only had complete data on these properties for the five year study. 35 3.0 DATA BASE The previous chapter explained, in some detail, the literature which has provided a platform for this work. This chapter explains the data base utilized in the paper. The data consist of a set of apartment properties located in Vancouver, British Columbia, and a set of returns from a number of other investment instruments which are required to answer question two of the paper. In order to discuss the data base, the chapter divides into three sections. The first presents an overview of the apartment market in Vancouver, so as to familiarize the reader with this market and to help him better understand the results of the paper. Section 3.2 describes the sample of apartment properties and their characteristics along with the assumptions and estimating procedures necessary to complete the information on the properties. The chapter concludes with a presentation of the other investment instruments, and explains the methods used for calculating the rates of returns for this group of assets. 3.1 ,THE APARTMENT MARKET IN VANCOUVER The apartment market in Vancouver primarily developed over a ten-year span from 1961-1971. During this period, the total number of apartment units in Vancouver almost tripled, the major concentration of growth occurring in the high density zoned area 36 of the West End.1 The increase was stimulated by a strong demand for rental units, the result of the coming of age of the post war baby boom generation. The members of this generation were young, and with a good economic climate were able to form new households. The types of housing they sought were rental apartments. After this ten-year period of expansion, construction of new apartment units slowed considerably. The supply of rental units even slipped slightly over the next nine years, 1971-I979(see Table 3.1). The factors for this turn-around can be associated with the considerable change in conditions on the supply side of the market. The supply side had started to encounter constraints unfamilar to the industry, constraints that began to appear in 1970 when mortgage rates reached double digits. Developers, believing that the high cost of capital was short term, decided to wait on the sidelines until rates decreased. However, when mortgage rates did not recede, these developers looked for other investment opportunities in real estate. They switched to the condominium market, an attractive investment since the pay-back period for condominiums was short(until the condominuium units were sold off), while the pay-back period for rental apartments extended over a much longer period of time. In Vancouver, condominiums starts represented 90 percent of all multi-unit starts in the sevent ies.2 Another constraint that affected supply was the change in 37 TABLE 3.1 VANCOUVER APARTMENT DATA CITY OF VANCOUVER YEAR BUILDINGS SUITES VACANCY RATES 1971 2,135 51 ,128 2. 1 1972 - -1973 1,983 49,930 0.2 1974 -1975 1,969 48,899 0.1 1976 -1977 1,973 49,077 1.0 1978 -1979 1,955 50,982 0.2 Note: Data limited to privately-owned rental units in apartment buildings containing six or more units Source: Canada Mortgage and Housing Corporation 38 the federal tax laws. Effective January 1, 1972 a loss created by capital cost allowance on the rental of real property could no longer be applied to non-rental income. In addition, the revised law discontinued the pooling of real estate assets, so that a different pool had to be created for each building over $50,000. The effect of these tax law changes to investors who were looking for tax shelter benefits was to discourage them from investing in the apartment market. The final constraint impeding new construction was the combined effect of high inflation and rent controls imposed by the provincial government. High inflation was a new phenomenon in the seventies, and forced the cost of construction to soar as land, labor and material costs all rose. To recover the higher costs, developers began to charge higher rents. But as the rents began to rise, renters cried out to the government to stop the higher cost of living. So, in 1974, the Province of British Columbia established controls over rent increases for existing apartment buildings. The following limits were in effect during the time period of the study: January 1, 1974 - December 31, 1974 8.0 percent/year January 1, 1975 - April 30, 1977 10.6 percent/year May 1, 1977 - June 30, 1980 7.0 percent/year The rent controls imposed on existing buildings kept prevailing market rents low, making it difficult for new apartment buildings to compete. The rents that developers could receive on new apartment buildings were too low for them to recover 39 their costs, with the result that developers refrained from participating in the market. The Canadian Government tried to step in to stimulate construction activity in the multi-family housing market. The same supply constraints that were affecting the construction activity in Vancouver were affecting cities throughout Canada. The Federal Government decided to initiate two supply-side programs: one was started in 1974 and the other in 1976. In 1974, the government developed the MURB Program, a program that tried to return private capital to the apartment market by once again permitting capital cost allowance to be applied to non-rental income for all new construction after January 1, 1974. The program the government initiated in 1976 was the ARP(Assisted Rental Program). This program encouraged developers to construct moderately priced rental housing by giving them interest-free loans for 10-15 years with a maximum limit on the loans. Unfortunately, as seen in Table 3.1, Vancouver did not have an increase in rental units, suggesting that neither of the two programs fully achieved the expectations of the government. 3.2 APARTMENT BLOCK SAMPLE I'n â€¢'â€¢statistical terms, the universe which this sample is drawn from is all the apartment blocks located in the city of Vancouver and built before I970(the starting time of the study). From this universe, those apartment blocks sold during 1979 and 40 1980 were selected as the sampling base. The decision to sample apartment blocks that were sold during 1979 and 1980 was due to the availability of information(provided by the British Columbia Assessment Authority). Also, the two years of sales, 1979 and 1980, coincided with the time period which the data were collected. The number of apartment blocks sold during the two year period totaled 347. The sample base of 347 properties was reduced in size by eliminating apartment blocks which lacked sufficient information for the study. The study required sales transactions and income, debt and physical characteristcs of the properties. In the elimination process 87 properties were dropped from the sample base, to produce a final sample consisting of 260 apartment blocks. Of the 87 properties eliminated, 58 were thrown out for lack of income information,17 were dropped due to the unavailability of either debt or transaction information,and 12 were discarded because of missing physical characteristics. General statistics for the final sample appear in Table 3.2. Even though the final sample contained apartment blocks with all the required information, certain assumptions and estimating procedures still had to be carried out to calculate quarterly returns. Assumptions and estimates were required on the income, operating expenses, debt,and quarterly market values for the properties. All of the 260 apartment blocks in the final sample had some income information, but very few had income figures for all 41 TABLE 3.2 SUMMARY STATISTICSS FOR THE APARTMENT BLOCK SAMPLE CHARACTERISTICS MEAN STANDARD DEVIATION Number of Suites 19.71 1 5.08 Gross Floor Area(square feet) 13,542.78 9978.77 Average Suite Size(square feet) 715.72 219.58 Age(as of 1983) 37. 19 21 .02 Number of Stories 3.10 1 .89 Lot Size(square feet) 8,547.08 4061.50 Number of Properties/Area West End 73 Ki tsilano 29 Kerrisdale 4 Marpole 23 South Granville 43 East Hastings 75 Rest of the City 1 3 42 ten years of the study.3 Estimating procedures were therefore necessary to fill in the years when information on income was missing on the properties. The primary method for estimation was interpolation. If a property had no more than three consecutive years of missing income, then the compound growth rate was applied over the intermediate period. For almost all the properties, this procedure was employed over some portion of the ten-year period. In cases where the spread between income years was greater than three years, extrapolation was utilized. Two methods were used in extrapolating income, depending on the time period. The first method, applied to the time period 197 0-1973, extrapolated by means of a yearly growth rate model, based on the average rent for a given area of the city. The city was divided into seven areas; from each area the average rents for studio, one bedroom and two bedrooms suites was found."5 The average rent for the three different types of suites was then weighted by the proportion of that suite type to the total number of suites in the area to derive an overall average rent for each area. Table 3.3 presents the growth rates for the various areas. The second method of extrapolation, applied during the time period 1974-1979, used the maximum allowable rent increases permitted under the rent controls of British Columbia(see Section 3.1). Since the rental market was extremely tight at the time, we assume that landlords would have increased rents by the maximum amount granted by law. Our assumption seemed 43 TABLE 3.3 AN AVERAGE RENT INDEX FOR VANCOUVER BY AREA YEAR WEST END KITSILANO KERRISDALE 1 970 100.00 100.00 100.00 1971 109.74 100.00 1 03.89 1 972 112.16 101.50 111.12 1 973 119.35 113.04 1 20.65 1 974 125.65 122.56 127.99 YEAR SOUTH GRANVILLE EAST HASTINGS MARPOLE REST OF THE CITY 1 970 100.00 100.00 100.00 100.00 1 97 1 105.09 106.59 1 10.39 106.96 1 972 110.77 110.17 116.51 109.91 1 973 117.93 117.07 123.75 118.68 1974 126.21 129.05 135.91 130.59 44 justified by the results of the interpolation computations made for this same time period, which showed that the compound growth rates in rents were very similar to the maximum allowed rent increases. To determine the operating expenses for the properties, the statistical technique of multiple regression was used.- Since the properties themselves did not have sufficient operating expense information to run the regression analysis, the paper made use of the analysis performed by Gau.6 Table 3.4 provides a complete description of the results. The reader should note that the estimation is an expense ratio (operating expenses to gross income) and not an actual estimate of operating expenses. By looking at the table, the reader can see that the only physical characteristic that has a positive sign is age. This implies that older buildings result in higher operating expenses. The other two physical characteristics, number of stories and gross floor area, have negative signs indicating economies of scale. The complete debt background on the properties was gathered from the British Columbia Land Title Office. Assumptions were required to determine what debt on the properties was property specific. Since real estate is an asset which is often used as collateral, the properties contained many debt obligations which were not property specific. The additional debt on the properties could have been for the purpose of financing other investments or for personal needs, and as such the leverage on 45 TABLE 3.4 APARTMENT OER EQUATION AOER = 47.992 (16.058)* .297 AGE (6.768)* 511 LOC1 - 2.282 LOC2 -(.295) - .582 D68 (.226) -2.317 D72 (.949) -1.883 D76 ( .832) (1.299) + .857 D69 (.414) - 3.500 D73 (1.689) + .086 D77 (.029) .194 STOR (1 .894)* 1 .666 LOC3 ( .988) 1.740 D70 (.869) 2.768 D74 (1.296) 3.884 D78 (1.599) .008 GFA (2.616)* 4.605 LOC4 (2.018)* .291 D71 (2.018) 1.759 D75 (.771 ) 1.177 D79 (.500) R .302 SE = 6.694 n = 263 t-statistic in parentheses * = coefficient significant at .05 level AOER = operating expense ratio of apartment properties (X100) AGE age in years of apartment building STOR = number of stories of building GFA average gross floor area per suite in square feet LOC1...LOC4 = dummy, 0-1 variable for specific geographical locations D68...D78 = dummy, 0-1 variable for year of ratio from 1968 to 1979, Source: Gau[23] 46 the properties was often overstated. Two assumptions were employed to limit the debt solely to property specific debt: (1) Debt could not be greater than the value of the property at the time of purchase. (2) Debt obligations released and not refinanced were not considered property specific unless the released obligation occurred at the time of a sales transaction. Under the first assumption, we believe that lenders would have been unwilling to lend funds greater than the worth of the property; therefore the loan-to-value ratio had to be less than one at time of purchase. Under the second assumption, we reason that funds from other investments must have retired the debt obligation, suggesting that the financing must have initially been used for these other investments too. The estimating procedure to determine the quarterly market values of the properties is discussed in Chapter 5. 3.3 OTHER INVESTMENT ASSETS AND THEIR RATE OF RETURNS The selection of investment instruments chosen for the study includes assets of the kind most likely to be incorporated into an investor's portfolio. Each of these assets, which are listed below, can be considered to have a different investment objective for the investor, i.e. fixed income, growth potential, hedge against inflation: (1) COMMON STOCK - The total return index of the Toronto Stock Exchange 300 represents this asset. 47 (2) GOVERNMENT OF CANADA TREASURY BILLS - The 91-day treasury bills sold by the government represent this asset. The yield on the T-Bill was used as the rate of return. (3) LONG-TERM GOVERNMENT BONDS - The total rate of return on long-term government bonds was calculated for the paper.7 (4) Gold - The return on gold is measured by the quarterly price change. The source of information was the International Monetary Fund. The consumer price index for Canada,as supplied by the Bank of Canada Review, is the measure used for inflation. 48 ENDNOTES 1. Mitchell,E.C.,"The Apartment Rental Market in Metropolitan Vancouver", Real Estate Trends in Metropolitan Vancouver,197 6,pp.B-1 2. Mitchell,E.C.,"Multiple Housing Activity in Metropoltan Vancouver:Quo Vadis?", Real Estate Trends in Metropolitan Vancouver,1977,pp.B-1 3. There were two sources from which income was collected:The B.C. Assessment Authority, and The Greater Vancouver Real Estate Board Multiple Listing Service. 4. The seven areas are: 1.West End 2.Kitsilano 3.Kerrisdale 4.Marpole 5.South Granville 6.East Hastings 7.Remaining areas of city 5. The source for the average rent was Real Estate Trends in Metropolitan Vancouver,1970- 1 979 6. Gau,George W.,"Determinants of Return in Real Estate Investment and the Role of Real Estate Management", Institute of Real Estate Management Foundation,July 1981,pp.1-46 7. The total rate of return was calculated as follows: Pt+1 + Jb + Zt - Pt Pt where: P&t+1 is the bond price at the end of the quarter; I k is the interest paid on the bond for the period; Ifc is the interest collected from reinvesting the bond coupons at the T-Bill rate; and P. is the bond price at the beginning of the quarter. 49 4 . 0 PROCEDURES Chapter 3 discussed the data chosen to test diversification; this chapter presents the methodology required to answer the two questions posed at the outset of this paper. It begins by delineating return and risk: the two parameters used to measure the performance of the apartment properties as well as of the randomly selected portfolios. Next, the chapter describes the procedures used to examine diversification within real estate. Lastly, the chapter presents the methods used to calculate efficient portfolios, mean-variance and inflation hedged portfolios. 4. 1 RETURN AND RISK Investors in selecting or ranking alternative investment choices evaluate these investment choices by their expected return and variance of return(risk).1 The most appropriate way to characterize this expected return is in terms of a probability distribution. Tests have shown that the probability distributions of returns on investments(common stock) are normally or lognormally distributed.2 Since they are distributed in this manner, investors can distinguish them from one another by two parameters: mean or expected return, and the standard deviation(the squared deviation is the variance). The standard deviation or variance measures the dispersion of the probability 50 distribution around the mean(expected return). These measures of dispersion disclose the riskiness of an investment. For the purpose of the study, returns on the apartment properties are not expected returns but realized ( ex post ) returns. The study looks historically at these properties to examine the diversification potential of real estate. Two measures of return are calculated. The first, often referred to as return on capital, is calculated as follows: Equation 1. Rifc = f(MVit+1 + Cifc) - MVifc] MV. . it where: R^t is the quarterly holding period return of the i property in period t; MV\t+1 is the ending market value estimate; is the net cash flow during the period t; and MV^t is the beginning market value estimate. This return measure is calculated for each of the 260 apartment properties in the study. The other return measure computed for each property is the return on.equity, which takes into .consideration any financing applied to the property. The return on equity is determined .as follows: 51 Equation 2. R.t = HMVit + 1 - Dit+,) + C^) - (MV.t - D.t)] (MVit - Â°it) where R-,, MV. . , C, , MV.. are the same as in Equation 1, it I t+1 It it M ^it+1 *S t*ie ^eDt outstanding at the end of the period and is the debt outstanding at the beginning of the period. Equation 2. can be further simplified: Equation 3. Rj = [(BTERit + Cifc) - Eo] Eo where BTER^ and Eo are the before-tax equity reversion of property i at the end of period t and the initial equity respect ively. In both cases, the return measures are before tax. Using a before-tax rate of return raises the question of whether these return measures have any relevance for investors, who are usually more concerned with an after-tax rate of return. A before-tax return facilitates the comparison of the real estate returns with the returns of the other investment instruments(which are calculated on a before-tax basis). However, the reader can argue that the relationship between real estate returns and those of other assets might be one thing on a before-tax basis and quite another on an after-tax basis, because of the tax shelter benefits associated with real estate, i.e. the benefits from capital cost allowances. Gau[23] using 52 almost the same data base as this paper found that the tax shelter benefits were not a major determinant of the return.3 He noted that the lack of relative importance of the tax shelter was due to the high land-to-total-value ratio of the properties. Therefore using before-tax rate of return measures should not prejudice the results of the analysis. Another issue should be clarified. Often two return measures exist for real estate, return on capital and return on equity, while only one is used for the other assets, return on capital. The return on equity measure is included for real estate, because of the importance of leverage to a real estate investor. Since real estate is a lumpy and an indivisible asset, small capital investors often must obtain financing in order to purchase real estate. The real estate investor is concerned not only with the return on the property, but also with how his equity return is affected by leverage. With other investments, financing is not as critical; investors can usually acquire equities without the need of leverage. In this study, the return on equity will not be compared to the return on capital of the other investments, but is included in order to provide real estate investors and researchers with information on how financing affects the return on capital. Given these conditions, the before-tax return on the market and on randomly selected portfolios can be calculated.The return on the market includes all properties in the sample, and is calculated as follows: 53 K Equation 4. R = I R-^/K M m it' i= 1 where: R is the return on the market at time t; m R^t is the return of the ith property at time t; and K is the number of properties in the market. For the return on the market, each property is equally weighted. The return on a randomly selected portfolio is: M Equation 5. R = I Rit/M i = 1 where R t is the return on the portfolio at time t, and M is the number of properties in the portfolio. After calculating the different return measures, the average quarterly variance(risk) for each property is determined. The variance for each property can be computed as follows: Equation 6. Vi = (Ri - R^)2 â€”-j where: V\ is the variance for property i; R. is the mean quarterly return for the property; and 54 n is the number of quarters in the study. With the variance for each property known, the average total variance for the real estate market can be calculated." The average total variance represents the upper boundary for risk, systematic risk as well as the unsystematic risk of real estate. The average total variance is computed as: K Equation 7. V = L V^/K i= 1 where V"t is the average total variance and K is the number of properties in the market. Next the market variance is calculated for the total sample: Equation 8. Vm = (R - R )2 ^ m mt m n- 1 where: V is the variance of the market; m R . is the return on the market in period t; and mt R is the mean return of all properties in the market over m c c the period of the study, n. V represents a completely diversified portfolio and serves as a proxy for systematic risk. The difference between Vfc and V m 55 reflects the unsystematic or diversifiable risk within the market. The measure of variance is also required for the randomly selected portfolios. The average quarterly variance for these portfolios is computed as follows: Equation 9. V = (R - R ) 2 n-1 where Vp is the average quarterly variance, Rp^_ and Rp are the return of the portfolio in period t and the mean return of the portfolio respectively. The variance for a portfolio, V , like P the average total variance of the market, can be decomposed into systematic(non-diversifiable) and unsystematic (diversifiable) r isk: Equation 10. V = V + V M p s us where Vs is the systematic and Vug is the unsystematic risk. 4.2 PROCEDURES TO TEST DIVERSIFICATION WITHIN REAL ESTATE Is there sufficient unsystematic risk within real estate to allow investors to reduce risk by purchasing a cross-section of properties? We have approached this question by measuring the effect of portfolio size on return variation. If return 56 variation is reduced as additional properties are added, then the potential to diversify within real estate exists. The exact method used to answer this question follows a number of steps. First the return and variances for all the properties will be calculated. From this set of properties(which will be termed the market), the return of the market and the risk of the market(total(V.) and market(V )) will t m be computed. Next, on a preliminary basis, a comparison of market risk to total risk is made, (V"m/V^) . This comparison will indicate the extent to which risk can be diversified away. The lower the ratio of ^m^t^' fc^e 9reater the possibility of diversification within real estate. We repeat the comparison by dividing the sample into two sub-samples by location: one for properties located in the West End, the urban section of the city, and the other covering the outlying parts of the city. This test will check for geographic diversification within the city. The next step in measuring diversification within real estate is to generate random samples of portfolios from size 2 to 30 properties. For each property size,30 random portfolios are created, so that a total of 870 portfolios are formed. By having 30 random portfolios for each portfolio size, the distribution of returns and variance of returns for each portfolio size should be normal. Therefore the mean return and variance for the different portfolio sizes can be used in the 57 analysis without great concern for outliers or abnormal results. The set of mean return variances for the different portfolio sizes will first be perused to see if the variances are reduced as portfolio size increases. If return variance is reduced, then t-tests will be employed to find out at what portfolio size significant reduction in variation take place. Finally, a simple regression analysis is run to determine how much reduction in variation can be explained by portfolio size. The regression equation is: where Y equals the return variance of the portfolio and X is the portfolio size.5 The R2 will provide the answer for how much reduction in variation is explained by portfolio size. To find the efficient portfolios under conditions of mean-variance, recall that under Markowitz's definition of mean-variance, efficient portfolios are the set of portfolios which offers the highest expected return for a given variance. Mathematically this objective function is written as: Y= a + b(l//x) 4.3 PROCEDURES TO CALCULATE EFFICIENT PORTFOLIOS Equat ion 11. maximize N I X. R. l i X N N I Z i=1 i=1j=1 where: 58 X^,X_j are the proportional weights of the assets in the portfolio; Pw is the return on asset i; o^j is the covariance between asset i and j;and X is a Lagrangian multiplier. N The first section( ^L^ xiRi^ of the equation calculates the N N highest possible return;the second section(X Z Z i=1j=1 X^Xj )constrains the highest return by minimizing the variance of the portfolio. Added to this objective function is the constraint that the sum of the weights of the assets in the portfolio equals one: Equation 12. N N N N maximize I X.R. - X Z Z X.X.a.. - M( Z X.-1) 11 IJIJ l i=1 i=1j=1 i=1 N where M is another Lagragian multiplier and ( ,Z X^-1) i = 1 constrains the portfolio weights to one.To derive this objective function, a computer program has been written(see Appendix A). The design of the computer program permits the weights of the 59 assets to be negative, implying that the assets can be sold short. If real estate is found to have a negative weight in the portfolios, a conclusion can be drawn that real estate does not contribute to the efficiency of the portfolio, since real estate cannot be sold short. The procedure used to compute an inflation-hedged portfolio is ordinary least squares regression analysis. By regressing inflation (the dependent variable) against the various investment returns(independent variables), a linear equation is derived which replicates inflation. To constrain the portfolio so that the sum of the weights of the assets equals one, the regression coefficients are added and each coefficient is then divided by the sum of those coefficients. Like the mean-variance portfolios, the inflation-hedged portfolio can have assets with negative weights. All assets that have a positive weight contribute as a hedge against inflation. Those assets that have a negative weight should be sold short since they are not effective hedges against inflation.6 60 ENDNOTES 1. Markowitz, Harry M., "Portfolio Selection", Journal of Finance, Vol.12, March 1952, pp.77-91 2. Fama, Eugene F., Foundations Of Finance, Basic Books Inc., 1 976 3. Gau, George W., "Determinants of Return in Real Estate Investment and the Role of Real Estate Management", Institute of Real Estate Management Foundation, 1981, pp.1-46 4. Miles, Mike and McCue, Tom, "Considerations in Real Estate Portfolio Diversification" ,Working Paper, University of North Carolina, 1980 5. Latane, H. and Young, W., "Test of Portfolio Building Rules", Journal of Finance, Vol.24, September 1969, pp.595-612 6. A correlation matrix of the assets and inflation can also confirm which assets are hedges against inflation. 61 5.0 Valuation Model In this chapter a valuation model is developed to estimate quarterly market values for the apartment properties. The first section of the chapter describes the theoretical specifications of the model. Then Section 5.2 presents the estimated regression equation for the apartment properties and considers the effectiveness of the model. 5.1 THEORETICAL SPECIFICATION In the marketplace, the value of apartment blocks in Vancouver is determined by the interaction of the supply and demand schedules. Since we need to estimate the value for these properties, we must derive their supply and demand schedules. To do this, two assumptions are made: that all apartment blocks have the same supply and demand curves, 1 and that the market is in equilibrium so that price is determined where the quantity demanded equals the quantity supplied. To examine the supply and demand curves, we first consider the apartment block market in the long run. The supply and demand curves are neither perfectly elastic nor inelastic(see Figure 5.1). The supply, the stock of apartment blocks, can adjust in response to the demand. 62 \ / Supply \ / \\ / \ / \ / \ / \ / \ / \ / \ / \ Demand / \ \ \ Supply \ \ \ \ \ \ \ \ \ \ Demand \ Q Figure 5.1 Figure 5.2 The variables that are important to the developers who provide the supply and- to the investors who are the demand are characterized as follows: Supply = f(price of apartment blocks, construction costs, interest rates, rental income, land prices, inflation, taxes, availablity of zoned sites, increase in non-family households, vacancy rate) Demand = f(price of apartment blocks, future rents, risk premium of apartment investments, inflation, interest rates, potential of new supply, taxes, expected return on alternative investment opportunities) If we reduce the time span to examine the apartment block market in the short run, the supply curve becomes inelastic(see Figure 63 5.2). The time period is too short for any new stock to be added to the market; hence, market value is primarily determined by the demand variables.2 Investors incorporate the information from the supply and demand schedules into mathematical models which analyze the investment. The models which investors often use for analysis are discounted cash flow models. The most popular of these is the net present value model, NPV, a model which evaluates an investment through a comparison of the equity invested in a property at the time of purchase(Eo) and the present value of the after-tax equity cash flows(Ct) accruing to the real estate investors during the holding period(t=1, ...n) discounted at the required rate of return(r).3 N Equation 1. NPV = Z Cfc -Eo i = 1 (1+r)fc The decision criterion is to accept the real estate investment if NPV > 0 and reject it if NPV<0. From this equation, we find the value of a property by setting the equation equal to its present value, PV, by adding Eo to each side of the equation. In this new equation, the discounted future benefits equal the present value of the property. N Equation 2. PV. = Z Cfc i = 1 . (l+r)fc 64 Shenkel has shown by use of multiple regression analysis that the future benefits of a property are related to a set of common property characteristics, and that these property characteristics can be used to predict market value." The set of property characteristics that Shenkel used are grouped into three categories: area(or size), location, and services and amenities. Church, in his use of multiple regression analysis, argued that property characteristics are related to the supply and demand schedules. He considered as important those property characteristics that "explained" sales price differences from property to property, and categorized these characteristics under physical, locational, market( economic and financial) and prior knowledge classifications. This paper follows the work of Shenkel and Church by using least-squares regression analysis to explain the value for the apartment properties. The variables we judged to be pertinent for this study are listed below, together with reasons for selection and some descriptive detail: Market Value The market value(sales price) of the apartment blocks is the dependent variable for the initial runs in the regression model. The market value is taken as the actual sales price of the property as filed with the British Columbia Land Title Office. 65 Gross Income Multiplier The gross income multiplier(GIM) is the dependent variable for the final regression model. It represents the relationship between the purchase price of the property and its gross income. The GIM was used as a proxy for sales price because the GIM model increases the significance of many of the independent var iables. Gross Income The gross income for each property is the first independent variable, and is estimated from the procedure described in Chapter 3, Section 2. The gross income reflects the present benefits of the property and indicates the potential for future benefits. The expected sign of the variable is negative, because of the inverse relationship between income and the GIM; as income increases, the GIM decreases. AÂ£e The age of the building is taken as the number of years from the year of construction to the year of valuation. The age variable relates to the net operating income as well as to the reversion value. The expected sign is negative. Gross Floor Area The gross floor area(measured in square feet)is a size factor, and relates to the present(future) gross income and the 66 operating expenses of a property. The expected sign is positive. Floor Area Per Suite The floor area per suite (also measured in square feet) reflects on average the type of suites in the buildings. The floor area per suite relates to income and operating expenses. The expected sign for the floor area per suite is positive. Number of Stories The number of stories of the apartment block is assumed to have an effect on gross income and operating expenses. The expected sign is positive. Lot Size The size of the lot is calculated in square feet and is assumed to have an effect on the reversion value. The expected sign is positive. Locat ion The locational variables are dummy variables and four are included in the model. The areas for the dummy variables are: (l)West End, (2)Kitsilano, (3)South Granville, (4)East Side.5 Dummy variables were used for location, to attempt to pick up the different factors relating to location, i.e. proximity to downtown, vacancy rates, desirability of area, etc. The 67 expected signs for the West End, Kitslano, and South Granville are positive. The expected sign for the East Side is either positive or negative. Quarterly Dummy Variables The quarterly dummy variables are used to capture the change in economic conditions as well as shifts in the supply and demand curves. The quarterly dummy variables are also included in the regression equation to determine the quarterly price changes of the properties. The expected sign will vary over the time period. There are no financial variables included in the regression model. Church suggested that a variable that reflects the duration of the debt on the property or the interest rate weighted by the size of the remaining principal of each mortgage should be included.6 These variables were excluded because of data which was unable to be processed. 5.2 DEVELOPMENT AND ANALYSIS OF THE REGRESSION MODEL The first step in the development of the regression model was to see if the model could be separated into annual equations. Table 5.1 presents the total number of sales transactions by year. The rule of thumb for estimating our model on an annual basis is that the number of 68 observations/equation be greater than the degrees of freedom. The table shows that there were enough observations(sales transactions)for each year to permit annual estimated regression equations. These annual equations were useful, because, as Shenkel pointed out by limiting the estimated equation to a short period of time, the influence of time on the equation is reduced and the accuracy of the model is increased. As a next step, a summary of statistics was generated on the variables. The statistics were useful in analyzing the model, and in insuring that the model conformed to the assumptions of regression analysis. One assumption the model needed to conform to was that there be linearity in the coefficients of the independent variables.78 To increase the likelihood that the model satisfied this assumption, the distributions of the variables were examined for normality, by assessing the skewness of the distributions on an annual basis. The distributions for the price, GIM, number of stories, floor area per suite and lot size were all positively skewed. To normalize these distributions, lograrithmic transformations were applied. The log transformations constricted the intervals of the data as the values increased in size. The consequences to the distributions were that the right tail was drawn in while the values of the left tail of the distribution were moved away from the mean, thus tending to normalize the distributions.9 After transforming the variables, a series of regression equations were run to identify the best possible model: we TABLE 5.1 NUMBER OF SALES TRANSACTIONS PER YEAR YEAR NUMBER OF TRANSACTIONS 1 970 28 1971 35 1 972 39 1 973 56 1974 31 1 975 34 1 976 37 1 977 44 1 978 1 02 1 979 1 32 70 needed a model that minimized predictive error and a model that included enough variables so as to distinguish price differences from property to property. The first run of the model had the log of the price as the dependent variable, with the variables decribed in Section 5.1 as the independent variables. The first run produced quite surprisingly good results with the coefficent of determination for each of the ten annual regression equations above .90. The standard error of the estimate ranged from .10 to .28. These results were superior to those obtained by Hoag[28] but not as strong as Shenkel's results. The problem with this inital regression model was that only one explanatory variable, the log of income, was significant for all ten equations. Even though the estimated equations achieved the objective of a strong predictive model with minimal error, the model did not contain enough significant variables to explain price differences between the properties. By having only income as a significant variable, price would be essentially estimated by simple regression, a method rightfully critized for its lack of accuracy.10 Moreover, by only having a single variable to predict price, the correlations of the properties would be so strongly positive that there would be little po.ssiblity of finding potential diversification within real estate. So since this model failed to achieve the objective of including property characteristics that vary from property to property and that explain sales price differences, 71 the model was discarded. The model was then altered by dropping income as an explanatory variable. This procedure had been tried by Shenkel with great success.11 In the current study, the results from the regression run were also quite reasonable. The coefficient of determination for the ten estimated equations ranged from .70 to .96. The standard errors of the estimate were higher than in the first run, ranging from .11 to .34. this second run also brought out the significance of many of the independent variables. As a result, this model was adequate for use in the study; it had predictive power and could explain sales price differences of the study. Even though this model was satisfactory, another approach was taken to assure that it was the appropriate model. The new approach substituted GIM for market value as the dependent variable. With GIM as the dependent variable, a regression was run leaving the log of income out as an explanatory variable. The results from this run were poor, with the coefficient of determination for the ten equations ranging from .17 to .68. Most of the independent variables were not significant. The only good statistic was that the standard error of the estimate was low, from .11 to .22. Another run was attempted, keeping the GIM as the dependent variable, but in this equation the log of income was included as an independent variable. By including income, the significance of the other independent variables increased. The t-values for 72 these variables were larger in this equation than in the three previous equations. The coefficents of determination were mixed, varying from .404 to .761, but the standard errors of the estimates were quite good, ranging from .10 to .21. To compare the predictive accuracy of this model to the model with market value as the dependent variable, the average residual error, in absolute terms, was calculated. Table 5.2 reveals that the average predictive error was lower for nine of the ten annual equations with the GIM model. The average residual error was 11.3 percent in the GIM model as compared to 15.8 percent in the market value model. As a result, since the GIM model appeared the strongest predictive model with minimal error and it had more significant property characteristics to explain sales price differences, this model was used to predict market value. The ten annual equations of the model appear in Table 5.3. An attempt was made to keep only those variables which had a t-value greater than 1.0, so as to minimize the standard error. The quarterly dummy variables were an exception; these variables were always kept in the equation even if the t-values were below 1.0. Since all the other independent variables were constant throughout the year, the quarterly dummy variables were needed to calculate the change in value on a quarterly basis. The t-values of many of these variables(DM2, DM3, DM4) were low, implying that for many periods of time the change in value was not significant. As a result of keeping in all the dummy 73 TABLE 5.2 THE AVERAGE PREDICTIVE ERROR FOR THE GIM AND THE MARKET VALUE MODEL (BY PERCENTAGE) YEAR GIM MODEL MARKET VALUE MODEL 1970 1 1 .25 17.10 1 971 7.54 9.67 1 972 11.41 17.72 1973 12.16 1 9.68 1 974 23.73 1 0.93 1975 7.34 12.10 1 976 13.58 1 3.94 1977 8.87 1 3.92 1 978 7 .44 23.76 1 979 10.04 19.39 AVERAGE 11.33 15.79 TABLE 5 3 1970 THE ANNUAL VALUATION EQUATIONS GIM = (--.644+.037LINC-.005AGE+.154L0C1 .591) (.493) (-2.3) (1.6) +.184L0C5+.120LOCG ( 1 .S) (1.21 +.345LFAST (3.0) R2=.603 S.E.=.18404 F=3.042 0BS=28 -.141DM2-.157DM3-(-1.1) (-1.2) (â€¢ 048DM4 . 35 1 ) 1971 GIM = 5.645-.476LINC-.OO7AGE+.633L0C1+.6 17L0C2+.585L0C5+.'58OLOC6+.405E-O4FLAR (6.0) (-4.2) (-4.4) (3.1) (3.3) (3.0) (3.2) (3.6) ^.0780M2+.155DM3+.062DM4 (1.1) (2.0! (.7251 R2=.634 S.E. 12099 F = 4.159 0BS=35 1972 GIM =1.4 15+.007LINC-.004AGE+.13GL0C1+.192L0C2 (1.3) (.071) (-2.3) (1.0) (1.3) â€¢.204L0C6 ( 1.9) +.294LFAST (1.9) -.165LL0T-.061DM2- 022DM3-.111DM4 (-1.2) (-.594) (-.270) (-1.3) R2=.382 S.E.=.18168 F=1.520 0BS=39 1973 GIM = 4 . 185--. 252LINC- . 007AGE+. 097L0C 1 + . 223L0C2+. 1 19L0C5 (4.6) (-2.7) (-4.4) (1.1) (2.2) (1.0) +.114E-04FLAR (2.3) >â€¢ .030LL0T- .002DM2- .097DM3+ .0620M4 (1.1) (-.021) (-1.2) (.726) R2=.444 S.E.=.20867 F=3.589 0BS=56 1974 GIM=2.439-.137LINC-(2.5) (-2.3) .006AGE (-4.0) â€¢ .1O5L0C5-. 15OL0C6 (-1.1) (-1.8) .19GLFAST (2.3) -.042DM2-.085DM3-.1B0DM4 (-.674) (-.834) (-2.2) R2=.710 S.E.=.14058 F=5.706 0BS=31 1975 GIM=4.194-.371LINC-.004AGE+.13OL0C1+ 258L0C2+ 067L0C5 (6.6) (-5.7) (-3.8) (2.4) (3.2) (1.1) +.886E-05FLAR-(2.4) 185LL0T-(2.7) 020DM2< (- 295) 007DM3+.056DM4 (.112) (.842) R2=761 S.E.=.10302 F=7.326 0BS=34 1976 GIM = 4.477- .228LINC-.004AGE (6.3) (-3.1) (-3.1) 159LOC6*.813E-05FLAR (-2.8) (1.7) - 026DM2* 0030M3-.132DM4 (-.400) (.040) (-.1.9) R2=.565 S.E.=.14574 F'5.388 0BS'37 1977 GIM=5.066-.281LINC-.005AGE+.059LOC1+.081L0C2+.084L0C5-. 112L0C6+. 118E-04FLAR - . 129DM2-.0850M3-.211DM4 (6.4) (-3.5) (-4.0) (1.0) (1.1) (1.4) (-1.9). (2.01 (-1.96) (-1.3) (-3.2) R2=.592 S.E.=.12720 F=4.784 0BS=44 1978 GIM=3.318-. 146LINC-.004AGE+.031L0C 1+.129L0C2+.096L0C5 (13.2) (-6.0) (-7.2) (1.0) (3.7) (3.3) R2 =.543 S.E. 10056 F=10.840 0BS=102 â€¢ 031LFAST+.098LNOST (2.1) (3.0) - .06 1DM2-.015DM3+.049DM4 (-2.0) (-.480 (1.8) 1979 GIM=2.848-. 197LINC-.002AGE+. 107L0C1+.074LOC2+.O83L0C5-.O44L0C6 â€¢. 130LN05T+. 134LL0T-.003DM2+.007DM3+.053DM4 (10.0) (-4.6) (-3.0) (2.6) (1.6) (2.0) (-1.3) (3.0) (2.4) (-.077) (.202) (1.4) R2=304 S.E.=.12837 F=4.783 0BS=132 Definitions of Variables T-Statistic in Parentheses GIM - Gross Income Multiplier LINC - Log of gross income AGE - Age of Apartment Block LOCI - West End L0C2 - Kitsilano L0C5 -South Granville L0C6 - East Side of Vancouver Flar - Gross Floor Area LFAST - Log of Floor Area/Suite LNOST - Log of the Number of Stories LLOT - Log of the Lot Size DM2 - Economic Variable for 2nd Ouartor DM3 - Economic Variable for 3rd Quarter DM4 - Economic Variable for 4th Quarter 76 variables, the variablity of value may be overstated, making the variance of return of the properties overstated. Looking again at Table 5.3, we see that most of the signs for the variables were consistent with the expected signs. Income and age had negative signs and gross floor area, floor area per suite, number of stories, lot size and the locational variables were positive. There were two equations, 1970 and 1972, where the signs for income, lot size, and the dummy variable for the East Side were the reverse of their signs in other equations. These reverse signs along with the high standard errors of the estimate in the equations suggest that these equations maybe the weakest of the ten. In terms of problems that are associated with regression analysis: multicolinearity, heteroscedasticity, and outliers, the equations showed little evidence of their effects. With respect to multicolinearity the correlation matrices(see Appendix B) illustrate that the variables associated with size (log of lot size, gross floor area, and log of the number of stories) had a high correlation with income. The high correlations, though, did not alter any of the expected signs. Also, the standard errors of the coefficients for these variables were not significantly greater than the standard errors of the other variables. A possible reason that multicolinearity did not have an impact is that often only one of the variables reflecting size appeared in an equation with income at a time. 77 In checking for heteroscedascticity, the residual errors were plotted versus the predicted values for GIM(see Appendix B). The results show there to be some heteroscedasticity. However, the standard errors for the equations are low enough that the equations can tolerate some overstatement of the reliability because of heteroscedasticity. The last problem to check for is outliers. Outliers exist when a residual is extremely large(positive or negative) compared with other residuals. There were some outliers in the equations. Trial runs were made throwing out these observations, but there were no differences in the results. Hence all observations were kept in the study. In conclusion the weakness of using this model is that it employs quarterly dummy variables to determine the quarterly price changes. As a result, all properties increase in value by the same percentage, making the correlations between the properties 100 percent, from quarter to quarter and hindering the test to find diversification. On the whole, the model to predict market value is reasonable. On average, the predictive error is 11 percent. Also, the model also contains enough variables to explain sales price differences. 78 ENDNOTES 1. Church, Albert M., "An Econometric Model for Appraising", American Real Estate and Urban Economics Association Journal, Vol.3, No.1, Spring 1975, pp.17-29 2. Grether, D. and Mieskowski, P., "Determinants of Real Estate Values", Journal of Urban Economics, April 1974, pp.47-52 3. Gau, George W., "Risk Analysis and Real Estate Investment: Theoretical and Methodological Issues", Working Paper, University of British Columbia, 1982 4. Shenkel, William M., "The Valuation of Multiple Family Dwellings by Statistical Inference", The Real Estate Appraiser, January-Febuary 1975, pp.25-36 5. For an area to be included as a dummy variable, at least 10 percent of the sample to be located in that area. 6. Church, Albert M., "An Econometric Model for Appraising", American Real Estate and Urban Economics Association Journal, Vol.3, No.1, Spring 1975, pp.25-36 7. In least-squares regression, the most efficient estimator of a coefficient is a linear least squares estimator. 8. Rummel, R.J., Applied Factor Analysis , Evanston: Northwestern Press, 1970 9. ibid 10. Shenkel, William M., "The Valuation of Multiple Family Dwellings by Statistical Inference", The Real Estate Appraiser, January-Febuary 1975, pp.25-36 11. ibid 79 6.0 RESULTS This chapter presents the empirical results of the study and analyzes the two questions proposed in the introduction of the paper. The chapter begins with a description of the rates of returns, the standard deviations, and the variances for the set of apartment properties. In Section 6.2, we present the analysis of the answer to question one: can investors diversify their portfolios solely within real estate market? Lastly in Section 6.3, we frame our response to question two: can real estate improve the efficiency of investor's portfolios? 6.1 RETURN AND RISK MEASURES OF APARTMENT BLOCKS In the last chapter, a valuation model was developed to estimate market value. Using the predicted sales prices from the model and the cash flow information described in Chapter 3, rates of returns were calculated on the apartment properties. These rates of returns are set out in Appendix C. Most of the properties exhibit a mean return on capital of between 4 and 6 percent/quarter. The returns on equity are more dispersed, with a number of properties having a negative mean return. Generally, though, most properties have a positive return on equity which is greater than the return on capital. These higher returns on equity illustrate the benefits of leverage to an investor. The standard deviations and variances(the measures of risk), are much more dispersed for the returns on equity, as 80 compared to the returns on capital. . The majority of properties have a standard deviation for the return on capital that fall within a range of 11.00 percent to 15.00 percent/quarter, and variance of 1.50 percent to 3.25 percent/quarter. In respect to the standard deviation and variance for the return on equity, no such defined range exists. The vast dispersion of the standard deviation and variance for the returns on equity demonstrates the high risk factor of leverage. Table 6.1 displays the mean return of the market(Rm), the average total risk(V.), and the market risk(V ). The mean t m return on capital is 5.00 percent/quarter and the return on equity is 15.81 percent/quarter. In terms of risk, the market risk(Vm) and the average total risk(V ) associated with the return on capital is 1.50 percent/quarter and 2.10 percent/quarter repectively. The market and average total risks associated with the return on equity are far greater at 28.21 percent and 169.27 percent/quarter respectively.1 The additional risk caused by leverage seems to outweigh the benefit of a higher return. 6.2 ANSWER AND ANALYSIS OF QUESTION ONE In the introductory chapter of the paper, the following question was proposed: can investors diversify their portfolios solely within real estate? The only other study to investigate 81 TABLE 6.1 THE RETURN AND RISK MEASURES FOR THE SET OF APARTMENT BLOCKS(PERCENTAGE/QUARTER) Return on Capital Return on Equity Mean Return on Market(Rm) 5.01 15.81 Variance of Market(Vm) 1.50 28.21 Average Total Variance(Vt) 2.10 169.28 Ratio(Vt/Vm) .71 82 this question so far was conducted by Miles and McCue[44]; they found that diversification was possible within real estate.2 Given the results of Miles and McCue, this paper has tested the hypothesis that real estate investors can diversify their portfolios within a local real estate market. Beginning the analysis of question one, we calculated the ratio of ^vm/vt^ ^or t*ie return on capital.3 This ratio indicates the proportion of total risk accounted for by the market , i.e. non-diversifiable risk. The more important systematic or market influences are, the closer this particular ratio will be to 1.0." The ratio appearing in Table 6.1 illustrates that market risk is 71.43 percent of average total risk. In comparison to other equities, market risk was 54.40 percent of average total risk for bonds and 37.80 percent for stocks.5 Thus it appears that the potential to diversify within real estate is quite small; only 28.57 percent of the total risk is diversifiable. To determine whether geographical diversification within the city is possible, the sample was divided into two subsamples by location(see Chapter 4). The results of this test appears in Table 6.2. The ratio of (V /V.) for the West End was 79.80 m t percent, and for the outlying areas the ratio was 71.59 percent. These ratios show little potential to diversify within the city, not a surprising finding given the results above. When comparing the two ratios, the outlying areas contribute more to 83 TABLE 6.2 THE RETURN AND RISK MEASURES FOR THE SUB-SAMPLE OF APARTMENT BLOCKS(PERCENTAGE/QUARTER) WEST END REST OF THE CITY Mean Return on Market(Rm) 4.48 5.09 Variance of Market(Vm) 1.71 1.49 Average Total Variance(Vt) 2.15 2.08 Ratio(Vt/Vm) 79.80 71.59 84 diversification than does the West End. The latter, an area with more varied types of apartment blocks, from garden apartments to high-rise apartments, does not contribute strongly to portfolio diversification. The next step of the analysis was to examine the rate at which variation of return for randomly selected portfolios was reduced as a function of the number of properties included in the portfolio. This examination looked at portfolios from size 2 to 30 properties. The results of the test appear in Table 6.3. The variations of return show a downward but inconsistent trend. From portfolios of size 2 to 13, all but four portfolios had a variance of return greater than 1.60 percent, but from portfolio size 14 to 30 all variances of return were below 1.60 percent, indicating that some reduction in variation of return was occurring with diversification. The table also illustrates that most of the unsystematic risk was diversified away through the holding of only a few properties: at two properties, approximately 50 percent of the total unsystematic risk had been diversified away, while at 29 properties(the lowest variance of return) only 75 percent of the unsystematic risk was diversified away, an improvement of a mere 25 percent for a portfolio of fourteen times the size. To analyze the results in more detail, we ran t-tests on successive portfolios to indicate which portfolio sizes cause significant reduction in return variation. The results of these tests showed that the addition of one property to a portfolio of 85 TABLE 6.3 DESCRIPTION OF PORTFOLIO SIZE AND REDUCTION IN RETURN VARIATION PORTFOLIO SI ZE VARIANCE OF RETURN (percentage/quarter) 2 Properties 1 .79 3 Properties 1 .73 4 Properties 1 .61 5 Properties 1 .56 6 Properties 1 .78 7 Properties 1 .56 8 Properties 1 .66 9 Properties 1 .70 10 Properties 1 .56 11 Properties 1 .65 12 Properties 1 .59 13 Properties 1 .62 14 Properties 1 .58 15 Properties 1 .53 16 Properties 1 .56 17 Properties 1.57 18 Properties 1 .56 19 Properties 1 .57 20 Properties 1 .57 21 Properties 1 .54 22 Properties 1 .53 23 Properties 1 .58 24 Properties 1 .57 25 Properties 1.57 26 Properties 1.57 27 Properties 1.54 28 Properties 1.52 29 Propert ies 1.51 30 Properties 1.55 87 sizes 3, 6, and 9 cause significant reduction at the .05 level. However the results should be qualified. Since the variations of return show an inconsistent downward trend, it seems unreasonable to conclude that certain portfolio sizes do significantly reduce variance of return. With regard to portfolio sizes 6 and 9, the variance of return increased, thus raising the possibility that a significant reduction in variance would occur with the addition of another property to the portfolio. As a final test on the set of random portfolios, a simple regression analysis was run on the variations of return to analyze the relationship of decreasing portfolio variation as diversification increases. Regression analysis was performed fitting by least squares the regression function: Y = a + b(1/fx) where Y equals the return variance of the portfolios and x is the portfolio size. The function did not produce an extremely good fit, as indicated by the low coefficient of determination, .36310. Only 36 percent of the variance of return can be explained by diversification. This result diff.er.s from the conclusions reached by Evans and Archer[l7] whose regression equation had a fit of .986,3. Our study's comparatively poor result is due to the inconsistent trend seen in the variations of return, and the fact that much of the reduction of variance occurred within a very few properties. Therefore, the results from the tests on the random portfolios are similar to the 88 results comparing market risk to average total risk; the potential to diversify is marginal. With the analysis concluded, we can now answer the first question proposed in the paper: can investors diversify their portfolios solely within a real estate market? The answer to the question is no, investors cannot diversify solely within a real estate market if that market is confined to one locale and one property type. The results demonstrate that less than 30 percent of the risk is diversifiable. Since the answer to the question is no, the hypothesis that investors can diversify their portfolios within a local real estate market must also be rejected. The rejection of the hypothesis might be reversed if different property types were included in the portfolio. A discussion on the effects these conclusions have on real estate investors is presented in the next chapter. 6.3 ANSWER AND ANALYSIS OF QUESTION TWO The second question of the study asks if real estate can improve the efficiency of investors' portfolios. To deal with this question, two different types of efficient portfolios are considered. The first type of efficient portfolio refers to an inflation-hedged portfolio: a portfolio that has a return which keeps pace with inflation and has a high correlation with the rate of inflation. The second type of efficient portfolio follows Markowitz's description of efficient portfolios, that set of portfolios which offer the highest expected return for a given variance of return. Past research has shown that real estate does improve the 89 efficiency of investors' portfolios in respect to both definitions. Since past literature demonstrated the usefulness of real estate in mixed asset portfolios, the paper proposed the hypothesis that real estate will improve the efficiency of investors' portfolios under both definitions of efficient. Given this hypothesis, we start the analysis by examining the effects of real estate on an inflation-hedged portfolio. Table 6.4 presents the mean rate of returns and standard deviations for the various investment assets to be included in the portfolio, and the inflation rate.6 All the assets except treasury bills, as the table indicates, have a rate of return that surpasses inflation. Treasury bills have a slightly lower rate of return but also a lower standard deviation. In the case of real estate, the return is high, 5.00 percent/quarter, with a quarterly standard deviation of 8.61 percent. The return and risk are comparable to those obtainable on the other investment assets. Turning to Table 6.5, we can view the cross correlations of the assets to inflation. The cross correlations indicate which assets might be useful in an inflation-hedged portfolio. The table shows that treasury bills have the strongest correlation with inflation, .50, and that real estate and gold are slightly positively correlated, .24 and .10 respectively. Bonds and stocks have a negative correlation of -.28 and -.13 respectively. So treasury bills, real estate and gold, being positively correlated, appear useful in an inflation-hedged 90 TABLE 6.4 THE INFLATION RATE, THE MEAN RETURNS AND STANDARD DEVIATIONS FOR THE INVESTMENT ASSETS(PERCENTAGE/QUARTER) MEAN RETURN STANDARD DEVIATION INFLATION 1.85 0.86 TREASURY BILLS 1.76 0.6BONDS 2.22 4.53 GOLD 7.77 15.40 COMMON STOCK 2.93 8.28 REAL ESTATE 5.00 12.25 91 TABLE 6.5 CORRELATION MATRIX OF INFLATION AND THE INVESTMENT ASSETS CPI TBILLS BONDS GOLD TSE RE CPI 1 .000 0.500 -0.283 0. 100 -0.129 0.241 TBILLS 0.500 1 .000 -0.116 -0.006 0.001 0.049 BONDS -0.283 -0.116 1 .000 -0.121 0.332 -0.343 GOLD 0. 1 00 -0.006 -0.121 1 . 000 0.078 0.223 TSE -0.129 0.001 0.332 0.078 1 .000 -0.243 RE 0.241 0.049 -0.343 0.223 -0.243 1 .000 92 portfolio. To determine the mixture of the assets in an inflation-hedged portfolio, the returns of the assets were regressed against inflation. From the equation, we determined which assets would be included and which assets would be sold short. Also from the equation, we calculated the weights of the asset in the portfolio. Table 6.6 presents the weights of the assets in the inflation-hedged portfolio. As seen from the table, treasury bills dominate the portfolio and appear to be the only valuable asset in it. Real estate and gold are included in the portfolio, but only a small percentage is allocated to these assets. Bonds and stocks would be sold short. At the bottom of the table is the rate of return and standard deviation that could have been obtained from this portfolio over the period of the study. The rate of return is slightly less than the rate of inflation, 1.82 percent/quarter compared to 1.85 percent/quarter for inflation. However, the variability of the portfolio is also lower than that of inflation. The low return and variability is a reflection of the dominance of treasury bills in the portfolio. When the correlation between inflation and the portfolio was calculated, the correlation was .55, not much larger than the correlation of inflation to treasury bills. Therefore this inflation-hedged portfolio is not a perfect hedge. The results illustrated that real estate does contribute to an inflation-hedged portfolio. However, treasury bills are the 93 TABLE 6.6 THE WEIGHTED PROPORTIONS FOR EACH ASSET IN AN INFLATION-HEDGED PORTFOLIO Treasury Bills 1.0368 Bonds - .0503 Gold .0053 Common Stock - .0083 Real Estate .0165 94 dominant asset in the portfolio, and even by including real estate and gold, the hedge against inflation does not improve greatly over a portfolio consisting solely of treasury bills. Turning to the second definition of efficient, we begin by recalling that Markowitz demonstrated that through diversification the overall variablity of the portfolio can be reduced, thereby making it more efficient. The reduction of risk occurs when assets are combined that have a negative(or low positive) correlation with other assets in the portfolio. The result of combining such assets is that the individual risk of the assets is diversified away, while only the interrelationship of the assets contributes to the portfolio risk. To see if real estate improves the efficiency of an investor's portfolio, we should then inspect the correlations of real estate to the other investment assets. The correlation matrix in Table 6.5 reveals that the correlation of real estate to the other assets is low positive for gold and treasury bills and slightly negative with common stock and bonds. It appears that real estate can improve the efficiency of investors' portfolios. The low correlation with the other assets should help diversify away individual risk of the assets. To actually ascertain if real estate improves the efficiency of an investors' portfolio, we employed the objective function described in Chapter 4: 95 maxlmize N Z X â€¢ R. N N - X Z Z - M( 2 ) N l l i = l 1=1j=i i = 1 To derive this objective function a computer program was written which computes the efficient frontier(see Appendix A). Figure 6.1 presents a graph of the efficient frontier. The scattered line represents the efficient frontier with real estate included in the portfolios, while the solid line denotes portfolios that contains all investment assets except real estate. The graph illustrates that the portfolios which include real estate strongly dominate the portfolios without real estate. The dominant position of the real estate-augmented portfolios decrease as the returns of the portfolio decrease. This is because at the lower rates of returns real estate becomes a decreasing percentage of the portfolios. Table 6.7 shows the asset mixture for portfolios (that include real estate) along the efficient frontier. If we divide the table in two, we see that the portfolios with high returns (a return above 3.94 percent/quarter) sell treasury bills short. This reflects the need of leverage to obtain these high rates of returns. Of the other assets, bonds are dominant; real estate and gold approximately have the same weight in the portfolios; and common stock contributes slightly less than that of real estate and gold. Bonds are a major factor because of their low risk relative to the other positive weighted assets. Looking 96 Figure 6.1 THE EFFICIENT FRONTIER O (percent/quarter) 97 TABLE 6.7 A SET OF PORTFOLIOS ALONG THE EFFICIENT FRONTIER (BY DECREASING RATE OF RETURN) RETURN VARIANCE OPTIMAL PROPORTIONS FOR EACH ASSET ARE: percent/ percent/ quarter quarter T-BILLS. BONDS GOLD TSE R.E. 13.73 5.99 - 3.97 2.03 1.10 0.70 1.14 11.16 3.66 - 2.90 1 .60 0.86 0.55 0.89 9.12 2.23 - 2.05 1 .26 0.67 0.43 0.70 7.52 1 .37 - 1 .40 0.99 0.52 0.33 0.55 6.27 0.84 - 0.88 0.78 0.41 0.26 0.43 5.30 0.51 - 0.48 0.62 0. 3,2 0.20 0.34 4.53 0.31 - 0.17 0.49 0.25 0.16 0.26 3.94 0.19 - 0.08 0.40 0.20 0.12 0.21 3.47 0.12 0.27 0. 32 0.15 0.10 0.16 3.11 0.07 0.42 0.26 0.12 0.08 0.13 2.83 0.05 0.53 0.21 0.10 0.06 0.10 2.61 0.03 0.63 0.17 0.07 0.03 0.08 2.43 0.02 0.70 0.14 0.06 0.04 0.06 2.30 0.01 0.75 0.12 0.05 0.03 0.05 2.19 0.01 0.80 0.10 0.04 0.02 0.04 98 TABLE 6.8 COMPARISONS OF THE RISK (VARIANCE) OF THE INDIVIDUAL ASSETS TO EFFICIENT PORTFOLIOS WITH THE SAME MEAN RETURN VARIANCE (percent/quarter) ASSET ASSET EFFICIENT PORTFOLIO PERCENTAGE DIFFERENCE REAL ESTATE 1 .50 0.43 - 71 .33 BONDS 0.20 0.01 - 95.00 GOLD 2.37 1 .49 - 37. 13 COMMON STOCK 0.69 0.06 - 91.30 Note: Treasury Bills since they have are not included in the lowest possible the comparisons, risk obtainable. 99 at the low return portfolios, the table illustrates that treasury bills are the most significant asset; bonds are a minor portion of the portfolios; while real estate, gold and common stock contribute only marginally to the portfolios. To further examine the benefits of diversifying in mixed-asset portfolios, Table 6.8 compares the risk of the individual assets to the risk of efficient portfolios with the same mean return. The comparisons clearly indicate the benefits of diversifying in mixed-asset portfolios. The risk of the mixed-asset portfolios is significantly less than the risk of the individual assets. For example, an efficient portfolio with the same mean return as real estate has approximately 70 percent less variability than real estate (.43 percent/quarter versus 1.50 percent/quarter). In conclusion, real estate does improve the efficiency of investors' portfolios. Our second hypothesis can be accepted under both definitions of efficiency. Real estate does help an investor hedge against inflation; real estate has a negative(or low positive) correlation with other investment assets, which enables investors to further reduce their diversifiable risk. 1 00 ENDNOTES 1. The distributions for the market and average total variance are strongly skewed positive. A few properties that have very large variances greatly influence the market and average total risk. 2. Miles, Mike and McCue, Tom, "Considerations in Real Estate Portfolio Diversification", Working Paper, University of North Carolina, 1980 3. Since the return on equity is influenced by investor's leverage, it can not indicate the risk that is strictly associated to real estate. Therefore it is unnecessary to calculate (Vm/Vt) for the return on equity. 4. Evans, John L. and Archer, Stephen N., "Diversification and the Reduction of Dispersion: An Empirical Analysis", Journal of Finance, December 1968, pp.761-767 5. Miles, Mike and McCue, Tom, "Considerations in Real Estate Portfolio Diversification", Working Paper, University of North Carolina, 1980 6. Only the return on capital for real estate is included in the efficient portfolios. It is only reasonable to use similar rates of return measures for both real estate and the other investment assets. Also the correlations for both measures for real estate, the return on capital and the return on equity, to the other investment assets are so similar that their effect on a mixed-asset portfolio is about the same. 101 7.0 DISCUSSION Chapter 6 presented the empirical results and answered the two questions proposed in this paper. This chapter briefly reviews the results, in the context of explaining their implications to investors. 7.1 Implications of Findings to Investors The popularity of real estate, as an investment, increased substantially through the seventies. The demand for real estate soared, as investors perceived real estate to be the investment to combat inflation.1 But what was the return on real estate during this decade? No one really knows. Since real estate lacks a "centralized" exchange, 2 it is difficult to compile information on returns. As a result, little research has been conducted on the behavior of real estate returns, although studies investigating the behavior of other assets are quite extensive. This study calculated a set of real estate returns for apartment blocks located in Vancouver, British Columbia, from 1970-1979. The paper used these returns to focus on the potential benefits of diversification in real estate. Two issues of diversification were dealt with: the potential of diversifying within real estate, and the benefits of including real estate in mixed-asset portfolios. 1 02 The mean return calculated on the apartment blocks was 5.00 percent/quarter and the standard deviation was 12.25 percent/quarter. The return and risk of real estate were second highest to gold, with real estate returns outpacing those of treasury bills, bonds, and common stock. Investors received a return from real estate that not only matched inflation, but also provided a real return of approximately 3.20 percent/quarter. Investors who applied leverage on their properties, on average, tripled their return; however the risk contributed by leverage might outweigh the benefits of the higher return. In comparing the average total variance(Vt) for the return on capital to the return on equity, the average total variance for the return on equity was overwhemingly greater. This information illustrates to investors the importance of conducting some form of analysis;such an analysis will make them aware of cash flow difficulties that might result from the added fixed costs of leverage. After calculating the returns on the properties, the paper examined the potential of diversification within real estate. The first part of the examination looked at the relative proportions of systematic and unsystematic risk. The investigation found that only 29 percent of total risk is unsystematic(diversifiable). In contrast, Miles and McCue[44] found that between 87 and 95 percent of total risk is unsystematic(they used a sample containing different property types throughout the United States). Miles and McCue considered 1 03 the important factors for the high unsystematic risk to be the result of a property's unique character, i.e. location, cash flow, and lease on property. There were four reasons why our study had such different results from that of Miles and McCue: (1) the data were confined to a single property type, (2) the property type was limited to one locale, (3) the valuation model was not able to incorporate enough of the characteristics Miles and McCue considered to be important, (4) the method to estimate value overstated the correlation of the properties(see Chapter 5) . In evaluating the results of this paper, real estate investors should discount the problems of the valuation model, and recognize the fact that portfolios confined to one property type in one local market are not well diversified. If investors want a diversified portfolio holding only real estate, then they need to include a range of property types throughout various markets. A factor that investors should consider if they try to fully diversify within real estate, is the cost of diversification. By having to diversify across property types and geographical regions, they may find the costs of obtaining information too high and the quality of that information of uncertain value. For the next part of the examination, the paper investigated the effect of portfolio size on the reduction of return variation. The results of this investigation were weak with only 36 percent of the variation of return being explained 1 04 by diversification. The return variation of portfolios of increasing size showed a downward but inconsistent pattern. When t-tests were run to see if any of the portfolios caused significant reduction in variation, three portfolios were found to have caused significant reduction, portfolio sizes 4, 7, and 10. But, because of the inconsistent pattern in return variation, these results should not be considered fully reliable. However, investors should note that it is possible to diversify away a large portion of the total unsystematic risk by holding portfolios which contain only a few properties. Investors do not have to incur large transaction costs to eliminate diversifiable risk in a local market; through two or three properties, investors can take advantage of most of the diversification potential. Even though the paper did not find the potential to diversify efficiently within a portfolio consisting solely of real estate, it did discover that investors can benefit by including real estate in mixed-asset portfolios. The study found that the inclusion of real estate in an inflation-hedged portfolio was beneficial. In this portfolio, real estate, treasury bills, and gold all contributed to its efficiency. The most valuable asset in the portfolio was treasury bills. Treasury bills had a correlation of .50 with inflation, while the inflation-hedged portfolio only had a correlation of .55. In other studies, Fama and Schwert[l9] and Hallengren[27 ] observed that real estate was the most effective hedge against 105 inflation. Even though real estate did not contribute as strongly in this study's inflation-hedged portfolio, the results still demonstrate to investors that they should include real estate in portfolios that are designed to hedge inflation. The study also found real estate to have a low or negative correlation with other assets, making the potential to diversify very high in a mean-variance efficient portfolio. For example, an efficient mixed-asset portfolio with the same return as one consisting solely of real estate(5.00 percent/quarter) had over 70 percent less risk. So investors can enjoy the high return associated with real estate without taking on a great deal of risk. Also, they can diversify in a mixed-asset portfolio without incurring great costs. If investors select mutual funds which reflect the return behavior of other equity markets, then transaction costs(including information costs) should be low, and the investor's portfolio will be well diversified. In addition, the study found that the efficient portfolios which had high rates of return sold treasury bills short, illustrating the need of leverage in obtaining high rates of return. The implication of these findings are that: (1) small individual investors who own their home should concentrate their remaining funds in other investment assets, in order to take advantage of diversification; (2) investors who invest strictly in real estate should consider the benefits of including other assets in their portfolio. The cost to diversify in a mixed-asset 1 06 portfolio may be less than the costs of diversifying within real estate. (3) investors concerned with the illiquidity of real estate can enjoy the benefits of diversification without having to feel that a large portion of their portfolio is tied up(illiquid); In conclusion, the paper discovered that real estate was beneficial in mixed-asset portfolios. Real estate is a useful addition to almost any portfolio no matter what the investment objectives are. The amount of real estate to be included in a portfolio depends on the investor, his investment objectives, and his beliefs on the return of real estate and how it covaries with other assets. THAT'S ALL FOLKS 1 07 ENDNOTES 1. Investors believed that the after-tax rate of return on real estate would be greater than other investments in an inflationary environment, because of leverage and the tax advantages of real estate. 2. Miles, Mike and McCue, Tom, "Considerations in Real Estate Portfolio Diversification", Working Paper, University of North Carolina, 1980 108 BIBLIOGRAPHY 1. Anderson, Lloyd A., Energy Economics in Office Buildings , Master of Science Thesis, University of British Columbia, 1 982 2. Ballard, CM., "Pension Funds in Real Estate: New Challenges/Opportunities for Professionals", The Appraisal Journal, October 1978 3. Beja, Avraham, "On Systematic and Unsystematic Components of Financial Risk", Journal of Finance, March 1972 4. Block, F.E., "Elements of Portfolio Construction", Financial Analysts Journal, May 1969 5. Blume, M.E., "Portfolio Theory: A Step Towards its Practical Application", Journal of Business, April 1970 6. Blume, M.E. and Friend, I., "Asset Structure of Individual Portfolios and Some Implications for Utility Functions", Journal of Finance, May 1975 7. Brealy, Richard A., An Introduction to Risk and Return from Common Stock , M.I.T. Press, Cambridge, Mass., 1969 8. Brealy, Richard A. and Myers, Stewart, Principles of Corporate Finance , McGraw-Hill Book Co., 1981 9. Brown, G., "Making Property Investment Decisions via Capital Market Theory", Accountancy, May-June 1978 10. Chudleigh III, Walter H. and Brown Lawrence E., "Real Estate Investment Yield as Correlated to the Rate Shown in Money and Capital Markets", The Real Estate Appraiser and Analyst, Novenber-December 1978 11. Church, Albert M., "An Econometric Model for Appraising, " American Real Estate and Urban Economics Association Journal, Spring 1975 12. Cohen, K.J. and Pogue, J.A., "Empirical Evaluation of Alternative Portfolio Selection Models", Journal of Business, April 1967 13. Curcio, Richard J. and Gaines James P., "Real Estate Portfolio Revesion", Journal of the American Real Estate and Urban Economics Association, Winter 1977 14. Draper, Dennis W. and Findlay, Chapman M., "Capital Asset Pricing and Real Estate Valuation", Working Paper, 109 University of Southern California, September 1981 15. Elton, Edwin J. and Gruber, Martin J., Modern Portfolio Theory and Investment Analysis , John Wiley and Sons, 1981 16. Elton, Edwin J. and Gruber, Martin J.,' "Risk Reduction and Portfolio Size: An Analytical Solution", Journal of Business, October 1977 17. Evans, John L. and Archer, Stephen N."Diversification and the Reduction of Dispersion:An Empirical Analysis", Journal of Finance, December 1968 18. Fama, Eugene F., Foundations of Finance , Basic Books Inc., New York, 1976 19. Fama, Eugene F., and Schwert, William G., "Asset Returns and Inflation", Journal of Financial Economics, June 1977 20. Findlay III, Chapman M., Hamilton, Carl W., Messner Stephen, D., and Yormark, Jonathan S., "Optimal Real Estate Portfolios", Journal of the American Real Estate and Urban Economics Association, Fall 1979 21. Fisher, L. and Lorrie, J., "Some Studies of Variability of Returns on Investments in Common Stocks", Journal of Business, April 1970 22. Friedman, Harris C, "Real Estate Investment and Portfolio Theory", Journal of Financial and Quantitative Analysis, April 1970 23. Gau, George W., "Determinants of Return in Real Estate Investment and the Role of Real Estate Management", Institute of Real Estate Management Foundation, July 1981 24. Gau, George W., "Risk Analysis and Real Estate Investment: Theoretical and Methodological Issues", Working Paper, University of British Columbia, 1982 25. Gau, George W. and Kohlhepp, Daniel, "The Estimation of Equity Yield Rates Based on Capital Market Returns", The Real Estate Appraiser and Analyst, November-December 1978 26. Grether, D. and Mieskowski, P., "Determinants of Real Estate Values", Journal of Urban Economics, April 1974 27. Hallengren, H.E., "How Different Investments Fair During Inflationary Cycles", Commercial and Financial Chroncle, June 1974 28. Hoag, James W., "Towards Indices of Real Estate Value and 1 1 0 Return", Journal of Finance, May 1980 29. Ibbotson, Roger G. and Singuefield, Rex A., "Stocks, Bonds, Bills and Inflation: Year-by-Year Historical Returns(1926-1974), Journal of Business, January 1976 30. Jacob, N.C., "Limited-Diversification Portfolio Selection Model for the Small Investor", Journal of Finance, June 1974 31. Johnson, Robert, Elementary Statistics, Duxbury Press, North Scituate, Mass., 1976 32. Katz, David A., Econometric Theory and Applications , Prentice-Hall, Englewood Cliffs, N.J., 1982 33. Klemkosky, R.C. and Martin, J.D., "Effect of Market Risk on Portfolio Diversification", Journal of Finance, March 1975 34. Latane, H.A. and Tuttle, D.L., "Criteria for Portfolio Building", Journal of Finance, September 1967 35. Latane, H.A., Tuttle, D.L. and Jones, CP., Security Analysis and Portfolio Management, The Ronald Press, New York, 1975 36. "Latane, H. and Young W., "Test of Portfolio Building Rules", Journal of Finance, September 1969 37. Livingston Miles, "Industry Movements of Common Stocks", Journal of Finance, June 1977 38. Mansfield, Edwin, Principles of Microeconomics, W.W.Norton & Co. Inc . , New York, 1977 39. Mao, J.C.T., "Essentials of Portfolio Diversification Strategy", Journal of Finance, December 1970 40. Markowitz, Harry M., "Portfolio Selection", The Journal of Finance, March 1952 41. Markowitz, Harry M.,* Portfolio Selection: Efficient Diversification of Investments, Cowles Foundation for Research in Economics at Yale University, 1959 42. Martin, John D. and Klemkosky, Robert C, "The Effect of Homogeneous Stock Groupings on Portfolio Risk", Journal of Business, July 1976 43. McEnally, Richard W., and Boardman, Calvin M., "Aspects of Corporate Bond Portfolio Diversification", Journal of Financial Research, Spring 1979 111 44. Miles, Mike and McCue Tom, "Considerations in Real Estate Portfolio Diversification", Working Paper, University of North Carolina, 1980 45. Miles, Mike and Rice, Michael, "Toward a More Complete Investigation of the Correlation of Real Estate Investment Yield to the Rate Evidenced in the Money and Capital Markets: The Individual's Perspective", The Real Estate Appraiser and Analyst, November-December 1978 46. Miller, Stanley F., "The Correlation of Real Estate Investment Yield to the Rate Evidenced in the Money and Capital Markets", The Real Estate Appraiser and Analyst, November-December 1978 47. Mills, W.C. and Hoover, W.C."Investment in Forest Land: Aspects of Risk and Diversification", Land Economics, Febuary 1982 48. Penny, Peter E., "Modern Investment Theory and Real Estate Analysis", The Appraisal Journal, January 1982 49. Porter, R.B. and Gaumnitz, J.E."Stochastic Dominance versus Mean-Variance Portfolio Analysis: An Empirical Evaluation", American Economic Review, June 1972 50. Robichek, A.A., Cohn, John J., and Pringle, J., "Returns on Alternative Investment Media and Implications for Portfolio Construction", The Journal of Business, 1972 51. Roulac, Stephen E., "How to Structure Real Estate Investment Management", Journal of Portfolio Management, Fall 1981 52. Roulac, Stephen E., "The Influence of Capital Market Theory on Real Estate Returns and the Value of Economic Analysis", The Real Estate Appraiser and Analyst, November-December 1978 53. Rummel, R.J., Applied Factor Analysis , Evanston: Northwestern University Press, 1970 54. Schotland, R.A., "Divergent Investing for Pension Funds", Financial Analysts Journal, October 1980 55. Sharpe, William F., "A Simplified Model for Portfolio Analysis", Management Science, January 1963 56. Sharpe, William F., Investments, Prentice-Hall Inc., Englewood Cliffs, New Jersey, 1981 57. Sharpe, William F., "Essentials of Portfolio Diversification Strategy:Reply", Journal of Finance, March 1972 .1 12 58. Shenkel, William M., Modern Real Estate Appraisal, McGraw-Hill Book Co., 1978 59. Shenkel, William M."The Valuation of Multiple Family Dwellings by Statistical Inference", The Real Estate Appraiser, January-Febuary 1975 60. Sirmans, C.F. and Webb James R., "Investment Yields in the Money, Capital and Real Estate Markets: A Comparative Ananlysis for 1951-1976", The Real Estate Appraiser and Analyst, November-December 1978 61 . Smith, K.V.. , "Stock Prices and Economic Indexes for Generating Efficient Portfolios", Journal of Business, September 1969 62. Upson R.B., "Portfolio Diversification Strategies", Financial Analysts Journal, May 1975 63. Wagner, W.H. and Lau, S.C., "Effect on Diversification on Risk", Fiancial Analysts Journal, Novenber 1971 64. Wendt, Paul F. and Wong, Sui N., "Investment Performance: Common Stocks versus Apartment Houses", Journal of Finance, December 1965 65. Wicks, Ann P., An Ananlysis of the Effects of M.U.R.B. Legislation on Vancouver's Rental Housing Market , Master of Science Thesis, 1982 66. Wofford, Larry E. and Moses, Edmund A., "The Relationship between Capital Markets and Real Estate Investment Yields:Theory and Application", The Real Estate Appraiser and Analyst, November-December 1978 67. Wonnacott, Thomas H. and Wonnacott, Ronald J., Introductory Statistics for Business and Economics John Wiley and Sons, 1977 1 1 3 APPENDIX A REAL SIGNVR,SIGNVJ,JSGNVJ,JSGNVR REAL ER,VLAM,VAR,SUM C PROG TO FORM PORTS CROM COUNTRY DATA DIMENSION VMN(5),VARC(5,5), 1CORR(2 0,20),SIG(20),RP(20) DIMENSION B(5,5),SIGNVR(5),SIGNVJ(5),IPERM(15),X(100) C READ VMEAN DO 10 1=1,5 READ(1,7)(VMN(I)) 7 FORMAT(5X,F7.3) 10 CONTINUE C READ VARC DO 9 KK=1 , 5 READ(2,12)(VARC(KK,J),J=1 , 5 ) 12 FORMAT(5X,5F9.3) 9 CONTINUE CALL FINV(5,5,VARC,I PERM,5,B,DET,JEXP,COND) DO 14 K=1,5 SIGNVR(K)=0.0 SIGNVJ(K)=0.0 DO 15 J=1 , 5 SIGNVR(K)= SIGNVR(K)+B(K,J)*VMN(J) SIGNVJ(K)=SIGNVJ(K)+B(K,J)*1 15 CONTINUE 14 CONTINUE JSGNVR=0 JSGNVJ=0 DO 16 K=1,5 JSGNVR=JSGNVR+SIGNVR(K) JSGNVJ=JSGNVJ+SIGNVJ(K) 16 CONTINUE VLAM=0.010 DO 18 KL=1,15 VMV=(JSGNVR-2*VLAM)/JSGNVJ W1=1.0/(2.0*VLAM) W2 =VMV/(2.0 *VLAM) DO 19 K=1,5 X(K)=W1*SIGNVR(K)-W2*SIGNVJ(K) 19 CONTINUE SUM=0 DO 731 1=1,5 SUM=SUM+X(I) 731 CONTINUE ER=0.0 VAR=0.0 DO 20 K=1,5 ER=ER+X(K)*VMN(K) DO 21 J=1 , 5 VAR=VAR+X(K)*X(J)*VARC(K,J) 1 1 4 21 CONTINUE 2 0 CONTINUE WRITE(6,282) 282 FORMAT(///,5X,17X,'EXPECTED RETURN',13X,'VARIANCE'///) WRITE(6,283)ER,VAR WRITE(6,997) 997 FORMAT(/'THE OPTIMAL PROPORTIONS FOR EACH ASSET ARE:'//) WRITE(6,998) 998 FORMAT(3X,'T~BILLS',3X,'BONDS',5X,'GOLD',5X,'TSE',7X,'R.E.' WRITE(6,284)(X(l),I=1,5) 284 FORMAT(//,10F9.2,/10F9.2) 283 FORMAT(5X,16X,F13.9,15X, F 1 3 . 9) VLAM=VLAM*1.28 18 CONTINUE STOP END 1970 CORRELATION LINC9 AGE L0C1 L0C2 L0C5 LOC LINC9 1 . . ooo -0. ,666 0, . 186 0, ,044 -0, . 100 -0, , 37 AGE -0. 66G 1 . .000 -0 . 264 -0. .118 0, .039 0, , 39 L0C1 0. . 186 -0. ,264 1 , .000 -0. , 269 -0, , 236 -0. 33 L0C2 0. .044 -o. 1 18 -0, , 269 1 . 000 -0. , 190 -0, 26 L0C5 -0. . 100 0. ,039 -0 . 236 -0, , 190 1 , ,000 -0, 23 L0C6 -0. 379 0. 390 -o. , 333 -0. 269 -0. 236 1 . 00 FLAR 0. .884 -0. 467 0, , 140 0, 024 -0. 176 -0, 18 LF AST 0. 042 -0. 015 -0, 119 -0. 013 0. 050 -0. 14 LN05T 0. 581 -0. 422 -0. 105 0. 051 -0, 155 0. 12 LLOT 0. 868 -0. 6 12 -o. 095 0. 169 -0. 223 -0. 21 DM2 -0. 134 0. 190 0. 132 -0. 321 0. 156 0. 13 DM3 0. 328 -0. 184 0. 048 0. 162 -0. 000 -0. 14 DM4 -0. 330 0. 088 -0. 221 0. 278 -0. 062 0. 13 LGIM 0. 377 -0. 563 0. 211 -0. 129 0. 1 1 1 -0. 24 LGIM LINC9 AGE LOC 1 L0C2 L0C5 L0C6 FLAR LF AST LNOST LLOT DM2 DM3 DM4 LGIM 0. 377 -O.563 21 1 129 1 1 1 -0.249 0. 290 0. 0. 0. 436 297 428 0. 224 0.046 0.086 1 .000 MULTIPLE R 0.77675 R SQUARE 0.60333 ADJUSTED R SQUARE 0.40500 STANDARD ERROR 0.18404 ANALYSIS OF VARIANCE REGRESSION RESIDUAL DF 9 18 F = 3.04202 VARIABLES IN THE EQUATION VARIABLE B SE B BETA T SIG LINC9 0 03702 0 07504 0 1 1 183 0 493 0 62 LF AST 0 34540 0 11518 0 47333 2 999 0 00 LOC5 0 1841 1 0 1 1725 0 27498 1 570 0 13 DM2 -0 14072 0 13406 -0 28051 - 1 050 0 30 LOC1 0 15377 0 09778 0 28420 1 573 0 13 DM3 -0 15679 0 13126 -0 28978 - 1 194 0 24 L0C6 0 12010 0 10438 0 22196 1 151 0 26 AGE -0 00514 0 00220 -0 49508 -2 338 0 03 DM4 -0 0475 1 0 13518 -0 0947 1 -0 351 0 72 (CONSTANT) -0 64434 1 08959 -0 591 0 56 CASEWISE PLOT OF STANDARDIZED RESIDUAL -3.0 0.0 3.0 SEONUM 0 â€¢ . . . : 0 LGIM 1 2 0953 2 * 1 2790 3 * 1 9354 4 1 8076 5 1 7489 6 * 1 78 17 7 1 9439 8 * 1 8050 9 1 6726 10 2 0093 1 1 * 1 8399 12 * 1 9917 13 * . 1 8659 14 * 2 0527 15 * 1 7577 16 1 9 124 17 1 8759 18 * 1 9872 19 2 0130 20 0 9282 2 1 1 6156 22 * 1 7546 23 * 1 9703 24 1 9833 25 * 1 795 1 26 1 8999 27 * 1 926 1 28 1 829 1 SEONUM o â€¢ . . . : 0 LGIM -3.0 0.0 3.0 FILE NONAME (CREATION DATE = 02/06/84) * * * * MULTIPLE DEPENDENT VARIABLE.. LGIM RESIDUALS STATISTICS: MI N MAX MEAN STD DEV N *PRED 1 . , 2686 2 . . 1225 1 .8242 0. 1686 28 *ZPRED -3 . 2959 1 . 7699 -0. .0000 1.0000 28 *SEPRED 0. .0367 0. 1379 0 .0543 0.0190 28 *ADJPRED 1 . . 5601 2 . 1357 1 . 8434 0.1365 28 *MAHAL 0 .2182 15 . 7172 1 . 9286 2.8479 28 *COOK D O .OOOO 5 . 3060 0 . 2247 0.9992 28 TOTAL CASES = 28 DURBIN-WATSON TEST = 2.38276 OUTLIERS - STANDARDIZED RESIDUAL SEONUM SUBFILE *ZRESID 2 NONAME -2 .57561 20 NONAME -1 . .93982 3 NONAME 1 . .75529 23 NONAME 1 . .71903 1 NONAME 1 . 33676 22 NONAME 0. .97819 8 NONAME -0. .96630 26 NONAME 0. .94388 25 NONAME -0. .71622 1 1 NONAME -0. .69269 FILE NONAME (CREATION DATE = 02/06/84) HISTOGRAM - STANDARDIZED RESIDUAL = 1 CASES, N EXP N ( * 0 0 03 OUT 0 0 02 3 00 0 0 02 2 87 0 0 03 2 75 0 0 04 2 62 0 0 06 2 50 0 0 08 2 37 0 0 1 1 2 25 0 0 15 2 12 0 0 19 2 00 0 0 24 1 87 2 0 30 1 75 0 0 37 1 62 0 0 45 1 50 1 0 54 1 37 0 0 64 1 25 0 0 74 1 12 2 0 85 1 00 : * 0 0 95 0 87 0 1 05 0 75 3 1 15 0 62 â€¢ * 0 1 23 0 50 2 1 30 0 37 : * 1 1 35 0 25 1 1 38 0 12 3 1 40 O 00 : * 1 1 38 -0 12 2 1 35 -0 25 2 1 30 -0 37 - * 2 1 23 -0 50 : * 1 1 15 -0 62 2 1 05 -o 75 . * 0 0 95 -0 87 1 0 85 -1 00 0 0 74 -1 12 0 0 64 -1 25 0 0 54 -1 37 0 0 45 -1 50 0 0 37 -1 62 0 0 30 -1 75 0 0 24 -1 87 1 0 19 -2 00 * 0 0 15 -2 12 0 0 1 1 -2 25 0 0 08 -2 37 0 0 06 -2 50 1 0 04 -2 62 * 0 0 03 -2 75 0 0 02 -2 87 0 0 02 -3 00 0 0 03 OUT = NORMAL CURVE) CO FILE NONAME (CREATION DATE = 02/06/84) NORMAL PROBABILITY (P-P) PLOT - STANDARDIZED RESIDUAL 1 . 00 + + * * * 0 B S E . 50 R V E D . 25 25 - + . 5 FILE NONAME (CREATION DATE = 02/06/84) STANDARDIZED SCATTERPLOT ACROSS - *ZPRED DOWN - *ZRESID OUT + + + + + + + -3 + â€¢ 1 + I I -3 + OUT ++--3 SYMBOLS: MAX N 1 . : 2. 3 OUT 1971 CORRELATION LINC9 AGE L0C1 L0C2 L0C5 LOC LINC9 1 000 -0 693 0 385 0 1 17 -0 074 -0 33 AGE -0 693 1 000 -0 134 0 164 -0 199 0 12 L0C1 0 385 -0 134 1 000 -0 207 -0 139 -0 49 L0C2 0 1 17 0 164 -0 207 1 000 -0 139 -0 49 L0C5 -0 074 -0 199 -0 139 -0 139 1 000 -0 33 L0C6 -0 331 0 125 -0 496 -0 496 -0 334 1 00 FLAR 0 862 -0 613 0 219 0 089 -0 1 13 -0 27 LFAST -0 090 0 012 -o 175 0 104 0 186 -0 27 LNOST 0 464 -0 339 0 395 0 007 0 136 -0 41 LLOT 0 854 -0 666 0 027 0 172 -0 1 10 -0 07 DM2 0 040 0 100 0 093 -0 062 -0 042 0 04 DM3 0 045 -0 072 -0 120 0 216 0 032 -0 18 DM4 0 174 -0 287 0 152 -0 227 0 102 0 02 LGIM 0 173 -0 526 -0 107 -0 087 0 192 0 03 o LGIM LINC9 AGE L0C1 L0C2 L0C5 L0C6 FLAR LF AST LNOST LLOT DM2 DM3 DM4 LGIM 0. 173 -0.526 -0.107 -0.087 0. 192 0.035 0. 302 0.057 0.079 0.312 0.009 O. 178 0.007 1 .000 MULTIPLE R 0.79628 R SQUARE 0.63406 ADJUSTED R SQUARE 0.48159 STANDARD ERROR 0.12099 ANALYSIS OF VARIANCE REGRESSION RESIDUAL DF 10 24 4.15850 VARIABLES IN THE EQUATION VARIABLE B SE B BETA T SIG LINC9 -0.47565 0.11412 - 1 71090 -4 168 0 00 DM2 0.07802 0.07367 0 23077 1 059 0 30 L0C5 0.58540 0.19305 0 98946 3 032 0 00 L0C2 0.61735 0.18945 1 40481 3 259 0 00 L0C1 0.63322 0.20339 1 44092 3 1 13 0 00 DM4 0.06187 0.08531 .0 14943 0 725 0 47 AGE -0.00705 0.00161 -0 91751 -4 376 0 00 DM3 0.15525 0.07762 0 42347 2 000 0 05 FLAR 0.40504E-04 0.1110E-04 1 30687 3 649 0 00 L0C6 0.57993 0.17971 1 74431 3 227 0 00 (CONSTANT) 5.64515 0.94772 5 957 0 00 CASEWISE PLOT OF STANDARDIZED RESIDUAL -3.0 0.0 3.0 SEQNUM 0: : :0 LGIM 1 . * . . 1 .4834 2 * 1.9543 3 *. 1.8951 4 1.9643 5 . * . 1.9113 6 * 1.8254 7 * . 2.0133 8 . 1.6154 9 * I .7537 10 . 1.8656 11. * . 1.9490 12 2.2322 13 + . 1.9048 14 * 1 .9720 15 . . 1.9636 16 1 .9717 17 * . 1.9244 18 1.82719 . 1.9720 20 * . 1.7206 21 . + . 1.9438 22 * 1.8224 23 * . 1.6513 24 * 1.7217 25 . 1.8866 26 . 1.9602 27 * . 1.9113 28 . * . 1.357 1 29 * . 1.5726 30 + . 1 .7837 31.. * 1.8828 32. . . 1.92 10 33 * 1.7726 34 . 2.0330 35 * 1.9643 SEONUM 0: : :0 LGIM -3.0 0.0 3.0 (V) FILE NONAME (CREATION DATE = 02/06/84) **** MULTIPLE DEPENDENT VARIABLE . . LGIM H: $i + ^: ^ ^ rfc RESIDUALS STATISTICS: MIN MAX MEAN STD DEV N *PRED 1 . 5401 2 .0959 1 . 8544 0.1320 35 *ZPRED -2 . 38 17 1 .8300 -0. .0000 1.0000 35 *SEPRED 0 .037 1 0 . 1 189 0 .0585 0.0149 35 *ADJPRED 1 .5122 2 .0623 1 .8556 0. 1361 35 *MAHAL 2 . 3449 33 .0286 7 .7714 5 . 2737 35 *COOK D 0. .0 0. .6118 0 .0408 0.1046 35 TOTAL CASES = 35 DURBIN-WATSON TEST = 2.02195 * * * He ***** * * * + OUTLIERS - STANDARDIZED RESIDUAL SEQNUM SUBFILE *ZRESID 1 NONAME -2 . 721'33 28 NONAME -1 .53805 4 NONAME 1 . 34821 24 NONAME 1 .34102 14 NONAME 1 .32322 20 NONAME -1 .25785 26 NONAME 1 .21091 12 NONAME 1 .14536 8 NONAME - 1 .12219 13 NONAME -0. .98796 rv FILE NONAME (CREATION DATE = 02/OG/84) HISTOGRAM - STANDARDIZED RESIDUAL N EXP N ( * = 1 0 0 04 OUT 0 0 02 3 00 0 0 03 2 87 0 0 04 2 75 0 0 06 2 62 0 0 08 2 50 0 0 10 2 37 0 0 14 2 25 0 0 18 2 12 0 0 24 2 00 0 0 30 1 87 0 0 38 1 75 0 0 47 1 62 0 0 57 1 50 3 o 68 1 37 . * * 1 0 80 1 25 1 0 93 1 12 0 1 06 1 00 0 1 19 0 87 2 1 32 0 75 : * 2 1 44 0 62 : * 0 1 54 0 50 5 1 63 0 37 *â€¢*:(:* 0 1 69 0 25 1 1 73 0 12 * . 4 1 74 0 00 3 1 73 -o 12 4 1 69 -0 25 0 1 63 -0 37 2 1 54 -0 50 * : 2 1 44 -0 62 : * 0 1 32 -0 75 0 1 19 -0 87 1 1 06 -1 00 1 0 93 -1 12 1 0 80 -1 25 0 0 68 -1 37 1 0 57 -1 50 0 0 47 -1 62 0 0 38 -1 75 0 0 30 -1 87 0 0 24 -2 00 0 0 18 -2 12 0 0 14 -2 25 0 0 10 -2 37 0 0 08 -2 50 0 0 06 -2 62 1 0 04 -2 75 0 0 03 -2 87 0 0 02 -3 00 0 0 04 OUT NORMAL CURVE) FILE NONAME (CREATION DATE = 02/06/84) NORMAL PROBABILITY (P-P) PLOT - STANDARDIZED RESIDUAL 1 .00 + + * * * * * * * * * + Â± + * * . 25 FILE NONAME (CREATION DATE = 02/06/84) STANDARDIZED SCATTERPLOT ACROSS - *ZPRED DOWN - *ZRESID OUT ++ + + + + 3 + - + + + SYMBOLS: MAX N 1 . 2 . 3 . -1 -3 + OUT ++--3 - 1 1 - + + 2 3 OUT 1972 CORRELATION LINC9 AGE L0C1 L0C2 L0C5 LOC LINC9 1 000 -0 417 0 554 -0 202 -0 042 -0 24 AGE -0 417 1 000 -0 032 0 160 0 198 -o 20 L0C1 0 554 -0 032 1 000 -0 225 -0 298 -0 43 L0C2 -0 202 0 160 -o 225 1 000 -0 195 -0 28 L0C5 -0 042 0 198 -0 298 -0 195 1 000 -0 24 L0C6 -0 240 -0 200 -0 439 -0 287 -0 248 1 00 FLAR 0 885 -0 247 0 552 -0 210 -0 099 -0 20 LFAST 0 033 0 163 0 080 0 201 0 06 1 -o 24 LNOST 0 664 -0 392 0 454 -0 159 -0 239 -o 06 LLOT 0 808 -0 340 0 356 -0 142 -0 1 16 -0 02 DM2 0 175 -0 009 -0 088 0 262 0 135 -0 02 DM3 -0 200 0 009 -0 107 0 101 -0 036 0 00 DM4 -0 123 -0 003 -o 107 -0 240 -0 036 0 12 LGIM -0 076 -0 294 -0 067 0 161 -0 152 0 21 LGIM LINC9 AGE L0C1 L0C2 L0C5 L0C6 FLAR LF AST LNOST LLOT DM2 DM3 DM4 LGIM -0.076 -0.294 -0.067 0.161 -0.152 0.211 -0.043 0. 182 0. 159 -0.065 0.025 0. 192 -0.251 1 .000 MULTIPLE R 0.61843 R SQUARE 0.38245 ADJUSTED R SQUARE 0.13086 STANDARD ERROR 0.18168 ANALYSIS OF VARIANCE REGRESSION RESIDUAL DF 1 1 27 F = 1.52013 VARIABLES IN THE EQUATION VARIABLE B SE B BETA T SIG LINC9 0 007 15 0 10120 0 02585 0 071 0 94 LF AST 0 29350 0 15226 0 34930 1 928 0 06 DM4 -0 1 1 140 0 08468 -o 26061 - 1 316 0 19 DM2 -0 06060 0 10198 -0 1 1366 -0 594 0 55 L0C6 0 20394 0 10744 0 50859 1 898 0 06 AGE -0 00355 0 00154 -0 43807 -2 303 0 02 DM3 -0 02286 0 08468 -0 05348 -0 270 0 78 L0C2 0 19164 0 14265 0 33306 1 343 0 19 L0C1 0 1 3574 0 13332 0 30813 1 018 0 31 LLOT -0 16461 0 13864 -o 36300 -1 187 0 24 (CONSTANT) 1 4 1488 1 05392 1 342 0 19 CASEWISE PLOT OF STANDARDIZED RESIDUAL -3.0 0.0 3.0 SEQNUM 0: : 0 LGIM 1 * 2.5268 2 1.9476 3 * . 1 .8058 4 1.9210 5 .* . 2.0055 6 + . .1.9057 * . 1.5619 IV) 8 9 10 1 1 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 SEQNUM 0 : . . -3.0 0.0 . . : 0 3.0 2.0381 1.9000 1 .8943 2.0730 2.2933 2 . 0104 1.9119 1.8271 1.9803 1.9699 1.9238 1.9866 1 .792 1 1.7722 2.1669 1.7615 1.9622 1.8933 2.0254 2.0456 1.6797 1.9048 2.0090 1.5968 1.9633 1.9622 1.8874 1.3156 1.9360 2.0480 1.9199 LGIM FILE NONAME (CREATION DATE = 02/06/84) CASEWISE PLOT OF STANDARDIZED RESIDUAL SEQNUM 39 SEQNUM -3.0 0 : . . 0 : . . -3.0 0.0 0.0 3.0 . . : 0 . . : 0 3.0 LGIM 2.0259 LGIM RESIDUALS STATISTICS: MIN MAX MEAN STD DEV N *PRED 1 . 6704 2 .1117 1 . 9269 0.1019 39 *ZPRED -2 .5185 1 .8145 -0 .0000 1.0000 39 *SEPRED 0 .0351 0. .1040 0 .0610 0.0156 39 *ADJPRED I . 7205 2 . .0867 1 . 9277 0.1017 39 *MAHAL 0 . 5406 12 . . 36 1 1 3 . . 8974 2.5565 39 *C00K D 0 .0001 0. 6800 0 .0499 0.1332 39 TOTAL CASES 39 DURBIN-WATSON TEST = 1 .7337 1 \0 FILE NONAME (CREATION DATE = 02/06/84) OUTLIERS - STANDARDIZED RESIDUAL SEQNUM SUBFILE *ZRESID 1 NONAME 3 .26051 35 NONAME -2 .02022 28 NONAME . - 1 .44804 1 1 NONAME 1 .40058 31 NONAME - 1 .29031 30 NONAME 1 .27666 21 NONAME - 1 .20674 7 NONAME - 1 .20032 27 NONAME 1 .17467 12 NONAME 1 .03389 FILE NONAME (CREATION DATE = 02/06/84) HISTOGRAM - STANDARDIZED RESIDUAL N EXP N ( * 1 0 04 OUT t 0 0 02 3 00 0 0 03 2 87 0 0 04 2 75 0 0 06 2 62 0 0 09 2 50 0 0 12 2 37 0 0 16 .2 25 0 0 20 2 12 0 0 26 2 00 0 0 34 1 87 0 0 42 1 75 0 0 52 1 62 0 0 63 1 50 1 0 76 1 37 1 0 89 1 25 1 1 03 1 12 1 1 18 1 00 2 1 33 0 87 0 1 47 0 75 3 1 60 0 62 0 1 72 0 50 1 1 81 0 37 * 5 1 88 0 25 1 1 93 0 12 * 3 1 94 0 00 2 1 93 -0 12 4 1 88 -0 25 * 1 1 81 -0 37 2 1 72 -0 50 * 2 1 60 -0 62 1 1 47 -0 75 2 1 33 -o 87 0 1 18 -1 00 0 1 03 -1 12 3 0 89 -1 25 0 0 76 -1 37 1 0 63 -1 50 0 0 52 -1 62 0 0 42 -1 75 0 0 34 -1 87 1 0 26 -2 00 * 0 0 20 -2 12 0 0 16 -2 25 0 0 12 -2 37 0 0 09 -2 50 0 0 06 -2 62 0 0 04 -2 75 0 0 03 -2 87 0 0 02 -3 00 0 0 04 OUT NORMAL CURVE) FILE NONAME (CREATION DATE = 02/06/84) NORMAL PROBABILITY (P-P) PLOT - STANDARDIZED RESIDUAL 1 . 00 + + * * A * + * !^ .25 .FILE NONAME (CREATION DATE = 02/06/84) STANDARDIZED SCATTERPLOT ACROSS - *ZPRED OUT + + + + -3 + DOWN - *ZRESID SYMBOLS: MAX N -3 + OUT ++--3 - - + -- 1 -++ 3 OUT 1973 CORRELATION LINC9 AGE L0C1 L0C2 L0C5 LOC LINC9 1 000 -0 488 0 668 -0 153 -0 060 -0 36 AGE -0 488 1 000 -0 41 1 0 185 0 185 0 27 L0C1 0 668 -0 411 1 000 -0 189 -0 189 -o 58 L0C2 -0 153 0 185 -0 189 1 000 -0 098 -0 30 L0C5 -0 060 0 185 -0 189 -0 098 1 000 0 07 L0C6 -0 369 0 271 -0 584 -o 302 0 074 1 00 FLAR 0 757 -0 418 0 422 -0 120 -0 072 -0 34 LF AST 0 131 0 000 -0 039 0 087 0 100 0 07 LNOST 0 610 -0 387 0 253 0 001 -0 070 -0 17 LLOT 0 213 -0 245 0 229 0 064 -0 444 -0 29 DM2 0 078 -0 005 0 077 0 142 -0 01 1 -0 06 DM3 0 062 -0 101 -0 070 -0 036 -0 181 -o 06 DM4 0 099 -o 007 0 049 0 124 -0 024 -0 02 LGIM 0 073 -0 475 0 144 0 180 -0 063 -0 28 LINC9 LGIM 0.073 AGE LOOM L0C2 L0C5 L0C6 FLAR LF AST LNOST LLOT DM2 DM3 DM4 LGIM -0;. 475 0. 144 0. 180 -0.063 -0.289 0. 201 -0.062 O. 225 0. 222 0.003 -0.093 0. 103 1 .000 MULTIPLE R 0.66608 R SQUARE 0.44367 ADJUSTED R SQUARE 0.32004 STANDARD ERROR O.20867 ANALYSIS OF VARIANCE REGRESSION RESIDUAL DF 10 45 F = 3.58866 VARIABLES IN THE EQUATION VARIABLE B SE B BETA T SIG LINC9 -0 25185 0 09094 -0 64432 -2 769 0 00 L0C5 0 1 1855 0 1 1420 0 13480 1 038 0 30 DM2 -0 00179 0 08536 -0 00293 -0 02 1 0 98 L0C2 .0 22997 0 10554 0 26149 2 179 0 03 DM3 -0 097 14 0 08 158 -0 16773 - 1 191 0 24 LLOT 0 02975 0 02600 0 14790 1 144 0 25 AGE -0 00652 0 00147 -0 58927 -4 440 0 00 DM4 0 06197 0 08534 0 10434 0 726 0 47 L0C1 0 09702 0 09129 0 17133 1 063 0 29 FLAR 0.11436E-04 0.4987E-05 0 43875 2 293 0 02 (CONSTANT) 4 18512 0 88906 4 707 0 00 CASEWISE PLOT OF STANDARDIZED RESIDUAL -3.0 0.0 3.0 SEQNUM 0 : 0 LGIM 1 * 2.1801 2 2.1014 3 . 2.2015 4 .* .1.8881 5 * 1.7896 6 . . 1 .6916 iâ€”* 7 * . 1.9663 8 1.9285 9 1 .8540 10 .* . 2.0608 11 * 1.8279 12 * 2.14613 * 1.9671 14 . 1.7979 15 *. 1.9386 16 .* . 1.7792 17 * . 1.8743 18. . * 2.0609 19 . * 2.1826 20 * . 2.0777 2 1 1.8669 22 * . 1.93223 1.8934 24 1.8658 25 . 1.3016 26 * . 2.1292 27 1.53028 . 2.0501 29 *. . 1.7042 30 . 2.0577 31 2.0023 32 * 1.8690 33 . * 2.01934 * 1.4022 35 1.1128 36 . 1.7336 37 *. 1.6941 38 .* 1.9798 SEONUM 0: :0 LGIM -3.0 0.0 3.0 FILE NONAME (CREATION DATE = 02/06/84) CASEWISE PLOT OF STANDARDIZED RESIDUAL FILE NONAME (CREATION DATE = 02/06/84) * * * * MULTIPLE DEPENDENT VARIABLE. LGIM RESIDUALS STATISTICS: MIN MAX MEAN STD DEV N *PRED 1 .5744 2 . . 2872 1 .8767 0. 1603 56 *ZPRED - 1 .8849 2 . . 5604 -0 .0000 1 . 0000 56 *SEPRED 0. .0370 0. . 1268 0 .0633 0. 0229 56 *ADJPRED 1 . . 4902 2 . . 3288 1 .8770 0. 1643 56 *MAHAL 0. . 801 1 20. .0048 4 .9107 4 . 6780 56 *COOK D 0. .0000 0. .3179 0 .0244 0. 0575 56 TOTAL CASES = 56 DURBIN-WATSON TEST = 2.01126 OUTLIERS STANDARDIZED RESIDUAL SEQNUM SUBFILE ,:ZRESID 45 NONAME -3 .32209 26 NONAME 2 .70164 35 NONAME -2 .29126 25 NONAME - 1 .84541 14 NONAME - 1 .43436 40 NONAME 1 .35646 6 NONAME - 1 . 34934 46 NONAME -1 .28536 3 NONAME 1 .24258 28 NONAME 1 .07308 FILE NONAME (CREATION DATE = 02/06/84) HISTOGRAM - STANDARDIZED RESIDUAL N EXP N ( * = 1 CASES 0 0 06 OUT 0 0 03 3 .00 0 0 04 2 . 87 1 0 06 2 . 75 * 0 0 09 2 . 62 0 0 12 2 . 50 0 0 17 2 . 37 0 0 22 2 . 25 0 o 29 2.12 0 0 38 2 .00 0 0 48 1 . 87 o 0 60 1 . 75 0 0 75 1 . 62 o 0 91 1 . 50 1 1 09 1 . 37 1 1 28 1 . 25 1 1 48 1.12 2 1 69 1 .00 1 â€¢1 90 0. 87 * 4 2 1 1 0. 75 4 2 30 0. 62 1 2 46 0.50 * 6 2 60 0.37 5 2 7 1 0. 25 4 2 77 0.12 4 2 79 0.00 **:* 2 2 77 -0.12 3 2 71 -0. 25 1 2 60 -0. 37 * 4 2 46 -0. 50 0 2 30 -0.62 3 2 1 1 -0. 75 1 1 90 -0.87 * . 0 1 69 -1 .00 1 1 48 -1.12 1 1 28 - 1 . 25 2 1 09 - 1 . 37 0 0 91 - 1 . 50 0 0 75 - 1 . 62 0 0 60 -1 . 75 1 0 48 -1 .87 0 0 38 -2.00 0 0 29 -2.12 1 0 22 -2 . 25 * 0 0 17 -2 . 37 0 0 12 -2.50 0 0 09 -2 . 62 0 0 06 -2 . 75 0 0 04 -2 . 87 0 0 03 -3.00 1 0 06 OUT * NORMAL CURVE) CO FILE NONAME (CREATION DATE = 02/06/84) NORMAL PROBABILITY (P-P) PLOT - STANDARDIZED RESIDUAL 1 .00 + + * * :)". * # # 25 5 FILE NONAME (CREATION DATE = 02/06/84) STANDARDIZED SCATTERPLOT ACROSS - *ZPRED DOWN - *ZRESID OUT ++ + + + + 3 + -1 -3 + OUT ++--3 â€¢ - + -2 - + + + SYMBOLS: MAX N 1 . : 2. * 3. - 1 _ + -i + -0 1 2 + - + + 3 OUT 1974 CORRELATION LINC9 AGE L0C1 L0C2 L0C5 LOC LINC9 1 000 -0 435 0 028 -0 166 -0 234 0 27 AGE -0 435 1 000 -0 034 -0 145 0 123 -0 02 L0C1 0 028 -0 034 1 000 -0 107 -0 160 -0 36 L0C2 -0 166 -0 145 -0 107 1 000 -0 160 -0 36 L0C5 -o 234 0 123 -0 160 -0 160 1 000 -0 54 L0C6 0 277 -0 029 -0 361 -0 361 -0 540 1 00 FLAR 0 906 -0 437 -0 034 -0 202 -0 219 0 34 LFAST -0 275 -0 272 -0 018 0 013 0 262 -o 26 LNOST O 461 -0 446 -0 082 -0 032 -0 438 0 35 LLOT O 760 -0 713 -0 040 -0 1 16 -0 162 0 23 DM2 0 108 -0 107 0 008 -0 226 -0 338 0 34 DM3 -o 1 17 -0 015 -0 107 0 262 0 392 -0 36 DM4 -0 063 -0 008 0 153 0 153 0 007 -o 30 LGIM -0 21 1 -0 541 0 204 0 231 0 063 -o 33 o LGIM LINC9 AGE L0C1 L0C2 L0C5 L0C6 FLAR LFAST LNOST LLOT DM2 DM3 DM4 LGIM -0.211 -0.541 0. 204 0.231 0.063 -0.336 -0.076 O. 552 -0.038 O. 200 -0.016 0. 100 -0.040 1 .000 MULTIPLE R 0.84246 R SQUARE 0.70975 ADJUSTED R SQUARE 0.58535 STANDARD ERROR 0.14058 ANALYSIS OF VARIANCE REGRESSION RESIDUAL DF 9 21 5.70563 VARIABLES IN THE EQUATION VARIABLE B SE B BETA T SIG LINC9 -0 13743 0 05920 -0 35143 -2 32 1 0 03 DM2 -0 C4216 0 06254 -0 09177 -0 674 0 50 DM3 -0 08483 0 10169 -0 1 1678 -0 834 0 41 LFAST 0 19599 0 08475 0 34261 2 313 0 03 DM4 -0 18039 0 08326 -0 30894 -2 167 0 04 L0C5 -0 10506 0 09146 -o 19328 - 1 149 0 26 AGE -0 00569 0 00143 -0 59829 -3 989 0 00 L0C6 -0 14989 0 0831 1 -0 34733 - 1 803 0 08 (CONSTANT) 2 43881 0 977 16 2 496 0 02 CASEWISE PLOT OF STANDARDIZED RESIDUAL -3.0 0.0 3.0 SEQNUM 0: :0 LGIM 1 * 2.2154 2 . 2.0522 3 . 2.1143 4 . * 1.9816 5 * 2.1957 6 2.0280 7 . * 1.9432 8 * . 1.8309 . * 2 2405 10 * 1 9566 1 1 2 1337 12 1 8681 13 * 2 0610 14 * 1 8704 15 * 2 0129 16 * 1 7265 17 2 3657 18 2 061 1 19 * 1 5293 20 * 2 1876 21 1 591 1 22 * 2 0693 23 * 2 2247 24 * 1 9100 25 * 1 7373 26 2 1317 27 2 0157 28 * 1 4474 29 . * 2 1273 30 2 1 107 31 2 2458 SEONUM 0 : . . . â€¢ 0 LGIM -3.0 0.0 3.0 FILE NONAME (CREATION DATE DEPENDENT VARIABLE.. LGIM = 02/06/84) * * * * MULTI RESIDUALS STATISTICS: MIN MAX MEAN STD DEV N * P R E D 1.5295 2.2355 1.9995 0.1672 31 *ZPRED -2.8113 1.4116 -0.0000 1.0000 31 *SEPRED 0.0318 0.0926 0.0505 0.0170 31 *ADJPRED 1.4898 2.2778 2.0010 0.1672 31 *MAHAL 0.4198 10.7847 2.9032 2.8034 31 *COOK D 0.0000 0.2666 0.0370 0.0554 31 TOTAL CASES = 31 DURBIN-WATSON TEST = 1.51312 $L ft & OUTLIERS - STANDARDIZED RESIDUAL SEONUM SUBFILE *ZRESID 23 NONAME 1.86060 17 NONAME 1.79273 19 NONAME -1.78 101 14 NONAME -1.76555 15 NONAME -1.50444 12 NONAME -1.43084 22 NONAME 1.27155 28 NONAME -1.07586 6 NONAME 1.03803 16 NONAME -1.03069 3 L E FILE NONAME (CREATION DATE = 02/06/84) HISTOGRAM - STANDARDIZED RESIDUAL N EXP N ( * 0 0 03 OUT 0 0 02 3 00 0 0 02 2 87 0 0 04 2 75 0 0 05 2 62 0 0 07 2 50 0 0 09 2 37 0 0 12 2 25 0 0 16 2 12 0 0 21 2 00 1 0 27 1 87 * 1 0 33 1 75 * 0 0 41 1 62 0 0 50 1 50 . 0 0 60 1 37 . 1 0 7 1 1 25 : 0 0 82 1 12 . 1 0 94 1 00 : 0 1 05 0 87 . 4 1 17 0 75 : * 0 1 27 0 62 . 1 1 36 0 50 : 3 1 44 0 37 : * 4 1 50 0 25 : * 0 1 53 0 12 . 2 1 54 0 00 * : 2 1 53 -0 12 * : 1 1 50 -0 25 : 1 1 44 -0 37 : 1 1 36 -0 50 : 1 27 -0 62 . 1 1 17 -0 75 : 1 1 05 -0 87 : 1 0 94 -1 00 : 1 0 82 -1 12 : 0 7 1 -1 25 . 1 0 60 -1 37 : 1 0 50 -1 50 : 0 0 41 -1 62 2 0 33 -1 75 ** 0 0 27 -1 87 0 0 21 -2 00 0 0 16 -2 12 0 0 12 -2 25 O 0 09 -2 37 0 0 07 -2 50 0 0 05 -2 62 0 0 04 -2 75 0 0 02 -2 87 0 0 02 -3 00 0 0 03 OUT NORMAL CURVE) FILE NONAME (CREATION DATE = 02/06/84) NORMAL PROBABILITY (P-P) PLOT - STANDARDIZED RESIDUAL 1 .00 + + ******** ******* + * * 25 .5 FILE NONAME (CREATION DATE = 02/06/84) STANDARDIZED SCATTERPLOT ACROSS - *ZPRED DOWN OUT ++ + + + -3 + - 1 -3 + OUT ++--3 â€¢ZRESID â€”i + _ - + + + SYMBOLS: MAX N + -0 -- + + -1 2 3 OUT 1 . 2 . 1975 CORRELATION LINC9 AGE L0C1 L0C2 L0C5 LOC LINC9 1 000 -0 236 0 247 -0 204 -0 34 1 -0 00 AGE -0 236 1 000 0 271 0 129 -0 009 -0 35 L0C1 0 247 0 27 1 1 000 -0 197 -0 327 -0 54 L0C2 -0 204 0 129 -0 197 1 000 -0 104 -0 17 L0C5 -0 34 1 -0 009 -0 327 -0 104 1 000 -0 1 1 L0C6 -o 003 -0 356 -0 544 -0 173 -0 1 10 1 00 FLAR 0 765 0 087 0 188 -0 162 -0 220 0 01 LFAST -0 070 0 138 0 006 0 024 0 260 -0 20 LNOST 0 524 0 224 0 195 -0 1 1 1 -0 039 -0 14 LLOT 0 775 -0 417 -0 058 -0 130 -o 220 0 20 DM2 -0 208 0 48 1 -0 109 0 1 13 -0 086 -0 03 DM3 0 046 -0 360 -0 370 0 061 0 015 0 23 DM4 0 167 -0 102 0 430 -0 1 16 -0 192 -0 15 LGIM -o 501 -0 330 -0 141 0 312 0 228 0 01 LGIM LINC9 AGE L0C1 L0C2 L0C5 L0C6 FLAR LFAST LNOST LLOT DM2 DM3 DM4 LGIM . 501 . 330 141 .312 . 228 .018 . 366 . 227 -0.411 -0.139 -0.266 0. 222 .045 .000 -O. -0. -0. 0. O. O. -0. 0. 0. 1 10. FLAR MULTIPLE R 0.87239 R SQUARE 0.76106 ADJUSTED R SQUARE 0.65717 STANDARD ERROR 0.10302 ANALYSIS OF VARIANCE REGRESSION RESIDUAL DF 10 23 7.32587 VARIABLE VARIABLES IN THE EQUATION --B SE B BETA SIG LINC9 -0.37152 0.06511 - 1 . . 38737 -5 . 706 0. .00 DM3 0.00731 0.06512 0. 02049 0 .112 0. .91 L0C2 0. 25810 0.08147 0. 35036 3 . 168 0. .00 L0C5 0.06690 0.06308 0. . 13669 1 .061 0. . 29 DM4 0.05590 0.06638 0. 12293 0 .842 0. .40 AGE -0.00446 0.00118 -0. 58933 -3 . 762 0. 00 L0C1 0.13007 0.05384 0. 36467 2 .4 16 0. 02 DM2 -0.02016 0.06824 -0. 05299 -0. . 295 0. 77 LLOT 0.18458 0.06950 0. 49403 2 .656 0. 01 FLAR 0.88627E-05 0.3688E-05 0. 47139 2 . 403 0. 02 (CONSTANT) 4.19436 0.63355 6 .620 0. 00 CASEWISE PLOT OF STANDARDIZED RESIDUAL SEQNUM 1 2 3 4 -3.0 0 : . . 0.0 3.0 . . : 0 LGIM 2.4785 2.1502 2.1263 1.7989 ^3 5 * 2 .1738 6 1.9842 7 . * . 1.7558 8 * . 1.9280 9 * . 1.9925 10 2.0101 11 . * 2.3183 12 + 1.98213 *. 1.9907 14 + . 1.9171 15 * . 2.2085 16 . * 2.2314 17 . 2.0329 18 * 2.14419 1.88120 . * 2. 1331 2 1. * . 2.1320 22 * . 2.1594 23 1.9308 24 * 1.9880 25 .* . 2.0267 26 2.4065 27 * . 2.1660 28 2.094 1 29 2.1308 30 * 1.9891 31 . 1.6068 32 * 2.0675 33 . * . 2.2595 34 2.1742 SEONUM 0 : 0 LGIM -3.0 0.0 3.0 FILE NONAME (CREATION DATE DEPENDENT VARIABLE . . LGIM = 02/06/84) * * * * MULTIPLE RESIDUALS STATISTICS: MIN MAX MEAN STD DEV N *PRED 1.6656 2.3677 2.0697 0.1504 34 *ZPRED -2.687 1 1.9812 -0.0000 1.0000 34 *SEPRED 0.0268 0.0821 0.0434 0.0149 34 *ADUPRED 1.7337 2.4074 2.0691 0.1487 34 *MAHAL 1.3624 20.8647 5.8235 5.1259 34 *C00K D 0.0000 0.6438 0.0744 0.1474 34 TOTAL CASES = 34 DURBIN-WATSON TEST = 2.04040 * * + * * * + * * * + * * OUTLIERS - STANDARDIZED RESIDUAL SEONUM SUBFILE *ZRESID 30 NONAME -1.75639 26 NONAME 1.70428 22 NONAME -1.65217 7 NONAME -1.567911 NONAME 1.37354 6 NONAME 1.30992 18 NONAME 1.2 1125 28 NONAME -1.09741 1 NONAME 1.097419 NONAME - 1 .02437 FILE NONAME (CREATION DATE = 02/06/84) HISTOGRAM - STANDARDIZED RESIDUAL N EXP N ( * 0 0 04 OUT 0 O 02 3 00 0 0 03 2 87 0 0 04 2 75 0 0 05 2 62 0 0 07 2 50 0 0 10 2 37 0 0 14 2 25 0 0 18 2 12 0 0 23 2 00 0 0 29 1 87 1 0 37 1 75 * 0 0 45 1 62 0 0 55 1 50 . 1 0 66 1 37 : 2 0 78 1 25 : * 1 0 90 1 12 : 0 1 03 1 00 . 5 1 16 0 87 : * 0 1 28 0 75 . 0 1 39 0 62 . 0 1 50 0 50 . 1 1 58 0 37 * . 3 1 64 0 25 * : 1 1 68 0 12 * . 5 1 69 0 00 * : 0 1 68 -0 12 1 1 64 -0 25 * . 2 1 58 -0 37 * : 0 1 50 -0 50 . 4 1 39 -0 62 : * 1 1 28 -o 75 : 1 1 16 -0 87 : 1 1 03 -1 00 : 1 0 90 -1 12 : O 0 78 -1 25 . 0 0 66 -1 37 . 0 0 55 -1 50 . 2 0 45 -1 62 ** 1 0 37 -1 75 * 0 0 29 -1 87 0 0 23 -2 00 0 0 18 -2 12 0 0 14 -2 25 0 0 10 -2 37 0 0 07 -2 50 0 0 05 -2 62 0 0 04 -2 75 0 0 03 -2 87 0 0 02 -3 00 0 0 04 OUT NORMAL CURVE) O FILE NONAME (CREATION pATE = 02/06/84) NORMAL PROBABILITY (P-P) PLOT - STANDARDIZED RESIDUAL 1 .00 + + ***** * 25 5 FILE NONAME (CREATION DATE = 02/06/84) STANDARDIZED SCATTERPLOT ACROSS -OUT ++---3 + "ZPRED -- + + --3 + OUT ++----3 DOWN - *ZRESID + + SYMBOLS: MAX N 1 . : 2 . 3 OUT 1976 CORRELATION LINC9 AGE L0C1 L0C2 L0C5 LOC LINC9 1 000 -0 34 1 0 491 -0 148 0 038 -0 44 AGE -0 34 1 1 000 -0 141 -0 246 0 204 0 30 L0C1 0 491 -0 141 1 000 -0 145 -0 24 1 -0 56 L0C2 -0 148 -0 246 -0 145 1 000 -0 094 -0 22 L0C5 0 038 0 204 -0 241 -0 094 1 000 -0 20 L0C6 -o 449 0 304 -0 561 -0 220 -0 206 1 00 FLAR 0 831 -0 258 0 408 -0 169 -0 1 18 -0 43 LF AST 0 173 -0 181 0 118 -0 121 0 084 -0 41 LNOST O 548 -0 235 0 379 -0 044 -0 265 -0 06 LLOT O 798 -0 625 0 282 -0 085 -0 09 1 -0 36 DM2 0 204 -0 226 0 228 0 090 0 064 -0 29 DM3 -0 221 0 331 0 062 -0 105 -0 174 0 18 DM4 0 044 0 187 -0 061 -0 136 0 144 -o 01 LGIM -0 1 17 -0 458 0 139 0 260 -0 058 -0 35 LGIM LINC9 -0.117 AGE -0.458 L0C1 0.139 L0C2 0.260 L0C5 -0.058 L0C6 -0.350 FLAR 0.064 LFAST 0.342 LNOST 0.017 LLOT 0.196 DM2 0.197 DM3 0.021 DM4 -0.402 LGIM 1.000 MULTIPLE R 0.75187 R SQUARE 0.56530 ADJUSTED R SQUARE 0.46038 STANDARD ERROR 0.14574 ANALYSIS OF VARIANCE REGRESSION RESIDUAL DF 7 29 F = 5 . 38760 VARIABLES IN THE EQUATION VARIABLE B SE B BETA T SIG LINC9 -0.22773 0.07250 -0 75092 -3 14 1 0 00 DM4 -0.13210 0.07 127 -0 28960 -1 853 0 07 DM3 0.00329 0.08298 0 00619 0 040 0 96 L0C6 -0.15920 0.05696 -0 4054 1 -2 795 0 00 AGE -0.00370 0.00119 -o 45198 -3 1 13 0 00 DM2 -0.02619 0.06550 -0 06265 -0 400 0 69 FLAR 0.81283E-05 0.4828E-05 0 39095 1 684 0 10 (CONSTANT) 4.47714 0.71372 6 273 0 00 CASEWISE PLOT OF STANDARDIZED RESIDUAL -3.0 0.0 3.0 SEQNUM 0: : : 0 LGIM 1 *. . â€¢ 2. 1754 2 2.1057 3 * . 1.9478 4 1.9276 5 * . 1.9409 6 2.0645 7 * 2.0398 9 10 1 1 12 13 14 15 16 17 18 19 20 2 1 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 SEONUM 0 : . . -3.0 0.0 . . :0 3.0 2.1381 1.9774 2 . 2389 2.1036 2.2439 1.6596 1.8933 2.0250 1 . 8644 2 . 1789 1 .8650 1.9122 2 . 2182 1 . 7254 2.057 1 1 .7203 1 .4325 1 .7948 2.1211 1 .9382 2.1029 1.9438 2.1124 2.1519 2.0660 2.0364 1.4161 2.0097 2.0885 2.1594 LGIM FILE NONAME ' (CREATION DATE = 02/08/84) **** MULTIPLE DEPENDENT VARIABLE.. LGIM ft ft ft ft ft ft ft ft ft ft ft ft RESIDUALS STATISTICS: MIN MAX MEAN STD DEV N *PRED 1 . .6000 2 . . 2284 1 .9837 0. 1487 37 *ZPRED -2 . .5791 1 . .6454 -0. .0000 1 . 0000 37 *SEPRED 0. .0376 0. .0939 0. .0558 0. 01 18 37 *ADJPRED 1 . .6521 2 . 2529 1 .9835 0. 1530 37 *MAHA L 1 . . 57 24 14 .8981 4 .8649 2 . 6374 37 *COOK D 0. OOCO 0. . 1736 0 .0408 0. 0534 37 TOTAL CASES = 37 DURBIN-WATSON TEST = 1.80195 ft ft ft. ft ft ft ft ft ft ft ft ft ft OUTLIERS - STANDARDIZED RESIDUAL SEONUM SUBFILE *ZRESID 24 NONAME -2 . 19362 13 NONAME - 1 .67919 12 NONAME 1 .50417 31 NONAME 1 .41750 2 NONAME 1 . 37331 33 NONAME 1 .32154 34 NONAME - 1 .30015 7 NONAME - 1 .27995 1 1 NONAME 1 .24864 23 NONAME - 1 .17994 FILE NONAME (CREATION DATE = 02/08/84) HISTOGRAM - STANDARDIZED RESIDUAL N EXP N ( 0 0 04 OUT 0 0 02 3 00 0 0 03 2 87 0 0 04 2 75 0 0 06 2 62 0 0 08 2 50 0 0 1 1 2 37 0 0 15 2 25 0 0 19 2 12 0 0 25 2 00 0 0 32 1 87 0 0 40 1 75 0 0 49 1 62 1 0 60 1 50 3 0 72 1 37 1 0 85 1 25 2 0 98 1 12 0 1 12 1 00 2 1 26 0 87 0 1 39 0 75 2 1 52 0 62 1 1 63 0 50 1 1 72 0 37 1 1 79 0 25 * 1 1 83 0 12 5 1 84 0 00 * 2 1 83 -0 12 2 1 79 -0 25 0 1 72 -0 37 3 1 63 -0 50 * 2 1 52 -0 62 * 1 1 39 -0 75 2 1 26 -0 87 0 1 12 -1 00 1 0 98 -1 12 2 0 85 -1 25 0 0 72 -1 37 0 0 60 -1 50 1 0 49 -1 62 * 0 0 40 -1 75 0 0 32 -1 87 0 0 25 -2 00 0 0 19 -2 12 1 0 15 -2 25 + 0 0 1 1 -2 37 0 0 08 -2 50 0 0 06 -2 62 o 0 04 -2 75 0 0 03 -2 87 0 0 02 -3 00 0 0 04 OUT NORMAL CURVE) Os FILE NONAME (CREATION DATE = 02/08/84) NORMAL PROBABILITY (P-P) PLOT - STANDARDIZED RESIDUAL 1 .00 + + * ft. ft ft ft ft ft ft ft ft ft ft ft . 25 FILE NONAME (CREATION DATE = 02/08/84) STANDARDIZED SCATTERPLOT ACROSS - *ZPRED . OUT ++ + + -3 + -2 -3 + OUT + + --3 -- + -- 1 DOWN - *ZRESID + SYMBOLS: -++ 3 OUT MAX N 1977 CORRELATION LINC9 AGE L0C1 L0C2 L0C5 LOC LINC9 1 OOO -0 358 0 499 -0 1 15 -0 109 -0 28 AGE -0 358 1 000 -0 187 -0 022 0 149 0 30 L0C1 0 499 -0 187 1 000 -0 257 -0 305 -0 39 L0C2 -0 1 15 -0 022 -0 257 1 000 -0 187 -0 24 L0C5 -0 109 0 149 -0 305 -0 187 1 000 -0 02 L0C6 -0 285 0 307 -0 397 -0 243 -0 024 1 00 FLAR 0 891 -0 242 0 429 -0 200 -0 132 -0 27 LFAST -0 094 -0 137 -0 018 -0 017 0 155 -0 38 LNOST 0 G58 -0 292 0 360 -0 088 -0 098 -0 12 LLOT 0 700 -0 44 1 0 024 0 045 -0 046 -0 17 DM2 0 OOS 0 229 0 051 0 054 -0 024 -0 03 DM3 0 025 0 185 0 017 -0 1 12 0 082 0 16 DM4 -0 073 -0 236 -0 173 0 054 -0 024 -0 14 LGIM -0 185 -0 399 0 074 0 154 0 076 -0 37 LGIM LINC9 -0.185 AGE -0.399 L0C1 0.074 L0C2 0.154 L0C5 0.076 L0C6 -0.371 FLAR -0.158 LFAST 0.309 LNOST -0.109 LLOT 0.012 DM2 -0.128 DM3 -0.019 DM4 -0.116 LGIM 1.000 MULTIPLE R 0.76927 R SQUARE 0.59178 ADJUSTED R SQUARE 0.46807 STANDARD ERROR 0.12720 ANALYSIS OF VARIANCE REGRESSION RESIDUAL DF 10 33 F = 4 . 78382 VARIABLES IN THE EQUATION VARIABLE B SE B BETA T SIG LINC9 -0.28105 0 08095 - 1 02887 -3 472 0 00 DM2 -0.12906 0 06572 -0 33339 -1 964 0 05 L0C5 0.08384 0 06 175 0 18756 1 358 0 18 L0C2 0.08085 0 07436 0 16093 1 087 0 28 DM4 -0.21147 0 06535 -0 54626 -3 236 0 00 L0C6 -0.11286 0 06061 -0 29154 - 1 862 0 07 AGE -0.00502 0 00127 -0 55034 -3 967 0 00 DM3 -0.08481 0 06421 -0 22443 - 1 321 0 19 L0C1 0.05914 0 06613 0 15649 0 894 0 37 FLAR 0.11862E-04 0.607 1E-05 0 55324 1 954 0 05 (CONSTANT) 5.06615 0 79465 6 375 0 00 CASEWISE PLOT OF STANDARDIZED RESIDUAL -3.0 0.0 3.0 SEQNUM 0: : 0 LGIM 1 *. . 2.0558 2 . * 2.1847 3 * . 1.9060 4 2. 1238 5 2.2795 6 * 2.0817 G)(?i\r>cviD&0<X)^ca(>>*-o>^~coOci[nincnw^a)Tttr>^tT-Fir>oc!)<3 Om^Ocococnooo-^cnt^oajcrjOr^cNra^-^^cnro-^cTicO'^'^oo)-! l_J CJ o o o m '-'-'-'--^'-'-'-^cNtMCMPioiRKN^MMnnonnnconnD Z o LU l/J FILE NONAME (CREATION DATE = 02/06/84) CASEWISE PLOT OF STANDARDIZED RESIDUAL SEQNUM 39 40 4 1 42 43 44 SEQNUM LGIM 1 .9728 2.0952 1.8040 1.9063 1.9403 2.0849 LGIM RESIDUALS STATISTICS: MIN MAX MEAN STD DEV N *PRED 1 6364 2 2023 2 0046 0. 1234 44 *ZPRED -2 9842 1 6021 -0 0000 1 . 0000 44 *SEPRED 0 0267 0 0705 0 0423 0. 0108 44 *ADJPRED 1 6225 2 1943 2 0047 0 1231 44 +MAHAL 0 8592 1 1 78 19 3 9091 2 . 5115 44 *COOK D 0 0000 0 5879 0 0357 0. 0934 44 TOTAL CASES 44 DURBIN-WATSON TEST 2.02370 ON FILE NONAME (CREATION DATE = 02/06/84) OUTLIERS - STANDARDIZED RESIDUAL SEQNUM SUBFILE *ZRESID 36 NONAME 2 .52101 33 NONAME -2 .21352 34 NONAME - 1 .79239 24 NONAME - 1 .68049 40 NONAME 1 .67215 19 NONAME - 1 .63291 32 NONAME 1 .41938 31 NONAME 1 .36120 25 NONAME 1 .13806 3 NONAME - 1 .03646 FILE NONAME (CREATION DATE = 02/06/84) HISTOGRAM N EXP N ( * 0 0 05 OUT 0 0 02 3 00 0 0 04 2 87 0 0 05 2 75 0 0 07 2 62 1 0 10 2 50 0 0 13 2 37 0 0 18 2 25 o 0 23 2 12 0 0 30 2 00 0 0 38 1 87 0 0 48 1 75 1 0 59 1 62 0 0 71 1 50 2 0 85 1 37 0 1 00 1 25 1 1 17 1 12 1 1 33 1 00 1 1 50 0 87 0 1 66 0 75 6 1 80 0 62 4 1 94 0 50 * 1 2 04 0 37 * 1 2 13 0 25 2 2 18 0 12 * 3 2 19 0 00 * 1 2 18 -0 12 * 3 2 13 -0 25 1 2 04 -0 37 * 3 1 94 -0 50 * 3 1 80 -o 62 * 2 1 66 -0 75 * 2 1 50 -0 87 1 1 33 -1 00 0 1 17 -1 12 0 1 00 -1 25 0 0 85 -1 37 0 0 71 -1 50 2 0 59 -1 62 1 0 48 -1 75 0 0 38 -1 87 0 0 30 -2 00 0 0 23 -2 12 1 0 18 -2 25 * 0 0 13 -2 37 0 0 10 -2 50 0 0 07 -2 62 0 0 05 -2 75 0 0 04 -2 87 0 0 02 -3 00 0 0 05 OUT STANDARDIZED RESIDUAL * = 1 CASES, = NORMAL CURVE) ON FILE NONAME (CREATION DATE = 02/06/84) NORMAL PROBABILITY (P-P) PLOT - STANDARDIZED RESIDUAL 1 .00 + + * * * * * * + 25 5 FILE NONAME (CREATION DATE = 02/06/84) STANDARDIZED SCATTERPLOT ACROSS - *ZPRED DOWN - *ZRESID OUT ++ + + + + 3 + -++ + SYMBOLS: MAX N 1 . : 2 . * 3. -3 + OUT ++----3 h--2 + - + + 3 OUT 1978 CORRELATION LINC9 AGE L0C1 L0C2 L0C5 LOC LINC9 1 000 -0 297 0 528 -0 1 16 -0 256 -0 16 AGE -0 297 1 000 -0 029 -0 004 0 216 0 00 L0C1 0 528 -0 029 1 000 -0 214 -0 304 -0 41 L0C2 -0 1 16 -o 004 -0 214 1 000 -0 172 -0 23 L0C5 -0 256 0 216 -0 304 -0 172 1 000 -0 12 L0C6 -0 169 0 007 -0 416 -0 235 -0 121 1 00 FLAR 0 572 -0 158 0 258 -0 128 -0 190 0 03 LF AST 0 075 -0 014 0 039 0 051 0 089 -0 20 LNOST 0 658 -0 223 0 528 -o 137 -0 192 -0 14 LLOT 0 281 -0 257 0 120 -0 001 -0 285 -0 14 DM2 -0 1 10 0 046 0 058 0 243 -0 224 -0 04 DM3 0 019 -0 089 -0 109 0 048 0 101 -0 14 DM4 0 103 0 053 0 023 -0 161 0 103 0 15 LGIM -0 275 -0 377 -0 200 0 186 0 245 -0 18 LGIM LINC9 -0.275 AGE -0.377 L0C1 -0.200 L0C2 0.186 L0C5 0.245 L0C6 -0.182 FLAR -0.128 LFAST 0.127 LNOST -0.037 LLOT -0.045 DM2 -0.167 DM3 -0.006 DM4 0.120 LGIM 1.000 MULTIPLE R 0.73732 R SQUARE 0.54363 ADJUSTED R SQUARE 0.49348 STANDARD ERROR 0.10056 ANALYSIS OF VARIANCE REGRESSION RESIDUAL DF 10 91 F = 10.84013 VARIABLES IN THE EQUATION VARIABLE B SE B BETA T SIG LINC9 -o 14632 0.02443 -0 64055 -5 989 0 00 DM3 -0 01471 0.03066 -0 04304 -0 480 0 63 LFAST 0 03072 0.01491 0 15100 2 061 0 04 L0C2 0 12925 0.03524 0 28513 3 667 0 00 AGE -0 00380 0.5300E-03 -0 55465 -7 164 0 00 L0C5 0 09586 0.02894 0 27067 3 3 12 0 00 DM4 0 04962 0.02807 0 16231 1 768 0 08 L0C1 0 03087 , 0.02956 0 09799 1 045 0 29 DM2 -0 06 1 1 5 0.02998 -0 18708 -2 039 0 04 LNOST 0 09775 0.03242 0 30950 3 015 0 00 (CONSTANT) 3 3 1802 0. 251 13 13 2 12 0 00 CASEWISE PLOT OF STANDARDIZED RESIDUAL -3.0 0.0 3.0 SEQNUM 0: : 0 LGIM 1 *. . 1.8635 2 2.1453 . * . 1.9643 4 2.3855 5 * . 1.9184 6 *.. 2.0580 ON ON ' ' â€¢ 2.054 3 8 *â€¢ 1.9699 9 â€¢ . 1.8976 10 1.9574 11 â€¢* . 2.0177 12 *â€¢ 1.9400 13 â€¢ . 1.7267 14 â€¢* 2.0719 15 * â€¢ 1.8842 16 2.2166 17 2.0130 18 â€¢* . 2.0517 19 * . 1.9892 20 . 2.0359 21 * â€¢ 2.0537 22 â€¢ * â€¢ 1.8955 23 . * . 1.8319 24 * 2.0883 25 1.9216 26 * . 1.9492 27 1.92728 * . 1.9088 29 â€¢ 2.01530 â€¢ * .1.9568 31 * 1.7751 32 â€¢ . 2.1349 33 * 1 .8247 34 2.15735 . 2.0065 36 * 1.8993 37 â€¢ 1 .8057 38 * . 1.8089 QNUM 0: :0 LGIM -30 0.0 3.0 FILE NONAME (CREATION DATE = 02/06/84) CASEWISE PLOT OF STANDARDIZED RESIDUAL -3."0 0.0 3.0 SEONUM 0: :0 LGIM 39 . * 2.0173 40 * . 2.0371 41 . 1.9140 42 . 2.0491 43 * 1.9633 44 . * . 1 .8597 45 *. 1.86446 1.8763 47 + . 2.06 14 43 * 2.1230 49 1.7086 50 * . 1.9585 51 1.8787 52 + . 2.0130 53 * 2.1799 54 2.0505 55 * 1.9719. 56 . 2.1483 57 .* . 2.0969 58 + 2. 1344 59 * . 2.0262 60 . 2. 1371 6 1 * 1.7253 62 2.0335 63 * . 1.6172 64 . 1.9277 65 .* 1.9615 66 * 1.9418 67 * . 2.0012 68 . + 1 .98 1 7 69 * 1.7537 70 + 1.8756 71 * . 1.9335 72 2.0994 73 . * 2.093 1 74 2.2290 75 . * . . 1.4500 76 *. 1.7532 77 * 2.0229 78 * 1.8075 79 2 . 1344 80 . * . 1 .9892 SEONUM 0: : 0 LGIM -3.0 0.0 3.0 FILE NONAME (CREATION DATE = 02/06/84) CASEWISE PLOT OF STANDARDIZED RESIDUAL FILE NONAME (CREATION DATE = 02/06/84) * * * * MULTIPLE DEPENDENT VARIABLE.. LGIM RESIDUALS STATISTICS: MI N MAX MEAN STD DEV N * P R E D 1 . 7381 2 . 2280 1 .991 1 0.1035 102 *ZPRED -2 . 4434 2 . 2881 -0. .0000 1.0000 102 +SEPRED 0 .0167 0. .0939 0 .0284 0.0088 102 â€¢ADJPRED 1 . 5648 2 . 2380 1 . 9374 0.1117 102 *MAHAL 1 .8144 87 . 7467 7 .9216 8.6595 102 *COOK D 0 .0000 1 .4943 0 .0246 0.1481 102 TOTAL CASES = 102 DURB1N-WATS0N TEST = 1.96949 OUTLIERS - STANDARDIZED RESIDUAL SEQNUM SUEFILE *ZRESID 75 NONAME -2 .87535 91 NONAME 2 .30526 13 NONAME -2 .29006 63 NONAME -2 . 28546 4 NONAME 2 .20049 31 NONAME -2 . .12382 74 NONAME 1 .93259 22 NONAME - 1 . .83584 21 NONAME -1 . 64928 23 NONAME - 1 . .63006 -o o FILE NONAME (CREATION DATE = 02/06/84) HISTOGRAM N EXP N 0.11 0.06 0.08 0.12 0. 16 O, 0. O. 0 STANDARDIZED RESIDUAL O 0 0 0 0 O 0 2 0 O 1 0 2 1 2 1 2 5 2 5 2 5 6 6 6 1 1 6 7 4 4 1 2 3 1 3 3 0 2 2 O 1 0 1 2 0 0 0 0 1 0 0 . 22 .30 . 4 1 . 53 O. 69 0.88 1 . 10 1 . 36 1 .65 1 .98 2 . 33 70 .09 .47 . 84 18 4 .49 4 . 74 93 04 08 04 93 74 49 18 84 47 09 70 33 1 .98 1 .65 1 . 36 1 . 10 0.88 0.69 0.53 0.41 0.30 0. 22 0. 16 0.12 0.08 0.06 0.11 ( OUT 00 87 75 62 50 37 25 ** 12 . 00 . 1 . 87 : 1 . 75 . 1 .62 : * 1 .50 *. 1 .37 * : 1 . 25 * . 1.12 * *. 1.00 **:+â€¢* 0. 0. 0.62** . 0.50 * * *: 0.37 * * * * 0.25 * * * * 0.12 * * * * 0.00 * * * * -0.12 **** 25 * * * * 1 CASES, = NORMAL CURVE) .87 ** . .75 ***: 3-7 * * + * 50 ***: 62 * 75 ** 0.87 **: 1.00 * . 12 * * : - 1 â€¢ 1 .25 * : 1 -1 . 37 â€¢1.50 *: â€¢1 .62 :* â€¢ 1 .75 . â€¢1.87 : 00 . 12 : 25 ** 37 50 62 75 87 * 00 OUT FILE NONAME (CREATION DATE = 02/06/84) NORMAL PROBABILITY (P-P) PLOT - STANDARDIZED RESIDUAL 1 .00 + + ****** ***** 25 5 FILE NONAME (CREATION DATE = 02/06/84) STANDARDIZED SCATTERPLOT ACROSS - +ZPRED DOWN - *ZRESID OUT + + + + + + 3 + -3 + OUT ++--3 -2 - - + -- 1 _ + + + -0 1 2 SYMBOLS: MAX N 1 . : 2. * 4. + -++ 3 OUT 1979 CORRELATION LINC9 AGE L0C1 L0C2 L0C5 LOC LINC9 1 000 -0 44 1 0 434 -0 1 1 1 -0 230 -0 14 AGE -0 441 1 000 0 01 1 0 209 0 159 -0 19 L0C1 0 434 0 01 1 1 000 -0 191 -0 229 -0 42 L0C2 -0 1 1 1 0 209 -0 191 1 000 -0 131 -0 24 L0C5 -0 230 0 159 -0 229 -0 131 1 000 -0 29 L0C6 -0 14 1 -0 193 -0 429 -0 246 -0 295 1 00 FLAR 0 746 -0 314 0 334 -0 170 -o 227 -0 10 LF AST 0 113 0 058 0 016 0 037 -0 078 -0 03 LNOST 0 606 -0 271 0 422 -0 042 -0 128 -0 21 LLOT 0 829 -0 535 0 136 -0 061 -0 227 0 02 DM2 0 034 -0 066 -0 065 0 042 0 101 -0 04 DM3 -0 052 -0 023 -0 049 0 077 -0 051 0 02 DM4 0 010 0 043 0 175 -0 123 -0 1 16 0 03 LGIM -0 170 -0 092 0 1 14 0 086 0 159 -0 23 LGIM LINC9 -0.170 AGE -0.092 L0C1 0.114 L0C2 0.086 L0C5 0.159 L0C6 -0.237 FLAR -0.073 LFAST -0.046 LNOST 0.099 LLOT -0.113 DM2 -0.011 DM3 -0.038 DM4 0.131 LGIM 1.000 MULTIPLE R 0.55209 R SQUARE 0.30481 ADJUSTED R SQUARE 0.24108 STANDARD ERROR 0.12837 ANALYSIS OF VARIANCE DF REGRESSION 11 RESIDUAL 120 F = 4.78305 VARIABLES IN THE EQUATION VARIABLE B SE B BETA T SIG LINC9 -0 19729 0.04249 -0 93869 -4 644 0 00 DM4 0 05256 0.03730 0 15178 1 409 0 16 L0C6 -0 04454 0.03388 -0 14527 - 1 315 0 19 L0C2 0 07398 0.04671 0 15016 1 584 0 1 1 DM3 0 007 14 0.03543 0 02185 0 202 0 84 L0C5 0 08334 0.04239 0 19482 1 966 0 05 AGE -0 00231 0.7581E-03 -0 2941 1 -3 043 0 00 LNOST 0 12975 0.04318 0 32555 3 005 0 00 DM2 -0 00266 0.03473 -0 00849 -0 077 0 93 L0C1 0 10682 0.04110 0 31510 2 599 0 01 LLOT 0 13359 0.05563 0 4 1759 2 401 0 01 (CONSTANT) 2 84831 0.28504 9 993 0 00 CASEWISE PLOT OF STANDARDIZED RESIDUAL -3.0 0.0 3.0 SEQNUM 0: : : 0 LGIM 1 * . 2.1480 2 . + . 2.3284 3 . â€¢ * . 2.0818 4 * . 2.1619 5 * 2.3617 6 . * 1.7894 ' â€¢ â€¢ * â€¢ 2.2517 8 * 2.1973 9 * 1.96610 2.1679 11 * 2.0854 12 â€¢ 2.0798 13 * . 2.0276 14 . 2.1904 15 * 1.9652 16 1.9719 17 â€¢ * . 1.9432 18 * . 2.0756 19 2.3657 20 2.04 10 21 * 1.9976 22 â€¢ 2.1022 23 * 2.0395 24 2.0707 25 â€¢* . 2.1648 26 * 2.0231 27 * . 2.2226 28 * 2.2450 29 2.3792 30 * . 1.8770 31 . 2.1230 32 â€¢ - * 2.24 53 33 * . 1.9131 34 * 2. 1828 35 2.23336 * . 1.9811 37 1.9597 38 2.3368 SEONUM 0: : :0 LGIM -3.0 0.0 3.0 FILE NONAME (CREATION DATE = 02/06/84) CASEWISE PLOT OF STANDARDIZED RESIDUAL -3.0 0.0 3.0 SEQNUM 0: : 0 LGIM 39 + . 1.9468 40 * . 2.04041 .* 2.1084 4 2 * 2.0186 43 .. 2.5135 44 . * . 1 .8761 45 * 2.02346 * . 2.1936 47 * . 2.0067 48 2.0020 49 2.37 12 50 * 2.2017 5 1. . * 2. 1235 52 * 1.89053 . 2.2150 54 * . 2.0133 55 . * 2.1329 56 . 2.3508 57 * . 1 .9984 58 2. 1581 59 . * 2.0589 60 *. . 2.0823 61 2.2454 62 . * 2.09563 . 2. 1941 64 * 1.9753 65 . 2. 1255 66 â€¢ . 2.2566 67 . * 2.005 1 68 *. 2.0522 69 . 2. 1645 70 . 2. 1339 7 1 * . 2.082 1 72 * 1 .8088 73 . 2.1695 74 . * 2.01475 * . 2.0677 76 . * 2.0888 77 . * . 2.0639 78 * . 2.0669 79 1.87 18 80 * . 2.0681 SEONUM 0 : 0 LGIM -3.0 0.0 â€¢ 3.0 FILE NONAME (CREATION DATE = 02/0G/84) CASEWISE PLOT OF STANDARDIZED RESIDUAL -3.0 0.0 3.0 SEONUM 0: : :0 LGIM 81 *. 1 .9356 82 . + . 2.0848 83 * . 2.0165 84 2.0513 85 .+ 1 .9244 86 * 1.88987 , *. 1.9463 88 . * 2.228 1 89 * 2.1138 30 * . 2.2961 91 * . 2.0670 92 .* 1.9822 93 + 2.02094 * 2.00395 . * 2.06 10 96 * . 1.9962 97 1.9717 98 2.0623 99 . . 2.1229 100 * . 1.9402 101 . * 1.975102 + 2.1567 103 * 2.0653 104 * 1.8486 105 1.9141 106 * 2.0348 107 1.8535 108 . 2 . 1122 109 . *. . 2.0275 110 * 2.0859 111. . * 2.1331 112 * 1.9237 113 . 2.1662 114 â€¢ * . 2.2929 115 * . 1.8907 116. *. 1 .8912 117 * . . 1.7790 118 . + . 1.8527 119 2.4389 120 * 1.9387 121 2.2268 122 * . 1.8670 SEONUM 0: : :0 LGIM' -3.0 0.0 3.0 FILE NONAME (CREATION DATE = 02/06/84) CASEWISE PLOT OF STANDARDIZED RESIDUAL LGIM 1.9804 2.0334 1.9784 2.1936 2.0756 2.6285 1.9948 2.1131 2.0503 1.9468 LGIM ************* RESIDUALS STATISTICS: MIN MAX MEAN STD DEV N *PRED 1 8551 2 2865 2 0785 0 0799 132 *ZPRED -2 7950 2 6025 -0 0000 1 0000 132 *SEPRED O 0176 0 0640 0 032 1 0 0090 132 *ADUPRED 1 8686 2 3162 2 0783 0 0801 132 *MAHAL 1 4813 31 9276 7 9394 4 9515 132 *COOK D O OOOO 0 15 11 0 0095 0 0194 132 TOTAL CASES = 132 DURBIN-WATSON TEST = 2.36166 CO FILE NONAME (CREATION DATE = 02/06/84) OUTLIERS - STANDARDIZED RESIDUAL SEONUM SUBFILE *ZRESID 128 NONAME 3 .96254 1 19 NONAME 2 .44258 5 NONAME 2 .33148 72 NONAME -2 .18144 6 NONAME -2 .03590 43 NONAME 2 .01268 29 NONAME 1 . 84273 49 NONAME 1 .83932 44 NONAME -1 .83622 77 NONAME - 1 . .74171 FILE NONAME (CREATION DATE = 02/06/84) HISTOGRAM - STANDARDIZED RESIDUAL N EXP N ( + = 1 CASE 1 0 14 OUT * 0 0 07 3 00 0 0 1 1 2 87 0 0 15 2 75 0 0 21 2 62 1 0 29 2 50 * 1 0 39 2 37 0 0 53 2 25 0 0 69 2 12 1 0 89 2 00 2 1 14 1 87 â€¢ * 0 1 43 1 75 1 1 76 1 62 * 1 2 14 1 50 2 2 56 1 37 * * . 0 3 01 1 25 3 3 50 1 12 * * . 5 3 99 1 00 * * * . * 3 4 49 0 87 * * * _ 4 4 97 0 75 * * * * 8 5 41 0 62 * * * * . * * * 9 5 81 0 50 *****.*** 10 6 13 0 37 ***** . **** 4 6 38 0 25 * * * * 6 6 53 0 12 ****** 7 6 58 0 00 ****** . 6 6 53 -0 12 ****** 6 6 38 -0 25 ***** . 9 6 13 -0 37 ***** . *** 5 5 81 -0 50 ***** 6 5 41 -0 62 ****** 7 4 97 -o 75 ****.** 2 4 49 -0 87 * * 6 3 99 -1 00 * * * . * * 1 3 50 -1 12 * 5 3 01 -1 25 * * â€¢ * * 3 2 56 -1 37 * * â€¢ 1 2 14 -1 50 * 1 1 76 -1 62 * 2 1 43 -1 75 1 1 14 -1 87 1 0 89 -2 00 1 0 69 -2 12 0 0 53 -2 25 0 0 39 -2 37 0 0 29 -2 50 0 0 21 -2 62 0 0 15 -2 75 0 0 1 1 -2 87 0 0 07 -3 00 0 0 14 OUT = NORMAL CURVE) CO o FILE NONAME (CREATION DATE = 02/06/84) NORMAL PROBABILITY (P-P) PLOT - STANDARDIZED RESIDUAL 1 .00 + + _ * * * * * * * # * * * + * * * FILE NONAME (CREATION DATE = 02/06/84) STANDARDIZED SCATTERPLOT ACROSS - *ZPRED DOWN OUT + + + + + -3 + "ZRESID - + + --3 + OUT ++---3 - + + + SYMBOLS: - H ^ + --2 -1 0 - + + 3 OUT SSIGNOFF 183 APPENDIX C Return and Risk Statistics of Properties Return on St.Dev Var iance Return on St.Dev Variance Capital Equity A 1 02 0 .05551 0. 1 4821 0 .02197 0. 03849 0. 20794 0. 04324 A 1 06 0 .05716 0. 1 2962 0 .01680 0. 08064 0. 35527 0. 12621 A 1 07 0 .04951 0. 1 2466 0 .01554 0. 03487 0. 18241 0. 03327 A 1 1 1 0 .05325 0. 1 251 1 0 .01565 0. 09546 0. 421 83 0. 1 7794 A 1 1 2 0 .05526 0. 1 2163 0 .01 479 -0. 33608 1 . 09523 1 . 1 9953 A 1 1 3 0 .05501 0. 1 1 694 0 .01368 0. 07753 0. 42323 0. 1 7912 A 1 15 0 .05902 0. 1 9733 0 .03894 0. 05231 0. 31010 0. 0961 6 A 1 16 0 .05814 0. 1 2309 0 .01515 0. 1 561 5 0. 68062 0. 46325 A 1 19 0 .04638 0. 1 2220 0 .01493 -0. 81 649 1. 66354 2. 76735 A 1 22 0 .04941 0. 1 2225 0 .01494 0. 04461 0. 1 7397 0. 03027 A 1 24 0 .06152 0. 1 2299 0 .01513 0. 04980 0. 1 5049 0. 02265 A 1 25 0 .04237 0. 1 1643 0 .01356 0. 1 3322 0. 94332 0. 88984 A 1 26 0 .04406 0. 1 2668 0 .01605 0. 03357 0. 28978 0. 08397 A 1 27 0 .04407 0. 1 3549 0 .01836 0. 07865 0. 32855 0. 1 0794 A 1 28 0 .04432 0. 1 2776 0 .01632 0. 1 4501 0. 76902 0. 59139 A 1 29 0 .04523 0. 1 1 986 0 .01437 0. 04663 0. 25798 0. 06656 A 1 30 0 .04511 0. 11913 0 .01419 0. 051 1 5 0. 29307 0. 08589 A 1 32 0 .04296 0. 1 1 970 0 .01433 0. 02369 0. 1 6472 0. 0271 3 A 1 33 0 .04480 0. 1 2552 0 .01576 -0. 00062 0. 63334 0. 401 1 2 A 1 34 0 .04642 0. 1 2082 0 .01460 0. 031 49 0. 26341 0. 06938 A 1 37 0 .06216 0. 20285 0 .04115 0. 07694 0. 44796 0. 20067 A 1 38 0 .06975 0. 23581 0 .05561 -o. 04027 0. 56889 0. 32363 A 1 39 0 .05203 0. 1 3547 0 .01835 0. 1 0092 0. 49798 0. 24798 A 1 40 0 .04884 0. 1 3551 0 .01836 0. 06646 0. 3871 9 0. 1 4992 A 141 0 .04576 d. 1 3346 0 .01781 0. 04228 0. 22585 0. 051 01 A 1 42 0 .04642 0. 1 2254 0 .01502 0. 81960 4. 76605 22. 71 527 A 1 43 0 .06675 0. 23380 0 .05466 0. 1 5451 0. 71 622 0. 51 297 A 1 44 0 .05762 0. 1 2753 0 .01626 0. 10532 0. 3661 7 0. 1 3408 A 1 45 0 .05028 0. 11125 0 .01238 0. 05028 0. 11125 0. 01 238 A 1 46 0 .04468 0. 1 351 0 0 .01825 0. 05470 0. 28863 0. 08331 A 1 47 0 .05018 0. 1 6469 0 .02712 0. 08457 0. 37759 0. 1 4258 A 1 49 0 .04756 0. 1 2778 0 .01633 0. 01219 0. 25220 0. 06360 A 1 50 0 .05505 0. 1 2520 0 .01568 0. 1 3267 0. 67089 0. 45009 A 201 0 .04666 0. 1 5997 0 .02559 -o. 03041 0. 42502 0. 1 8064 A 202 0 .05247 0. 20497 0 .04201 0. 1 1 501 0. 55050 0. 30304 A 203 0 .04993 0. 1 4596 0 .02130 0. 09062 0. 54272 0. 29455 A 204 0 .04579 0. 1 5042 0 .02263 -o. 03861 0. 92670 0. 85878 A 205 0 .04794 0. 14289 0 .02042 0. 061 24 0. 31806 0. 10116 A 207 0 .04077 0. 1 3004 0 .01691 0. 04407 0. 33507 0. 1 1 227 A 209 0 .04949 0. 1 231 8 0 .01517 -o. 00373 0. 81690 0. 66732 A 210 0 .06973 0. 25507 0 .06506 0. 31 222 1. 491 31 2. 22402 A 21 1 0 .04566 0. 1 2988 0 .01687 0. 02539 0. 17806 0. 03170 A 212 0 .04697 0. 1 2982 0 .01685 0. 02876 0. 21676 0. 04699 184 A 213 0 .04891 0. 1 2608 0 .01590 0. 07791 0. 3821 2 0. 1 4601 A 214 0 .04844 0. 1 2602 0 .01588 0. 03378 0. 24630 0. 06067 A 215 0 .04417 0. 1 1809 0 .01395 0. 04731 0. 1 3067 0. 01708 A 217 0 .05533 0. 1 3362 0 .01785 0. 1 6905 0. 87696 0. 76906 A 218 0 .04760 0. 1 3587 0 .01846 0. 09667 0. 40352 0. 1 6282 A 219 0 .04850 0. 1 2235 0 .01497 0. 04082 0. 1 8763 0. 03520 A 220 0 .04394 0. 12653 0 .01601 0. 03425 0. 25577 0. 06542 A 221 0 .04931 0. 1 2079 0 .01459 0. 1 4426 1 . 501 77 2. 25533 A 222 0 .04273 0. 1 3358 0 .01784 -o. 061 53 1 . 20741 1 . 45784 A 223 0 .04218 0. 1 91 44 0 .03665 -o. 06481 0. 97603 0. 95263 A 224 0 .04545 0. 1 4368 0 .02064 0. 07223 0. 32116 0. 10314 A 225 0 .06323 0. 25382 0 .06443 0. 08907 1 . 0081 1 1. 01 628 A 226 0 .05967 0. 23678 0 .05607 -o. 60970 2. 62339 6. 88219 A 227 0 .06123 0. 26547 0 .07047 0. 1 5876 0. 6801 0 0. 46253 A 229 0 .04394 0. 14151 0 .02003 -1 . 33565 7. 1 3495 50. 90747 A 231 0 .04175 0. 1 2687 0 .01610 0. 01791 0. 20570 0. 04231 A 232 0 .04974 0. 12507 0 .01564 0. 02563 0. 95044 0. 90334 A 233 0 .05286 0. 1 31 02 0 .01717 0. 01 1 00 0. 45970 0. 21 1 33 A 2 34 0 .06326 0. 26074 0 .06799 0. 7791 2 6. 02329 36. 27998 A 235 0 .04548 0. 1 4021 0 .01966 0. 06898 0. 32574 0. 10611 A 238 0 .04345 0. 1 2685 0 .01609 0. 07933 0. 29256 0. 08559 A 301 0 .05545 0. 1 6547 0 .02738 0. 09962 0. 31 978 0. 1 0226 A 302 0 .04728 0. 17015 0 .02895 0. 1 3623 0. 59096 0. 34923 A 304 0 .05036 0. 1 7844 0 .03184 0. 07402 0. 33352 0. 11124 A 306 0 .05201 0. 17171 0 .02948 0. 06033 0. 27535 0. 07582 A 309 0 .04949 0. 17 125 0 .02933 0. 05073 0. 49119 0. 24127 A 310 0 .05041 0. 1 6455 0 .02708 0. 04642 0. 27061 0. 07323 A 31 1 0 .04935 0. 1 7246 0 .02974 0. 07378 0. 2671 8 0. 071 38 A 312 0 .06209 0. 1 7993 0 .03237 0. 1 6877 0. 61 094 0. 37325 A 313 0 .04825 0. 1 7039 0 .02903 0. 1 301 5 0. 52738 0. 27813 A 314 0 .05945 0. 1 8544 0 .03439 0. 091 57 0. 85754 0. 73537 A 315 0 .05028 0. 1 7363 0 .03015 -o. 00368 0. 48966 0. 23976 A 402 0 .04459 0. 1 21 74 0 .01482 0. 04970 0. 25234 0. 06367 A 403 0 .03839 0. 1 3901 0 .01932 0. 03733 0. 22990 0. 05285 A 404 0 .04802 0. 1 3627 0 .01857 -o. 1 2509 0. 74984 0. 56225 A 405 0 .03944 0. 1 3371 0 .01788 0. 24183 1. 6251 5 2. 641 1 2 A 408 0 .04703 0. 1 3591 0 .01847 0. 55692 2. 07627 4. 31088 A 410 0 .04022 0. 1 3655 0 .01865 0. 0441 5 0. 37377 0. 1 3970 A 413 0 .04329 0. 1 3303 0 .01770 0. 1 4443 1. 03403 1 . 06921 A 414 0 .05083 0. 13459 0 .01812 0. 06038 0. 68330 0. 46689 A 416 0 .04817 0. 1 1 375 0 .01294 0. 051 90 0. 30856 0. 09521 A 417 0 .04702 0. 1 2476 0 .01556 -o. 0271 1 0. 78973 0. 62367 A 418 0 .04486 0. 10897 0 .01187 0. 60778 2. 20052 4. 84229 A 419 0 .04360 0. 1 1 430 0 .01306 0. 03121 0. 21 368 0. 04566 A 420 0 .04140 0. 1 5958 0 .02547 -o. 01 537 0. 37639 0. 14167 A 422 0 .04527 0. 1 1887 0 .01413 0. 06796 0. 32872 0. 1 0806 A 423 0 .03811 0. 1 3769 0 .01896 0. 30973 1. 93694 3. 751 72 A 424 0 .04420 0. 1 2825 0 .01645 0. 03737 0. 21 006 0. 0441 3 A 425 0 .0471 1 0. 14395 0 .02072 0. 1 21 23 0. 78775 0. 62055 A 426 0 .04647 0. 1 0303 0 .01062 0. 06222 0. 76389 0. 58352 A 427 0 .04737 0. 1 2429 0 .01545 0. 07680 0. 331 03 0. 10958 A 428 0 .04175 0. 1 2906 0 .01666 0. 06070 0. 38775 0. 1 5035 185 A 429 0. 04738 0. 1 2474 0. 01 556 0. 04642 0. 31 972 0. 10222 A 430 0. 04264 0. 1 2840 0. 01 649 0. 031 96 0. 21 950 0. 04818 A 431 0. 04894 0. 1 2296 0. 01512 0. 06842 0. 51 979 0. 27018 A 432 0. 04373 0. 1 3069 0. 01 708 0. 07768 0. 40531 0. 1 6428 A 434 0. 04547 0. 1 1 971 0. 01 433 0. 1 2284 0. 57328 0. 32865 A 435 0. 05278 0. 1 4034 0. 01 970 0. 1 2750 0. 48873 0. 23886 A 436 0. 04203 0. 1 1 257 0. 01 267 0. 02880 0. 22108 0. 04888 A 437 0. 04353 0. 1 2731 0. 01 621 0. 40346 1 . 91 763 3. 67731 A 439 0. 04925 0. 1 3367 0. 01787 -o. 02576 0. 75021 0. 56282 A 440 0. 04880 0. 1 5772 0. 02488 0. 061 22 0. 29628 0. 08778 A 441 0. 04204 0. 1 2331 0. 01 521 -o. 85293 6. 34741 40. 28963 A 443 0. 05512 0. 1 2732 0. 01 621 0. 01141 0. 22346 0. 04994 A 444 0. 04731 0. 1 1 994 0. 01439 0. 05600 0. 22799 0. 05198 A 501 0. 06204 0. 22207 0. 04932 0. 1 6736 0. 82018 0. 67270 A 601 0. 06775 0. 21 655 0. 04689 0. 05234 0. 83485 0. 69697 A 602 0. 06227 0. 22341 0. 04991 0. 35340 1. 93324 3. 73742 A 604 0. 06044 0. 1 9867 0. 03947 1 . 57423 9. 63870 92. 90453 A1 004 0. 05825 0. 18538 0. 03437 0. 05806 0. 35743 0. 1 2775 A1 005 0. 05602 0. 1 2568 0. 01 579 -o. 29646 1 . 57856 2. 49185 A1 006 0. 04835 0. 1 3312 0. 01772 0. 1 3234 0. 71 235 0. 50744 A1 009 0. 04094 0. 1 1829 0. 01 399 -o. 00307 0. 51 396 0. 2641 5 Al 01 0 0. 04745 0. 1 2230 0. 01 496 0. 071 22 0. 48672 0. 23690 A1 01 3 0. 04925 0. 1 2641 0. 01 598 0. 09986 0. 34710 0. 1 2048 A1 0 1 5 0. 04456 0. 1 2681 0. 01 608 0. 08445 0. 31 608 0. 09990 A1 0 1 6 0. 04020 0. 1 3579 0. 01 844 0. 06832 0 . 28358 0. 08042 A1018 0. 0 5 1 .1 7 0. 1 2275 0. 01 507 0. 06998 0. 18973 0. 03600 A1 0 1 9 0. 041 96 0. 1 2528 0. 01 569 0. 03428 0. 1 9824 0. 03930 A1 021 0. 05246 0. 1 2696 0. 01612 0. 07867 0. 33700 0. 1 1 357 A1 022 0. 04912 0. 1 2506 0. 01 564 0. 05788 0. 27557 0. 07594 A1 023 0. 04899 0. 1 2562 0. 01 578 1. 1 1 320 6. 81 740 46. 47696 A1 027 0. 05782 0. 23958 0. 05740 0. 09929 0. 53946 0. 291 01 A1 03 1 0. 04641 0. 1 41 97 0. 0201 5 0. 08070 0. 36252 0. 1 31 42 A1 032 0. 04527 0. 1 71 49 0. 02941 0. 06482 0. 21 026 0. 04421 A1 037 0. 0551 3 0. 19110 0. 03652 0. 1 3758 0. 56254 0. 31 645 A1 038 0. 05787 0. 1 9024 0. 0361 9 0. 05787 0. 1 9024 0. 0361 9 A1 039 0. 06607 0. 1 3570 0. 01842 0. 1 7871 1. 0281 3 1 . 05705 A1 041 0. 0591 3 0. 1 21 45 0. 01 475 -o. 49298 2. 74992 7. 56206 A1 042 0. 06403 0. 1 0903 0. 01 189 0. 09331 0. 51 764 0. 26795 Al 044 0. 04320 0. 1 2332 0. 01 521 0. 02093 0. 26282 0. 06907 A1 046 0. 05747 0. 18418 0. 03392 0. 05735 0. 1 8463 0. 03409 A1 049 0. 04547 0. 1 2649 0. 01 600 0. 04544 0. 1 2654 0. 01 601 A1 052 0. 04303 0. 12123 0. 01 470 0. 06672 0. 26267 0. 06900 A1 053 0. 04181 0. 1 2208 0. 01 490 0. 04817 0. 1 5580 0. 02427 A1 054 0. 05897 0. 20387 0. 041 56 -1. 52234 8. 29928 68. 87808 A1 055 0. 04404 0. 1 2467 0. 01 554 0. 06272 0. 31 683 0. 1 0038 A1 056 0. 04736 0. 1 21 27 0. 01 471 0. 06625 0. 25464 0. 06484 A1 057 0. 04299 0. 1 2493 0. 01 561 0. 0281 6 0. 1 7646 0. 031 14 A1 058 0. 05217 0. 1 2725 0. 01619 0. 06307 0. 23760 0. 05646 A1 061 0. 04980 0. 1 3078 0. 01710 4. 22609 22. 39479501. 52661 A1 066 0. 04491 0. 16894 0. 02854 0. 09873 0. 50293 0. 25293 A1 067 0. 04478 0. 1 2881 0. 01 659 0. 05186 0. 1 5352 0. 02357 A1 069 0. 05929 0. 18942 0. 03588 0. 02794 0. 35878 0. 1 2872 186 A1 072 0. 05950 0. 5369 0 .02362 -o. 46889 1 . 47979 2. 18979 A1 073 0. 0521 4 0. 1 964 0 .01431 0. 48186 2. 66377 7 . 09567 A1 074 0. 04838 0. 0276 0 .01056 0. 04357 0. 1 7703 0. 031 34 A1 075 0. 05296 0. 261 0 0 .01590 0. 1 5405 1 . 43526 2. 05997 A1 076 0. 05842 0. 1307 0 .01278 0. 07068 0. 331 50 0. 10989 A1 077 0. 04601 0. 2327 0 .01519 0. 06853 0. 41 949 0. 17597 A1 078 0. 051 58 0. 2524 0 .01569 -0. 00227 0. 96642 0. 93396 A1 080 0. 05747 0. 1205 0 .01256 0. 05747 0. 1 1 205 0. 01256 A1 082 0. 0651 1 0. 3455 0 .01810 0. 04848 0. 58038 0. 33684 A1 083 0. 04446 0. 1213 0 .01257 0. 04446 0. 11213 0. 01 257 A1 084 0. 05773 0. 7448 0 .03044 -o. 04956 0. 62395 0. 38932 A1 085 0. 05028 0. 1 246 0 .01265 -0. 1 4897 5. 87818 34. 55304 A1 087 0. 06482 0. 11129 0 .01239-99. 00 0. 00 0. 00 A1 090 0. 05470 0. 1 2673 0 .01606 0. 51 1 08 2. 401 1 4 5. 76548 A1 095 0. 05254 0. 13184 0 .01738 0. 62055 2. 22081 4. 931 98 A1 098 0. 05726 0. 1 1 048 0 .01221 0. 07867 0. 44983 0. 20235 A1 1 00 0. 04841 0. 1 0774 0 .01161 -0. 08290 0. 53355 0. 28468 A1 1 03 0. 04981 0. 1 3298 0 .01768 0. 09380 0. 31 635 0. 1 0008 A1 104 0. 22470 1 . 1 4599 1 .31330 0. 22470 1. 1 4599 1 . 31 330 A1 105 0. 04325 0. 1 1 570 0 .01339 0. 03740 0. 32250 0. 1 0401 A1 1 06 0. 041 78 0. 1 1887 0 .01413 0. 04874 0. 1 5007 0. 02252 A1 107 0. 04528 0. 1 1 469 0 .01315 0. 041 55 0. 1 9944 0. 03978 A1 1 1 4 0. 04241 0. 1 2540 0 .01573 0. 1 21 00 0. 60976 0. 37181 A1 1 1 5 0. 041 60 0. 1 2841 0 .01649 0. 74830 4. 59437 21 . 1 0828 A1 1 1 7 0. 05057 0. 1 1 745 0 .01380 0. 07233 0. 47278 0. 22352 A1 1 1 8 0. 041 76 0. 11731 0 .01376 0. 2281 9 1 . 12128 1. 25727 A1 1 21 0. 04090 0. 1 3493 0 .01821 0. 05594 0. 1 9380 0. 03756 A1 1 22 0. 04507 0. 1 2505 0 .01564 0. 04507 0. 1 2505 0. 01 564 A1 1 24 0. 04405 0. 1 1 251 0 .01266 0. 03937 0. 1 3838 0. 01915 A1 1 27 0. 03770 0. 1 5800 0 .02496 0. 04363 0. 28780 0. 08283 A1 1 29 0. 05431 0. 11617 0 .01350 0. 2321 9 0. 80084 0. 641 35 A1 1 30 0. 04530 0. 10711 0 .01147 0. 01 346 0. 49763 0. 24763 A1 132 0. 06296 0. 1 7090 0 .02921 0. 05262 0. 1 9962 0. 03985 A1 1 33 0. 05638 0. 1 8523 0 .03431 0. 01080 0. 35644 0. 1 2705 A1 1 35 0. 0561 4 0. 1 8976 0 .03601 0. 05614 0. 18976 0. 03601 A2003 0. 05056 0. 1 1896 0 .01415 0. 05056 0. 1 1896 0. 01415 A201 1 0. 04921 0. 1 2793 0 .01637 0. 04573 0. 13916 0. 01937 A201 2 0. 04793 0. 1 2228 0 .01495 0. 05937 0. 1 5430 0. 02381 A201 6 0. 03994 0. 1 2647 0 .01600 0. 1 8757 0. 87602 0. 76741 A201 8 0. 04692 0. 1 1 527 0 .01329 -o. 05630 1. 00587 1. 01 1 78 A 2.01 9 0. 04745 0. 12110 0 .01466 0. 06536 0. 26663 0. 071 09 A2025 0. 0461 1 0. 1 2875 0 .01658 0. 03337 0. 24477 0. 05991 A2027 0. 03649 0. 14125 0 .01995 0. 04840 0. 1 9267 0. 03712 A2033 0. 03561 0. 1 2335 0 .01522 -o. 46232 2. 1 1 797 4. 48578 A2035 0. 05409 0. 1 7026 0 .02899 2. 401 01 10. 93716119. 621 44 A2036 0. 05408 0. 1 6776 0 .02815 0. 45458 2. 18556 4. 77669 A2039 0. 04533 0. 1 3692 0 .01875 0. 03817 0. 63873 0. 40798 A2041 0. 04303 0. 1 1871 0 .01409 0. 04971 0. 24498 0. 06002 A2045 0. 04538 0. 14598 0 .02131 0. 09786 0. 83045 0. 68965 A2047 0. 04755 0. 1 2882 0 .01660 0. 51 689 2. 30664 5. 32061 A2048 0. 04640 0. 1 2591 0 .01585 0. 09310 0. 49861 0. 24861 A2049 0. 04494 0. 1 2461 0 .01553 0. 03304 0. 15173 0. 02302 A2051 A3002 A3003 A3005 A3009 A301 0 A301 2 A3029 A3033 A3035 A3036 A3037 A3039 A3040 A3041 A3042 A3043 A3044 A3046 A3049 A3050 A3051 A3052 A3054 A3055 A3056 A3058 A3059 A3061 A3063 A3064 A3069 A3077 A3080 A3084 A3085 A3088 A3089 A3091 A3093 A3094 A3096 A3097 A3 1 0 1 A3 1 02 A31 04 A31 05 A31 06 A3 1 07 A3! 08 A31 1 0 A31 1 4 0.03870 0.04655 0.04349 0.04736 0.04884 0.04619 0.04477 0.04939 0.04281 0.04624 0.04823 0.04621 0.04512 0.05144 0.04860 0.04248 0.04517 0.04500 0.04575 0.04493 0.061 70 0.04621 0.04077 0.04706 0.04376 0.04511 0.04478 0.05624 0.05046 0.05040 0.05852 0.05798 0.04574 0.04089 0.04458 0.04551 0.04934 0.04581 0.04115 0.04779 0.06107 0.05938 0.05854 0.0558.5 0.05778 0.05994 0.05194 0.05123 0.04636 0.05175 0.04902 0.04500 0. 1 1877 0. 1 1 766 0. 1 1 555 0. 11713 0. 1 1 945 0. 13166 0. 1 231 6 0. 1 2560 0. 12901 0. 1 2829 0. 13033 0. 12869 0. 12745 0. 1 2827 0. 1 2325 0. 12609 0. 1 2673 0. 12731 0. 1 3430 0. 1 2924 0. 25381 0. 13518 0. 1 3928 0. 14122 0. 1 4904 0. 14479 0. 1 4287 0. 10877 0. 1 4064 0. 1 1 844 0. 18056 0. 1 0992 0. 11140 0. 1 3322 0. 12761 0. 12687 0. 13027 0. 10994 0. 11417 0. 1 081 9 0. 18875 0. 1 9496 0. 18420 0. 1 7202 0. 1 9924 0. 20065 0. 1 2731 0. 12104 0. 1 2496 0. 1 3045 0. 12301 0. 12281 0.01411 0.01384 0.01335 0.01372 0.01427 0.01733 0.01517 0.01577 0.01664 0.01646 0.01699 0.01656 0.01624 0.01645 0.01519 0.01590 0.01606 0.01621 0.01804 0.01670 0.06442 0.01827 0.01940 0.01994 0.02221 0.02096 0.02041 0.01183 0.01978 0.01403 0.03260 0.01208 0.01241 0.01775 0.01628 0.01610 0.01697 0.01209 0.01303 0.01171 0.03563 0.03801 0.03393 0.02959 0.03970 0.04026 0.01621 0.01465 0.01561 0.01702 0.01513 0.01508 0.04699 0.08211 -0.27003 0.06580 0.07147 0.05051 0.04211 0.96577 0.05593 -0. 12733 0.09047 0.06197 0. 18708 0.21872 0.06132 0.02781 0.06184 0.21247 0.07757 0.10640 -0.19057 0.04660 0. 10606 0.06394 0.04513 0.23389 0.14060 0.04483 0.76491 0.09248 -0.09990 0.12134 0.02862 0.23016 0.06260 0.05812 0.05943 0.06967 0.11407 0.03347 0.10830 0.07308 0. 16831 0.21329 -0.32231 0.06212 0.04952 0.05880 0.04733 0.02624 0.05031 0.05809 0.16722 0.38635 1.68789 0.40148 0.32977 0.64051 0.20260 5.28492 0.94121 0.69216 0.33302 0.18370 0.97709 2.35339 0.34205 0.74066 0.37031 1.01623 0.21934 0.58995 1.05782 0.24272 0.60677 0.20770 0.22208 1.15224 0.58183 0.18397 6.98121 0.34956 1.71620 0.48542 0.16162 1.58148 0.29280 0.95096 0.30037 0.31310 0.61432 0. 18840 0.46962 0.31786 0.71845 0.73926 2.24813 0.30041 0.31722 0.37096 0.17661 0.20669 0.21960 0.47613 0.02796 0.14926 2.84898 0.16119 0.10875 0.41025 0.04105 27.93034 0.88587 0.47909 0.11090 0.03375 0.95470 5.53842 0.11700 0.54857 0.13713 1 .03273 0.04811 0.34804 1.11899 0.05891 0.36817 0.04314 0.04932 1.32765 0.33852 0.03385 48.73727 0. 12219 2.94535 0.23563 0.02612 2.50107 0.08573 0.90433 0.09022 0.09803 0.37738 0.03549 0.22055 0.10104 0.51617 0.54651 5.05408 0.09025 0.10063 0.13761 0.03119 0.04272 0.04822 0.22670 A3 1 1 5 0.06173 A3 116 0.04623 A3 117 0.04175 A3 118 0.06145 A3123 0.04062 0.19505 0.03804 0.12427 0.01544 0.11901 0.01416 0.21162 0.04478 0.12315 0.01517 0.07764 0.33455 0.11193 0.03552 0.16104 0.02593 0.03838 0.29427 0.08660 2.85418 12.96216168.01765 0.05817 0.68513 0.46941
- Library Home /
- Search Collections /
- Open Collections /
- Browse Collections /
- UBC Theses and Dissertations /
- Real estate portfolio diversification
Open Collections
UBC Theses and Dissertations
Featured Collection
UBC Theses and Dissertations
Real estate portfolio diversification Kurtin, Todd H. 1984
pdf
Page Metadata
Item Metadata
Title | Real estate portfolio diversification |
Creator |
Kurtin, Todd H. |
Publisher | University of British Columbia |
Date | 1984 |
Date Issued | 2010-05-08T21:29:59Z |
Description | This thesis examines the potential benefits of diversification in real estate. By calculating a set of returns for apartment blocks in Vancouver, British Columbia, two issues of diversification are dealt with: the potential of diversifying within real estate, and the benefits of including real estate in mixed-asset portfolios. To examine the potential of diversifying within real estate, the study looks at the relative proportions of systematic and unsystematic risk of real estate. Also, the paper investigates the rate at which variations of returns for randomly selected portfolios are reduced as a function of the number of properties in a portfolio. To investigate the benefits of including real estate in mixed-asset portfolios, two types of efficient portfolios are constructed: one that hedges against inflation, and the other that is mean-variance efficient. By selecting these two types of efficient portfolios, the paper considers two major investment objectives of investors: (1) that their portfolio provides a return to combat inflation; (2) that their portfolio have minimum risk for a given expected rate of return. The findings of the study show that portfolios consisting solely of real estate(of one property type in one local market) are not well diversified. The investigation found that only 29 percent of total risk is unsystematic(diversifiable). However, a large portion of the unsystematic risk can be diversified away by holding a portfolio which contains only a few properties. The findings also illustrate that real estate is a useful addition in mixed-asset portfolios. Real estate contributes to the effectiveness of both the inflation-hedged portfolio and the mean-variance efficient portfolio. In the inflation-hedged portfolio, real estate does not contribute as strongly as expected, but the results still demonstrate that real estate should be included in portfolios that are designed to hedge inflation. In the mean-variance efficient portfolio, real estate is found to have a low or negative correlation with other assets, making the potential to diversify very high. |
Genre |
Thesis/Dissertation |
Type |
Text |
Language | eng |
Collection |
Retrospective Theses and Dissertations, 1919-2007 |
Series | UBC Retrospective Theses Digitization Project |
Date Available | 2010-05-08 |
Provider | Vancouver : University of British Columbia Library |
Rights | For non-commercial purposes only, such as research, private study and education. Additional conditions apply, see Terms of Use https://open.library.ubc.ca/terms_of_use. |
DOI | 10.14288/1.0096012 |
Degree |
Master of Science - MSc |
Program |
Business Administration |
Affiliation |
Business, Sauder School of |
Degree Grantor | University of British Columbia |
Campus |
UBCV |
Scholarly Level | Graduate |
URI | http://hdl.handle.net/2429/24504 |
Aggregated Source Repository | DSpace |
Download
- Media
- [if-you-see-this-DO-NOT-CLICK]
- [if-you-see-this-DO-NOT-CLICK]
- UBC_1984_A4_6 K87.pdf [ 9.71MB ]
- Metadata
- JSON: 1.0096012.json
- JSON-LD: 1.0096012+ld.json
- RDF/XML (Pretty): 1.0096012.xml
- RDF/JSON: 1.0096012+rdf.json
- Turtle: 1.0096012+rdf-turtle.txt
- N-Triples: 1.0096012+rdf-ntriples.txt
- Original Record: 1.0096012 +original-record.json
- Full Text
- 1.0096012.txt
- Citation
- 1.0096012.ris
Full Text
Cite
Citation Scheme:
Usage Statistics
Country | Views | Downloads |
---|---|---|
United States | 13 | 1 |
China | 10 | 129 |
Azerbaijan | 6 | 0 |
France | 6 | 0 |
United Kingdom | 5 | 4 |
Vietnam | 4 | 1 |
Russia | 2 | 0 |
Japan | 2 | 0 |
Poland | 1 | 0 |
Finland | 1 | 2 |
City | Views | Downloads |
---|---|---|
Unknown | 22 | 2 |
Hangzhou | 5 | 0 |
Ashburn | 5 | 0 |
Hanoi | 4 | 1 |
Shenzhen | 3 | 1 |
Boardman | 3 | 0 |
Tokyo | 2 | 0 |
Beijing | 2 | 128 |
Helsinki | 1 | 1 |
Sunnyvale | 1 | 0 |
San Francisco | 1 | 0 |
Redmond | 1 | 0 |
{[{ mDataHeader[type] }]} | {[{ month[type] }]} | {[{ tData[type] }]} |
Share
Embed
Customize your widget with the following options, then copy and paste the code below into the HTML
of your page to embed this item in your website.
<div id="ubcOpenCollectionsWidgetDisplay">
<script id="ubcOpenCollectionsWidget"
src="{[{embed.src}]}"
data-item="{[{embed.item}]}"
data-collection="{[{embed.collection}]}"
data-metadata="{[{embed.showMetadata}]}"
data-width="{[{embed.width}]}"
async >
</script>
</div>
Our image viewer uses the IIIF 2.0 standard.
To load this item in other compatible viewers, use this url:
http://iiif.library.ubc.ca/presentation/dsp.831.1-0096012/manifest