Baixe o app para aproveitar ainda mais
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
Menu Simular MonteCarlo.xls Apoio ao livro Avaliação de Investimentos, publicado pela Editora Atlas. Adriano Leal Bruni www.MinhasAulas.com.br albruni@minhasaulas.com.br Simular MonteCarlo Planilha específica para simulações de Monte Carlo Simular 1 0 Descrição Valor Valor a simular 0.22 Número de simulações 30 Sugestão: entre 295 e 400 Freio (fim didático) N Simulado Média Desvio 1 0.1307546937 2 0.5349817941 0.3328682439 0.2858317238 3 0.1789165565 0.2815510148 0.2207946131 4 0.5899192685 0.3586430782 0.2372191373 5 0.2008713555 0.3270887337 0.2172166491 6 0.286282506 0.3202876957 0.1949973918 7 0.4472171417 0.3384204737 0.1843589862 8 0.1207715478 0.311214358 0.1872275498 9 0.4547612671 0.3271640145 0.1815541514 10 0.0060701858 0.2950546317 0.1990216072 11 0.7314789185 0.3347295668 0.2301385353 12 0.1357651572 0.3181491994 0.2268209922 13 0.0364055719 0.2964766126 0.2307954986 14 0.7124537614 0.3261892661 0.2480502352 Máximo $0.87 15 0.391776895 0.3305617747 0.2396263317 Mínimo $0.01 16 0.619595474 0.3486263809 0.2425159931 H Classe $0.09 17 0.1615209995 0.337620182 0.2391598848 N Classes 10 18 0.2849814513 0.3346958081 0.2323506615 19 0.0615188177 0.3203180718 0.2343399845 Limite Sup Fi 20 0.0476381133 0.3066840738 0.2360988588 $0.09 5 21 0.2478469992 0.3038823084 0.2304786005 $0.18 5 22 0.8104144343 0.3269064959 0.2495061798 $0.27 3 23 0.5004951019 0.3344538266 0.2464422192 $0.35 4 24 0.4471968302 0.3391514518 0.2421214431 $0.44 1 25 0.2878627649 0.3370999043 0.2372454383 $0.53 4 26 0.2000311933 0.3318280308 0.2340012627 $0.61 2 27 0.3482008321 0.3324344308 0.22947875 $0.70 1 28 0.828365425 0.3501462521 0.2439138148 $0.79 2 29 0.8745613014 0.3682295296 0.2585581328 $0.87 3 30 0.0374211324 0.357202583 0.2611414608 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Menu Simula Graficos Resultados Média $0.36 Desvio $0.26 Prob > 0 91.43% Graficos 1 1 0.3328682439 0.2858317238 0.2815510148 0.2207946131 0.3586430782 0.2372191373 0.3270887337 0.2172166491 0.3202876957 0.1949973918 0.3384204737 0.1843589862 0.311214358 0.1872275498 0.3271640145 0.1815541514 0.2950546317 0.1990216072 0.3347295668 0.2301385353 0.3181491994 0.2268209922 0.2964766126 0.2307954986 0.3261892661 0.2480502352 0.3305617747 0.2396263317 0.3486263809 0.2425159931 0.337620182 0.2391598848 0.3346958081 0.2323506615 0.3203180718 0.2343399845 0.3066840738 0.2360988588 0.3038823084 0.2304786005 0.3269064959 0.2495061798 0.3344538266 0.2464422192 0.3391514518 0.2421214431 0.3370999043 0.2372454383 0.3318280308 0.2340012627 0.3324344308 0.22947875 0.3501462521 0.2439138148 0.3682295296 0.2585581328 0.357202583 0.2611414608 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Média Desvio Numero de Simulações Média e Desvio 5 5 3 4 1 4 2 1 2 3 Limites superiores dos valores simulados Frequência
Compartilhar