Getting started using Ibbotson software: An unofficial tutorial MGT 544 Stanley
Ross, Mike, Managing Editor;News Director has reference to this Academic Journal, PHwiki organized this Journal Getting started using Ibbotson software: An unofficial tutorial MGT 544 Stanley Martinez, TA 01.19.01 Sequencing: 1. Encorr Analyzer 2. Inputs generator 3. Encorr Optimizer Encorr Attribution (not covered today) (Note: Encorr Allocator is a new feature to ver. 8.0) 1. Encorr Analyzer (Start here) File>New Folder Select series Options include: 1. Raw Data 2. Derived Data 3. Case Files Raw Data> Ibbotson Database> Stocks, Bonds, Bills in addition to Inflation Left click on a series to add it to selected series on the right Select each of the following 1. S&P 500 TR (Domestic large cap equities) 2. US Small Stk TR (Domestic small cap equities) 3. US IT Gvt TR (Domestic intermediate 3-10 year Treasury notes) 4. US 1 Yr. Gvt TR (A cash surrogate w/ higher E(r))
This Particular University is Related to this Particular Journal
1. Encorr Analyzer Other useful features A. Query: Helps you quickly look up a series 1. Select the entire Ibbotson Database folder 2. Type Farm to right of Series Name in the Time Series Query dialogue box 3. Click Search At left will appear three data series containing returns as long as Farm Real Estate. 4. Select in addition to Add Farm RE TR (Repeat this process searching as long as EAFE under the World Capital Markets- Equity folder. Select in addition to Add MSCI EAFE TR) 1. Encorr Analyzer Other useful features 2. Trans as long as m: Helps you convert A. Series from real to nominal B. From as long as eign currency to $US or another currency (Neither are necessary now, but these may play a role in Going Global due Feb 9) 1. Encorr Analyzer You should now have six data series. Hit OK>Date Settings Select Common Date Settings: This truncates the set to 1970-96 Annual a file containing annual total returns as long as all six assets classes Save as: create a folder in addition to save it somewhere i.e., Tutorial.fld You now have a series that can be used as long as generating optimization inputs >Create Inputs
2. Inputs Generators Expected Return Computation Method: Select Arithmetic Mean Expected Return: Use this to adust from historical inputs Ibbotson: Building blocks approach using bootstrapping method 1. Select International Component as long as MSCI-EAFE TR 2. Select Building Block Equity as long as US Small Stock TR 3. Select Inputs Summary folder: shows E(r), , as long as each asset shows covariance matrix between each asset 4. Click on an icon that looks like this to create an Optimization file 3. Encorr Optimizer From Available Assets add the following assets to Selected Assets S&P 500 TR U.S. Small Stk TR U.S. IT Govt TR U.S. 1 Yr TR MSCI EAFE TR From Available Assets add the following asset to Liabilities Farm R.E. TR 3. Encorr Optimizer Add Constraints from Constraints folder Minimum 10% US Int. Gov Maximum 25% each to EAFE in addition to Small Stocks These are typical risk constraints impose by plan sponsors or endowment funds Cost to Increase in addition to Cost to Decrease = 0
3. Encorr Optimizer Report features A. Efficient frontier: see right Plots portfolio assets relative to liabilities in mean-variance space B. Portfolio mix given 13.28% expected annual st in addition to ard deviation: see right By dragging on the st in addition to ard deviation scale on the X axis, we can change the optimal portfolio mix as long as a given level of risk 3. Encorr Optimizer Report features C. Wealth percentiles (Trumpets) Given the stated portfolio mix in addition to a lognormal return distribution, what is the portfolios return distribution over time D. Return percentiles (Tulips) What is the distribution of the portfolios expected return through time given the policy mix 3. Encorr Optimizer Report features E. Frontier area: How do changes in the efficient portfolio weights change with a portfolios target st in addition to ard deviation of returns There are many more tools. These are just a few to get you started.
Ross, Mike Managing Editor;News Director
Ross, Mike is from United States and they belong to Metro Networks/Shadow Broadcast Services – Scottsdale Bureau and they are from Scottsdale, United States got related to this Particular Journal. and Ross, Mike deal with the subjects like National News; Regional News
Journal Ratings by Coppin State College
This Particular Journal got reviewed and rated by Coppin State College and short form of this particular Institution is US and gave this Journal an Excellent Rating.