SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Portfolio Allocation Model

mercury avatar
mercury
8 diapositives · 208 Views · Feb 09, 2013

This guide offers insights into effective portfolio allocation, emphasizing how different investors have unique objectives and how to account for uncertain returns. It introduces a simple spreadsheet model to simulate annualized returns across various asset classes, including Money Market, Income, Growth & Income, and Aggressive Growth. By defining assumptions and setting simulation parameters, users can analyze results to make informed decisions. The guide also covers optimization techniques using OptQuest to find the best asset allocation tailored to individual goals, highlighting the balance between risk and return.

Portfolio Allocation Model - slide 1
01 / 8Portfolio Allocation Model
1 / 17

Télécharger la présentation

Portfolio Allocation Model
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Portfolio Allocation Model • How to invest in different asset classes? • Different people have different objectives/goals. • Returns from investments are inherently random. How can we take this uncertainty into account and still make a reasonable decision?

  2. Simple Spreadsheet Model

  3. Asset Return Uncertainty (annualized) • Money Market • Uniform(minimum 2%, maximum 4%) • Income • Normal(mean 5%, stdev 5%) • Growth & Income • Normal(mean 7%, stdev 12%) • Aggressive Growth • Normal(mean 11%, stdev 18%)

  4. Crystal Ball • Define Assumption Cells for the annual returns • Define Forecast Cell • Set Simulation Settings (Number trials = 1000) • Run Simulation • View & Analyze Results • Run other two scenarios, complete summary table • Compare alternatives • (If no disk) Upload model to Blackboard Drop Box (toolsdigital drop box).

  5. Results • Summary Statistics • Mean, standard deviation, minimum, maximum, standard error • Frequency Distribution • Graphical, table of percentiles • Interactive use of frequency chart • What is the probability that the dollar return will be worse than $X? • What are the quartiles of the return distribution? What do they mean? • If I invest this way, at least how much should I be prepared to lose about 5% of the time?

  6. Goals/Objectives • Performance is a function of asset returns as well as asset allocation. • We cannot control returns, but we can control the allocation. • What is the “best” allocation? • Depends on the performance measure!

  7. Constrained Optimization • Objective (maximizing or minimizing) • Constraints • Decision Variables • Basic Question: What are the values of the decision variables which 1) satisfy the constraints, and 2) maximize or minimize the objective? • We will be using Solver soon in the course; however, Crystal Ball has a tool called OptQuest built in. • OptQuest is good for models which incorporate uncertainty, but is much slower than Solver for deterministic models.

  8. OptQuest • Build simulation model: define assumptions, forecast cells, and decision cells • CBTools…OptQuest • Wizard takes you through the process of specifying the optimization model. • Defining the objective: What is it you want to maximize or minimize?