Getting started using Ibbotson software: An unofficial tutorial MGT 544 Stanley

Getting started using Ibbotson software: An unofficial tutorial MGT 544 Stanley www.phwiki.com

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))

Coppin State College US www.phwiki.com

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 portfolio’s return distribution over time D. Return percentiles (Tulips) What is the distribution of the portfolio’s 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 portfolio’s 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 Metro Networks/Shadow Broadcast Services - Scottsdale Bureau Managing Editor;News Director www.phwiki.com

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.